STATEPROV

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

Column Descriptions:

NameTypeDescription
STATEPROVABBRCHAR (20) NOT NULLUnique string to identify the State or Province. Sample values are for demonstration purposes only.
LANGUAGE_IDINTEGER NOT NULLThe Language ID that identifies the Language. Foreign key that references the LANGUAGE_ID column in the LANGUAGE table.
NAMEVARCHAR (254)Name of the State or Province in the Language identified by the LANGUAGE_ID.
COUNTRYABBRCHAR (5)Country or region abbreviation code for the country or region. The country or region name is stored in the COUNTRY table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STATEPROVABBR+LANGUAGE_IDPrimary Key
I0000340LANGUAGE_ID+NAMENon-Unique Index
I0000341LANGUAGE_ID+NAME+COUNTRYABBRNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_758LANGUAGE_IDLANGUAGELANGUAGE_IDCascade