dbo.primeJobCustomField

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Primary key / unique identifier for this record
2	jobId	uniqueidentifier	yes		Foreign key to primeJobs
3	customFieldId	uniqueidentifier	yes		Foreign key to primeJobCustomField definition
4	customFieldActive	bit	yes		Flag indicating whether the custom field is active
5	type	varchar(50)	yes		Category/type classification of this record
6	name	nvarchar(255)	yes		Display name
7	label	nvarchar(255)	yes		Display label
8	description	nvarchar(MAX)	yes		Free-text description
9	value	nvarchar(MAX)	yes		Value of the field/attribute
10	isRequired	bit	yes		Flag indicating whether this field/item is required
11	order	int	yes		Sort order of this item
12	createdAt	datetime2(0)	yes		Timestamp the record was created
13	createdBy	nvarchar(100)	yes		User/system that created the record
14	updatedAt	datetime2(0)	yes		Timestamp the record was last updated
15	updatedBy	nvarchar(100)	yes		User/system that last updated the record
16	version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeJobCustomField	CLUSTERED	yes	yes	id
IX_primeJobCustomField_jobId	NONCLUSTERED			jobId
IX_primeJobCustomField_customFieldId	NONCLUSTERED			customFieldId

Relationships (inferred)

From	To	Confidence
dbo.primeJobCustomField.jobId	dbo.primeJobs.Id	high

Referenced by

Procedures: dbo.spPrimeUpsertJobCustomFields