/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

1 vote190 views3 answers
What is union in sql
SQL
10 votes183 views1 answer
Create table oracle
SQL
4 votes180 views1 answer
Id primary key auto generated
SQL
0 vote208 views3 answers
Insert query in ci
SQL
4 votes246 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote196 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
2 votes207 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote217 views1 answer
Into operator in sql
SQL
25 votes215 views6 answers
How to change column name in mysql
SQL
6 votes251 views2 answers
Install psql mac
SQL