1. Tables and Views for SCM
  2. MSC_OBJECT_METADATA

MSC_OBJECT_METADATA

This is metadata table to store the relationship between the tables of various object type. The data will be seeded in this table.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

MSC_OBJECT_METADATA_PK

OBJECT_TYPE, TABLE_NAME

Columns

Name Datatype Length Precision Not-null Comments
OBJECT_TYPE VARCHAR2 64 Yes Identifier of the type of the object that gets stored.
TABLE_NAME VARCHAR2 64 Yes Name of the table being used for deleting records.
PK_COLUMNS CLOB Primary key columns of the table that is being used.
PARENT_TABLE VARCHAR2 64 Parent table name of the table that is being used for plan actions.
FK_COLUMNS CLOB Foreign key columns of the table that is being used.
PARENT_COLUMNS CLOB List of columns dependent on parent table.
K_COLUMNS_MAP CLOB Optional key column map for additional key map columns and mapping column to other named key.
DUP_COLUMNS CLOB Columns that need unique contents such as copy of string.
DUP_PATTERN VARCHAR2 128 String substitution pattern that maps to unique contents for unique changes as Copy of string.
TABLE_REF_COLUMNS CLOB Columns of table that are table names, if part of uniqueness of row then new table created as duplicate.
LEVEL_ORDER NUMBER 18 The order in which the execution will happen for trashing.
ACTION_CODE NUMBER 1 The value representing the actions that this table definition should be included in. Valid values are : 1 - General but not trash, 2 - Trash action.
SEQUENCE_NAME VARCHAR2 128 Name of sequence to use for new key in new or duplicate operation.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
MSC_OBJECT_METADATA_U1 Unique FUSION_TS_SEED OBJECT_TYPE, TABLE_NAME, ORA_SEED_SET1
MSC_OBJECT_METADATA_U11 Unique FUSION_TS_SEED OBJECT_TYPE, TABLE_NAME, ORA_SEED_SET2