/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 vote140 views1 answer
Sql values that contains certain multiple ids
SQL
5 votes123 views5 answers
Sqlite install python
SQL
0 vote121 views1 answer
Remove binlog mysql
SQL
1 vote148 views1 answer
Postgres select as csv
SQL
0 vote146 views1 answer
Str_to_date sql server
SQL
3 votes126 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote134 views1 answer
Select last N rows mysql
SQL
0 vote127 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote122 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
1 vote159 views1 answer
Homebrew install mysql
SQL