/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 vote367 views1 answer
Mysql c commands
SQL
2 votes356 views1 answer
Oracle current date without time
SQL
-3 votes338 views1 answer
Remove spaces sql 2008
SQL
5 votes380 views3 answers
Db begintransaction laravel
SQL
1 vote351 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote336 views1 answer
Input in mysql
SQL
0 vote397 views1 answer
Mysql average from two table
SQL
0 vote387 views1 answer
Oracle swap partition
SQL
2 votes368 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote366 views1 answer
Mysql isshow
SQL