Data dictionary

One page per table, with column types and descriptions (206 pages). Generated from the SQL ontology repo.

• dbo.A&GPredefinedEstimateItems
• dbo.ApiTokens
• dbo.EthAppointmentConfig_Depcreated
• dbo.EthCompletiontimesObjectivedb
• dbo.EthEstimatorPerformance
• dbo.EthEstimatorStageSummary
• dbo.EthHOWCompliance
• dbo.EthMFAAsAService
• dbo.EthNonPrefinedItems
• dbo.EthPeerReviewQueue
• dbo.EthPeerReviewStatus
• dbo.EthPeerReviewedErrors
• dbo.EthSalesPipelinejobsObjectivedb
• dbo.EthTasks
• dbo.EventLog_Deprecated
• dbo.MSSQL_TemporalHistoryFor_731865674
• dbo.OptimoRouteLog
• dbo.PB_DateDim
• dbo.PredefinedEstimateItems
• dbo.PrimeAccountsPayableInvoices
• dbo.PrimeAccountsPayableInvoices_Depcrecated
• dbo.PrimeLockedEstimatesThisYear
• dbo.airtopSession
• dbo.clicksendConversations
• dbo.clicksendSMSReply
• dbo.elevenLabsConversations
• dbo.endataCostCentreDescriptions
• dbo.endataCostCentres
• dbo.endataLocations
• dbo.ethAIPrimeJobSummary
• dbo.ethAppointmentDefinition
• dbo.ethAppointmentDefinitionUser
• dbo.ethAppointmentInstance
• dbo.ethBooking
• dbo.ethBookingAppointmentSkill
• dbo.ethBookingConfig
• dbo.ethBookingDaySlot
• dbo.ethBookingEstimatorJobDistance
• dbo.ethBookingEstimatorSkill
• dbo.ethBookingEstimator_Deprecated
• dbo.ethBookingJobJobDistance
• dbo.ethBookingOffice
• dbo.ethBookingService
• dbo.ethBookingSlot
• dbo.ethCalendar
• dbo.ethChatQuestion
• dbo.ethECDHistory
• dbo.ethEmailMessage
• dbo.ethEmailMessageAttachment
• dbo.ethFactPriceBracket
• dbo.ethFactStatus
• dbo.ethFlowLogs_Deprecated
• dbo.ethFormDepartureNotice
• dbo.ethFormMakeSafeSLA
• dbo.ethFormSharingCode
• dbo.ethFormTriage
• dbo.ethGeoLocationStatus
• dbo.ethJobQueue
• dbo.ethKpiJobInstance
• dbo.ethKpiJobSummary
• dbo.ethKpiJobTag
• dbo.ethKpiMeasures
• dbo.ethKpiMeasures_Deprecated
• dbo.ethKpiQueue
• dbo.ethKpiResults
• dbo.ethKpiResultsActive
• dbo.ethKpiResultsActiveAll
• dbo.ethKpiResultsActive_Deprecated
• dbo.ethKpiResultsClosed_Deprecated
• dbo.ethKpiRole
• dbo.ethKpiSupervisorType
• dbo.ethListsFact
• dbo.ethPrimeInvoiceUser
• dbo.ethPrimeKeys
• dbo.ethPublicHoliday
• dbo.ethStagehandProcessLogs
• dbo.ethStagehandTasks
• dbo.ethStatusHistoriesJobQueue
• dbo.ethSyncProgress
• dbo.ethSyncProgressHistory
• dbo.ethSyncQueue
• dbo.ethSyncSchedule
• dbo.ethTask
• dbo.ethTaskLock
• dbo.ethTaskSchedule_Deprecated
• dbo.ethTradeMatchupFact
• dbo.ethWIPClientHistory_Deprecated
• dbo.ethWIPJobHidden
• dbo.ethWIPJobHistory
• dbo.ethWIPJobHistoryContacts
• dbo.ethWIPJobHistoryWorkItems
• dbo.ethWIPJobStatuses
• dbo.ethWIPJobSyncHistory
• dbo.ethWIPJobWeeklySnapshot
• dbo.ethinvoicedataObjectivedb
• dbo.ethjobsdataObjectivedb
• dbo.ethretroactiveinvoicedataObjectivedb
• dbo.ethretroactivejobsdataObjectivedb
• dbo.excelAPITest
• dbo.kpiTableLookup_Deprecated
• dbo.kpiTableResponsibilitiesLookup_Deprecated
• dbo.makesafeActivity
• dbo.makesafeEscalationSettings
• dbo.makesafeEventLog
• dbo.makesafeEventLogAction
• dbo.makesafeMessage
• dbo.makesafePhoneCall
• dbo.makesafePhoneCallHistory
• dbo.makesafePhoneCallLocation
• dbo.makesafePhoneCallTrade
• dbo.makesafeSMSMessage
• dbo.makesafeSharingCode
• dbo.makesafeSiteOptions
• dbo.makesafeUser
• dbo.makesafeUserSchedule
• dbo.n8nExecutions
• dbo.n8nFlows
• dbo.n8nRateLimit
• dbo.optimoRouteAPILog
• dbo.optimoRouteDriverDay
• dbo.optimoRouteOrder
• dbo.optimoRoutePlan
• dbo.optimoRoutePlanLog
• dbo.optimoRoutePlanOrderLog
• dbo.primeAccountsReceivableInvoices
• dbo.primeAccountsReceivableInvoicesItem
• dbo.primeAccountsReceivableInvoicesItemAllocation
• dbo.primeAllocations
• dbo.primeAllocatonStatuses
• dbo.primeAppointmentType
• dbo.primeAppointments
• dbo.primeAttachment
• dbo.primeAttachmentType
• dbo.primeCatastropheCodes
• dbo.primeContactLicences
• dbo.primeContactLocation
• dbo.primeContactRegions
• dbo.primeContactRelationshipTypes
• dbo.primeContactRelationships
• dbo.primeContactTrades
• dbo.primeContacts
• dbo.primeEmailJobRegistered
• dbo.primeEmailMessageQueue
• dbo.primeEstimateCategories
• dbo.primeEstimateCategoryItems
• dbo.primeEstimates
• dbo.primeExportActualInvoicedFYTD
• dbo.primeExportAssetUtilisation
• dbo.primeExportAttachmentSWMSCount
• dbo.primeExportClosedJobReviewARTotal
• dbo.primeExportClosedJobReviewCosts
• dbo.primeExportClosedJobReviewInvAuthWorks
• dbo.primeExportConversionReport
• dbo.primeExportCurrentMonthSalesForecastList
• dbo.primeExportFeedbackRegister
• dbo.primeExportFormConstructionReport
• dbo.primeExportFutureInvoices
• dbo.primeExportJobTags
• dbo.primeExportJobWIPList
• dbo.primeExportJobsRegistered
• dbo.primeExportPastInvoices
• dbo.primeExportRegionsandSuburbs
• dbo.primeExportRestorationSales
• dbo.primeExportUpdatedStatus
• dbo.primeExportWIPJobsWithoutForecast
• dbo.primeExportWIPUpdates
• dbo.primeExportsEndataScopeImport
• dbo.primeExportsEndataScopeImport_stage
• dbo.primeFilterTags
• dbo.primeFilterTypes
• dbo.primeHistory
• dbo.primeHistoryActions
• dbo.primeHistoryItem
• dbo.primeJobCustomField
• dbo.primeJobDateHistory
• dbo.primeJobFilterTags
• dbo.primeJobs
• dbo.primeJobsLocation
• dbo.primeJobsLocationTask
• dbo.primeJobsTemp
• dbo.primeLockedEstimateCategories
• dbo.primeLockedEstimateCategoryItems
• dbo.primeLockedEstimates
• dbo.primeMilestone
• dbo.primeMilestoneItem
• dbo.primeMilestoneItemFirstValue
• dbo.primeNotificationTemplates
• dbo.primeNotifications
• dbo.primePerils
• dbo.primeSchedule
• dbo.primeScheduleItem
• dbo.primeScheduleItemLinkFrom
• dbo.primeScheduleItemLinkTo
• dbo.primeSiteFormItems
• dbo.primeSiteFormTemplates
• dbo.primeSiteForms
• dbo.primeStatusHistories_Job
• dbo.primeStatuses
• dbo.primeTrades
• dbo.primeUsers
• dbo.primeWorkOrderItems
• dbo.primeWorkOrders
• dbo.primeinvoicecheck
• dbo.sysdiagrams
• dbo.wipStatus
• dbo.wipTextInstructions