Footprints Data Model

Table
Table Name Data Mart Request Queue
Table Definition The queue of active data mart load requests. An entry in this table will be picked up by the Java Data Mart manager and used to initiate and then maintain state of the request. The FootPrints UI controls data mart execution by creating and updating rows in this table. During upgrade, a request to update all data marts is added, and once the system comes up, Data Marts are updated in round robin fashion.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Data Mart Request Queue Id The automatically generated primary key of the data_mart_rqst_queue table. LONG Yes
Item Definition Id A Foreign Key to the Definition table. LONG No
Data Mart Request State Id A Foreign Key to the Data Mart Request State table. INTEGER No
Request Date Request date DATE No
Request Date UTC String Request Date as a UTC string to avoid JDBC/Hibernate errors. VARCHAR(23) No
Data Mart Request Type Id A Foreign Key to the Data Mart Request Type table. INTEGER No