/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

23 votes259 views6 answers
Delete all rows from table sql
SQL
-2 votes265 views1 answer
Group functions in sql
SQL
1 vote260 views1 answer
Psql client write to bash variable
SQL
2 votes268 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote267 views1 answer
How to output a different column name in mysql
SQL
1 vote266 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote270 views1 answer
Kill a pid redshift
SQL
15 votes393 views2 answers
Sql order by alphabetical
SQL
8 votes295 views3 answers
Postgres database sizes
SQL
0 vote280 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL