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 |