/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

35 votes292 views5 answers
Sql alter column
SQL
0 vote257 views1 answer
Group by sql not ordering issues
SQL
1 vote251 views1 answer
Alter add syntax
SQL
0 vote263 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes263 views2 answers
Enable foreign key checks postgres
SQL
2 votes260 views1 answer
Oracle apex who is connected
SQL
24 votes249 views4 answers
Mssql get all table names
SQL
0 vote255 views1 answer
Learn sqlite dart
SQL
3 votes262 views2 answers
Postgres alter table owner
SQL
0 vote288 views1 answer
Add new column in sql with foreign key
SQL