CZ_RULE_DEPENDENCIES
CZ_RULE_DEPENDENCIES stores information about model nodes that are referenced either explicitly or implicitly by rules.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CZ_RULE_DEPENDENCIES_PK |
DEPENDENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| DEPENDENCY_ID | NUMBER | 18 | Yes | Sequence-populated surrogate primary key | ||
| RULE_ID | NUMBER | 18 | Yes | Identifies Rule, for which the dependency is defined. | ||
| START_MODEL_VERSION | NUMBER | 18 | Yes | Identifies Rule, for which the dependency is defined. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Together with organization_id, identifies Item when item_updated = Y or child_node_added = Y. In conjunction with suppl_attr_id and value_set_value_id identifies dependency on supplemental attribute value change on this item. | |||
| ORGANIZATION_ID | NUMBER | 18 | Together with inventory_item_id, identifies Item when item_updated = Y or child_node_added = Y. In conjunction with suppl_attr_id and value_set_value_id identifies dependency on supplemental attribute value change on this item. | |||
| COMPONENT_ITEM_ID | NUMBER | 18 | Inventory item ID of PIM component referred by a rule. | |||
| PARENT_ITEM_ID | NUMBER | 18 | Inventory item ID of parent of PIM component referred by a rule. | |||
| MODEL_NODE_ID | NUMBER | 18 | Identifies Supplemental structure node when child_node_added = Y or node_deleted = Y. In conjunction with suppl_attr_id and value_set_value_id identifies dependency on supplemental attribute value change on this Supplemental node. | |||
| UDA_ID | VARCHAR2 | 150 | Identifies UDA when attr_value_updated = Y | |||
| VALUE_SET_ID | NUMBER | 18 | Identifies Value Set when value_set_updated = Y. Or, for supplemental attributes, this is the ID of the value set of the supplemental attribute's value that this row's rule depends on. In this case, changes to the value set in a draft model do not require recompilation of the rule.. | |||
| CHILD_NODE_ADDED | VARCHAR2 | 1 | Y - this rule is affected by adding a child component in the item's structure or a supplemental node | |||
| MUTEX_UPDATED | VARCHAR2 | 1 | Y - this rule is affected when mutually_exclusive_options flag is changed (updated from Yes to No) | |||
| INSTANTIABILITY_UPDATED | VARCHAR2 | 1 | Y - this rule is affected when component's instantiability is changed | |||
| ATTR_VALUE_UPDATED | VARCHAR2 | 1 | Y - this rule is affected when UDA's or suuplemental attribute value is changed | |||
| VALUE_SET_UPDATED | VARCHAR2 | 1 | Y - this rule is affected when Value Set is changed | |||
| MAX_SELECTIONS_UPDATED | VARCHAR2 | 1 | Y - the rule is affected when the supplemental structure node maximum number of selections is changed | |||
| OPTIONAL_UPDATED | VARCHAR2 | 1 | This field has a value of Y when the rule is affected by an optional flag change on a Model or Option Class component whose parent in the structure is an Option Class. | |||
| ITEM_CLASS_ID | NUMBER | 18 | In conjuction with trans_attr_id, stores a rule participant's dependency on a TIA. This will only be populated when a TIA of a participant is referenced in a rule. When an item itself is referenced without a TIA, item class changes do not impact the rule. | |||
| TRANS_ATTR_ID | NUMBER | 18 | In conjunction with item_class_id, used to store a rule's dependency on a TIA. | |||
| SUPPL_ATTR_VALUE_ID | NUMBER | 18 | ID of a supplemental attribute value that this row's rule depends on. Changing the value in a draft model requires recompilation of the rule. | Obsolete | ||
| SUPPL_ATTR_ID | NUMBER | 18 | Supplemental attribute ID. Together with item or supplemental node identity columns identifies dependency on this attribute value change on this item or supplemental node. | |||
| VALUE_SET_VALUE_ID | NUMBER | 18 | ID of a supplemental attribute's value set value that this row's rule depends on. Changing to a different value set value in a draft model requires recompilation of the rule. Non-null only for attributes based on independent or subset value sets. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_RULE_DEPENDENCIES_N1 | Non Unique | Default | RULE_ID, START_MODEL_VERSION |
| CZ_RULE_DEPENDENCIES_N2 | Non Unique | Default | INVENTORY_ITEM_ID, UDA_ID |
| CZ_RULE_DEPENDENCIES_N3 | Non Unique | Default | COMPONENT_ITEM_ID, PARENT_ITEM_ID |
| CZ_RULE_DEPENDENCIES_N4 | Non Unique | Default | MODEL_NODE_ID |
| CZ_RULE_DEPENDENCIES_N5 | Non Unique | Default | TRANS_ATTR_ID, ITEM_CLASS_ID |
| CZ_RULE_DEPENDENCIES_N6 | Non Unique | Default | VALUE_SET_ID |
| CZ_RULE_DEPENDENCIES_N7 | Non Unique | Default | VALUE_SET_VALUE_ID |
| CZ_RULE_DEPENDENCIES_U1 | Unique | Default | DEPENDENCY_ID |