CMFEEDLOG

This table logs information about each feed that has been processed. It also records a hash code for the record to compare against to determine if there is an update to the record.

Column Descriptions:

Name	Type	Description
CMFEEDLOG_ID	INTEGER NOT NULL	The internal reference number of the feed.
FEED_ID	VARCHAR (256) NOT NULL	Uniquely identifies a feed.
STOREENT_ID	INTEGER NOT NULL	Unique ID of the store for which the feed is processed.
FEEDRECORD_ID	VARCHAR (256) NOT NULL	Uniquely identifies a record in the feed.
HASHCODE	VARCHAR (128) NOT NULL	Hash code generated using the feed properties.
TIMECREATED	TIMESTAMP	Record creation time stamp.
TIMEUPDATED	TIMESTAMP	The time the record was last updated.
TIMEDELETED	TIMESTAMP	The time the record was deleted.
MARKFORDELETE	SMALLINT DEFAULT 0	Indicates if a record is marked for deletion. 0 Record is not marked for deletion. 1 Record is marked for deletion.
LOADSUCCESS	SMALLINT	This column is reserved for future use and is not currently used.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CMFEEDLOG_ID	Primary Key
I0001393	FEED_ID+STOREENT_ID+FEEDRECORD_ID	Unique Index
I0001390	FEED_ID+STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3678	STOREENT_ID	STOREENT	STOREENT_ID	Cascade