Footprints Data Model

Table
Name rpt
Comment
A dashboard report definition.  The report information is used with the Logi
Analytics embedded reporting engine to render reports in the UI.

Column
Name Datatype Comment Is PK Is FK
rpt_id bigint The automatically generated primary key of the rpt table. Yes No
rpt_name varchar(255) The name of the Report. No No
rpt_descr varchar(512)
A descriptive name of the Report.  This descriptive name may be localized.
No No
rpt_comment varchar(255) The value of a Report, stored as a string. No No
rpt_title varchar(255) The name of the Report. No No
item_defn_id bigint A Foreign Key to the Definition Version table. No Yes
created_by bigint A Foreign Key to the Application User table. No Yes
created_on datetime The value of a Report, stored as a date. No No
mod_by bigint A Foreign Key to the Application User table. No Yes
mod_on datetime The value of a Report, stored as a date. No No
rpt_visibility_type_id int A Foreign Key to the Report Visibility Type table. No Yes
next_schdd_run_date datetime Next run date No No
rpt_grp_id bigint A Foreign Key to the Definition Version table. No Yes
rpt_type_id bigint A Foreign Key to the Definition table. No Yes
deleted_on datetime The value of a Report, stored as a date. No No