Contains normalized category inheritance translation information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| ctg_index* | INT | Category identifier |
| fl_str_hierarchy | NVARCHAR (MAX) | Translated positional long category name in a hierarchical structure |
| language_id* | VARCHAR (6) | Translation Language Identifier |
Primary Key
| PK_ASDK_CATEGORY_HIERARCHY |
|---|
| ctg_index, language_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| ctg_index* | dbo.ASDK_CATEGORY | ctg_index | FK01_ASDK_CATEGORY_HIERARCHY |
| language_id* | Bod. ASMS_LANGUAGE | id | FK02_ASDK_CATEGORY_HIERARCHY |