/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 vote382 views1 answer
Sql quary intervewi question
SQL
0 vote379 views1 answer
Oracle remove line breaks
SQL
0 vote348 views1 answer
Mssql current date
SQL
0 vote369 views1 answer
T-SQL Create Trigger
SQL
0 vote364 views1 answer
Get current date data in mysql
SQL
0 vote374 views2 answers
Oracle sql for each row
SQL
-1 vote344 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
17 votes360 views3 answers
Cast in sql server
SQL
16 votes386 views5 answers
Select last row in sql
SQL
0 vote360 views1 answer
Sql decode
SQL