You are here:
ccdl_product_category
Contains category hierarchy information within catalogs. Each record represents a category with its parent relationship and metadata.
Default refresh frequency: Daily.
Primary Key: (catalogId, categoryId).
Column Reference
| Column Name | Data Type | Description |
|---|---|---|
| catalogId | Text | Parent catalog identifier |
| categoryId | Text | Unique category identifier |
| createdDate | Date | Record creation timestamp |
| description | Text | Category description |
| displayName | Text | Display name of the category |
| modifiedDate | Date | Last modification timestamp |
| name | Text | Category name |
| parentCategoryId | Text | Parent category identifier for hierarchy |
| rootCategory | Boolean | Whether this is a root category |
| tenantId | Text | Tenant identifier |
| validFrom | Date | Category availability start date |
| validTo | Date | Category availability end date |
| version | Text | Schema version identifier |

