MDS_COMPONENTS
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COMP_PARTITION_ID | NUMBER | Yes | COMP_PARTITION_ID | ||
| COMP_CONTENTID | NUMBER | Yes | COMP_CONTENTID | ||
| COMP_SEQ | NUMBER | 6 | Yes | COMP_SEQ | |
| COMP_LEVEL | NUMBER | 4 | Yes | COMP_LEVEL | |
| COMP_NSID | NUMBER | 5 | COMP_NSID | ||
| COMP_PREFIX | VARCHAR2 | 127 | COMP_PREFIX | ||
| COMP_LOCALNAME | VARCHAR2 | 400 | COMP_LOCALNAME | ||
| COMP_VALUE | VARCHAR2 | 4000 | COMP_VALUE | ||
| COMP_ID | VARCHAR2 | 400 | COMP_ID | ||
| COMP_COMMENT | VARCHAR2 | 4000 | COMP_COMMENT | ||
| ENTERPRISE_ID | NUMBER | 18 | ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MDS_COMPONENTS_N1 | Non Unique | Default | COMP_PARTITION_ID, COMP_LOCALNAME, COMP_CONTENTID, COMP_NSID, COMP_SEQ, COMP_ID |
| MDS_COMPONENTS_N2 | Non Unique | Default | COMP_PARTITION_ID, COMP_ID, COMP_CONTENTID |
| MDS_COMPONENTS_U1 | Unique | Default | COMP_PARTITION_ID, COMP_CONTENTID, COMP_SEQ |