/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 vote297 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote317 views1 answer
How to start with sql
SQL
4 votes292 views1 answer
To date oracle with time
SQL
1 vote343 views2 answers
Truncate table sqlite
SQL
0 vote308 views1 answer
Mysql not defined
SQL
0 vote304 views2 answers
How to use aggregate functions in sql
SQL
0 vote309 views1 answer
How to declare variable date in mysql
SQL
2 votes355 views2 answers
Set value to null sql
SQL
3 votes293 views1 answer
Sql datetime as date
SQL
3 votes357 views2 answers
Wp do sql query from function
SQL