/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 vote217 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
10 votes159 views2 answers
Mysql select timestamp group by day
SQL
2 votes187 views3 answers
Mysql pass command from command line
SQL
0 vote181 views1 answer
Oracle DROP PROGRAM
SQL
0 vote194 views1 answer
Sql get count without group by
SQL
32 votes203 views6 answers
Rename column mysql
SQL
0 vote183 views2 answers
Mysql select date from datetime
SQL
0 vote179 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote185 views3 answers
Execute sp in sql server
SQL
0 vote177 views1 answer
Psql store procedure-return multiple table values
SQL