CSO_SCHEMA_ATTRIBUTE
This table contains the content channel attributes that have been configured in each channel.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_SCHEMA_ATTRIBUTE_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ATTRIBUTE_TYPE | VARCHAR2 | 1 | Yes | A flag indicating the type of attribute. Valid values are S=simple attribute and C=complex node. |
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| DISPLAY_ON_FORM | VARCHAR2 | 1 | Yes | Deprecated. Flag indicating whether to display the attribute on the data entry form |
| AFFECTS_WORKFLOW | CHAR | 1 | Flag indicating if the attribute affects workflow. | |
| FLOOKUP_CODE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| INDEXABLE | VARCHAR2 | 1 | Yes | Flag indicating whether or not the attribute is included in the full text index |
| MASTER_IDENTIFIER | VARCHAR2 | 1 | Yes | Flag indicating if the attribute is part of the index master identifier. |
| MAX_OCCURS | NUMBER | For a node, indicates the maximum number of child nodes allowed. | ||
| MIN_OCCURS | NUMBER | Yes | For a node, indicates the minimum number of child nodes allowed. | |
| PARENT_ID | VARCHAR2 | 32 | This is the GUID reference to SCHEMAATTRIBUTE record that is the parent of this record, primarily used for nodes. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| SCHEMA_ID | VARCHAR2 | 32 | This is the GUID reference to the XMLSCHEMA record that aggregates all of the attributes. | |
| SEARCHABLE | VARCHAR2 | 1 | Yes | A flag indicating attribute is indexed for attribute level search |
| SORT_ORDER | NUMBER | Yes | Sort order of the node within the entire schema | |
| SYSTEM_VALUE | VARCHAR2 | 100 | Yes | This is the Reference key of the channel attribute. |
| LOOKUP_CODE_ID | VARCHAR2 | 32 | This is the GUID reference key to LOOKUP_CODE table that determines what type of attribute this is (i.e. text area, text field, file, etc) | |
| XPATH | VARCHAR2 | 2000 | Yes | This is the the complete XPATH to the node. |
| TEXT_HEIGHT | VARCHAR2 | 10 | For text areas and rich text boxese the height of the control. | |
| TEXT_WIDTH | VARCHAR2 | 10 | The width of the text area and text field. | |
| SUB_TYPE_ID | VARCHAR2 | 32 | This is the GUID reference to LOOKUP_CODE that provides values to sub choice boxes used for specific channel attribute types (i.e., list of valid data list types) | |
| DATA_LIST_ID | VARCHAR2 | 32 | This is the GUID reference to DATALIST record. | |
| READONLY | CHAR | 1 | Flag indicating if the attribute should not be allowed to be edited on the data entry forms. | |
| COUNTER_PREFIX | VARCHAR2 | 50 | A user supplied prefix used for creating the document ids. | |
| COUNTER | NUMBER | Counter that increments after each document is created for the channel. If the counter is reset it is possible to have duplicate document IDs. | ||
| SECURED | CHAR | 1 | Flag indicating if the channel attribute is secured with user groups. | |
| SECURITY_REQUIRED | CHAR | 1 | Flag indicating whether the attribute uses User Groups to secure the attribute contents. | |
| CHANGE_SECURITY | CHAR | 1 | Flag that indicates if the content editor can change the security settings on a content record. | |
| SECURED_FILE_RESOURCE | CHAR | 1 | Flag that indicates if the file should be saved in a secure location. New feature using the IMServletFilter to police requests. | |
| SECURITY_REGEX | VARCHAR2 | 100 | ESAPI Security filter regex to validate input provided by user. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_SCHEMA_ATTRIBUTE | cso_data_list | DATA_LIST_ID |
| CSO_SCHEMA_ATTRIBUTE | cso_lookup_code | FLOOKUP_CODE_ID |
| CSO_SCHEMA_ATTRIBUTE | cso_lookup_code | LOOKUP_CODE_ID |
| CSO_SCHEMA_ATTRIBUTE | cso_schema_attribute | PARENT_ID |
| CSO_SCHEMA_ATTRIBUTE | cso_xml_schema | SCHEMA_ID |
| cso_xml_attribute_user_grp | cso_schema_attribute | ATTRIBUTE_ID |
| cso_schema_attribute_res | cso_schema_attribute | ATTRIBUTE_ID |
| cso_schema_attribute | cso_schema_attribute | PARENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_SCHEMA_ATTRIBUTE_N1 | Non Unique | Default | FLOOKUP_CODE_ID |
| CSO_SCHEMA_ATTRIBUTE_N2 | Non Unique | Default | LOOKUP_CODE_ID |
| CSO_SCHEMA_ATTRIBUTE_N3 | Non Unique | Default | PARENT_ID |
| CSO_SCHEMA_ATTRIBUTE_N4 | Non Unique | Default | SCHEMA_ID |
| CSO_SCHEMA_ATTRIBUTE_N5 | Non Unique | Default | DATA_LIST_ID |
| CSO_SCHEMA_ATTRIBUTE_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_SCHEMA_ATTRIBUTE_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |