Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table contact (
- id int8 not null unique,
- first_name varchar(100),
- last_name varchar(100),
- email varchar(200) not null unique,
- -- extraneous columns removed, total columns: 34
- primary key (id)
- );
- create table address (
- id int8 not null unique,
- city varchar(255),
- line1 varchar(255),
- line2 varchar(255),
- state varchar(255),
- country varchar(255) not null,
- postal_code varchar(255),
- primary key (id)
- );
- create table contact_address_map (
- contact id int8 not null,
- address_id int8 not null,
- unique (address_id)
- );
- alter table contact_address_map
- add constraint cam_to_contact
- foreign key (contact_id)
- references contact;
- alter table contact_address_map
- add constraint cam_to_address
- foreign key (address_id)
- references address;
Advertisement
Add Comment
Please, Sign In to add comment