/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 vote250 views1 answer
On delete set default
SQL
0 vote219 views1 answer
Postgres add prefix to primary key
SQL
4 votes239 views1 answer
SQL find text in SP
SQL
0 vote246 views1 answer
Run mysql xampp shell
SQL
1 vote226 views1 answer
Import in mysql without a software
SQL
3 votes257 views1 answer
Postgres select max value
SQL
3 votes231 views2 answers
Pl sql escape '
SQL
0 vote232 views1 answer
Sauvegarde complète my sql
SQL
0 vote258 views3 answers
Run sql command line
SQL
0 vote234 views1 answer
T sql check active deadlock
SQL