1. Tables and Views
  2. PSC_OPA_META_ENTITY_LINK_B

PSC_OPA_META_ENTITY_LINK_B

This table contains Oracle Policy Automation metadata entity link information.

Details

  • Schema: FUSION

  • Object owner: PSC_TS

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PSC_OPA_META_ENTITY_LINK_B_PK

META_DATA_MODEL_NAME, ENTITY_MODEL_NAME, TARGET_ENTITY_MODEL_NAME, TARGET_ENTITY_NAME

Columns

Name Datatype Length Precision Not-null Comments Status
META_DATA_MODEL_NAME VARCHAR2 30 Yes This column is used to indicate meta data model name Active
ENTITY_MODEL_NAME VARCHAR2 30 Yes This column is used to indicate entity model name Active
TARGET_ENTITY_MODEL_NAME VARCHAR2 30 Yes This column is used to indicate target entity model name Active
TARGET_ENTITY_NAME VARCHAR2 30 Yes This column is used to indicate target entity name Active
DESCRIPTION VARCHAR2 100 Yes This column is used to indicate description Active
CARDINALITY VARCHAR2 10 This column is used to indicate cardinality Active
OWNER_ID VARCHAR2 10 This column is used to indicate owner id Active
ENTITY_NAME VARCHAR2 30 This column is used to indicate entity name Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
SEED_DATA_LOCK NUMBER 1 Yes Indicates whether the row is seed data. Valid values are 0 for data that is customer data, 1 for seed data that cannot be modified, and 2 indicates that the seed data can be modified.
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.
DELETED_FLAG VARCHAR2 1 Yes Indicates whether the record is logically deleted (Y or N). Valid values are Y for deleted record, and N for active record. Default value is N.
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
PSC_OPA_META_ENTITY_LINK_B psc_opa_meta_entity_reln_b META_DATA_MODEL_NAME, ENTITY_MODEL_NAME
psc_opa_meta_entity_link_tl psc_opa_meta_entity_link_b META_DATA_MODEL_NAME, ENTITY_MODEL_NAME, TARGET_ENTITY_MODEL_NAME, TARGET_ENTITY_NAME

Indexes

Index Uniqueness Tablespace Columns
PSC_OPA_META_ENT_LINK_B_UK1 Unique Default META_DATA_MODEL_NAME, ENTITY_MODEL_NAME, TARGET_ENTITY_MODEL_NAME, TARGET_ENTITY_NAME, ORA_SEED_SET1
PSC_OPA_META_ENT_LINK_B_UK11 Unique Default META_DATA_MODEL_NAME, ENTITY_MODEL_NAME, TARGET_ENTITY_MODEL_NAME, TARGET_ENTITY_NAME, ORA_SEED_SET2