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. |
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 |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_758 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|