/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

1 vote281 views1 answer
Alter constraint postgres
SQL
0 vote314 views1 answer
Pgadmin save data greyed out
SQL
0 vote270 views1 answer
Sql get month and year from date
SQL
6 votes322 views5 answers
Oracle list tablespaces
SQL
4 votes269 views1 answer
Oracle user tables
SQL
0 vote353 views1 answer
Mysql get longest string in column
SQL
3 votes287 views1 answer
Uppercase and lowercase in sql
SQL
0 vote317 views1 answer
Virtuoso sql query tutorial
SQL
0 vote301 views1 answer
Postgres can integer fields be negative
SQL
0 vote297 views1 answer
Openquery join two tables
SQL