Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
CON_ID | int | 4 | null |
|
|
|||||
PALLIATIVE_ID | int | 4 | √ | null |
|
|
||||
TEMP_ID | varchar | 255 | √ | null |
|
|
||||
L_CONTACT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
L_RESIDENCE | int | 4 | √ | null |
|
|
||||
L_LOCATION | int | 4 | √ | null |
|
|
||||
L_OTHER_LOCATION | varchar | 255 | √ | null |
|
|
||||
L_HOSPITAL | varchar | 5 | √ | null |
|
|
||||
L_CLINIC | varchar | 255 | √ | null |
|
|
||||
L_CONTACT_TYPE | int | 4 | √ | null |
|
|
||||
L_TIME | int | 4 | √ | 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_PROF_WHO | varchar | 255 | √ | null |
|
|
||||
L_SEEN_BY | int | 4 | √ | null |
|
|
||||
L_SEEN_NAME | varchar | 50 | √ | null |
|
|
||||
L_SEEN_BY_2 | int | 4 | √ | null |
|
|
||||
L_SEEN_NAME_2 | varchar | 50 | √ | null |
|
|
||||
L_PAIN_CONTROL | int | 4 | √ | null |
|
|
||||
L_OTHER_SYMP_MAN | int | 4 | √ | null |
|
|
||||
L_TEL_SUPP | int | 4 | √ | null |
|
|
||||
L_PSYC_SUPP | int | 4 | √ | null |
|
|
||||
L_INFO_GIVE | int | 4 | √ | null |
|
|
||||
L_PAL_TREAT | int | 4 | √ | null |
|
|
||||
L_TERM_CARE | int | 4 | √ | null |
|
|
||||
L_STAFF_SUPP | int | 4 | √ | null |
|
|
||||
L_FAM_SUPP | int | 4 | √ | null |
|
|
||||
L_DISCH_LIASON | int | 4 | √ | null |
|
|
||||
L_PLN_RAPID_DISCH | int | 4 | √ | null |
|
|
||||
L_HOME_VISIT | int | 4 | √ | null |
|
|
||||
L_BEREAV_SUPP | int | 4 | √ | null |
|
|
||||
L_INT_INVEST | int | 4 | √ | null |
|
|
||||
L_PAT_REL_ADMIN | int | 4 | √ | null |
|
|
||||
L_REF_COMP_INT | int | 4 | √ | null |
|
|
||||
L_INT_BLOOD | int | 4 | √ | null |
|
|
||||
L_INT_PARA | int | 4 | √ | null |
|
|
||||
L_INT_NEURAL | int | 4 | √ | null |
|
|
||||
L_INT_INFUSE | int | 4 | √ | null |
|
|
||||
L_CURRENT_MEDICATION | varchar | 255 | √ | null |
|
|
||||
L_CURRENT_THERAPIES | varchar | 255 | √ | null |
|
|
||||
L_CURRENT_DIET | varchar | 255 | √ | null |
|
|
||||
L_CURRENT_EXCERCISE | varchar | 255 | √ | null |
|
|
||||
L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
PATIENT_ID | int | 4 | √ | null |
|
|
||||
L_REG_DATE | smalldatetime | 16 | √ | null |
|
|