/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 vote226 views1 answer
How to find top 3 salary in sql
SQL
0 vote177 views2 answers
Sql query in dax power bi
SQL
0 vote200 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote210 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote170 views3 answers
Select random sql
SQL
1 vote187 views1 answer
Denied
SQL
6 votes180 views2 answers
Oracle undotbs usage
SQL
0 vote173 views1 answer
Sql not exists
SQL
0 vote175 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote182 views1 answer
Mysql workbench procedure
SQL