dbo.primeContactLicences

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Primary key / unique identifier for this record
2	contactId	uniqueidentifier	yes		Foreign key to primeContacts
3	licenceStatus	varchar(50)	yes		Status of the contact's trade licence
4	licenceType	varchar(50)	yes		Type of trade licence held
5	licenceClassification_id	uniqueidentifier	yes		Foreign key reference to the related licenceClassification_ record
6	state	varchar(50)	yes		State/territory of the site/property address
7	attachmentId	uniqueidentifier	yes		Foreign key to primeAttachment
8	licenceNumber	varchar(50)	yes		Contact's trade licence number
9	startDate	date	yes		Start date of this record/job
10	expiryDate	date	yes		Date this record/licence expires
11	label	varchar(100)	yes		Display label
12	notes	text(16)	yes		Free-text internal notes
13	version	int	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeCon__3213E83F3E859920	CLUSTERED	yes	yes	id

Referenced by

Procedures: dbo.spPrimeUpsertContactLicences