podoc:state_sql_table
Database Table Description of "state"
Name
state
Description
Purpose
Schema
CREATE TABLE state ( identifier INTEGER NOT NULL PRIMARY KEY, code VARCHAR(5), VALUE VARCHAR(40) );
References tables
None.
Is referenced by tables
- contact_info(state) references identifier
- location(state) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
CREATE TABLE state ( identifier INTEGER NOT NULL PRIMARY KEY, code VARCHAR(5), VALUE VARCHAR(40) );
Data change history
= Version 2.5 =
INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'AL', 'Alabama'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'AK', 'Alaska'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'AZ', 'Arizona'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'AR', 'Arkansas'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'CA', 'California'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'CO', 'Colorado'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'CT', 'Connecticut'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'DE', 'Delaware'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'DC', 'District of Columbia'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'FL', 'Florida'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'GA', 'Georgia'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'HI', 'Hawaii'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'ID', 'Idaho'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'IL', 'Illinois'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'IN', 'Indiana'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'IA', 'Iowa'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'KS', 'Kansas'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'KY', 'Kentucky'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'LA', 'Louisiana'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'ME', 'Maine'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MD', 'Maryland'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MA', 'Massachusetts'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MI', 'Michigan'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MN', 'Minnesota'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MS', 'Mississippi'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MO', 'Missouri'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MT', 'Montana'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NE', 'Nebraska'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NV', 'Nevada'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NH', 'New Hampshire'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NJ', 'New Jersey'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NM', 'New Mexico'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NY', 'New York'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'NC', 'North Carolina'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'ND', 'North Dakota'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'OH', 'Ohio'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'OK', 'Oklahoma'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'OR', 'Oregon'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'PA', 'Pennsylvania'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'RI', 'Rhode Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'SC', 'South Carolina'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'SD', 'South Dakota'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'TN', 'Tennessee'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'TX', 'Texas'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'UT', 'Utah'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'VT', 'Vermont'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'VA', 'Virginia'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'WA', 'Washington'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'WV', 'West virginia'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'WI', 'Wisconsin'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'WY', 'Wyoming'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'AS', 'American Samoa'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'GU', 'Guam'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MP', 'Northern Mariana Islands'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'PR', 'Puerto Rico'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'VI', 'Virgin Islands'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'FM', 'Federal States of Micronesia'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'UM', 'United States Minor Outlying Islands'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '67', 'Johnston Atoll'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'MH', 'Marshall Islands'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), 'PW', 'Palau'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Midway Islands'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Navassa Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Wake Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Baker Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Howland Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Jarvis Island'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Kingman Reef'); INSERT INTO state VALUES (NEXTVAL('state_id_sequence'), '', 'Palmyra Atoll');
podoc/state_sql_table.txt · Last modified: 2007/04/20 13:39 by Luud