/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

3 votes216 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote228 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote211 views1 answer
Mysql column start with string
SQL
0 vote232 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote222 views1 answer
Character count sql
SQL
6 votes178 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote216 views1 answer
Add SuperUser MySQL
SQL
0 vote249 views1 answer
Sql quary stuf
SQL
0 vote211 views1 answer
Composit key in sql
SQL
0 vote220 views1 answer
Example of sql querry result sepapreted by comma
SQL