Guest User

Untitled

a guest
Feb 21st, 2013
222
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table contact (
  2.     id int8 not null unique,
  3.     first_name varchar(100),
  4.     last_name varchar(100),
  5.     email varchar(200) not null unique,
  6.     -- extraneous columns removed, total columns: 34
  7.     primary key (id)
  8. );
  9. create table address (
  10.     id int8 not null unique,
  11.     city varchar(255),
  12.     line1 varchar(255),
  13.     line2 varchar(255),
  14.     state varchar(255),
  15.     country varchar(255) not null,
  16.     postal_code varchar(255),
  17.     primary key (id)
  18. );
  19. create table contact_address_map (
  20.     contact id int8 not null,
  21.     address_id int8 not null,
  22.     unique (address_id)
  23. );
  24.  
  25. alter table contact_address_map
  26.     add constraint cam_to_contact
  27.     foreign key (contact_id)
  28.     references contact;
  29.  
  30. alter table contact_address_map
  31.     add constraint cam_to_address
  32.     foreign key (address_id)
  33.     references address;
Advertisement
Add Comment
Please, Sign In to add comment