/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 vote139 views2 answers
Select limit ms sql
SQL
0 vote174 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
8 votes156 views1 answer
Check mysql version phpmyadmin
SQL
0 vote156 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote144 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote212 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote154 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote152 views1 answer
How to print some string in mysql
SQL
0 vote193 views1 answer
Postgres extract number from string
SQL
4 votes141 views1 answer
To date oracle with time
SQL