tblSCORES


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SCORE_ID int identity 4 √ null
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblSCORES_tblMAIN_REFERRALSC
TEMP_ID varchar 255 null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_SCORE int 4 √ null
L_SCORE_DATE datetime 16,3 √ null
L_SCORE_ONLY int 4 √ null
L_BARTHEL_BOWEL int 4 √ null
L_BARTHEL_BLADDER int 4 √ null
L_BARTHEL_PERSONAL int 4 √ null
L_BARTHEL_TOILET int 4 √ null
L_BARTHEL_EATING int 4 √ null
L_BARTHEL_TRANSFER int 4 √ null
L_BARTHEL_MOBILITY int 4 √ null
L_BARTHEL_DRESS int 4 √ null
L_BARTHEL_STAIRS int 4 √ null
L_BARTHEL_BATHING int 4 √ null
L_GCS_EYE int 4 √ null
L_GCS_VERBAL int 4 √ null
L_GCS_MOTOR int 4 √ null
L_GDS_LIFE int 4 √ null
L_GDS_DROPPED int 4 √ null
L_GDS_EMPTY int 4 √ null
L_GDS_BORED int 4 √ null
L_GDS_SPIRIT int 4 √ null
L_GDS_AFRAID int 4 √ null
L_GDS_HAPPY int 4 √ null
L_GDS_HELPLESS int 4 √ null
L_GDS_HOME int 4 √ null
L_GDS_MEMORY int 4 √ null
L_GDS_WONDERFUL int 4 √ null
L_GDS_WORTHLESS int 4 √ null
L_GDS_ENERGY int 4 √ null
L_GDS_HOPELESS int 4 √ null
L_GDS_BETTER int 4 √ null
L_RANKIN int 4 √ null
L_MENTAL_AGE int 4 √ null
L_MENTAL_TIME int 4 √ null
L_MENTAL_ADDRESS int 4 √ null
L_MENTAL_HOSPITAL int 4 √ null
L_MENTAL_YEAR int 4 √ null
L_MENTAL_PEOPLE int 4 √ null
L_MENTAL_DOB int 4 √ null
L_MENTAL_WWII int 4 √ null
L_MENTAL_MONARCH int 4 √ null
L_MENTAL_COUNT int 4 √ null
L_HADS_TENSE int 4 √ null
L_HADS_SLOW int 4 √ null
L_HADS_ENJOY int 4 √ null
L_HADS_FRIGHT int 4 √ null
L_HADS_AWFUL int 4 √ null
L_HADS_APPEARANCE int 4 √ null
L_HADS_FUNNY int 4 √ null
L_HADS_RESTLESS int 4 √ null
L_HADS_WORRY int 4 √ null
L_HADS_FORWARD int 4 √ null
L_HADS_CHEERFUL int 4 √ null
L_HADS_PANIC int 4 √ null
L_HADS_RELAXED int 4 √ null
L_HADS_PROGRAM int 4 √ null
L_NIH_CONSCIOUS int 4 √ null
L_NIH_QUESTION int 4 √ null
L_NIH_COMMAND int 4 √ null
L_NIH_GAZE int 4 √ null
L_NIH_VISUAL int 4 √ null
L_NIH_PALSY int 4 √ null
L_NIH_ARM int 4 √ null
L_NIH_LEG int 4 √ null
L_NIH_LIMB int 4 √ null
L_NIH_SENSORY int 4 √ null
L_NIH_LANGUAGE int 4 √ null
L_NIH_DYSARTHRIA int 4 √ null
L_NIH_NEGLECT int 4 √ null
L_MMSE_1 int 4 √ null
L_MMSE_2 int 4 √ null
L_MMSE_3 int 4 √ null
L_MMSE_4 int 4 √ null
L_MMSE_5 int 4 √ null
L_MMSE_6 int 4 √ null
L_MMSE_7 int 4 √ null
L_MMSE_8 int 4 √ null
L_MMSE_9 int 4 √ null
L_MMSE_10 int 4 √ null
L_MMSE_11 int 4 √ null
L_FIMFAM_1 int 4 √ null
L_FIMFAM_2 int 4 √ null
L_FIMFAM_3 int 4 √ null
L_FIMFAM_4 int 4 √ null
L_FIMFAM_5 int 4 √ null
L_FIMFAM_6 int 4 √ null
L_FIMFAM_7 int 4 √ null
L_FIMFAM_8 int 4 √ null
L_FIMFAM_9 int 4 √ null
L_FIMFAM_10 int 4 √ null
L_FIMFAM_11 int 4 √ null
L_FIMFAM_12 int 4 √ null
L_FIMFAM_13 int 4 √ null
L_FIMFAM_14 int 4 √ null
L_FIMFAM_15 int 4 √ null
L_FIMFAM_16 int 4 √ null
L_FIMFAM_17 int 4 √ null
L_FIMFAM_18 int 4 √ null
L_FIMFAM_19 int 4 √ null
L_FIMFAM_20 int 4 √ null
L_FIMFAM_21 int 4 √ null
L_FIMFAM_22 int 4 √ null
L_FIMFAM_23 int 4 √ null
L_FIMFAM_24 int 4 √ null
L_FIMFAM_25 int 4 √ null
L_FIMFAM_26 int 4 √ null
L_FIMFAM_27 int 4 √ null
L_FIMFAM_28 int 4 √ null
L_FIMFAM_29 int 4 √ null
L_FIMFAM_30 int 4 √ null
L_MRMI_TURNING int 4 √ null
L_MRMI_LYING int 4 √ null
L_MRMI_BALANCE int 4 √ null
L_MRMI_SITTING int 4 √ null
L_MRMI_STANDING int 4 √ null
L_MRMI_TRANSFER int 4 √ null
L_MRMI_WALKING int 4 √ null
L_MRMI_STAIRS int 4 √ null
L_GOS int 4 √ null
L_FRANKEL int 4 √ null
L_KARNOFSKY int 4 √ null
L_LANSKY int 4 √ null
L_TOTAL_SCORE int 4 √ null
ACTION_ID int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblSCORES Primary key Asc SCORE_ID

Relationships

Close relationships within degrees of separation