Footprints Data Model

Table
Name data_mart_rqst_queue
Comment
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.

Column
Name Datatype Comment Is PK Is FK
data_mart_rqst_queue_id bigint The automatically generated primary key of the data_mart_rqst_queue table. Yes No
item_defn_id bigint A Foreign Key to the Definition table. No Yes
rqst_date datetime Date of the request No No
rqst_date_utc_string varchar(23) Request Date as a UTC string to avoid JDBC/Hibernate errors. No No
data_mart_rqst_type_id int A Foreign Key to the Data Mart Request Type table. No Yes
data_mart_rqst_state_id int A Foreign Key to the Data Mart Request State table. No Yes