/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 vote210 views1 answer
Changing name of column and datatype in sql
SQL
3 votes215 views2 answers
Having in mysql
SQL
1 vote189 views1 answer
Oracle get current schema
SQL
0 vote191 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote188 views1 answer
Mysql case when null
SQL
0 vote206 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote233 views1 answer
Sql server beginning of month
SQL
13 votes224 views2 answers
Oracle inner join
SQL
0 vote193 views1 answer
Acual month sql
SQL
0 vote190 views1 answer
Sql create text column limited values
SQL