/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

3 votes333 views1 answer
Sql insert inserted id
SQL
0 vote321 views1 answer
Sql server set complex constraints
SQL
8 votes322 views3 answers
Postgres connection string
SQL
5 votes305 views2 answers
Mysql drop table cascade
SQL
4 votes297 views2 answers
Oracle unliock account
SQL
0 vote335 views1 answer
Running percentage of total postgres
SQL
4 votes316 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote309 views1 answer
Oracle create package specification
SQL
0 vote310 views2 answers
Sql use not in
SQL
0 vote324 views1 answer
Psql attribute cannot login
SQL