WIA_SCENARIO_LOG_MAPPING

This table stores the mapping relationships between scenarios and content change logs.

Foreign Keys

This table does not use any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
ID	NOT NULL	INT8	Mapping ID
SCENARIO_ID	NOT NULL	INT8	Scenario ID
EVENT_ID	NOT NULL	INT8	Content change log ID
SYNCED	NOT NULL	CHAR(1)	Whether the record is synced
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_SCENARIO_LOG_MAPPING_PK	UNIQUE	1	ID
WIA_SCENARIO_LOG_MAPPING_EVENT_ID_IDX	NORMAL	2	EVENT_ID
WIA_SCENARIO_LOG_MAPPING_SCENARIO_ID_IDX	NORMAL	3	SCENARIO_ID

Sequences

Sequence Name	Sequence Type
WIA_SCENARIO_LOG_MAPPING_S	ID