CSO_CONTENT_HISTORY
This table contains the version history of a content record. The number of records in the history is determined by settings in the Content Channel setup.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_CONTENT_HISTORY_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTENT_ID | VARCHAR2 | 32 | This is the Reference to content table record. | ||
| CONTENT_TEXT_ID | VARCHAR2 | 32 | Yes | This is the Reference to content text table record. | |
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime that the record was added to the repository. | ||
| DATE_MODIFIED | TIMESTAMP | Yes | This is the datetime that the record was modified. | ||
| DESC_LOOKUP_CODE_ID | VARCHAR2 | 32 | This is the type of comment or user action that caused the history record to be recorded, i.e. APPROVED, REJECTED. Reference to LOOKUP_CODE table. | ||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| USER_INFORMATION_ID | VARCHAR2 | 32 | The obsolete GUID of the user associated with this history record. | ||
| COMMENTS | VARCHAR2 | 2000 | This is the user provided comment about the change recorded. | ||
| USER_NAME | VARCHAR2 | 100 | De-normalized username associated with the user login. | ||
| WORKFLOW_NAME | VARCHAR2 | 1000 | De-normalized reference key name of the workflow associated with the change. | ||
| WORKFLOW_STEP_ID | VARCHAR2 | 32 | This is the GUID reference to workflow step that caused the change. | ||
| METADATA | VARCHAR2 | 2000 | This is additional information provided by the client to add context to this history item. | ||
| WORKFLOW_STEP_NAME | VARCHAR2 | 1000 | De-normalized reference key name of workflow step that caused the change. | ||
| PREVIOUS_WORKFLOW_STEP_ID | VARCHAR2 | 32 | This is the GUID reference to the previous workflow step. | ||
| USER_PARTY_ID | NUMBER | 18 | The ID of the user associated with this history record. | ||
| TASK_ASSIGNEE_PARTY_ID | NUMBER | 18 | This is the id of the user who is assigned to this workflow task. | ||
| TASK_OWNER_PARTY_ID | NUMBER | 18 | This is the id of the user who is the owner of this workflow task. | ||
| ANSWER_ID | NUMBER | This is the answerid for the referenced article. | |||
| WORKFLOW_INSTANCE_ID | VARCHAR2 | 32 | This is the unique id for workflow instance. | ||
| EXTERNAL_TASK_IDENTIFIER | VARCHAR2 | 64 | This is the unique id for external task reference associated with this history item. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_CONTENT_HISTORY | cso_content_text | CONTENT_TEXT_ID |
| CSO_CONTENT_HISTORY | cso_content | CONTENT_ID |
| CSO_CONTENT_HISTORY | cso_lookup_code | DESC_LOOKUP_CODE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_CONTENT_HISTORY_N1 | Non Unique | Default | CONTENT_ID |
| CSO_CONTENT_HISTORY_N2 | Non Unique | Default | CONTENT_TEXT_ID |
| CSO_CONTENT_HISTORY_N3 | Non Unique | Default | DESC_LOOKUP_CODE_ID |
| CSO_CONTENT_HISTORY_N4 | Non Unique | Default | WORKFLOW_STEP_ID |
| CSO_CONTENT_HISTORY_N5 | Non Unique | Default | USER_PARTY_ID |
| CSO_CONTENT_HISTORY_N6 | Non Unique | Default | EXTERNAL_TASK_IDENTIFIER |
| CSO_CONTENT_HISTORY_N7 | Non Unique | Default | ANSWER_ID, WORKFLOW_INSTANCE_ID |
| CSO_CONTENT_HISTORY_U1 | Unique | Default | RECORD_ID |