Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
contactID | int | 4 | null |
|
|
|||||
distressValue | int | 4 | ((0)) |
|
|
|||||
childCare | bit | 1 | ((0)) |
|
|
|||||
housing | bit | 1 | ((0)) |
|
|
|||||
insurance | bit | 1 | ((0)) |
|
|
|||||
transportation | bit | 1 | ((0)) |
|
|
|||||
workSchool | bit | 1 | ((0)) |
|
|
|||||
dealingWithChildren | bit | 1 | ((0)) |
|
|
|||||
dealingWithPartner | bit | 1 | ((0)) |
|
|
|||||
depression | bit | 1 | ((0)) |
|
|
|||||
fears | bit | 1 | ((0)) |
|
|
|||||
nervousness | bit | 1 | ((0)) |
|
|
|||||
sadness | bit | 1 | ((0)) |
|
|
|||||
worry | bit | 1 | ((0)) |
|
|
|||||
lossOfFaith | bit | 1 | ((0)) |
|
|
|||||
relatingToGod | bit | 1 | ((0)) |
|
|
|||||
appearance | bit | 1 | ((0)) |
|
|
|||||
bathingDressing | bit | 1 | ((0)) |
|
|
|||||
breathing | bit | 1 | ((0)) |
|
|
|||||
changesInUrination | bit | 1 | ((0)) |
|
|
|||||
constipation | bit | 1 | ((0)) |
|
|
|||||
diarrhea | bit | 1 | ((0)) |
|
|
|||||
eating | bit | 1 | ((0)) |
|
|
|||||
fatigue | bit | 1 | ((0)) |
|
|
|||||
feelingSwollen | bit | 1 | ((0)) |
|
|
|||||
fevers | bit | 1 | ((0)) |
|
|
|||||
gettingAround | bit | 1 | ((0)) |
|
|
|||||
indigestion | bit | 1 | ((0)) |
|
|
|||||
mouthSores | bit | 1 | ((0)) |
|
|
|||||
nausea | bit | 1 | ((0)) |
|
|
|||||
noseDryCongested | bit | 1 | ((0)) |
|
|
|||||
pain | bit | 1 | ((0)) |
|
|
|||||
sexual | bit | 1 | ((0)) |
|
|
|||||
skinDryItchy | bit | 1 | ((0)) |
|
|
|||||
sleep | bit | 1 | ((0)) |
|
|
|||||
tinglingInHandsFeet | bit | 1 | ((0)) |
|
|
|||||
communication | bit | 1 | ((0)) |
|
|
|||||
householdtasks | bit | 1 | ((0)) |
|
|
|||||
money | bit | 1 | ((0)) |
|
|
|||||
mealsDrinks | bit | 1 | ((0)) |
|
|
|||||
relativeFriend | bit | 1 | ((0)) |
|
|
|||||
anger | bit | 1 | ((0)) |
|
|
|||||
diffMakingPlans | bit | 1 | ((0)) |
|
|
|||||
guilt | bit | 1 | ((0)) |
|
|
|||||
loneliness | bit | 1 | ((0)) |
|
|
|||||
notAtPeace | bit | 1 | ((0)) |
|
|
|||||
lossOfMeaningPurpose | bit | 1 | ((0)) |
|
|
|||||
flushes | bit | 1 | ((0)) |
|
|
|||||
memoryProblems | bit | 1 | ((0)) |
|
|
|||||
speechProblems | bit | 1 | ((0)) |
|
|
|||||
tasteDisturbance | bit | 1 | ((0)) |
|
|
|||||
woundProblems | bit | 1 | ((0)) |
|
|
|||||
otherProblems | varchar | 8000 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_tblPALLIATIVE_HOLISTIC_ASSESSMENT | Primary key | Asc | contactID |