/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

10 votes143 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote131 views1 answer
Mariadb maximum left join
SQL
0 vote140 views1 answer
Stored procedures example
SQL
0 vote98 views1 answer
Mysql workbench search all tables
SQL
5 votes162 views3 answers
Db begintransaction laravel
SQL
0 vote131 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote185 views1 answer
T-sql delete view if exists
SQL
0 vote131 views1 answer
Equi joins in oracle
SQL
1 vote122 views1 answer
Table infromation in sql server
SQL
0 vote128 views1 answer
If exist column in table drop sql query mysql
SQL