Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Facility Name | varchar | 500 | √ | null |
|
|
||
| Facility Govid | varchar | 50 | √ | null |
|
|
||
| Care Area | varchar | 200 | √ | null |
|
|
||
| F-Tag Num | varchar | 50 | √ | null |
|
|
||
| F-Tag Title | varchar | 500 | √ | null |
|
|
||
| Root Causes | varchar | 2000 | √ | null |
|
|
||
| Date | date | 6 | √ | null |
|
|
||
| Response History | nvarchar | 8000 | √ | null |
|
|
||
| SnapshotId | int | 4 | null |
|
|
|||
| Snapshot Name | varchar | 200 | √ | null |
|
|
||
| Snapshot Type | varchar | 200 | √ | null |
|
|
||
| Snapshot Date | date | 6 | √ | null |
|
|
||
| Snapshot Status | varchar | 100 | √ | null |
|
|
||
| AVA_insdate | datetime2 | 16 | null |
|
|