Photo Organizer

This is an old revision of the document!

Database Table Description of "contact_info"

Name

contact_info

Description

Contact information for the individual users.

Purpose

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

Schema

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

Related sequences

contact_info_id_sequence

Related indexes

contact_info_idx

Related functions

Related views

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= 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)
);

Data change history

= Version 2.5 =

insert into contact_info values (1, '', '', '', '', null, null, '', '', '');