/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

11 votes234 views1 answer
How to get ddl for materialized view
SQL
0 vote205 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote190 views1 answer
Sql quary intervewi question
SQL
1 vote132 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
58 votes551 views6 answers
Create new user in postgres
SQL
0 vote256 views1 answer
TSQL Find csv file in folder
SQL
1 vote202 views3 answers
Rows, INSERT INTO
SQL
0 vote219 views1 answer
How to insert same table data using mysql query
SQL
0 vote264 views2 answers
Return the number of records in a single table mysql
SQL
2 votes200 views2 answers
Postgresql search all tables for column name
SQL