/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 vote226 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote237 views2 answers
Script all indexes in a database
SQL
0 vote236 views1 answer
Oracle last connexion
SQL
0 vote229 views1 answer
Sql server beginning of month
SQL
0 vote237 views1 answer
Select into table variable
SQL
0 vote226 views1 answer
Mysql select field if condition
SQL
0 vote223 views2 answers
Starting mysql service from mac
SQL
11 votes244 views1 answer
Creating tables in sql with python
SQL
0 vote228 views1 answer
Executescalar in sql server
SQL
2 votes238 views1 answer
Use cases condition in sql query laravel
SQL