/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

2 votes154 views1 answer
Date_format for time sql
SQL
1 vote173 views1 answer
Postgresql update auto_increment value
SQL
22 votes154 views3 answers
SQL CHEATSHEET
SQL
0 vote162 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote149 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote156 views1 answer
Incorrect string value: mysql
SQL
4 votes151 views2 answers
Oracle set date format
SQL
1 vote187 views1 answer
Oracle columns table
SQL
0 vote155 views1 answer
Test sql query
SQL
0 vote146 views1 answer
Data directory postgresql
SQL