Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN_ID | int identity | 4 | √ | null |
|
|
||||
| PUBLISHED_TREATMENT_SUMMARY_ID | int | 4 | null |
|
|
|||||
| PUBLISHED_CNS_CONCERN_NAME | varchar | 50 | √ | null |
|
|
||||
| PUBLISHED_CNS_CONCERN_DETAILS | varchar | 2147483647 | √ | null |
|
|
||||
| PUBLISHED_CNS_PATIENT_ACTIONS | varchar | 2147483647 | √ | null |
|
|
||||
| PUBLISHED_CNS_CNS_ACTIONS | varchar | 2147483647 | √ | null |
|
|
||||
| PUBLISHED_CNS_DISTRESS_VALUE | int | 4 | √ | null |
|
|
||||
| CaringResponsibilities | varchar | 100 | √ | null |
|
|
||||
| LossOfInterest | varchar | 100 | √ | null |
|
|
||||
| anger | varchar | 100 | √ | null |
|
|
||||
| appearance | varchar | 100 | √ | null |
|
|
||||
| bathingDressing | varchar | 100 | √ | null |
|
|
||||
| breathing | varchar | 100 | √ | null |
|
|
||||
| cbAlcohol | varchar | 100 | √ | null |
|
|
||||
| cbDiet | varchar | 100 | √ | null |
|
|
||||
| cbExercise | varchar | 100 | √ | null |
|
|
||||
| cbHobbies | varchar | 100 | √ | null |
|
|
||||
| cbOther | varchar | 100 | √ | null |
|
|
||||
| cbSmoking | varchar | 100 | √ | null |
|
|
||||
| cbSun | varchar | 100 | √ | null |
|
|
||||
| cbSupport | varchar | 100 | √ | null |
|
|
||||
| cbTherapies | varchar | 100 | √ | null |
|
|
||||
| cbexpressfeelings | varchar | 100 | √ | null |
|
|
||||
| cbhopelessness | varchar | 100 | √ | null |
|
|
||||
| changesInUrination | varchar | 100 | √ | null |
|
|
||||
| childCare | varchar | 100 | √ | null |
|
|
||||
| communication | varchar | 100 | √ | null |
|
|
||||
| constipation | varchar | 100 | √ | null |
|
|
||||
| dealingWithChildren | varchar | 100 | √ | null |
|
|
||||
| dealingWithPartner | varchar | 100 | √ | null |
|
|
||||
| depression | varchar | 100 | √ | null |
|
|
||||
| diarrhea | varchar | 100 | √ | null |
|
|
||||
| diffMakingPlans | varchar | 100 | √ | null |
|
|
||||
| eating | varchar | 100 | √ | null |
|
|
||||
| fatigue | varchar | 100 | √ | null |
|
|
||||
| fears | varchar | 100 | √ | null |
|
|
||||
| feelingSwollen | varchar | 100 | √ | null |
|
|
||||
| fevers | varchar | 100 | √ | null |
|
|
||||
| flushes | varchar | 100 | √ | null |
|
|
||||
| gettingAround | varchar | 100 | √ | null |
|
|
||||
| guilt | varchar | 100 | √ | null |
|
|
||||
| householdtasks | varchar | 100 | √ | null |
|
|
||||
| housing | varchar | 100 | √ | null |
|
|
||||
| indigestion | varchar | 100 | √ | null |
|
|
||||
| insurance | varchar | 100 | √ | null |
|
|
||||
| loneliness | varchar | 100 | √ | null |
|
|
||||
| lossOfFaith | varchar | 100 | √ | null |
|
|
||||
| lossOfMeaningPurpose | varchar | 100 | √ | null |
|
|
||||
| mealsDrinks | varchar | 100 | √ | null |
|
|
||||
| memoryProblems | varchar | 100 | √ | null |
|
|
||||
| money | varchar | 100 | √ | null |
|
|
||||
| mouthSores | varchar | 100 | √ | null |
|
|
||||
| nausea | varchar | 100 | √ | null |
|
|
||||
| nervousness | varchar | 100 | √ | null |
|
|
||||
| noseDryCongested | varchar | 100 | √ | null |
|
|
||||
| notAtPeace | varchar | 100 | √ | null |
|
|
||||
| pain | varchar | 100 | √ | null |
|
|
||||
| relatingToGod | varchar | 100 | √ | null |
|
|
||||
| relativeFriend | varchar | 100 | √ | null |
|
|
||||
| sadness | varchar | 100 | √ | null |
|
|
||||
| sadnessOrDepression | varchar | 100 | √ | null |
|
|
||||
| sexual | varchar | 100 | √ | null |
|
|
||||
| skinDryItchy | varchar | 100 | √ | null |
|
|
||||
| sleep | varchar | 100 | √ | null |
|
|
||||
| speechProblems | varchar | 100 | √ | null |
|
|
||||
| tasteDisturbance | varchar | 100 | √ | null |
|
|
||||
| tinglingInHandsFeet | varchar | 100 | √ | null |
|
|
||||
| transportation | varchar | 100 | √ | null |
|
|
||||
| workSchool | varchar | 100 | √ | null |
|
|
||||
| worry | varchar | 100 | √ | null |
|
|
||||
| woundProblems | varchar | 100 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblTREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN | Primary key | Asc | TREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN_ID |