/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

2 votes226 views1 answer
Sql server find columns list in tables
SQL
1 vote212 views1 answer
Update substring in mysql
SQL
0 vote217 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote252 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote209 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote229 views4 answers
Forenkey code alchemy sql
SQL
0 vote207 views1 answer
How to install mysql without admin rights
SQL
1 vote284 views3 answers
Date_add mysql
SQL
1 vote207 views7 answers
Filter
SQL
1 vote219 views2 answers
Oracle leftmost characters
SQL