Footprints Data Model

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

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Report Id The automatically generated primary key of the rpt table. LONG Yes
Report Name The name of the Report. VARCHAR(255) No
Report Description A descriptive name of the Report. This descriptive name may be localized. VARCHAR(512) No
Report Comment The value of a Report, stored as a string. VARCHAR(255) No
Report Title The name of the Report. VARCHAR(255) No
Item Definition Id A Foreign Key to the Definition Version table. LONG No
Created By A Foreign Key to the Application User table. LONG No
Created On The value of a Report, stored as a date. DATE No
Modified By A Foreign Key to the Application User table. LONG No
Modified On The value of a Report, stored as a date. DATE No
Report Visibility Type Id A Foreign Key to the Report Visibility Type table. INTEGER No
Next Scheduled Run Date Next run date DATE No
Report Group Id A Foreign Key to the Definition Version table. LONG No
Report Type Id A Foreign Key to the Definition table. LONG No
Deleted On The value of a Report, stored as a date. DATE No