/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 vote138 views1 answer
C# sql transaction multiple connections
SQL
4 votes96 views3 answers
Order by value mysql
SQL
-1 vote112 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
3 votes114 views2 answers
How to start postgresql on windows
SQL
0 vote106 views1 answer
Oracle db timestamp auto add
SQL
3 votes106 views1 answer
Increment integer in table sql
SQL
0 vote143 views1 answer
Count column of tables psql
SQL
0 vote114 views1 answer
How to check which table has data in mysql
SQL
2 votes112 views2 answers
Create empty table from existing table
SQL
0 vote109 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL