CSO_CONTENT_VALUE
Contains a listing of the XPATHs and values for PUBLISHED content records. This is used in the WHERE clause of the get.channel.data tags. If the size of the value is larger than the maximum column size the string is broken up into segments and stored separately. At runtime the segments are retrieved and concatenated back into a single string
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_CONTENT_VALUE_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| NODE_SEQUENCE | NUMBER | This column is used to reassemble the content for the attribute back into the proper order. The content is broken into chunks during the save process and needs to be re-assembled before being used. | ||
| CONTENT_ID | VARCHAR2 | 32 | Yes | This is the Reference to content table record. |
| CONTENT_TEXTPUB_ID | VARCHAR2 | 32 | Yes | This is the GUID reference to the published CONTENT_TEXTPUB record. |
| DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
| LOCALE_ID | VARCHAR2 | 32 | This is the Reference to locale table record. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| SEQUENCE | NUMBER | Numeric ordering for each segment of a value answer that is greater than the total size of the value column. | ||
| VALUE | VARCHAR2 | 2000 | This field contains the text of the XPATH value for the node. If the string is longer than 2000 characters it is broken down into segments. | |
| XPATH | VARCHAR2 | 255 | Yes | The full XPATH (without the node index) for each entry in the content record. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_CONTENT_VALUE | cso_content | CONTENT_ID |
| CSO_CONTENT_VALUE | cso_content_text_pub | CONTENT_TEXTPUB_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_CONTENT_VALUE_U1 | Unique | RECORD_ID |
| CSO_CONTENT_VALUE_N1 | Non Unique | CONTENT_ID, LOCALE_ID |
| CSO_CONTENT_VALUE_N3 | Non Unique | CONTENT_TEXTPUB_ID |
| CSO_CONTENT_VALUE_N4 | Non Unique | CONTENT_ID, XPATH |
| CSO_CONTENT_VALUE_N5 | Non Unique | XPATH, VALUE, SEQUENCE |