/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 vote133 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote142 views2 answers
Sql where is not number
SQL
1 vote133 views1 answer
Mysql change root mysql_native_password
SQL
0 vote127 views1 answer
Mysql terminal list table
SQL
4 votes151 views2 answers
Oracle unlock account
SQL
1 vote125 views1 answer
Oracle get current schema
SQL
0 vote116 views1 answer
Update having mysql
SQL
0 vote129 views1 answer
Set a value by excuting stored procedure
SQL
4 votes159 views2 answers
Oracle unliock account
SQL
0 vote126 views1 answer
Psql attribute cannot login
SQL