/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 vote121 views1 answer
Mysql update from n to 100
SQL
0 vote131 views1 answer
TSQL convert csv to table
SQL
17 votes138 views4 answers
Mysql remove ubuntu
SQL
0 vote115 views4 answers
Mysql on kubernetes
SQL
5 votes128 views1 answer
Oracle columns in all_tables
SQL
0 vote124 views1 answer
Neo4j command to run script file
SQL
2 votes118 views6 answers
In in sql
SQL
0 vote109 views1 answer
Change database name psql 8
SQL
0 vote76 views1 answer
Online sql compiler
SQL
0 vote116 views1 answer
How to count with except in psql
SQL