CZ_MODEL_NODES_B
Each row of this table represents a Supplemental Node defined by the user in a Model Version. A new row will be inserted when user creates, updates or deletes a supplemental node. In addition to supplemental nodes, the root node of the Item based model also be added to this table.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
CZ_MODEL_NODES_B_PK |
MODEL_NODE_ID, START_MODEL_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MODEL_NODE_ID | NUMBER | 18 | Yes | System generated unique identifier of the Configurator Model Node. | |
| START_MODEL_VERSION | NUMBER | 18 | Yes | Indicates the version from which this node record will be effective. | |
| 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. | |
| MODEL_ID | NUMBER | 18 | Yes | Identifier of the model to which the node belongs. | |
| PARENT_ID | NUMBER | 18 | Node identifier of the parent node. Parent_id of null for a model represents the root node. | ||
| MODEL_NODE_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of node. Valid values are: SUPPLEMENTAL_ROOT, BOM_ROOT, COMPONENT, MODEL_REFERENCE, OPTION_FEATURE, COUNTED_OPTION_FEATURE, INTEGER_FEATURE, BOOLEAN_FEATURE, TEXT_FEATURE, OPTION, TOTAL | |
| NAME | VARCHAR2 | 1000 | Yes | Name of the model node. | |
| DELETED_FLAG | NUMBER | 18 | Yes | This flag indicates the logical deletion of the row. The Non-Zero value represents deleted state and 0 represents not-deleted state. A user controlled background purge process will physically delete the orphaned rows with the Non-Zero flag value. | |
| REFERENCE_ID | NUMBER | 18 | Relevant only for model node type REFERENCE and CONNECTOR. It identifies the model root node to which this reference/connector points. | ||
| SEQUENCE_NUMBER | NUMBER | 38 | Provides an ordering of this node among other nodes with the same PARENT_ID. | ||
| INITIAL_NUM_VALUE | NUMBER | For storage of numeric initial values. | |||
| INITIAL_VALUE | VARCHAR2 | 1000 | Node initial value. | ||
| INSTANTIATION_TYPE | VARCHAR2 | 30 | It indicates instantiation behavior for Component and Reference structure nodes. Valid values are: OPTIONAL, REQUIRED, MULTIPLE. Value OPTIONAL indicates an Optional node (minimum 0 instances, maximum 1 instance); Value REQUIRED indicates a Mandatory or Single instance (1, 1) node; Value MULTIPLE indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. | ||
| MAXIMUM | NUMBER | For Component nodes: maximum number of (distinct) instances allowed. For Option-list Feature nodes: maximum allowed number of selected children. For Numeric Feature nodes: maximum value allowed. For References to Component models: maximum number of (distinct) instances allowed. For References to BOM models: maximum instances, effectively always 1 | |||
| MINIMUM | NUMBER | For Component nodes: minimum number of (distinct) instances required. For Option-list Feature nodes: minimum required number of selected children. For Numeric Feature nodes: minimum value allowed. For References to Component models: minimum number of (distinct) instances required. For References to BOM models: minimum instances, effectively always 1. | |||
| MIN_CARDINALITY | NUMBER | 18 | Currently applicable only for CONNECTOR nodes. Specifies the minimum number of connections that need to be made through the connector. | ||
| MAX_CARDINALITY | NUMBER | 18 | Currently applicable only for CONNECTOR nodes. Specifies the maximum number of connections that can be made through the connector. | ||
| MAX_QTY_PER_OPTION | NUMBER | 9 | Maximum Quantity per Option for Counted Option Features. | ||
| COUNTED_OPTIONS_FLAG | VARCHAR2 | 1 | Flag indicating if option can be counted (vs. selected) | ||
| DOMAIN_ORDER | VARCHAR2 | 30 | Domain Value Ordering Heuristics, appliable for Integer, Decimal and Boolean features | ||
| REVERSE_CONNECTOR_ID | NUMBER | 18 | Indicates the Reverse Connector's node Id. Reverse connectors are allowed only for the Connector Nodes defined directly under the root model node. | ||
| END_MODEL_VERSION | NUMBER | 18 | Indicates the version from which this node record will be ineffective. The NULL value indicates this record has no end date. | ||
| CONNECTOR_TARGET_TYPE | VARCHAR2 | 30 | Applicable only for CONNECTOR nodes. Specifies the connector target type. Currently only one target type is supported: ITEM_CLASS. | ||
| MUTUALLY_EXCLUSIVE_FLAG | VARCHAR2 | 1 | Applicable only for CONNECTOR nodes. Value Y means that only one item under the connector can be selected at a time. Value N means any number of items can be selected, satisfying the minimum and maximum quantity requirements. | ||
| UI_TIMESTAMP_ADD | TIMESTAMP | Timestamp populated by CME when a new model node is added to Supplemental model | |||
| UI_TIMESTAMP_REMOVE | TIMESTAMP | Timestamp populated by CME when model node is removed from a Supplemental model | |||
| UI_TIMESTAMP_MOVE | TIMESTAMP | Timestamp populated by CME when model node is moved under new parent in a Supplemental model. | |||
| UI_TIMESTAMP_CHANGETYPE | TIMESTAMP | Timestamp populated by CME when instantiation_type or counted_options_flag is modified. | |||
| UI_TIMESTAMP_REORDER | TIMESTAMP | Timestamp populated by CME when model node is reordered under its parent in a Supplemental model. | |||
| SKIP_VALIDATION_FLAG | VARCHAR2 | 1 | Applicable only to the root model node. Indicates whether, for this model, configurator validation will be skipped when it is not required. Allowed values are Y, N and NULL, which is equivalent to N. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CZ_MODEL_NODES_B | cz_models | MODEL_ID |
| CZ_MODEL_NODES_B | cz_models | REFERENCE_ID |
| cz_model_nodes_tl | cz_model_nodes_b | MODEL_NODE_ID, START_MODEL_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_MODEL_NODES_B_N1 | Non Unique | Default | MODEL_NODE_ID, PARENT_ID, START_MODEL_VERSION, END_MODEL_VERSION |
| CZ_MODEL_NODES_B_N2 | Non Unique | Default | NAME |
| CZ_MODEL_NODES_B_N3 | Non Unique | Default | REFERENCE_ID, MODEL_NODE_TYPE |
| CZ_MODEL_NODES_B_N4 | Non Unique | Default | MODEL_ID, REFERENCE_ID |
| CZ_MODEL_NODES_B_N5 | Non Unique | Default | PARENT_ID, REFERENCE_ID, MODEL_NODE_ID |
| CZ_MODEL_NODES_B_U1 | Unique | Default | MODEL_NODE_ID, START_MODEL_VERSION, DELETED_FLAG |
| CZ_MODEL_NODES_B_U2 | Unique | Default | MODEL_NODE_ID, START_MODEL_VERSION |