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:

NameTypeDescription
CMFEEDLOG_IDINTEGER NOT NULLThe internal reference number of the feed.
FEED_IDVARCHAR (256) NOT NULLUniquely identifies a feed.
STOREENT_IDINTEGER NOT NULLUnique ID of the store for which the feed is processed.
FEEDRECORD_IDVARCHAR (256) NOT NULLUniquely identifies a record in the feed.
HASHCODEVARCHAR (128) NOT NULLHash code generated using the feed properties.
TIMECREATEDTIMESTAMPRecord creation time stamp.
TIMEUPDATEDTIMESTAMPThe time the record was last updated.
TIMEDELETEDTIMESTAMPThe time the record was deleted.
MARKFORDELETESMALLINT DEFAULT 0Indicates if a record is marked for deletion.
0
Record is not marked for deletion.
1
Record is marked for deletion.
LOADSUCCESSSMALLINTThis column is reserved for future use and is not currently used.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMFEEDLOG_IDPrimary Key
I0001393FEED_ID+STOREENT_ID+FEEDRECORD_IDUnique Index
I0001390FEED_ID+STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3678STOREENT_IDSTOREENTSTOREENT_IDCascade