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