/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 vote180 views1 answer
How to know if table in rigt or left in sql
SQL
13 votes184 views6 answers
Current date sql
SQL
0 vote247 views1 answer
Inner join distinct
SQL
0 vote248 views2 answers
Uninstall postgresql mac
SQL
0 vote203 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote178 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote201 views1 answer
Default column value in sql same as another column laravel
SQL
5 votes220 views1 answer
How to use rank function in sql
SQL
0 vote196 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote259 views1 answer
Mysql disable triggers
SQL