/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

0 vote117 views1 answer
"Hello User Name"
SQL
0 vote116 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote133 views1 answer
How to define a non primary composite key in sql
SQL
1 vote106 views3 answers
Sql server get week dates from week number
SQL
2 votes62 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes119 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote107 views1 answer
Select only one row sql
SQL
17 votes107 views6 answers
Current date in sql
SQL
4 votes117 views3 answers
Sql drop primary key
SQL
0 vote107 views1 answer
Sql constarint
SQL