Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ID | bigint identity | 8 | √ | null |
|
|
||||||||||
ReferralID | int | 4 | null |
|
|
|||||||||||
ReferralTypeID | int | 4 | null |
|
|
|||||||||||
RecordID | varchar | 255 | null |
|
|
|||||||||||
RecordTypeID | int | 4 | null |
|
|
|||||||||||
ReleaseBuildID | int | 4 | null |
|
|
|||||||||||
DateChanged | date | 20 | null |
|
|
|||||||||||
FieldNameID | int | 4 | null |
|
|
|||||||||||
OldFieldValue | nvarchar | 1073741823 | null |
|
|
|||||||||||
NewFieldValue | nvarchar | 1073741823 | √ | null |
|
|
||||||||||
WorkItemNumber | int | 4 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
HistoricData_ID | Primary key | Asc | ID |