/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 vote143 views1 answer
Mysql current running queries
SQL
7 votes127 views1 answer
Query delete duplicates
SQL
3 votes129 views2 answers
Postgresql select all column names
SQL
0 vote112 views2 answers
Mysql password error create datbase
SQL
10 votes111 views4 answers
Sql pagination
SQL
1 vote116 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote163 views2 answers
SQL BULK INSERT
SQL
5 votes126 views1 answer
Oracle nls instance
SQL
19 votes113 views2 answers
Mysql add column after another
SQL
0 vote137 views2 answers
How to list all values of a column that start with a letter in sql
SQL