Footprints Data Model

Table
Name rpt_cfg
Comment Configuration data values associated with a dashboard report.

Column
Name Datatype Comment Is PK Is FK
rpt_cfg_id bigint The automatically generated primary key of the rpt_cfg table. Yes No
rpt_id bigint A Foreign Key to the Report table. No Yes
rpt_cfg_name varchar(255) The name of the Report Configuration. No No
val_type_cd char(1)
The data type for a Value Type Code.  The choices are 'S' string, 'D' date, 'T'
text, 'I' integer.
No Yes
string_val varchar(255) The value of a Report Configuration, stored as a string. No No
text_val varchar(max) The value of a Report Configuration, stored as a long text object. No No
date_val datetime The value of a Report Configuration, stored as a date. No No
real_val numeric(38,20) The value of a Report Configuration stored as real. No No
int_val int The value of a Report Configuration stored as boolean. No No
long_val bigint The value of a Report Configuration stored as Long. No No
boolean_val bit The Boolean Value. No No