/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

61 votes326 views6 answers
Mysql add column
SQL
0 vote141 views1 answer
Load data from text file to mysql database on mac terminal
SQL
11 votes151 views1 answer
Oracle export view ddl
SQL
0 vote136 views1 answer
Closure in sql
SQL
0 vote143 views2 answers
Create-toys-table-with-toy_name-column
SQL
2 votes136 views1 answer
Sqlite indexes
SQL
32 votes142 views6 answers
Insert into values select
SQL
5 votes141 views3 answers
MySql get fields of table
SQL
5 votes167 views3 answers
Sql limit offset
SQL
2 votes131 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL