CHAN_OBJECT_SNAPSHOT

Definition

The CHAN_OBJECT_SNAPSHOT table contains the snapshots of objects contained in change lists

Technical Data

Schema Version	5.0.6
Partitioned	No

Summary

The CHAN_OBJECT_SNAPSHOT table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
CHAN_OID	PK_CHAN_OBJECT_SNAPSHOT			CHANGE_LIST (OID)		The unique identifier of the related change list
OID	PK_CHAN_OBJECT_SNAPSHOT					The unique identifier of the snapshot
VALUE						A copy of the object as it was when the related change list was created

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

CHAN_OID

Definition	The unique identifier of the related change list
Type	DECIMAL(28), NOT NULL
Primary Key	PK_CHAN_OBJECT_SNAPSHOT

OID

Definition	The unique identifier of the snapshot
Type	DECIMAL(5), NOT NULL
Primary Key	PK_CHAN_OBJECT_SNAPSHOT

VALUE

Definition	A copy of the object as it was when the related change list was created
Type	BLOB, NOT NULL

Primary Key Details

See the primary key information:

PK_CHAN_OBJECT_SNAPSHOT

Column(s)	CHAN_OID, OID
Tablespace	CATALOG_INDX