/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

3 votes294 views1 answer
Force using index oracle
SQL
0 vote276 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote318 views1 answer
Creating h2 database in relative directory eclopse
SQL
4 votes293 views1 answer
Oracle select first 10 rows
SQL
1 vote295 views1 answer
How do you use sql in you company
SQL
0 vote309 views1 answer
SQL division of an integer by another integer get float CAST
SQL
2 votes322 views1 answer
How to select from mssql
SQL
1 vote276 views1 answer
Mysql server does not start mac
SQL
0 vote295 views1 answer
How to find columns with null values in sql
SQL
24 votes309 views6 answers
Replace mysql
SQL