/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 vote177 views2 answers
Postgresql change user role grant
SQL
0 vote176 views1 answer
Partitioning in oracle-base
SQL
0 vote153 views1 answer
Mysql offset from bottom
SQL
0 vote201 views1 answer
Sql server isnull function nor working count
SQL
0 vote216 views2 answers
While mysql
SQL
1 vote186 views1 answer
Select if then postgresql
SQL
0 vote273 views2 answers
Search stored procedures by name
SQL
1 vote173 views1 answer
Oracle aleter trigger ora-01031
SQL
11 votes206 views4 answers
Reset identity column values in sql server
SQL
0 vote174 views1 answer
How to define a save method in ruby for sql databases
SQL