/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 votes206 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote216 views1 answer
Uncheck constraints and delete from table
SQL
1 vote197 views1 answer
Mysql get latest duplicate rows
SQL
1 vote210 views1 answer
Postgres install unaccent extension
SQL
1 vote246 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
7 votes221 views1 answer
Query postgres delete duplicates
SQL
16 votes204 views6 answers
Mysql find and replace
SQL
0 vote213 views1 answer
Drop database using terminal postgres
SQL
9 votes221 views3 answers
Where clause sql
SQL
0 vote215 views1 answer
Show mysql account privilleges
SQL