/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

2 votes304 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote314 views2 answers
Sql join on comma separated field
SQL
2 votes358 views3 answers
Xampp mysql database not starting
SQL
22 votes312 views3 answers
Join three tables sql
SQL
9 votes570 views2 answers
Current date in postgresql minus 1 day
SQL
5 votes309 views2 answers
Oracle timestamp to date
SQL
0 vote329 views1 answer
What does leave do in mysql
SQL
5 votes302 views4 answers
Sql check
SQL
104 votes521 views2 answers
Like in mysql
SQL
0 vote326 views1 answer
Sqlite löschen einer tabelle
SQL