WIA_CONTENT_CHANGE_LOG

This table stores scenario content change logs.

Foreign Keys

This table has no foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
ID	NOT NULL	INT8	Log ID
EVENT_TYPE	NOT NULL	VARCHAR(50)	Event type: Add, Remove, Modify
EVENT_DATE	NOT NULL	TIMESTAMP	Time when the event happened
MODIFY_TYPE	NULLABLE	VARCHAR(50)	What has been modified
ENTITY_ID	NOT NULL	INT8	ID of the modified entity
ENTITY_TYPE	NOT NULL	VARCHAR(50)	Type of the modified entity
CONTENT_ID	NULLABLE	INT8	ID of the added or removed entity
CONTENT_TYPE	NULLABLE	VARCHAR(50)	Type of the added or removed entity
AUDIT_ID	NULLABLE	INT8	Audit log ID for the Modify event
CREATION_DATE	NOT NULL	TIMESTAMP	Date when the record was created
CREATED_BY	NOT NULL	INT8	User who created the record
LAST_UPDATE_DATE	NOT NULL	TIMESTAMP	Last update date of the record
LAST_UPDATED_BY	NOT NULL	INT8	User who last updated the record
VERSION	NOT NULL	INT8	Version of the record

Indexes

Index Name	Index Type	Sequence	Column Name
WIA_CONTENT_CHANGE_LOG_PK	UNIQUE	1	ID

Sequences

Sequence Name	Sequence Type
WIA_CONTENT_CHANGE_LOG_S	ID