/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

1 vote288 views1 answer
Simple project for database
SQL
0 vote298 views1 answer
Get who is hired in february in sql
SQL
21 votes300 views1 answer
SQL cheat sheet pdf
SQL
0 vote320 views1 answer
Date 3 months from today sql
SQL
13 votes279 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote318 views2 answers
Generate sql trigger through ef migration
SQL
7 votes276 views1 answer
Sql management studio display line numbers
SQL
3 votes268 views1 answer
Oracle nextval
SQL
0 vote351 views1 answer
Oracle convert int to date
SQL
2 votes283 views1 answer
Sql update alias
SQL