/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 vote205 views1 answer
Postgres set sequence value to max id
SQL
1 vote192 views1 answer
Psql connect to another database
SQL
4 votes197 views1 answer
Alter session set nls_date_format
SQL
1 vote184 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote195 views2 answers
Tsql row number
SQL
0 vote186 views1 answer
Select insert new table sql server
SQL
8 votes183 views1 answer
Mac restore mysql database command line
SQL
-1 vote193 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote187 views1 answer
Power query datetime to date
SQL
2 votes201 views1 answer
Postgresql left join distinct on
SQL