/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

1 vote163 views1 answer
Error code 1292 mysql workbench
SQL
0 vote113 views1 answer
Psql not found windows
SQL
0 vote147 views1 answer
Declare date variable sql
SQL
0 vote165 views1 answer
How to find lowest in sql
SQL
0 vote159 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
3 votes152 views1 answer
Laravel paginate raw sql
SQL
1 vote128 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote143 views1 answer
Dump only schema
SQL
7 votes174 views5 answers
Sql remove spaces
SQL
0 vote181 views1 answer
UNION ALL LEFT JOIN
SQL