/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

50 votes202 views6 answers
Install mysql on ubuntu
SQL
5 votes110 views3 answers
Sql make column nullable
SQL
1 vote98 views1 answer
What is int in mysql
SQL
0 vote115 views1 answer
Shortcut run sql pgadmin
SQL
1 vote119 views2 answers
Sql multiline comment
SQL
0 vote135 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote120 views1 answer
Mysql 8 error on identified by
SQL
0 vote120 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote120 views1 answer
Sql server convert to guid
SQL
4 votes108 views1 answer
Add constraint fk
SQL