Footprints Data Model

Table
Name data_mart_rqst_history
Comment
A history table detailing the results of Data Mart request execution.  It is
also used to report the last run of the data mart on data mart reports.  It may
need to be purged from time to time as each request is logged even if no updates
occur, and the frequency defaults to 10 minutes.

Column
Name Datatype Comment Is PK Is FK
data_mart_rqst_history_id bigint The automatically generated primary key of the data_mart_rqst_history table. Yes No
item_defn_id bigint A Foreign Key to the Definition table. No Yes
rqst_begin_date datetime Request Begin Date No No
rqst_begin_date_utc_string varchar(23) Begin Date as a UTC string to avoid JDBC/Hibernate errors. No No
rqst_end_date datetime End Date No No
rqst_end_date_utc_string varchar(23) End 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