CZ_RULES
This table is used to store Configuration Rules data in Oracle Configurator.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
CZ_RULES_PK |
RULE_ID, START_MODEL_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Yes | System generated unique identifier of the rule or folder. | ||
| 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 this rule belongs to. | ||
| NAME | VARCHAR2 | 255 | Yes | User given Rule Name or Folder Name | ||
| PARENT_FOLDER_ID | NUMBER | 18 | Identifier of the parent rule folder. | |||
| RULE_OBJECT_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of rule. Following are the valid lookup code values: LOGIC, ACCUMULATOR, COMPARISON, PROPERTY_BASED_COMPATIBILITY, EXPLICIT_COMPATIBILITY, DESIGN_CHART, STATEMENT, CONFIGURATOR_EXTENSION, FOLDER | ||
| RULE_TEXT | CLOB | Rule text of a CDL Rule entered by user. | ||||
| RULE_STATUS | VARCHAR2 | 30 | Yes | Stores current status of the rule - UNKNOWN, VALIDATED, VALIDATION_FAILED, LOGIC_GENERATED, LOGIC_FAILED. | ||
| INVALID_FLAG | VARCHAR2 | 1 | This flag indicates the validation status of the rule. The value '1' represents invalid rule and '0' represents valid rule. | |||
| MODEL_NODE_PATH | VARCHAR2 | 1000 | Model node path that uniquely identifies a model node for which this rule is associated with. It is used to store the Node Path associated with a CX Rule. | |||
| RULE_CLASS_SEQ | NUMBER | 38 | Defaults or Search Decisions Rule Sequence number that determines rule execution order within the class. | |||
| REASON_TYPE | VARCHAR2 | 30 | Indicates the type of message. Following are the valid lookup code values: RULE_NAME DECLARATIVE_STATEMENT RULE_DESCRIPTION CUSTOM_RULE | |||
| DISABLED_FLAG | VARCHAR2 | 1 | This flag indicates the diable status of the rule. The value '1' represents disabled rule and '0' represents active rule. | |||
| SIGNATURE_CODE | VARCHAR2 | 48 | Used by CX's, FK to CZ_SIGNATURES.SIGNATURE_CODE | |||
| PRESENTATION_TYPE | VARCHAR2 | 30 | Indicates how this rule is presented to the user and it is used to determine if parsing is required or not. Valid values of this column are: TEMPLATE_BASED, STATEMENT_RULE | |||
| CX_CLASS_NAME | VARCHAR2 | 1000 | Fully qualified CX class name. Obsolete. | Obsolete | ||
| CX_CLASS_INST_MODE | VARCHAR2 | 30 | Indicates whether rules on instance or instance set Lookup code values: NULL, INSTANCE, INSTANCE_SET. | |||
| RULE_CLASS | VARCHAR2 | 30 | Rule Class lookup code. Valid Lookup code values: CONSTRAINT, DEFAULT, SEARCH_DECISION | |||
| DESCRIPTION | VARCHAR2 | 1000 | User given description of the rule. | |||
| END_MODEL_VERSION | NUMBER | 18 | Indicates the version from which this rule record will be ineffective. The NULL value indicates this record has no end date. | |||
| TRANS_ATTR_ID | NUMBER | 18 | Identifier of transactional item attribute | |||
| 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 actually delete the orphaned rows with the Non-Zero flag value. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update 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. | |||
| NODE_NAME_PATH | CLOB | Name path that uniquely identifies a model node or a TIA with which the rule is associated. This is used only in error reporting for a Configurator extension rule as its value can become stale when model changes. | ||||
| CX_CLASS_INFO | BLOB | Serialized representation of CX class and method information. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CZ_RULES | cz_models | MODEL_ID |
| CZ_RULES | cz_signatures | SIGNATURE_CODE |
| cz_rule_bytecodes | cz_rules | RULE_ID, START_MODEL_VERSION |
| cz_compat_combinations | cz_rules | RULE_ID, START_MODEL_VERSION |
| cz_compat_participants | cz_rules | RULE_ID, START_MODEL_VERSION |
| cz_expression_nodes | cz_rules | RULE_ID, START_MODEL_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_RULES_N1 | Non Unique | Default | PARENT_FOLDER_ID, RULE_ID |
| CZ_RULES_N2 | Non Unique | Default | MODEL_ID, START_MODEL_VERSION, NAME, DELETED_FLAG |
| CZ_RULES_U1 | Unique | Default | RULE_ID, START_MODEL_VERSION |