Sql make sure every user is unqiuew

This article is tagged with: Sql make sure every user is unqiuew and mysql

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)
);

This article is tagged with: Sql make sure every user is unqiuew and mysql