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 |