CSO_CONTENT_REC
This table is used to track content recommendations that have been submitted to request new content to be created.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_CONTENT_REC_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SITE_ID | VARCHAR2 | 32 | Yes | The repository associated with the request. | |
| CASE_NUMBER | VARCHAR2 | 255 | An external identifier associated with the recommendation request. | ||
| COMMENTS | CLOB | This is the user provided comment regarding the recommendation. | |||
| COMPLETED_USER_ID | VARCHAR2 | 32 | This is the obsolete GUID for the userinformation record of the user that completed the recommendation. | ||
| COMPLETED_USER_NAME | VARCHAR2 | 255 | De-normalized user name for the user that completed the content recommendation. | ||
| CONTENT_CHANNEL_ID | VARCHAR2 | 32 | This is the Reference to content channel record. | ||
| CONTENT_ID | VARCHAR2 | 32 | This is the Reference to content 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. | ||
| PRIORITY | NUMBER | This is the user assigned priority for completing the recommendation. Valid values: 0=low; 1=medium; 2=high | |||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| REQUEST_USER_ID | VARCHAR2 | 32 | This is the obsolete GUID of the user that made the recommendation. | ||
| REQUEST_USER_NAME | VARCHAR2 | 255 | De-normalized name of the user that made the recommendation. | ||
| STATUS | NUMBER | The status of the recommendation. Valid values: 1= new; 2=rejected duplicate; 3=rejected not enough info; 4=rejected unsuitable; 5=rejected other; 6=content created. | |||
| TASK_ID | VARCHAR2 | 32 | This is the GUID to the task that was created as a result of the recommendation. | ||
| TITLE | VARCHAR2 | 1000 | This is the title of the recommendation. | ||
| STATUS_COMMENTS | VARCHAR2 | 4000 | This is the user comments associated with the recommendation status. | ||
| LOCALE_ID | VARCHAR2 | 32 | This is the Reference to locale table record. | ||
| COMPLETED_USER_PARTY_ID | NUMBER | 18 | This is the ID of the user that completed the recommendation. | ||
| REQUEST_USER_PARTY_ID | NUMBER | 18 | This is the ID of the user that made the recommendation. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_CONTENT_REC | cso_content | CONTENT_ID |
| cso_content_rec_tag | cso_content_rec | RECOMMENDATION_ID |
| cso_cr_site | cso_content_rec | RECOMMENDATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_CONTENT_REC_N1 | Non Unique | Default | CONTENT_CHANNEL_ID |
| CSO_CONTENT_REC_N2 | Non Unique | Default | CONTENT_ID |
| CSO_CONTENT_REC_N3 | Non Unique | Default | SITE_ID |
| CSO_CONTENT_REC_U1 | Unique | Default | RECORD_ID |