dbo.primeJobsLocationTask

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.primeJobsLocationTask.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	nearestHospital	bit	no		Flag indicating whether nearest hospital information is required/known
4	nearestDoctor	bit	no		Flag indicating whether nearest doctor information is required/known
5	updatedAt	datetime2(7)	no		Timestamp the record was last updated

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeJobsLocationTask	CLUSTERED	yes	yes	ID

Relationships (inferred)

From	To	Confidence
dbo.primeJobsLocationTask.jobID	dbo.primeJobs.Id	medium

Referenced by

Procedures: dbo.spPrimeGetJobsLocationTaskQueue, dbo.spPrimeSetJobsLocationTask