/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

23 votes253 views3 answers
Sql where contains part of string
SQL
0 vote234 views2 answers
Get all index postgres
SQL
27 votes247 views3 answers
Mysql show tables in database
SQL
1 vote249 views3 answers
Divide by zero error in sql
SQL
0 vote222 views1 answer
Postgresql subquery
SQL
0 vote231 views1 answer
Sql database connectivity
SQL
12 votes235 views2 answers
Delete entries in postgresql
SQL
7 votes243 views3 answers
Python and mysql connectivity
SQL
9 votes240 views2 answers
Sql server check table exists
SQL
0 vote225 views1 answer
Create a PostgreSQL user django on mac
SQL