Database Schema Diagram

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

Change History

8.215

  • Added Approval_Group table

  • Added Approval.Operation

8.214

  • Added Report_Template.Asset_Dashboard

  • Removed Report_Template.Is_Asset_Dashboard

  • Removed Signoff.Description

  • Added Signoff.Comments

  • Removed Finding_Signoff.Description

  • Added Signoff.Comments

  • Removed Header.HasComments

  • Removed Finding.HasComments

  • Added Repository_Data.Thumbnail_Data

  • Added Personnel.Job_Title

  • Added Description, Category to Chart

  • Added Vertical_Align, Text_Orientation and numerous field changes to Report_Style

  • Added Form_Page.Page_Order

  • Added Table_Def.Supports_Attributes

  • Added Comp_Type.Prevent_Duplicates

  • Added Report_Category.Enabled

  • Added Finding_Status table and Finding.FS_ID

  • Added Drawing_Properties, Client.Job_Retention, remove unused fields.

8.211

  • Added User_Setting table.

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.