/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 vote148 views1 answer
Mql5 datetime get hour
SQL
1 vote129 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote138 views1 answer
Oracle select partition
SQL
1 vote137 views2 answers
Oracle list partitioned tables
SQL
1 vote124 views2 answers
Mysql allow remote connections
SQL
0 vote141 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote141 views1 answer
Drop index in sql
SQL
6 votes124 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
1 vote127 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote130 views1 answer
How to get n result in sql
SQL