/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 vote204 views1 answer
Count in sql and diff
SQL
0 vote217 views1 answer
Get null value in sql
SQL
1 vote201 views1 answer
Get current date in pyspark sql
SQL
4 votes202 views2 answers
Delete all table oracle
SQL
1 vote187 views2 answers
Snowflake alter column data type
SQL
1 vote197 views1 answer
Mysql find most common value
SQL
0 vote184 views1 answer
Psotgres multiple values
SQL
1 vote176 views1 answer
Oracle get current schema
SQL
0 vote200 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote184 views1 answer
Mysql group by derived column
SQL