Appearance
dbo.ethWIPClientHistory_Deprecated
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethWIPClientHistory_Deprecated.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | Identity primary key of the deprecated WIP client history record. |
| 2 | WIPID | int | no | Identifier of the related WIP job update record this client history entry belongs to. | |
| 3 | JobId | uniqueidentifier | no | Prime Ecosystem job (primeJobs.id) this client history entry relates to. | |
| 4 | CreatedAt | datetime | no | Date and time this client history record was created. | |
| 5 | UpdatedAt | datetime | no | Date and time this client history record was last modified. | |
| 6 | ClientUpdatePostedAt | datetime | yes | Date and time the client-facing update/note was posted for this job; null if not yet posted. |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_ethWIPClientHistory | CLUSTERED | yes | yes | ID |

