CSO_REPUTATION_CONFIG

This table contains the reputation model configuration for the default and overrides per repository.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_REPUTATION_CONFIG_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments Status
TYPE NUMBER This is the type of reputation. This value determines if it is the default(1) or an override(2)
DATE_ADDED TIMESTAMP Yes This is the date that the record was added to the repository.
DATE_MODIFIED TIMESTAMP Yes Date record was last modified in repository.
OWNER_SITE VARCHAR2 32 Yes This is the GUID reference to the repository(SITE) object.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
REFERENCE_KEY VARCHAR2 100 Yes This is the reference key identifier for this object.
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. Obsolete

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_REPUTATION_CONFIG cso_site OWNER_SITE
cso_reputation_reward cso_reputation_config REPUTATION_ID
cso_reputation_level cso_reputation_config REPUTATION_ID

Indexes

Index Uniqueness Tablespace Columns
CSO_REPUTATION_CONFIG_N1 Non Unique Default OWNER_SITE, TYPE
CSO_REPUTATION_CONFIG_U1 Unique Default RECORD_ID
CSO_REPUTATION_CONFIG_UK1 Unique Default OWNER_SITE