CSO_SITE
This table contains the repositories for Information Manager.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_SITE_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ADMIN_ROLE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| PREFERRED_LOCALE_ID | VARCHAR2 | 32 | This is the default preferred locale of the repository. | |
| 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. |
| DOMAIN_NAME | VARCHAR2 | 50 | This has been deprecated from the schema. | |
| ERROR_PAGE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| HOMEPAGE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| LOCALE_ID | VARCHAR2 | 32 | This is the Reference to locale table record. | |
| LOGIN_PAGE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| PAGE_TEMPLATE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| PARENT_ID | VARCHAR2 | 32 | This is the GUID for the parent repository if a view, if a repository this is set to null. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| REFERENCE_KEY | VARCHAR2 | 100 | Yes | Locale independent name for the record. Translated localized versions of the reference key are stored in property files and in table with names ending in RESOURCe. |
| USER_REG_PAGE_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| USER_REG_SCHEMA_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| USER_REG_STYLESHEET_ID | VARCHAR2 | 32 | This has been deprecated from the schema. | |
| USER_ROLE_ID | VARCHAR2 | 32 | This is the GUID for the default web user role for the associated repository. | |
| OBJECT_ID | VARCHAR2 | 32 | This is the ID used to calculate the hierarchal position of a view. | |
| OBJECT_COUNT | NUMBER | This is the number of children views. | ||
| PARENT_OBJECT_ID | NUMBER | The integer used to calculate the next object Id. | ||
| REGISTERED_VIEW | CHAR | 1 | This has been deprecated from the schema. | |
| TEMP_LATE_LOCATION | VARCHAR2 | 500 | This has been deprecated from the schema. | |
| RESTRICT_TASK_CATS | CHAR | 1 | A flag indicating the categories should be used to filter tasks. | |
| TASK_PREFIX | VARCHAR2 | 100 | The prefix used for task IDs for the associated repository. | |
| TASK_ID_COUNTER | NUMBER | This is the current task number for this record. | ||
| SELF_ADMIN_CATS | CHAR | 1 | A flag indicating whether a user can add/remove categories to/from his profile. | |
| SELF_ADMIN_LOCALES | CHAR | 1 | A flag indicating whether a user can add/remove supported locales to/from his profile. | |
| SELF_ADMIN_TEAMS | CHAR | 1 | A flag indicating whether a user can add/remove workteams to/from his profile. | |
| SKILLS_BRANCH_FILTERING | CHAR | 1 | A flag indicating the branch categories should be required for users for the task inbox | |
| AUTO_ASSIGN_ON_INIT | CHAR | 1 | A flag indicating whether InfoManager should attempt to auto-assign the workflow task, on content creation. | |
| AUTO_ASSIGN_ON_APPROVE | CHAR | 1 | A flag indicating whether InfoManager should attempt to auto-assign the workflow task, on step approval. | |
| AUTO_ASSIGNON_REJECT | CHAR | 1 | A flag indicating whether InfoManager should attempt to auto-assign the workflow task, on step rejection. | |
| AUTO_ASSIGN_TRANSLATION | CHAR | 1 | A flag indicating whether InfoManager should attempt to auto-assign the translation task | |
| 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_SITE | cso_locale | LOCALE_ID |
| CSO_SITE | cso_xml_schema | USER_REG_SCHEMA_ID |
| CSO_SITE | cso_stylesheet | USER_REG_STYLESHEET_ID |
| CSO_SITE | cso_site | PARENT_ID |
| cso_newsletter | cso_site | OWNER_SITE_ID |
| cso_survey_site | cso_site | SITE_ID |
| cso_index_queue_item | cso_site | REPOSITORY_ID |
| cso_cr_site | cso_site | SITE_ID |
| cso_content_text_view | cso_site | SITE_ID |
| cso_workflow | cso_site | OWNER_SITE_ID |
| cso_stylesheet | cso_site | SITE_ID |
| cso_work_team | cso_site | OWNER_SITE_ID |
| cso_notification | cso_site | OWNER_SITE_ID |
| cso_query | cso_site | SITE_ID |
| cso_site_tag | cso_site | SITE_ID |
| cso_newsletter_site | cso_site | SITE_ID |
| cso_normalized_questions | cso_site | DEPARTMENT_ID |
| cso_user_information | cso_site | DEFAULT_SUB_SITE_ID |
| cso_user_information | cso_site | OWNER_SITE_ID |
| cso_db_site | cso_site | SITE_ID |
| cso_c_batch_request | cso_site | SITE_ID |
| cso_article_status | cso_site | SITE_ID |
| cso_role_sub_site | cso_site | SITE_ID |
| cso_search_tokens | cso_site | DEPARTMENT_ID |
| cso_site | cso_site | PARENT_ID |
| cso_reputation_config | cso_site | OWNER_SITE |
| cso_search_stats | cso_site | DEPARTMENT_ID |
| cso_content | cso_site | ROOT_SITE_ID |
| cso_replacement_tokens | cso_site | SITE_ID |
| cso_site_user_grps | cso_site | SITE_ID |
| cso_tag | cso_site | OWNER_SITE_ID |
| cso_case_link | cso_site | SITE_ID |
| cso_data_list | cso_site | OWNER_SITE_ID |
| cso_content_att_summary | cso_site | SITE_ID |
| cso_bulk_update_request | cso_site | SITE_ID |
| cso_gsr_request | cso_site | SITE_ID |
| cso_discussion_board | cso_site | OWNER_SITE_ID |
| cso_site_content_channel | cso_site | SITE_ID |
| cso_site_locale | cso_site | SITE_ID |
| cso_site_res | cso_site | SITE_ID |
| cso_pub_site | cso_site | SITE_ID |
| cso_user_site | cso_site | SITE_ID |
| cso_survey | cso_site | SITE_ID |
| cso_role | cso_site | SITE_ID |
| cso_event | cso_site | SITE_ID |
| cso_task | cso_site | OWNER_SITE_ID |
| cso_user_attributes | cso_site | DEFAULT_SUB_SITE_ID |
| cso_site_property | cso_site | SITE_ID |
| cso_channel | cso_site | SITE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_SITE_N1 | Non Unique | Default | LOCALE_ID |
| CSO_SITE_N2 | Non Unique | Default | USER_ROLE_ID |
| CSO_SITE_N3 | Non Unique | Default | USER_REG_SCHEMA_ID |
| CSO_SITE_N4 | Non Unique | Default | USER_REG_STYLESHEET_ID |
| CSO_SITE_N5 | Non Unique | Default | RECORD_ID, OBJECT_ID |
| CSO_SITE_N6 | Non Unique | Default | PARENT_ID |
| CSO_SITE_N7 | Non Unique | Default | REFERENCE_KEY |
| CSO_SITE_N8 | Non Unique | Default | OBJECT_ID |
| CSO_SITE_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_SITE_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |