Photo Organizer

contact_info

Contact information for the individual users.

It's split out from the main 'users' table to keep that schema simpler.

CREATE TABLE contact_info (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  address1              VARCHAR(100),
  address2              VARCHAR(100),
  city                  VARCHAR(100),
  zipcode               VARCHAR(10),
  state                 INTEGER REFERENCES state(identifier),
  country               INTEGER REFERENCES country(identifier),
  phone                 VARCHAR(40),
  email                 VARCHAR(150),
  url                   VARCHAR(150)
);

• country references country(identifier)
• state references state(identifier)

• users(contact) references identifier

• contact_info_id_sequence

• contact_info_idx

None.

• view_contact_info

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE contact_info (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  address1              VARCHAR(100),
  address2              VARCHAR(100),
  city                  VARCHAR(100),
  zipcode               VARCHAR(10),
  state                 INTEGER REFERENCES state(identifier),
  country               INTEGER REFERENCES country(identifier),
  phone                 VARCHAR(40),
  email                 VARCHAR(150),
  url                   VARCHAR(150)
);

= Version 2.5 =

INSERT INTO contact_info VALUES (1, '', '', '', '', NULL, NULL, '', '', '');