/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

2 votes357 views2 answers
How to run postgresql in linux
SQL
0 vote354 views1 answer
Java sql connection
SQL
0 vote349 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote336 views1 answer
Sqlite3 get data from table c
SQL
1 vote312 views1 answer
Postgres kill pid
SQL
3 votes335 views2 answers
Sqlite show table definition
SQL
0 vote359 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote339 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote363 views1 answer
Mysql date format unix timestamp
SQL
0 vote350 views1 answer
Raven ql select count
SQL