Appearance
dbo.primeMilestoneItemFirstValue
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeMilestoneItemFirstValue.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | id | uniqueidentifier | no | Primary key / unique identifier for this record | |
| 2 | jobId | uniqueidentifier | no | Foreign key to primeJobs | |
| 3 | milestoneId | uniqueidentifier | no | Foreign key to primeMilestone | |
| 4 | value | nvarchar(255) | no | Value of the field/attribute | |
| 5 | recordedAt | datetime2(0) | no | Timestamp this record was captured | |
| 6 | recordedBy | nvarchar(100) | yes | User/system that captured this record |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_primeMilestoneItemFirstValue | CLUSTERED | yes | yes | id | ||
| UQ_primeMilestoneItemFirstValue_JobMilestone | NONCLUSTERED | yes | jobId, milestoneId |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.primeMilestoneItemFirstValue.jobId | dbo.primeJobs.Id | high |
Referenced by
Procedures: dbo.spEthRepairlineJobDatesQueueTasks, dbo.spEthSedgwickJobDatesqueueTasks, dbo.spPrimeGetJobDates, dbo.spPrimeUpsertMilestoneItems