/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 vote211 views1 answer
Sql query to select even numbers
SQL
0 vote185 views1 answer
Mysql subtract month from timestamp
SQL
0 vote177 views1 answer
Stored procedures example
SQL
0 vote159 views1 answer
Mysql drop multiple tables at once
SQL
0 vote175 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote179 views1 answer
Sql server alter table column nullable
SQL
3 votes170 views1 answer
Ssh check mysql version
SQL
32 votes189 views6 answers
Insert select
SQL
2 votes187 views2 answers
Postgres timestamp to datetime
SQL
10 votes151 views2 answers
Mysql select timestamp group by day
SQL