/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 vote163 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
1 vote173 views1 answer
Sql list all procedures
SQL
0 vote176 views1 answer
Sql auto_increment syntax
SQL
0 vote159 views1 answer
Check if a word appears at the end sql query
SQL
4 votes162 views2 answers
Sql select except null
SQL
5 votes166 views1 answer
Purge undo tablespace oracle 11g
SQL
12 votes169 views4 answers
Mysql version
SQL
2 votes164 views1 answer
Install sqlite npm
SQL
1 vote161 views4 answers
Fatal database postgres does not exist
SQL
24 votes168 views4 answers
Mssql get all table names
SQL