/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 vote64 views1 answer
Update set with join pl sql
SQL
0 vote107 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote107 views1 answer
Python connect microsoft sql server
SQL
19 votes112 views5 answers
Display table in sql
SQL
0 vote109 views1 answer
How to update sql server version
SQL
0 vote96 views1 answer
Concat column value of same user in mysql
SQL
0 vote101 views1 answer
Sql server check whether column has same equal values
SQL
0 vote105 views1 answer
Oracle right characters
SQL
0 vote104 views1 answer
SAP Return
SQL
1 vote108 views1 answer
Oracle update with sequence
SQL