/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 vote338 views1 answer
Sqlalchemy on delete set null
SQL
0 vote352 views1 answer
Psql check if sql script is valid
SQL
1 vote311 views1 answer
Drop table if exists oracle
SQL
7 votes312 views3 answers
How ot change name of column mysql
SQL
0 vote310 views1 answer
Tsql pad left
SQL
0 vote316 views1 answer
Postgresql delete limit
SQL
-1 vote343 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote321 views1 answer
Ceil upto 2 decimal place mysql
SQL
5 votes265 views1 answer
Alter table default value mysql
SQL
0 vote343 views1 answer
Insert value in identity
SQL