/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 vote225 views1 answer
Mysql add to value
SQL
1 vote219 views1 answer
Sql oracle update multiple rows
SQL
0 vote240 views1 answer
Alter table add check constraint oracle
SQL
19 votes251 views3 answers
How to change column type psql
SQL
0 vote264 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote229 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
2 votes245 views1 answer
Sql find not in list
SQL
0 vote232 views2 answers
Many to many flask-sqlalchemy
SQL
1 vote223 views1 answer
Get table which have specific columns in mysql
SQL
0 vote268 views1 answer
Traccar mysql
SQL