CZ_SUPPL_ATTR_VALUES
Table contains definitions of Supplemental attribute values.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CZ_SUPPL_ATTR_VALUES_PK |
ATTR_VALUE_ID, START_MODEL_VERSION |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ATTR_VALUE_ID | NUMBER | 18 | Yes | Primary key column, a system generated identifier of the value of a Supplemental Attribute associated with a particular structure node. | |
ATTRIBUTE_ID | NUMBER | 18 | Yes | Indicates Supplemental Attribute, a foreign key to CZ_SUPPLEMENTAL_ATTRIBUTES_B table. | |
MODEL_NODE_ID | NUMBER | 18 | Identifier of the Supplemental model node on which the value is defined. | ||
START_MODEL_VERSION | NUMBER | 18 | Yes | Primary key column, indicates the model version from which this value will be defined on the Supplemental node. | |
END_MODEL_VERSION | NUMBER | 18 | Indicates the model version from which this value is not defined on the Supplemental node. NULL value means that value is always defined for that node in the future. | ||
MODEL_ID | NUMBER | 18 | Yes | Configurator Model identifier associated with the structure node, a foreign key to CZ_MODELS table. | |
VALUE_ID | NUMBER | 18 | Value id in case when the value comes from an independent value set. Added in order to be able to efficiently account for value effectivity intervals if needed, but can be useful for other purposes. | ||
NUMBER_VALUE | NUMBER | Stores the value of a Format Only attribute if the attribute is of type NUMBER, otherwise NULL. | |||
TEXT_VALUE | CLOB | Stores the value of a Format Only attribute if the attribute is of type TEXT, otherwise NULL. | |||
DATE_VALUE | DATE | Stores the value of a Format Only attribute if the attribute is of type DATE, otherwise NULL. | |||
TIMESTAMP_VALUE | TIMESTAMP | Stores the value of a Format Only attribute if the attribute is of type TIMESTAMP, otherwise NULL. | |||
DELETED_FLAG | NUMBER | 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. | ||
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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CZ_SUPPL_ATTR_VALUES | cz_models | MODEL_ID |
CZ_SUPPL_ATTR_VALUES | cz_supplemental_attributes_b | ATTRIBUTE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CZ_SUPPL_ATTR_VALUES_N1 | Non Unique | Default | MODEL_ID |
CZ_SUPPL_ATTR_VALUES_N2 | Non Unique | Default | ATTRIBUTE_ID |
CZ_SUPPL_ATTR_VALUES_U1 | Unique | Default | ATTR_VALUE_ID, START_MODEL_VERSION |
CZ_SUPPL_ATTR_VALUES_U2 | Unique | Default | MODEL_NODE_ID, ATTRIBUTE_ID, START_MODEL_VERSION, DELETED_FLAG |