User Tools

Site Tools


podoc:contact_info_sql_table

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

References tables

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

Is referenced by tables

  • users(contact) references identifier

None.

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, '', '', '');
podoc/contact_info_sql_table.txt · Last modified: 2007/04/20 11:32 by Luud