Database Schema Diagram

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

Change History

8.210

  • Added table indexes to optimise some calculations and row retrievals.
  • Updated ‘Library’ icon.

8.209

  • Added Comp_Type.Category
  • Added Action.Is_Due
  • Added Anomaly.Assigned_To_ID
  • Renamed Anomaly.Created_By to Anomaly.Created_By_ID
  • Added Anomaly.CV_ID

8.208

  • Added Report_Schedule.SU_ID

8.207

  • Increased Session.IP_Address to 45 characters

8.206

  • Added Security_Hash.Session_ID

8.205

  • Added Visible and Order (IC-Inspector) to Field Definition as passthrus
  • Changed Personnel.Email to be 254 characters
  • Added Category to Scenario
  • Added RBI_Model_Comp_Type table
  • Added Filter_Order to Workflow_Filter

8.204

  • Added Server_Job table
  • Added Est_Timing_FD_ID and Requires_Shutdown_FD_ID to LTIP_Task
  • Added Allow_Adhoc to LTIP_Task
  • Added Enabled to Workflow
  • Added LinkTD_ID to Field_Def
  • Added Include_Timestamp to Report_Schedule

8.201

  • Increase Workpack.Abbreviation to 15 characters

8.199

  • New chart series types
  • Added Function_Definition.Readonly
  • Added Approval.Link_ID
  • Added Active_Inspection.Is_Inspecting

8.198

  • Increased size of Library.Name to 100 characters

8.196

  • Added Layer.Auto_Layer_Id

8.195

  • Added Expert_System.Signature
  • Added Expert_System_Row.Manual
  • Added Task.Retasked_Same
  • Added Task.Is_Held

8.194

  • Added Form_Caption, Visible_Mobile, Mobile_Order and Mobile_Caption to Field_Layout
  • Added LTIP.WPG_ID and LTIP.Revision_ID
  • Added Series.Opacity
  • Added Chart.Available
  • Added Layer.Relative_Asset
  • Change Action.Created_By and Assigned_To to FK’s to Personnel
  • Added Table_Def.Allow_History
  • Added Finding.Status
  • Added LTIP_Task.Instructions_FD_ID
  • Added Bound.Include_Bounds
  • Added Report_Schedule.FD_ID
  • Added Overlay_Value.Legend_Order
  • Added Finding.Finding_Number
  • Added Finding.Has_Comments
  • Added Export_System, Expert_System_Row, and Expert_System_Version tables.

8.193

  • Added Table_Def.Auto_Calculate field

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.