CSO_STYLESHEET

This table contains is a container for XSLT style sheets used for transforming content.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_STYLESHEET_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
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.
DEFAULT_FLAG CHAR 1 This has been deprecated from the schema.
LOCALE_ID VARCHAR2 32 Yes The locale associated with the current record.
LOOKUP_CODE_ID VARCHAR2 32 This is the GUID to the lookup code.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
SITE_ID VARCHAR2 32 This is the GUID for the repository that the record belongs to
SUPER_TYPE_CODE_ID VARCHAR2 32 DEPRECATED: A flag indicating (Possible values: HETEROGENEOUS,HOMOGENEOUS,USERREGISTRATION) type of stylesheet. Not used any longer.
XML_SCHEMA_ID VARCHAR2 32 This is the GUID to the XML schema
REFERENCE_KEY VARCHAR2 50 The unique key used to reference the style sheet from the tag library.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_STYLESHEET cso_locale LOCALE_ID
CSO_STYLESHEET cso_lookup_code LOOKUP_CODE_ID
CSO_STYLESHEET cso_site SITE_ID
CSO_STYLESHEET cso_lookup_code SUPER_TYPE_CODE_ID
CSO_STYLESHEET cso_xml_schema XML_SCHEMA_ID
cso_stylesheet_res cso_stylesheet STYLESHEET_ID
cso_site cso_stylesheet USER_REG_STYLESHEET_ID

Indexes

Index Uniqueness Columns
CSO_STYLESHEET_U1 Unique RECORD_ID
CSO_STYLESHEET_N1 Non Unique LOCALE_ID
CSO_STYLESHEET_N2 Non Unique XML_SCHEMA_ID
CSO_STYLESHEET_N3 Non Unique SITE_ID
CSO_STYLESHEET_N4 Non Unique SUPER_TYPE_CODE_ID
CSO_STYLESHEET_N5 Non Unique LOOKUP_CODE_ID