/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 vote201 views1 answer
List column names of multiple tables psql
SQL
5 votes212 views2 answers
Oracle list columns
SQL
0 vote152 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote200 views1 answer
Temp table vs variable table in sql server
SQL
0 vote232 views1 answer
Mysql relationships between tables
SQL
0 vote196 views1 answer
Mysql function variable
SQL
0 vote208 views2 answers
Get top 1 row of each group
SQL
28 votes206 views4 answers
Show tables mysql
SQL
13 votes210 views1 answer
Views in sql
SQL
0 vote219 views1 answer
Mysql aspas simples
SQL