/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 vote199 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
19 votes173 views5 answers
Date between in mysql
SQL
0 vote172 views1 answer
Multiple tricky query in sql server
SQL
0 vote169 views1 answer
Starting mysql shell lampp ubuntu
SQL
3 votes165 views1 answer
Oracle revoke grant
SQL
0 vote181 views1 answer
Psql show db
SQL
1 vote174 views1 answer
Neo4j display all nodes and relationships
SQL
7 votes295 views2 answers
Drop index oracle
SQL
0 vote178 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote222 views1 answer
Change redo log file size in mysql 5.6
SQL