STATEPROV

This table lists State and Province names (by country or region) in each of the supported Languages identified by LANGUAGE_ID.

Column Descriptions:

Name	Type	Description
STATEPROVABBR	CHAR (20) NOT NULL	Unique string to identify the State or Province. Sample values are for demonstration purposes only.
LANGUAGE_ID	INTEGER NOT NULL	The Language ID that identifies the Language. Foreign key that references the LANGUAGE_ID column in the LANGUAGE table.
NAME	VARCHAR (254)	Name of the State or Province in the Language identified by the LANGUAGE_ID.
COUNTRYABBR	CHAR (5)	Country or region abbreviation code for the country or region. The country or region name is stored in the COUNTRY table.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	STATEPROVABBR+LANGUAGE_ID	Primary Key
I0000340	LANGUAGE_ID+NAME	Non-Unique Index
I0000341	LANGUAGE_ID+NAME+COUNTRYABBR	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_758	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade

Related reference
Country and state code data model