/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 vote193 views1 answer
Oracle rolling back transactions
SQL
0 vote449 views1 answer
Create pl/sql stored procedure
SQL
36 votes216 views3 answers
Add column in mysq
SQL
2 votes203 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
1 vote186 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote200 views1 answer
Convert polygon to text in mysql
SQL
7 votes188 views2 answers
Sql server drop temp table if exists
SQL
1 vote208 views3 answers
Get all tables postgres
SQL
0 vote213 views4 answers
Sql rownum
SQL
0 vote194 views1 answer
Sql column as header
SQL