/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 vote204 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
3 votes221 views1 answer
Mysql cli connect with password
SQL
0 vote329 views1 answer
Sqlite display data in separated columns
SQL
0 vote209 views1 answer
Get only structure database mysql
SQL
0 vote191 views1 answer
Mysql get first 2 characters of string
SQL
0 vote237 views2 answers
Mysql cast to varchar
SQL
8 votes175 views3 answers
Alter user root mysql
SQL
8 votes176 views3 answers
Oracle auto_increment
SQL
1 vote213 views1 answer
Nvl postgres
SQL
0 vote210 views1 answer
Mssql find deadlocks
SQL