dbo.OptimoRouteLog

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.OptimoRouteLog.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key of the log entry.
2	Module	nvarchar(50)	no		Name of the OptimoRoute integration module/component that generated this log entry.
3	Action	nvarchar(50)	no		The action performed or event that occurred (e.g. create/update/sync/error).
4	JobID	uniqueidentifier	yes		Prime Ecosystem job the log entry relates to, if applicable.
5	AppointmentID	uniqueidentifier	yes		Prime Ecosystem appointment the log entry relates to, if applicable.
6	BookingID	int	yes		ethBooking record the log entry relates to, if applicable.
7	UserID	uniqueidentifier	yes		User (e.g. estimator/driver) the log entry relates to, if applicable.
8	Details	nvarchar(1000)	yes		Free-text detail/message describing what happened, e.g. request/response info or error text.
9	UpdatedAt	datetime	no		Timestamp when this log entry was recorded.
10	PlanDate	datetime	yes		Date of the OptimoRoute route plan the log entry relates to, if applicable.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_OptimoRouteLog_UpdatedAt	NONCLUSTERED			UpdatedAt	Action, AppointmentID, BookingID, JobID, Module, UserID
IX_OptimoRouteLog_ModuleActionUpdatedAt	NONCLUSTERED			Module, Action, UpdatedAt

Relationships (inferred)

From	To	Confidence
dbo.OptimoRouteLog.AppointmentID	dbo.primeAppointments.id	high
dbo.OptimoRouteLog.JobID	dbo.primeJobs.Id	high
dbo.OptimoRouteLog.UserID	dbo.primeUsers.id	high

Referenced by

Procedures: dbo.spOptimoRouteGetDistinctActions, dbo.spOptimoRouteGetDistinctModules, dbo.spOptimoRouteGetLogs, dbo.spOptimoRouteGetLogsPaged, dbo.spOptimoRouteLogInsert