MDS_PATHS
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: TABLE
-
表領域: SYSTEM
列
| 名前 | データ型 | 長さ | 精度 | 非null | コメント |
|---|---|---|---|---|---|
| PATH_PARTITION_ID | NUMBER | はい | PATH_PARTITION_ID | ||
| PATH_NAME | VARCHAR2 | 400 | はい | PATH_NAME | |
| PATH_DOCID | NUMBER | はい | PATH_DOCID | ||
| PATH_OWNER_DOCID | NUMBER | はい | PATH_OWNER_DOCID | ||
| PATH_FULLNAME | VARCHAR2 | 1250 | はい | PATH_FULLNAME | |
| PATH_GUID | VARCHAR2 | 36 | PATH_GUID | ||
| PATH_TYPE | VARCHAR2 | 30 | はい | 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 |
索引
| 索引 | 一意性 | 表領域 | 列 |
|---|---|---|---|
| MDS_PATHS_N1 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_NAME, PATH_TYPE, PATH_CONTENTID, PATH_DOC_ELEM_NSURI, PATH_DOC_ELEM_NAME, PATH_GUID |
| MDS_PATHS_N3 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_HIGH_CN |
| MDS_PATHS_N4 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, PATH_HIGH_CN |
| MDS_PATHS_N5 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_TYPE, PATH_GUID, PATH_HIGH_CN, PATH_LINEAGE_ID |
| MDS_PATHS_N6 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_LOW_CN, PATH_HIGH_CN, PATH_OPERATION, PATH_TYPE |
| MDS_PATHS_N7 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, "PATH_LOW_CN", PATH_HIGH_CN |
| MDS_PATHS_N8 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_CONTENTID |
| MDS_PATHS_N9 | 非一意 | SYSTEM | PATH_PARTITION_ID, PATH_DOC_ELEM_NAME |
| MDS_PATHS_U1 | 一意 | SYSTEM | PATH_PARTITION_ID, PATH_DOCID, PATH_VERSION |
| MDS_PATHS_U2 | 一意 | SYSTEM | PATH_PARTITION_ID, PATH_OWNER_DOCID, PATH_NAME, PATH_VERSION, PATH_GUID |
| MDS_PATHS_U3 | 一意 | SYSTEM | PATH_PARTITION_ID, PATH_FULLNAME, PATH_VERSION, PATH_GUID |
| MDS_PATHS_U4 | 一意 | SYSTEM | "PATH_HIGH_CN"がNULLの場合、TO_CHAR("PATH_PARTITION_ID") || "PATH_FULLNAME"の場合はNULLの終了 |