MDS_PATHS
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: SYSTEM
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PATH_PARTITION_ID | NUMBER | Yes | PATH_PARTITION_ID | ||
| PATH_NAME | VARCHAR2 | 400 | Yes | PATH_NAME | |
| PATH_DOCID | NUMBER | Yes | PATH_DOCID | ||
| PATH_OWNER_DOCID | NUMBER | Yes | PATH_OWNER_DOCID | ||
| PATH_FULLNAME | VARCHAR2 | 1250 | Yes | PATH_FULLNAME | |
| PATH_GUID | VARCHAR2 | 36 | PATH_GUID | ||
| PATH_TYPE | VARCHAR2 | 30 | Yes | PATH_TYPE | |
| PATH_LOW_CN | NUMBER | PATH_LOW_CN | |||
| PATH_HIGH_CN | NUMBER | PATH_HIGH_CN | |||
| PATH_CONTENTID | NUMBER | PATH_CONTENTID | |||
| PATH_DOC_ELEM_NSURI | VARCHAR2 | 800 | PATH_DOC_ELEM_NSURI | ||
| PATH_DOC_ELEM_NAME | VARCHAR2 | 127 | PATH_DOC_ELEM_NAME | ||
| PATH_VERSION | NUMBER | PATH_VERSION | |||
| PATH_VER_COMMENT | VARCHAR2 | 800 | PATH_VER_COMMENT | ||
| PATH_OPERATION | NUMBER | PATH_OPERATION | |||
| PATH_XML_VERSION | VARCHAR2 | 10 | PATH_XML_VERSION | ||
| PATH_XML_ENCODING | VARCHAR2 | 60 | PATH_XML_ENCODING | ||
| PATH_CONT_CHECKSUM | NUMBER | PATH_CONT_CHECKSUM | |||
| PATH_LINEAGE_ID | NUMBER | PATH_LINEAGE_ID | |||
| PATH_DOC_MOTYPE_NSURI | VARCHAR2 | 800 | PATH_DOC_MOTYPE_NSURI | ||
| PATH_DOC_MOTYPE_NAME | VARCHAR2 | 127 | PATH_DOC_MOTYPE_NAME | ||
| PATH_CONTENT_TYPE | NUMBER | PATH_CONTENT_TYPE | |||
| PATH_WEB_APP_ID | VARCHAR2 | 200 | PATH_WEB_APP_ID | ||
| ENTERPRISE_ID | NUMBER | 18 | ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MDS_PATHS_N1 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_NAME, PATH_TYPE, PATH_CONTENTID, PATH_DOC_ELEM_NSURI, PATH_DOC_ELEM_NAME, PATH_GUID |
| MDS_PATHS_N3 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_HIGH_CN |
| MDS_PATHS_N4 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, PATH_HIGH_CN |
| MDS_PATHS_N5 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_TYPE, PATH_GUID, PATH_HIGH_CN, PATH_LINEAGE_ID |
| MDS_PATHS_N6 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_LOW_CN, PATH_HIGH_CN, PATH_OPERATION, PATH_TYPE |
| MDS_PATHS_N7 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, "PATH_LOW_CN", PATH_HIGH_CN |
| MDS_PATHS_N8 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_CONTENTID |
| MDS_PATHS_N9 | Non Unique | SYSTEM | PATH_PARTITION_ID, PATH_DOC_ELEM_NAME |
| MDS_PATHS_U1 | Unique | SYSTEM | PATH_PARTITION_ID, PATH_DOCID, PATH_VERSION |
| MDS_PATHS_U2 | Unique | SYSTEM | PATH_PARTITION_ID, PATH_OWNER_DOCID, PATH_NAME, PATH_VERSION, PATH_GUID |
| MDS_PATHS_U3 | Unique | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, PATH_VERSION, PATH_GUID |
| MDS_PATHS_U4 | Unique | SYSTEM | CASE WHEN "PATH_HIGH_CN" IS NULL THEN TO_CHAR("PATH_PARTITION_ID") || "PATH_FULLNAME" ELSE NULL END |