Categories Platforms
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| categories_platforms/categories_platforms_yyyy_MM_dd.csv | :white_check_mark: | :white_check_mark: | Daily |
📘 If there is no
PUBLISH_STARTorPUBLISH_ENDdates set then only thePUBLISHEDflag should be used to determine if a Category is published on a platform
| Attribute | Required? | Value | Description |
|---|---|---|---|
| ID | Yes | NUMBER | Unique identifier of entity |
| PLATFORM_ID | Yes | NUMBER | Foreign key for Platforms |
| SECTION_ID | NUMBER | Can be used for external CMS mapping | |
| CATEGORY_ID | Yes | NUMBER | Foreign key for Categories |
| NAME | VARCHAR2(100 BYTE) | Name of category | |
| PRIORITY | Yes | NUMBER | Used for category sorting. A negative number indicates a rejected / deleted channel |
| PUBLISHED | Yes | 0 or 1 | Flag if category has been published or not on platform |
| SEARCHABLE | 0 or 1 | Flag if category should be searchable through API | |
| SHARABLE | 0 or 1 | Flag clients can use as hint if content should be sharable or not | |
| UPDATE_TIME | DATE | ||
| PUBLISH_START | DATE | Used for scheduled publishing / access control, to ensure Category is only available in range between start and end | |
| PUBLISH_END | DATE | Used for scheduled publishing / access control, to ensure Category is only available in range between start and end | |
| PUBLISHING_REGION_NAME | VARCHAR2 |