Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
DisabilityAdjustmentHistorySeq | int identity | 4 | √ | null |
|
|
||
TransactionMode | char | 1 | √ | null |
|
|
||
DisabilityAdjustmentSeq | int | 4 | √ | null |
|
|
||
ID | int | 4 | √ | null |
|
|
||
DisabilityCategoryCode | varchar | 15 | √ | null |
|
|
||
DisabilityAdjustmentLevelCode | varchar | 15 | √ | null |
|
|
||
IncludeInExportFlag | bit | 1 | √ | null |
|
|
||
IdentifiedNeeds | varchar | 2147483647 | √ | null |
|
|
||
AdjustmentsMade | varchar | 2147483647 | √ | null |
|
|
||
StartDate | datetime | 16,3 | √ | null |
|
|
||
ReviewDate | datetime | 16,3 | √ | null |
|
|
||
EndDate | datetime | 16,3 | √ | null |
|
|
||
Consultation | varchar | 2147483647 | √ | null |
|
|
||
Review | varchar | 2147483647 | √ | null |
|
|
||
CreatedByID | int | 4 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | null |
|
|
||
ModifiedByID | int | 4 | √ | null |
|
|
||
ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
DeletedByID | int | 4 | √ | null |
|
|
||
DeletedDate | datetime | 16,3 | √ | null |
|
|
Table contained -1 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_DisabilityAdjustmentHistory | Primary key | Asc | DisabilityAdjustmentHistorySeq |
AK_DisabilityAdjustmentHistory_ID | Performance | Asc | ID |