ACA_DOCUMENT_RESOLUTION_GT
The structure resolution table for document objects.
Details
-
Schema: FUSION
-
Object owner: ACA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACA_DOCUMENT_RESOLUTION_G_PK |
TREESEQ |
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| TREESEQ | NUMBER | Yes | The sequence number of this row. | |
| TREELEVEL | NUMBER | The indentation level of the current tree row | ||
| RECURSION_FLAG | NUMBER | Indicator for a recursion of the structure resolution | ||
| LEAF_FLAG | NUMBER | Indicator for a leaf of the structure resolution | ||
| DOCUMENT_VERSION_PARENT_ID | NUMBER | 18 | The id of the parent master record | |
| DOCUMENT_VERSION_ID | NUMBER | 18 | The id of the child master record | |
| DOCUMENT_STRUCTURE_ID | NUMBER | 18 | The id of the structure record |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ACA_DOCUMENT_RESOLUTION_GT_U1 | Unique | TREESEQ |