/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
How to get inserted id in sql server
SQL
0 vote146 views1 answer
Oracle sql date summer time
SQL
12 votes130 views2 answers
Delete all data in neo4j
SQL
0 vote145 views2 answers
Sql query for getting details by id
SQL
22 votes170 views4 answers
Date format mysql
SQL
-1 vote130 views1 answer
Round up and down sql
SQL
5 votes143 views2 answers
Get number of columns sql
SQL
0 vote136 views1 answer
View t-sql mail configuration
SQL
0 vote146 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
8 votes132 views5 answers
Grant permission in postgres
SQL