LANGUAGE
Each row of this table represents a language. HCL Commerce supports multiple languages and is translated into ten languages by default. Using the predefined ISO codes users can add other supported languages.
Column Descriptions:
Name | Type | Description |
---|---|---|
LANGUAGE_ID | INTEGER NOT NULL | The language ID (primary key of this table) for each language. Foreign key to the tables that contain language-dependent information. The following is the list of language components (language ID codes) of the locale: -1 = English (US) -2 = French -3 = German -4 = Italian -5 = Spanish -6 = Brazilian Portuguese -7 = Simplified Chinese -8 = Traditional Chinese -9 = Korean -10 = Japanese -20 = Russian -21 = Romanian -22 = Polish |
LOCALENAME | CHAR (16) NOT NULL | A Java locale used to represent a political, geographical, or cultural region that has a distinct language and customs. The following is the list of locale used for formatting: en_US = United States fr_FR = France de_DE = Germany it_IT = Italy es_ES = Spain pt_BR = Brazil zh_CN = China zh_TW = Taiwan ko_KR = Korea ja_JP = Japan ru_RU = Russian ro_RO = Romanian pl_PL = Polish |
LANGUAGE | CHAR (5) | Language component of the locale.
NOTE: A value must be entered for this column:
en = English (US)
fr = French
de = German
it = Italian
es = Spanish
pt = Brazilian Portuguese
zh = Simplified Chinese
zh = Traditional Chinese
ko = Korean
ja = Japanese
ru = Russian
ro = Romanian
pl = Polish
To choose another language component, refer to the existing
ISO codes. |
COUNTRY | CHAR (5) | Country or region component of the locale. NOTE: A value must be entered for this column: US = United States FR = France DE = Germany IT = Italy ES = Spain BR = Brazil CN = China TW = Taiwan KR = Korea JP = Japan RU = Russia RO = Romania PL = Poland To choose another country or region, refer to the existing ISO codes. |
VARIANT | CHAR (10) | Variant component of the locale. Used to specify the locale encoding character set or to further segregate a distinct formatting custom for a political, geographical, or cultural region. |
ENCODING | VARCHAR (32) | The character encoding value that the browser uses to display the page in the selected language. |
MIMECHARSET | VARCHAR (32) | The MIME character encoding value that the notification system uses to encode a message for the selected language. |
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> | LANGUAGE_ID | Primary Key |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
---|---|---|---|---|
F_1 | LANGUAGE_ID | ACACGPDESC | LANGUAGE_ID | Cascade |
F_1008 | LANGUAGE_ID | ACPLGPDESC | LANGUAGE_ID | Cascade |
F_1029 | LANGUAGE_ID | ROLEDESC | LANGUAGE_ID | Cascade |
F_1031 | LANGUAGE_ID | MBRGRPDESC | LANGUAGE_ID | Cascade |
F_109 | LANGUAGE_ID | BASEITMDSC | LANGUAGE_ID | Cascade |
F_1106 | LANGUAGE_ID | ATCHTGTDSC | LANGUAGE_ID | Cascade |
F_1112 | LANGUAGE_ID | ATCHASTLG | LANGUAGE_ID | Cascade |
F_1117 | LANGUAGE_ID | ATCHRELDSC | LANGUAGE_ID | Cascade |
F_1121 | LANGUAGE_ID | ATCHRLUSDS | LANGUAGE_ID | Cascade |
F_1124 | LANGUAGE_ID | CMFWKSPCDSC | LANGUAGE_ID | Cascade |
F_1126 | LANGUAGE_ID | CMFTGDSC | LANGUAGE_ID | Cascade |
F_1132 | LANGUAGE_ID | CMFTASKDSC | LANGUAGE_ID | Cascade |
F_1165 | LANGUAGE_ID | CCOMMENT | LANGUAGE_ID | Cascade |
F_1167 | LANGUAGE_ID | BUSCHNDESC | LANGUAGE_ID | Cascade |
F_1187 | LANGUAGE_ID | DKPDCDESC | LANGUAGE_ID | Cascade |
F_1194 | LANGUAGE_ID | TICKLER | LANGUAGE_ID | Cascade |
F_1200 | LANGUAGE_ID | TKLACTHIST | LANGUAGE_ID | Cascade |
F_1204 | LANGUAGE_ID | TKLRACTDSC | LANGUAGE_ID | Cascade |
F_1207 | LANGUAGE_ID | TKLRRSNDSC | LANGUAGE_ID | Cascade |
F_1222 | LANGUAGE_ID | BLKRSNDESC | LANGUAGE_ID | Cascade |
F_1234 | LANGUAGE_ID | PRCORSNDSC | LANGUAGE_ID | Cascade |
F_158 | LANGUAGE_ID | CALCODEDSC | LANGUAGE_ID | Cascade |
F_180 | LANGUAGE_ID | CALSCALEDS | LANGUAGE_ID | Cascade |
F_184 | LANGUAGE_ID | CATALOGDSC | LANGUAGE_ID | Cascade |
F_195 | LANGUAGE_ID | CATENTATTR | LANGUAGE_ID | Cascade |
F_197 | LANGUAGE_ID | CATENTDESC | LANGUAGE_ID | Cascade |
F_218 | LANGUAGE_ID | CATGRPATTR | LANGUAGE_ID | Cascade |
F_220 | LANGUAGE_ID | CATGRPDESC | LANGUAGE_ID | Cascade |
F_237 | LANGUAGE_ID | CHRGTYPDSC | LANGUAGE_ID | Cascade |
F_242 | LANGUAGE_ID | CLSFCODEDS | LANGUAGE_ID | Cascade |
F_250 | LANGUAGE_ID | COLLDESC | LANGUAGE_ID | Cascade |
F_257 | LANGUAGE_ID | COUNTRY | LANGUAGE_ID | Cascade |
F_269 | LANGUAGE_ID | CPPMNDESC | LANGUAGE_ID | Cascade |
F_28 | LANGUAGE_ID | ACPOLDESC | LANGUAGE_ID | Cascade |
F_290 | LANGUAGE_ID | CURFMTDESC | LANGUAGE_ID | Cascade |
F_297 | LANGUAGE_ID | DISPCGPREL | LANGUAGE_ID | Cascade |
F_302 | LANGUAGE_ID | DISPENTREL | LANGUAGE_ID | Cascade |
F_315 | LANGUAGE_ID | FFMCENTDS | LANGUAGE_ID | Cascade |
F_321 | LANGUAGE_ID | FLDOMNDESC | LANGUAGE_ID | Cascade |
F_329 | LANGUAGE_ID | FLOWDESC | LANGUAGE_ID | Cascade |
F_337 | LANGUAGE_ID | FLSTDCTDSC | LANGUAGE_ID | Cascade |
F_339 | LANGUAGE_ID | FLSTGPDSC | LANGUAGE_ID | Cascade |
F_341 | LANGUAGE_ID | FLTRANSDSC | LANGUAGE_ID | Cascade |
F_347 | LANGUAGE_ID | FLTYPEDESC | LANGUAGE_ID | Cascade |
F_35 | LANGUAGE_ID | ACRELDESC | LANGUAGE_ID | Cascade |
F_3517 | LANGUAGE_ID | ATTRDICTGRPDESC | LANGUAGE_ID | Cascade |
F_3549 | LANGUAGE_ID | PX_DESCRIPTION | LANGUAGE_ID | Cascade |
F_3558 | LANGUAGE_ID | ATTRDESC | LANGUAGE_ID | Cascade |
F_3561 | LANGUAGE_ID | ATTRVALDESC | LANGUAGE_ID | Cascade |
F_3571 | LANGUAGE_ID | STLOCATTR | LANGUAGE_ID | Cascade |
F_3573 | LANGUAGE_ID | STLOCDS | LANGUAGE_ID | Cascade |
F_3575 | LANGUAGE_ID | GEONDDS | LANGUAGE_ID | Cascade |
F_358 | LANGUAGE_ID | ICCONSTVAL | LANGUAGE_ID | Cascade |
F_360 | LANGUAGE_ID | ICEXPLDESC | LANGUAGE_ID | Cascade |
F_364 | LANGUAGE_ID | ICKNOWDESC | LANGUAGE_ID | Cascade |
F_3665 | LANGUAGE_ID | CATFLTDSC | LANGUAGE_ID | Cascade |
F_367 | LANGUAGE_ID | ICMERDESC | LANGUAGE_ID | Cascade |
F_3683 | LANGUAGE_ID | CLSATTRSRCHCONF | LANGUAGE_ID | Cascade |
F_3685 | LANGUAGE_ID | CFCONDVAL | LANGUAGE_ID | Cascade |
F_3687 | LANGUAGE_ID | SRCHTERMASSOC | LANGUAGE_ID | Cascade |
F_3699 | LANGUAGE_ID | SEOPAGEDEFDESC | LANGUAGE_ID | Cascade |
F_3706 | LANGUAGE_ID | SEOURLKEYWORD | LANGUAGE_ID | Cascade |
F_3709 | LANGUAGE_ID | SRCHCONFEXT | LANGUAGE_ID | Cascade |
F_3722 | LANGUAGE_ID | CATENTDESCOVR | LANGUAGE_ID | Cascade |
F_3738 | LANGUAGE_ID | FACETDESC | LANGUAGE_ID | Cascade |
F_3743 | LANGUAGE_ID | COLLIMGMAPAREA | LANGUAGE_ID | Cascade |
F_3745 | LANGUAGE_ID | SRCHATTRDESC | LANGUAGE_ID | Cascade |
F_3748 | LANGUAGE_ID | PLWIDGETDEFDESC | LANGUAGE_ID | Cascade |
F_375 | LANGUAGE_ID | ICMREGDESC | LANGUAGE_ID | Cascade |
F_389 | LANGUAGE_ID | INVADJDESC | LANGUAGE_ID | Cascade |
F_400 | LANGUAGE_ID | INVRSRVDSC | LANGUAGE_ID | Cascade |
F_413 | LANGUAGE_ID | LANGPAIR | LANGUAGE_ID | Cascade |
F_414 | LANGUAGE_ID | LANGPAIR | LANGUAGE_ID_ALT | Cascade |
F_416 | LANGUAGE_ID | LANGUAGEDS | LANGUAGE_ID | Cascade |
F_417 | LANGUAGE_ID | LANGUAGEDS | LANGUAGE_ID_DESC | Cascade |
F_42 | LANGUAGE_ID | ACRESGPDES | LANGUAGE_ID | Cascade |
F_465 | LANGUAGE_ID | NUMBRUSGDS | LANGUAGE_ID | Cascade |
F_471 | LANGUAGE_ID | OFFERDESC | LANGUAGE_ID | Cascade |
F_481 | LANGUAGE_ID | OPERATRDSC | LANGUAGE_ID | Cascade |
F_487 | LANGUAGE_ID | ORDADJDSC | LANGUAGE_ID | Cascade |
F_5 | LANGUAGE_ID | ACACTDESC | LANGUAGE_ID | Cascade |
F_53 | LANGUAGE_ID | ACRLGPDESC | LANGUAGE_ID | Cascade |
F_556 | LANGUAGE_ID | OUTPUTQDSC | LANGUAGE_ID | Cascade |
F_56 | LANGUAGE_ID | ACRSCGDES | LANGUAGE_ID | Cascade |
F_562 | LANGUAGE_ID | PARTROLEDS | LANGUAGE_ID | Cascade |
F_564 | LANGUAGE_ID | PATTRDESC | LANGUAGE_ID | Cascade |
F_574 | LANGUAGE_ID | PAYMTHDDSC | LANGUAGE_ID | Cascade |
F_589 | LANGUAGE_ID | PKGATTR | LANGUAGE_ID | Cascade |
F_591 | LANGUAGE_ID | PKGATTRVAL | LANGUAGE_ID | Cascade |
F_597 | LANGUAGE_ID | PLCYACCDSC | LANGUAGE_ID | Cascade |
F_601 | LANGUAGE_ID | PLCYLCKDSC | LANGUAGE_ID | Cascade |
F_603 | LANGUAGE_ID | PLCYPWDDSC | LANGUAGE_ID | Cascade |
F_606 | LANGUAGE_ID | PLCYTYPDSC | LANGUAGE_ID | Cascade |
F_611 | LANGUAGE_ID | POLICYDESC | LANGUAGE_ID | Cascade |
F_620 | LANGUAGE_ID | PRODSETDSC | LANGUAGE_ID | Cascade |
F_642 | LANGUAGE_ID | QTYFMTDESC | LANGUAGE_ID | Cascade |
F_647 | LANGUAGE_ID | QTYUNITDSC | LANGUAGE_ID | Cascade |
F_71 | LANGUAGE_ID | ATTRIBUTE | LANGUAGE_ID | Cascade |
F_719 | LANGUAGE_ID | RTNDNYDESC | LANGUAGE_ID | Cascade |
F_723 | LANGUAGE_ID | RTNDSPDESC | LANGUAGE_ID | Cascade |
F_732 | LANGUAGE_ID | RTNRSNDESC | LANGUAGE_ID | Cascade |
F_743 | LANGUAGE_ID | SETCURRDSC | LANGUAGE_ID | Cascade |
F_756 | LANGUAGE_ID | SHPMODEDSC | LANGUAGE_ID | Cascade |
F_758 | LANGUAGE_ID | STATEPROV | LANGUAGE_ID | Cascade |
F_76 | LANGUAGE_ID | ATTRVALUE | LANGUAGE_ID | Cascade |
F_777 | LANGUAGE_ID | STORE | LANGUAGE_ID | Cascade |
F_79 | LANGUAGE_ID | AUCTDESC | LANGUAGE_ID | Cascade |
F_793 | LANGUAGE_ID | STOREENTDS | LANGUAGE_ID | Cascade |
F_798 | LANGUAGE_ID | STORELANG | LANGUAGE_ID | Cascade |
F_809 | LANGUAGE_ID | STORLANGDS | LANGUAGE_ID | Cascade |
F_819 | LANGUAGE_ID | TAXCGRYDS | LANGUAGE_ID | Cascade |
F_825 | LANGUAGE_ID | TCDESC | LANGUAGE_ID | Cascade |
F_829 | LANGUAGE_ID | TCSUBTYPDS | LANGUAGE_ID | Cascade |
F_845 | LANGUAGE_ID | TFALGPOLDS | LANGUAGE_ID | Cascade |
F_847 | LANGUAGE_ID | TFALGTYPDS | LANGUAGE_ID | Cascade |
F_849 | LANGUAGE_ID | TFALREGDSC | LANGUAGE_ID | Cascade |
F_851 | LANGUAGE_ID | TFDOMDSC | LANGUAGE_ID | Cascade |
F_857 | LANGUAGE_ID | TFSBDOMDSC | LANGUAGE_ID | Cascade |
F_861 | LANGUAGE_ID | TFTRENGDSC | LANGUAGE_ID | Cascade |
F_873 | LANGUAGE_ID | TRDDESC | LANGUAGE_ID | Cascade |
F_883 | LANGUAGE_ID | TRDTYPEDSC | LANGUAGE_ID | Cascade |
F_897 | LANGUAGE_ID | USERS | LANGUAGE_ID | Cascade |
F_9 | LANGUAGE_ID | ACATTRDESC | LANGUAGE_ID | Cascade |
F_903 | LANGUAGE_ID | VENDORDESC | LANGUAGE_ID | Cascade |
F_909 | LANGUAGE_ID | WCSDTNRYDS | LANGUAGE_ID | Cascade |
F_920 | LANGUAGE_ID | STRELTYPDS | LANGUAGE_ID | Cascade |
F_950 | LANGUAGE_ID | STCGRYDESC | LANGUAGE_ID | Cascade |
F_953 | LANGUAGE_ID | QUEUEDESC | LANGUAGE_ID | Cascade |