CSO_ARTICLE_STATS
This table will be populated hourly and daily from cso_stg_article_view. In the future we plan to add counts from ratings and recommendations. Hourly rollup will be deleted at the end of every day once the day ends. At the end of every month, older daily rollup data will be purged.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSO_ARTICLE_STATS_PK |
ARTICLE_STATS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ARTICLE_STATS_ID | NUMBER | 18 | Yes | Primary key of the table. Populated by sequence number. | |
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. | |
INTERFACE_ID | NUMBER | 18 | The unique ID for the interface. Will be used to identify an HR view from a Service view. | ||
ANSWER_ID | NUMBER | Yes | A way to uniquely identify an article by locale ID and content ID. | ||
ARTICLE_VIEW_COUNT | NUMBER | 18 | The article view count based on answer ID. | ||
CASELINK_COUNT | NUMBER | 18 | The number of caselinks based on answer ID. | ||
PUBLISHED_COUNT | NUMBER | 18 | The number of articles published based on answer ID. | ||
RATING_COUNT | NUMBER | 18 | The article rating count based on answer ID. | ||
RATING_01_COUNT | NUMBER | 18 | The article rating count with a value of one based on answer ID. | ||
RATING_02_COUNT | NUMBER | 18 | The article rating count with a value of two based on answer ID. | ||
RATING_03_COUNT | NUMBER | 18 | The article rating count with a value of three based on answer ID. | ||
RATING_04_COUNT | NUMBER | 18 | The article rating count with a value of four based on answer ID. | ||
RATING_05_COUNT | NUMBER | 18 | The article rating count with a value of five based on answer ID. | ||
THUMBS_UP_COUNT | NUMBER | 18 | The article rating count with a value of thumbs up based on answer ID. | ||
THUMBS_DOWN_COUNT | NUMBER | 18 | The article rating count with a value of thumbs down based on answer ID. | ||
RATING_SUM | NUMBER | 18 | The article rating sum based on answer ID. | ||
VERSION_COUNT | NUMBER | 18 | The number of versions based on answer ID. | ||
STAT_DATE | DATE | Yes | The date the stats occurred in DDMMYYYY format. | ||
STAT_HOUR | NUMBER | 9 | Yes | Applicable for window=1 and represents the HOUR of the DAY for which the data belongs to. | |
WINDOW | NUMBER | 1 | Yes | 1-hourly, 2-daily, 3-monthly (rollup strategy). |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSO_ARTICLE_STATS_PK | Unique | Default | ARTICLE_STATS_ID |
CSO_ARTICLE_STATS_U1 | Unique | Default | ANSWER_ID, INTERFACE_ID, STAT_DATE, STAT_HOUR, WINDOW |