/SQL/Sql make sure every user is unqiuew

Sql make sure every user is unqiuew

create table user(
    user_id  INT  auto_increment  PRIMARY KEY,
    username varchar(50) not null,
    avator  varchar(50),
    gender  boolean not null,
    phone varchar(20),
    unique(username)
);

create table journey(
    id INT auto_increment PRIMARY KEY,
    start varchar(100) not null,
    dest varchar(100) not null,
    time date not null,
    person INT,
    user_id INT not null,
    foreign key(user_id) references user(user_id)
);

Source: stackoverflow.com

Similar codes

17 votes355 views6 answers
What is cursor in sql server with example
SQL
0 vote329 views1 answer
Call rest api from postgresql
SQL
0 vote371 views1 answer
How to inner join 4 tables in sql
SQL
0 vote304 views1 answer
Opensuse status MySQL
SQL
10 votes332 views4 answers
Mysql one week ago
SQL
0 vote340 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote331 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote365 views1 answer
Backup mysql schema only
SQL
0 vote287 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote332 views1 answer
Show all event schedular on mysql
SQL