Appearance
dbo.ethECDHistory
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethECDHistory.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | LastECD | datetime | yes | The previously recorded Estimated Completion Date (ECD) for the job before this change was captured. | |
| 2 | JobID | uniqueidentifier | no | Foreign key to the Prime Ecosystem job whose Estimated Completion Date changed. | |
| 3 | ID | int | no | identity | Surrogate primary key identifying this Estimated Completion Date history record. |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_ethECDHistory | CLUSTERED | yes | yes | ID |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.ethECDHistory.JobID | dbo.primeJobs.Id | medium |
Referenced by
Procedures: dbo.spEthNexusECDQueueTasks, dbo.spPrimeUpsertECDHistory

