ATK_KR_TOPICS
An individual instance of a title document, for a particular industry, localization(s), release, and language.
Details
-
Schema: FUSION
-
Object owner: ATK
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ATK_KR_TOPICS_PK |
TOPIC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | Tenant enterprise Id | |
| TOPIC_ID | VARCHAR2 | 150 | Yes | Unique generated primary key for the topic. | |
| ORIG_TITLE | VARCHAR2 | 150 | Yes | The title that this topic is an instance of. | |
| TITLE | VARCHAR2 | 4000 | Yes | Title of the topic. | |
| TOPIC_TYPE | VARCHAR2 | 20 | Yes | TOPIC_TYPE | |
| FILE_TYPE | VARCHAR2 | 20 | FILE_TYPE | ||
| DOCUMENT | BLOB | DOCUMENT | |||
| MIME_TYPE | VARCHAR2 | 128 | MIME_TYPE | ||
| ABSTRACT_SUMMARY | VARCHAR2 | 4000 | Yes | ABSTRACT | |
| SOURCE | VARCHAR2 | 20 | Yes | SOURCE | |
| CHANGED | TIMESTAMP | Yes | CHANGED | ||
| HIDDEN | VARCHAR2 | 1 | Yes | HIDDEN | |
| OBSOLETE | VARCHAR2 | 1 | Yes | Marked as 1 when Topic is obsoleted. | |
| ISO_LANGUAGE | VARCHAR2 | 30 | Yes | ISO_LANGUAGE | |
| RELEASE | VARCHAR2 | 4000 | Yes | RELEASE | |
| INDUSTRY_ID | NUMBER | INDUSTRY_ID | |||
| NEW_FEATURE | VARCHAR2 | 1 | NEW_FEATURE | ||
| FILE_NAME | VARCHAR2 | 2000 | FILE_NAME | ||
| URL | VARCHAR2 | 4000 | URL | ||
| UPK_READONLY_URL | VARCHAR2 | 4000 | UPK_READONLY_URL | ||
| UPK_TOPIC_GUID | VARCHAR2 | 4000 | UPK_TOPIC_GUID | ||
| UPK_TOPIC_NAME | VARCHAR2 | 2000 | UPK_TOPIC_NAME | ||
| UPK_TOPIC_URL | VARCHAR2 | 4000 | UPK_TOPIC_URL | ||
| TOP_TOPIC_COUNT | NUMBER | TOP_TOPIC_COUNT | |||
| PRIMARY_HIERARCHY_TYPE | VARCHAR2 | 20 | Yes | PRIMARY_HIERARCHY_TYPE | |
| PRIMARY_LEVEL1_ID | VARCHAR2 | 20 | Yes | PRIMARY_LEVEL1_ID | |
| PRIMARY_LEVEL2_ID | VARCHAR2 | 20 | PRIMARY_LEVEL2_ID | ||
| PRIMARY_LEVEL3_ID | VARCHAR2 | 20 | PRIMARY_LEVEL3_ID | ||
| PRIMARY_LEVEL4_ID | VARCHAR2 | 20 | PRIMARY_LEVEL4_ID | ||
| PRIMARY_LEVEL5_ID | VARCHAR2 | 20 | PRIMARY_LEVEL5_ID | ||
| PRIMARY_LEVEL6_ID | VARCHAR2 | 20 | PRIMARY_LEVEL6_ID | ||
| SEARCH_IDS | VARCHAR2 | 4000 | Yes | HIERARCHY_IDS | |
| INDEX_TERMS | VARCHAR2 | 4000 | Yes | INDEX_TERMS | |
| SEARCH_INDEXES | VARCHAR2 | 4000 | Yes | SES_INDEX_TERMS | |
| SEARCH_TERRITORIES | VARCHAR2 | 4000 | TERRITORY_CODES | ||
| SEARCH_RELEASES | VARCHAR2 | 4000 | Yes | RELEASES | |
| SEARCH_HELPKEYS | VARCHAR2 | 4000 | SEARCH_HELPKEYS | ||
| SEARCH_INDUSTRIES | VARCHAR2 | 4000 | INDUSTRIES | ||
| SECURITY_CODE | VARCHAR2 | 20 | A user definable security code that can be configured to support data security on help topics. | ||
| GETTING_STARTED | VARCHAR2 | 1 | Flag to determine whether the topic is a getting started topic or not. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ATK_KR_TOPICS | atk_kr_titles | ORIG_TITLE |
| atk_kr_srch_topics_hier | atk_kr_topics | TOPIC_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ATK_KR_TOPICS_N1 | Non Unique | FUSION_TS_TX_DATA | ORIG_TITLE |
| ATK_KR_TOPICS_N2 | Non Unique | FUSION_TS_TX_DATA | ISO_LANGUAGE |
| ATK_KR_TOPICS_N3 | Non Unique | Default | DOCUMENT |
| ATK_KR_TOPICS_N4 | Non Unique | Default | UPPER("TITLE") |
| ATK_KR_TOPICS_PK | Unique | FUSION_TS_TX_DATA | TOPIC_ID, ORA_SEED_SET1 |
| ATK_KR_TOPICS_PK1 | Unique | FUSION_TS_TX_DATA | TOPIC_ID, ORA_SEED_SET2 |