/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

1 vote131 views1 answer
Homebrew install mysql
SQL
0 vote110 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote110 views1 answer
Calculate age in sql postgresql
SQL
1 vote115 views1 answer
Postgres format date in select
SQL
0 vote103 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote101 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote129 views1 answer
Get total and distict row diff in sql
SQL
1 vote92 views1 answer
Sql server reseed single table
SQL
0 vote96 views1 answer
Execut sql python
SQL
1 vote105 views1 answer
Sql trigger before delete
SQL