/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

13 votes112 views2 answers
Oracle all source
SQL
2 votes153 views1 answer
Select * from table where name like
SQL
0 vote153 views4 answers
Database stuck at restoring state
SQL
0 vote154 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote191 views1 answer
Tsql create unique index composite
SQL
8 votes204 views1 answer
Mysql dump restore
SQL
0 vote146 views1 answer
Sql constarint
SQL
0 vote150 views1 answer
Mariadb number format
SQL
1 vote150 views4 answers
Psql check tables command
SQL
0 vote150 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL