Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce 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 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030430490 STATEPROVABBR+LANGUAGE_ID Primary Key I0000340 LANGUAGE_ID+NAME Non-Unique Index I0000341 LANGUAGE_ID+NAME+COUNTRYABBR Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_758 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_