Database Schema Diagram

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

Change History

8.191

  • Added Keepalive to Report_Schedule

8.188

  • Added Field_Def.Require_Unique and Field_Def.Unique_FD_ID
  • Added Task.Reference_Number
  • Added Line Weights for Series
  • Added Planning Task.Asset_Location

8.187

  • Added Library.Force_2D
  • Added Bound.Date_From, Bound.Date_To

8.186

  • Added Workflow_Item_Input.Attribute_Name
  • Added Approval, Approval_Note and Approval_Field tables
  • Added Client.Secondary_Logo

8.185

  • Added Asset_Location to Task, Finding, Event, Anomaly
  • Added Asset_Location to Library_Conn
  • Added Asset_Location to Component
  • Added RS_ID to Report_Template, and Report_Status table
  • Added Unit.Description
  • Added Workpack.Event_Count

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.