/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 vote182 views2 answers
Getting customers with no orders sql
SQL
0 vote217 views1 answer
Sql alchemy escape ; in insert statement
SQL
4 votes150 views2 answers
Show all database inside postgresql
SQL
0 vote141 views1 answer
Sql contains numeric characters
SQL
0 vote163 views1 answer
Alter check command
SQL
8 votes168 views2 answers
Sqlsrv default port
SQL
0 vote158 views1 answer
Oracle procedure teamplate
SQL
48 votes245 views3 answers
Psql create database
SQL
3 votes188 views2 answers
How to list columns for particular tables in postgresql
SQL
8 votes195 views6 answers
Insert command in sql
SQL