Categories
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| categories/categories_yyyy_MM_dd.csv | :white_check_mark: | :white_check_mark: | Daily |
| Attribute | Required? | Value | Description |
|---|---|---|---|
| CATEGORY_ID | Yes | NUMBER | Unique id of category |
| ASSET_TYPE_ID | NUMBER | Foreign key for Asset Types. Assets are linked to content categories through asset type | |
| PRIORITY | Yes | NUMBER | Sets the sort index of the category |
| PARENT_ID | NUMBER | Foreign key for Categories. References the parent category | |
| SECTION_ID | NUMBER | When external CMS is used for content curation, SECTION_ID holds a reference to the external content curated for this category | |
| LEVEL_TYPE_ID | NUMBER | Foreign key for CATEGORY_LEVEL_TYPE.Indicates which level in the tree this node belongs to. Defaults to: 1 TOP_LEVEL 2 MAIN_CATEGORY 3 CATEGORY 4 UNKNOWN 5 UNKNOWN 6 SHOW 7 SHOW 8 SHOW 9 EXTRAS 10 SHOW 11 SHOW 12 SUB_SHOW | |
| LEVEL_TYPE | VARCHAR2 | Name of level as described above | |
| FREE_LABEL | 0 or 1 | Can be set to true to indicate to the front-end that the content is free | |
| FAVORITABLE | 0 or 1 | Indicates if this category should be possible to mark as a favorite | |
| UPDATE_TIME | DATE | ||
| CREATE_TIME | DATE | ||
| APPROVAL_STATUS | VARCHAR2 | NEW, APPROVED, APPROVED_CHANGED, APPROVED_CHANGE_REJECTED, REJECTED_CHANGED, REJECTED | |
| ACTIVATION_STATUS | VARCHAR2 | ACTIVE, DEACTIVATED | |
| ASSET_SORT_BY | VARCHAR2 | publishdate desc, publishdate asc, episode asc, episode desc | |
| REJECTION_MESSAGE | VARCHAR2 | A message from Admin to Publisher describing why the category (or category change) was rejected. | |
| TENANT_ID | NUMBER | Foreign key for Tenants |