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