/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

0 vote192 views4 answers
Database stuck at restoring state
SQL
1 vote203 views5 answers
Postgresql difference between two dates in days
SQL
0 vote204 views1 answer
Casterar postgres
SQL
0 vote205 views1 answer
Oracle c# multiple update sql
SQL
4 votes206 views4 answers
Pl sql output
SQL
0 vote193 views1 answer
Allow external access to mysql
SQL
1 vote211 views1 answer
Add multiple row table pl sql
SQL
0 vote237 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote210 views1 answer
Migration graphql
SQL
3 votes216 views1 answer
Where id is in list sql
SQL