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 |