/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 vote210 views1 answer
Mysql not supported auth mode
SQL
5 votes190 views1 answer
Invalid column name sql
SQL
0 vote197 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote190 views1 answer
Get first name and last name from full name string in SQL
SQL
2 votes202 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote202 views1 answer
Oracle synonym procedure dblink
SQL
0 vote200 views1 answer
Timestamp(0) postgresql
SQL
0 vote193 views1 answer
How to get inserted id in sql server
SQL
4 votes193 views1 answer
Mysql timestamp in laravel migration
SQL
3 votes181 views2 answers
Mysql create database
SQL