Database Schema Diagram

Click to download a copy of the latest core database schema diagram pdf

Change History

8.184

  • Added Report_Schedule.Status

8.181

  • Removed Report_Template.IsWelcomePage
  • Renamed Report_Template.IsDashboard to Is_Asset_Dashboard
  • Added Chart.Show_X_Axis_Title and Chart.Show_Y_Axis_Title

8.180

  • Renamed function GetDate to ‘Current Date/Time’, added ‘Current Date’.
  • Removed Range Event Type.

8.179

  • Removed Report_Template.Last_Generation_Time
  • Added new Report_Generation table.

8.178

  • Added FP_ID to Workflow_Item_Input.

8.177

  • Changed Report_Part.Name to 200 characters.
  • New calculated fields for Library_Conn and Library.

8.176

  • Added Allow_Adhoc (bit) to Task.
  • Added Adhoc_Complete (bit) to Task.
  • Added Report_Favourite table.
  • Added Dashboard_Report (bit) to Report_Template.
  • Added Supports_Dashboard (bit) to Report_Part_Type.
  • Added Schedule_Repeat table.
  • Added Report_Schedule table.

8.174

  • Added Map_Server table.

8.173

  • Added Expiry (datetime) field to Repository_Data table.
  • Added Text_Align table and TA_ID (int) field to Field_Layout table.
  • Added Allow_Add (bit) to Form_Page table.