podoc:contact_info_sql_table
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) );
References tables
Is referenced by tables
None.
Related sequences
Related indexes
Related functions
None.
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, '', '', '');
podoc/contact_info_sql_table.1177071441.txt.gz · Last modified: 2007/04/20 12:17 by Luud