dbo.primeJobDateHistory

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Id	int	no	identity	Primary key / unique identifier for this record
2	JobId	uniqueidentifier	no		Foreign key to primeJobs
3	ContractSent	datetime	yes		Timestamp the contract was sent
4	ContractReturned	datetime	yes		Timestamp the signed contract was returned
5	ExpectedStartDate	datetime	yes		Expected/scheduled start date
6	ExpectedEndDate	datetime	yes		Expected/scheduled end date
7	ActualStartDate	datetime	yes		Actual date work started
8	ActualEndDate	datetime	yes		Actual date work finished
9	UpdatedAt	datetime	no		Timestamp the record was last updated

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeJobDateHistory	CLUSTERED	yes	yes	Id
UQ_primeJobDateHistory_JobId	NONCLUSTERED	yes		JobId

Relationships (inferred)

From	To	Confidence
dbo.primeJobDateHistory.JobId	dbo.primeJobs.Id	high

Referenced by

Procedures: dbo.spEthRepairlineJobDatesQueueTasks, dbo.spEthSedgwickJobDatesqueueTasks, dbo.spPrimeGetJobDates, dbo.spPrimeUpsertJobDateHistory