state

CREATE TABLE state (
  identifier            integer NOT NULL PRIMARY KEY,
  code                  varchar(5),
  value                 varchar(40)
);

None.

• contact_info(state) references identifier
• location(state) references identifier

• state_id_sequence

None.

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE state (
  identifier            integer NOT NULL PRIMARY KEY,
  code                  varchar(5),
  value                 varchar(40)
);

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