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, '', '', '');