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 |