/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 vote303 views1 answer
R write csv without index
SQL
0 vote495 views1 answer
Get first match in each group mysql query
SQL
0 vote340 views1 answer
Mssql find deadlocks
SQL
0 vote301 views1 answer
Insert set mysql
SQL
0 vote261 views1 answer
Procedures and functions in pl/sql
SQL
1 vote287 views1 answer
Select 2 rows in sql
SQL
0 vote298 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote295 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote271 views1 answer
SQL get max per id
SQL
6 votes313 views2 answers
Sql sequence
SQL