ZCH_DATA_MGMT_SNAPSHOTS
Stores a snapshot of a member within a data set. If member data is stored outside the set, the snapshot content is captured by resolving the record ID of the member using the REST resource of the corresponding object. Alternatively, member data can be stored as part of the set by uploading the snapshot content when the member is added to the set.
Details
-
Schema: FUSION
-
Object owner: ZCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
zch_data_mgmt_snapshots_PK |
DATA_SET_UUID, DATA_MGMT_SNAPSHOT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DATA_MGMT_SNAPSHOT_ID | NUMBER | 18 | Yes | Identifies this snapshot within the data set | |
DATA_MGMT_MEMBER_ID | NUMBER | 18 | Yes | Member of which the snapshot was taken | |
DATA_SET_UUID | VARCHAR2 | 36 | Yes | Data set which contains this snapshot, denormed from DATA_SET_UUID in ZCH_DATA_MGMT_MEMBERS | |
RECORD_ID | NUMBER | 18 | Identifier of the member record in the registry DB | ||
RECORD_UPDATE_DATE | TIMESTAMP | Update date of the member record in the registry DB | |||
RECORD_VERSION | NUMBER | 9 | Version of the member record in the registry DB | ||
SNAPSHOT_CONTENT | CLOB | Content of this snapshot stored inline | |||
SNAPSHOT_CONTENT_TYPE | VARCHAR2 | 250 | Yes | MIME type of snapshot content | |
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. | ||
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. | |
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. | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCH_DATA_MGMT_SNAPSHOTS_N1 | Non Unique | Default | DATA_SET_UUID, DATA_MGMT_MEMBER_ID |
ZCH_DATA_MGMT_SNAPSHOTS_PK | Unique | Default | DATA_SET_UUID, DATA_MGMT_SNAPSHOT_ID |
ZCH_DATA_MGMT_SNAPSHOTS_U1 | Unique | Default | DATA_SET_UUID, RECORD_ID, RECORD_UPDATE_DATE, RECORD_VERSION |