Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AHP_ID | int identity | 4 | null |
|
|
|||
| CARE_ID | int | 4 | null |
|
|
|||
| FIRST_CONTACT | int | 4 | √ | null |
|
|
||
| L_REF_DATE | smalldatetime | 16 | √ | null |
|
|
||
| L_SEEN_DATE | smalldatetime | 16 | √ | null |
|
|
||
| L_AHP | int | 4 | √ | null |
|
|
||
| L_AHP_ID | int | 4 | √ | null |
|
|
||
| L_AHP_ROLE | int | 4 | √ | null |
|
|
||
| L_AHP_NAME | varchar | 100 | √ | null |
|
|
||
| L_CONTACT_PAT | int | 4 | √ | null |
|
|
||
| L_CONTACT_REL | int | 4 | √ | null |
|
|
||
| L_CONTACT_CARER | int | 4 | √ | null |
|
|
||
| L_CONTACT_PROF | int | 4 | √ | null |
|
|
||
| L_HCP_ROLE | int | 4 | √ | null |
|
|
||
| L_HCP_NAME | varchar | 255 | √ | null |
|
|
||
| L_CONTACT_TYPE | int | 4 | √ | null |
|
|
||
| L_TOTAL_TIME | int | 4 | √ | null |
|
|
||
| L_CONTACT_PLACE | int | 4 | √ | null |
|
|
||
| L_PRIVACY | int | 4 | √ | null |
|
|
||
| L_ADVICE | text | 2147483647 | √ | null |
|
|
||
| L_ACTIVITY | text | 2147483647 | √ | null |
|
|
||
| L_DENTAL_TREATMENT | int | 4 | √ | null |
|
|
||
| R_SWALLOW | varchar | 3 | √ | null |
|
|
||
| R_DIET | int | 4 | √ | null |
|
|
||
| R_SVR | varchar | 3 | √ | null |
|
|
||
| R_CONTACT_PURPOSE | varchar | 2 | √ | null |
|
|
||
| R_PT_STATUS | int | 4 | √ | null |
|
|
||
| R_COMM | varchar | 4 | √ | null |
|
|
||
| R_COMM_PRIMARY | varchar | 2 | √ | null |
|
|
||
| R_COMM_OTHER | varchar | 2 | √ | null |
|
|
||
| R_VOICING | int | 4 | √ | null |
|
|
||
| R_REMOVAL_REASON | int | 4 | √ | null |
|
|
||
| R_HEIGHT | real | 4 | √ | null |
|
|
||
| R_WEIGHT | real | 4 | √ | null |
|
|
||
| N_HN15_NUTRITION | varchar | 1 | √ | null |
|
|
||
| N_HN16_NUTRITION_TYPE | varchar | 1 | √ | null |
|
|
||
| N_HN17_NUTRITION_PROCEDURE | int | 4 | √ | null |
|
|
||
| N_HN18_NUTRITION_COMP | varchar | 5 | √ | null |
|
|
||
| R_SUPPORT_REMAIN | varchar | 1 | √ | null |
|
|
||
| L_NOTES | text | 2147483647 | √ | null |
|
|