/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 vote359 views1 answer
Bitmap join index
SQL
0 vote319 views1 answer
Postgresql import a database of gzip
SQL
0 vote317 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote326 views1 answer
Run mssql server terminal
SQL
10 votes297 views2 answers
Sql where clause multiple values
SQL
1 vote327 views3 answers
Drop unique key constraint in sql server
SQL
0 vote319 views1 answer
How to get data between a last week in mysql
SQL
3 votes327 views1 answer
Force using index plsql
SQL
0 vote314 views1 answer
Mysql server not running
SQL
3 votes302 views1 answer
Sql cast to integer
SQL