Table Description
CREOLE Product Snapshot: The CREOLE Product Snapshot entity maintains a history of changes to a product over its lifetime.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Products::Entity Objects::Infrastructure::Entities::CREOLEProductSnapshot::CREOLEProductSnapshot
Controlling File: core\model\Packages\Products\Infrastructure\Entities_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
snapshotIDkeynoThe unique identifier of the snapshot record.INTERNAL_ID SVR_INT64
productIDdetailsnoUnique identifier of the product to which the snapshot relates.PRODUCT_ID SVR_INT64
snapshotDatadetails Contains a snapshot of the product in XML format.CREOLE_PRODUCT_SNAPSHOT_DATA SVR_BLOB
userNamedetailsyesThe name of the user who created the snapshot.USER_NAME SVR_STRING<64>
actionTypedetailsnoDefines the type of action being performed on the sandbox, e.g. Created, Edited, Removed.CREOLE_PRODUCT_SANDBOX_ACTION_TYPEProductSandboxActionTypeSVR_STRING<10>
actionDateTimedetailsnoThe date/time on which the action was performed.CURAM_DATETIME SVR_DATETIME
successionIDdetails Contains the succession identifier which links a history of changes together for a specific product.VERSION_NO SVR_INT32
Foreign Keys (1)
ChildParent
CREOLEProductPublicationItem.snapshotIDCREOLEProductSnapshot.snapshotID
Indices (1)
Index NameAttributes
ProductSnapshot1IndexproductID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: snapshotID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readAllnkreadmulti   
searchByProductreadmulti   
Related Pages (8)