Stores information about topics configured in the ATG Search Workbench.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | smallint | No | Identifier; primary key. | |
NTOPIC_ID | varchar | 40 | No | Natural key of topic. |
PARENT_TOPIC_ID | integer | Yes | ID of parent topic from this table. | |
NAME | varchar | 254 | No | Topic name in the default language. |
NAME_EN | varchar | 254 | Yes | Topic name in English. |
DESCRIPTION | varchar | 1000 | Yes | Topic description in the default language. |
DESCRIPTION_EN | varchar | 1000 | Yes | Topic description in English. |
RECORD_START_DATE | timestamp | Yes | Date when the information in this warehouse record became effective | |
RECORD_END_DATE | timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
RECORD_LAST_UPDATE | timestamp | Yes | Date this re | |
MOST_RECENT | one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes Default value is 1. | |
DELETED | one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes Default value is 0. | |
TOPIC_PATH | varchar | 4000 | Yes | Path to this topic in the topic taxonomy. |