/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 vote146 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
2 votes146 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote130 views1 answer
Mysql with
SQL
0 vote161 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote131 views1 answer
Django how to get query result count
SQL
0 vote107 views1 answer
Hangfire clean script
SQL
0 vote155 views1 answer
Postgresql inheritance
SQL
0 vote148 views1 answer
Get schema of table sql
SQL
0 vote145 views3 answers
How to run sql query
SQL
0 vote158 views1 answer
Sql injection payload list github
SQL