Footprints Data Model

Table
Table Name Report Configuration
Table Definition Configuration data values associated with a dashboard report.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Report Configuration Id The automatically generated primary key of the rpt_cfg table. LONG Yes
Report Id A Foreign Key to the Report table. LONG No
Report Configuration Name The name of the Report Configuration. VARCHAR(255) No
Value Type Code The data type for a Value Type Code. The choices are 'S' string, 'D' date, 'T' text, 'I' integer. CHAR(1) No
String Value The value of a Report Configuration, stored as a string. VARCHAR(255) No
Text Value The value of a Report Configuration, stored as a long text object. TEXT No
Date Value The value of a Report Configuration, stored as a date. DATE No
Real Value The value of a Report Configuration stored as real. DECIMAL(,) No
Int Value The value of a Report Configuration stored as boolean. INTEGER No
Long Value The value of a Report Configuration stored as Long. LONG No
Boolean Value The Boolean Value. BOOLEAN No