MDS_DEPENDENCIES
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: SYSTEM
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEP_PARTITION_ID | NUMBER | Yes | DEP_PARTITION_ID | ||
| DEP_CHILD_DOCID | NUMBER | Yes | DEP_CHILD_DOCID | ||
| DEP_CHILD_LOCALREF | VARCHAR2 | 200 | DEP_CHILD_LOCALREF | ||
| DEP_PARENT_DOCNAME | VARCHAR2 | 1250 | Yes | DEP_PARENT_DOCNAME | |
| DEP_PARENT_LOCALREF | VARCHAR2 | 200 | DEP_PARENT_LOCALREF | ||
| DEP_TOPARENT_ROLE | VARCHAR2 | 127 | DEP_TOPARENT_ROLE | ||
| DEP_TOCHILD_ROLE | VARCHAR2 | 127 | DEP_TOCHILD_ROLE | ||
| DEP_GUID_REFERENCE | VARCHAR2 | 1 | DEP_GUID_REFERENCE | ||
| DEP_LOW_CN | NUMBER | DEP_LOW_CN | |||
| DEP_HIGH_CN | NUMBER | DEP_HIGH_CN | |||
| ENTERPRISE_ID | NUMBER | 18 | ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MDS_DEPENDENCIES_N1 | Non Unique | SYSTEM | DEP_PARTITION_ID, DEP_PARENT_DOCNAME, DEP_PARENT_LOCALREF, DEP_HIGH_CN, DEP_TOCHILD_ROLE |
| MDS_DEPENDENCIES_N2 | Non Unique | SYSTEM | DEP_PARTITION_ID, DEP_LOW_CN |
| MDS_DEPENDENCIES_N3 | Non Unique | SYSTEM | DEP_PARTITION_ID, DEP_HIGH_CN |
| MDS_DEPENDENCIES_N4 | Non Unique | SYSTEM | DEP_PARTITION_ID, DEP_CHILD_DOCID, DEP_CHILD_LOCALREF, DEP_HIGH_CN |