Database Table: STATEPROV

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

Column Name Column Type Column Description
COUNTRYABBR CHARACTER (5)
NULL
Country or region abbreviation code for the country or region. The country or region name is stored in the COUNTRY table.
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)
NULL
Name of the State or Province in the Language identified by the LANGUAGE_ID.
STATEPROVABBR CHARACTER (20)
NOT NULL
Unique string to identify the State or Province.
Indexes:
Index Name Indexed Column Names Index Type
I0000340 LANGUAGE_ID, NAME Non-Unique Index
I0000341 LANGUAGE_ID, NAME, COUNTRYABBR Non-Unique Index
SQL030416035108420 STATEPROVABBR, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_758 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable