/SQL/Sql create table with references not primary key

Sql create table with references not primary key

CREATE TABLE Users(
  address varchar(100),
  phone_number varchar(20),
  userid serial,
  constraint pk primary key (address, phone_number ),
  constraint userid_unq unique (userid)
);

create table Stores(
  storeid int primary key,
  ownerID integer,
  constraint b_fk foreign key (ownerID)
    references Users(userid)
);

Source: stackoverflow.com

Similar codes

14 votes278 views4 answers
Remove record from table sql
SQL
12 votes251 views1 answer
Env var for setting password for root user mysql docker hub
SQL
-1 vote245 views1 answer
How to use update trigger in sql
SQL
21 votes270 views5 answers
Oracle all tables
SQL
0 vote270 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote350 views1 answer
Delet all record statment sql
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote326 views1 answer
Stop and start mysql
SQL
1 vote312 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
3 votes259 views2 answers
Plsql print
SQL