/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 vote195 views1 answer
Mysql column start with string
SQL
1 vote153 views2 answers
Delete auto increment mysql
SQL
10 votes201 views1 answer
All_dependencies
SQL
-1 vote189 views8 answers
Create Trigger in phpMyAdmin
SQL
15 votes252 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote212 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote243 views1 answer
Sql select rows between 1000 and 2000
SQL
10 votes185 views1 answer
User_dependencies
SQL
3 votes186 views1 answer
Select nextval from sequence sql
SQL
4 votes229 views1 answer
How to check last gather stats on table in oracle
SQL