/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 vote293 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote256 views1 answer
Full syntax inner join
SQL
0 vote289 views1 answer
Sql developer search all packages for text
SQL
25 votes295 views3 answers
How to use a database to see tables mysql
SQL
1 vote301 views2 answers
Sql split string by space
SQL
0 vote270 views1 answer
Postgres full text search example
SQL
0 vote289 views1 answer
Sql order by except one row
SQL
5 votes266 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote256 views1 answer
Import all databases mysql
SQL
3 votes270 views2 answers
Oracle synonym
SQL