dbo.ethWIPJobHistoryWorkItems

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Identity primary key of the WIP job history work item record.
2	WIPJobHistoryID	int	no		Foreign key to the parent ethWIPJobHistory record (WIP update) this work item line belongs to.
3	SortOrder	int	no		Display order of this work item line within its section on the WIP update.
4	Section	nvarchar(50)	no		Name of the section of the WIP update this work item line appears under (e.g. a room or scope-of-work grouping).
5	Content	nvarchar(2048)	no		Free-text description of the scope-of-work line item.
6	UpdatedAt	datetime	no		Date and time this work item line was last modified.

Indexes

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

Referenced by

Procedures: dbo.spEthWIPJobSyncHistoryGetWorkItems, dbo.spEthWIPUpsertJobHistoryWorkItems