Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
AHP_ID | int identity | 4 | null |
|
|
|||||
CARE_ID | int | 4 | null |
|
|
|||||
TEMP_ID | varchar | 255 | √ | 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_WHO_CONTACT | varchar | 1 | √ | 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 |
|
|
||||
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 |
|
|
||||
R_EST_WEIGHT | real | 4 | √ | null |
|
|
||||
R_HEIGHT | varchar | 30 | √ | null |
|
|
||||
R_WEIGHT | varchar | 30 | √ | null |
|
|
||||
L_NOTES | text | 2147483647 | √ | null |
|
|