/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

61 votes303 views6 answers
Mysql add column
SQL
1 vote249 views1 answer
Import sql file from laravel
SQL
0 vote128 views1 answer
Trigger value from maltiple table to single table mysql
SQL
5 votes132 views3 answers
Truncate function in sql oracle
SQL
3 votes145 views1 answer
Oracle function return
SQL
0 vote138 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote135 views1 answer
Sql server python connection
SQL
5 votes129 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
13 votes141 views2 answers
Sql join 3 tables
SQL
0 vote146 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL