/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 vote271 views1 answer
Sql_inner_join
SQL
14 votes281 views4 answers
Online sql compiler
SQL
0 vote272 views1 answer
Sql server express download
SQL
0 vote276 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote276 views1 answer
Synapse sql table set pk
SQL
4 votes269 views2 answers
Xampp mysql database server is not starting mac m1
SQL
27 votes281 views6 answers
Sql update record
SQL
1 vote265 views1 answer
Load sql into mamp
SQL
5 votes257 views1 answer
Sql first day of current year
SQL
0 vote265 views2 answers
How to start postgresql laravel
SQL