tblINITIAL_BRAIN


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
tblINITIAL_ASSESSMENT.CARE_ID FK_tblINITIAL_BRAIN_tblINITIAL_ASSESSMENTR
L_ICP bit 1 ((0))

Raised Intra Cranial Pressure
L_VOMIT bit 1 ((0))

Headache with Vomiting
L_CONFUSION bit 1 ((0))

Confusion
L_CONSCIOUS bit 1 ((0))

Reduced Consciousness Level
L_VISUAL bit 1 ((0))

Visual Problems
L_SEIZURE bit 1 ((0))

Seizures
L_EXPRESS bit 1 ((0))

Dysphasia - Expressive
L_RECEPT bit 1 ((0))

Dysphasia - Receptive
L_MEMORY bit 1 ((0))

Memory Deficit
L_BEHAVIOUR bit 1 ((0))

Personality Changes
L_MOTOR bit 1 ((0))

Motor Dysfunction
L_DYSFUNCTION bit 1 ((0))

Cognitive Dysfunction
L_LHEM bit 1 ((0))

Left Hemiparesis
L_RHEM bit 1 ((0))

Right Hemiparesis
L_SENSORY bit 1 ((0))

Sensory Loss
L_NO_VOMIT bit 1 ((0))

Headache without Vomiting
L_B_CONTROL bit 1 ((0))

Altered Bowel Control
L_U_CONTROL bit 1 ((0))

Altered Urinary Control
L_TIREDNESS bit 1 ((0))

Tiredness
L_LETHARGY bit 1 ((0))

Lethargy
L_FOCAL bit 1 ((0))

Focal Neurological Deficit
L_VERTIGO bit 1 ((0))

Vertigo
L_UNSTEADINESS bit 1 ((0))

Unsteadiness
L_PAIN bit 1 ((0))

Pain (Spinal)
L_ICP_DURATION int 4 √ null

Raised Intra Cranial Pressure - Duration
L_VOMIT_DURATION int 4 √ null

Headache with Vomiting - Duration
L_CONFUSION_DURATION int 4 √ null

Confusion - Duration
L_CONSCIOUS_DURATION int 4 √ null

Reduced Consciousness Level - Duration
L_VISUAL_DURATION int 4 √ null

Visual Problems - Duration
L_SEIZURE_DURATION int 4 √ null

Seizures - Duration
L_EXPRESS_DURATION int 4 √ null

Dysphasia - Expressive - Duration
L_RECEPT_DURATION int 4 √ null

Dysphasia - Receptive - Duration
L_MEMORY_DURATION int 4 √ null

Memory Deficit - Duration
L_BEHAVIOUR_DURATION int 4 √ null

Personality Changes - Duration
L_MOTOR_DURATION int 4 √ null

Motor Dysfunction - Duration
L_DYSFUNCTION_DURATION int 4 √ null

Cognitive Dysfunction - Duration
L_LHEM_DURATION int 4 √ null

Left Hemiparesis - Duration
L_RHEM_DURATION int 4 √ null

Right Hemiparesis - Duration
L_SENSORY_DURATION int 4 √ null

Sensory Loss - Duration
L_NO_VOMIT_DURATION int 4 √ null

Headache without Vomiting - Duration
L_B_CONTROL_DURATION int 4 √ null

Altered Bowel Control - Duration
L_U_CONTROL_DURATION int 4 √ null

Altered Urinary Control - Duration
L_TIREDNESS_DURATION int 4 √ null

Tiredness - Duration
L_LETHARGY_DURATION int 4 √ null

Lethargy - Duration
L_FOCAL_DURATION int 4 √ null

Focal Neurological Deficit - Duration
L_VERTIGO_DURATION int 4 √ null

Vertigo - Duration
L_UNSTEADINESS_DURATION int 4 √ null

Unsteadiness - Duration
L_PAIN_DURATION int 4 √ null

Pain (Spinal) - Duration
L_MS bit 1 ((0))

Multiple Sclerosis
L_PARK bit 1 ((0))

Parkinsons Disease
L_NEURONE bit 1 ((0))

Motor Neurone Disease
L_EPILEPSY bit 1 ((0))

Epilepsy
L_MIGRAINE bit 1 ((0))

Migraine
L_HEAD bit 1 ((0))

Head Injury
L_TIA bit 1 ((0))

Previous TIA
L_CHICKENPOX bit 1 ((0))

Chickenpox
L_FUNDOSCOPY int 4 √ null

Fundoscopy
L_FUNDOSCOPY_DETAILS varchar 255 √ null

Fundoscopy Details
L_ACUITY int 4 √ null

Visual Acuity
L_ACUITY_DETAILS varchar 255 √ null

Visual Acuity Details
L_PUPILLARY int 4 √ null

Pupillary Exam
L_PUPILLARY_DETAILS varchar 255 √ null

Pupillary Exam Details
L_LLL_POWER int 4 √ null

Left Lower Limb
L_LUL_POWER int 4 √ null

Left Upper Limb
L_RLL_POWER int 4 √ null

Right Lower Limb
L_RUL_POWER int 4 √ null

Right Upper Limb
L_NEURO_ASS int 4 √ null

Neurological Assessment
L_CRANIAL_EXAM int 4 √ null

Cranial Nerve Exam
L_N1_L int 4 √ null

Left Cranial Nerves - Nerve I
L_N3_L int 4 √ null

Left Cranial Nerves - Nerve III
L_N3_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve III Details
L_N4_L int 4 √ null

Left Cranial Nerves - Nerve IV
L_N4_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve IV Details
L_N5_L int 4 √ null

Left Cranial Nerves - Nerve V
L_N6_L int 4 √ null

Left Cranial Nerves - Nerve VI
L_N6_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve VI Details
L_N7_L int 4 √ null

Left Cranial Nerves - Nerve VII
L_N8_L int 4 √ null

Left Cranial Nerves - Nerve VIII
L_N9_L int 4 √ null

Left Cranial Nerves - Nerve IX
L_N9_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve IX Details
L_N10_L int 4 √ null

Left Cranial Nerves - Nerve X
L_N10_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve X Details
L_N11_L int 4 √ null

Left Cranial Nerves - Nerve XI
L_N11_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve XI Details
L_N12_L int 4 √ null

Left Cranial Nerves - Nerve XII
L_N12_DETAILS_L varchar 255 √ null

Left Cranial Nerves - Nerve XII Details
L_CORNEAL_L int 4 √ null

Left Corneal Sensation
L_MASSETER_L int 4 √ null

Left Masseter Function
L_SENSATION_L varchar 255 √ null

Left Facial Sensation
L_FACIAL_L int 4 √ null

Left Type of Facial Palsy
L_HOUSE_L int 4 √ null

Left House-Brackman
L_HEARING_L int 4 √ null

Left Impaired Hearing
L_VESTIBULAR_L varchar 255 √ null

Left Vestibular Function
L_GAG_L int 4 √ null

Left Gag Reflex
L_PHARYNGEAL_L int 4 √ null

Left Pharyngeal Sensation
L_N1_R int 4 √ null

Right Cranial Nerves - Nerve I
L_N3_R int 4 √ null

Right Cranial Nerves - Nerve III
L_N3_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve III Details
L_N4_R int 4 √ null

Right Cranial Nerves - Nerve IV
L_N4_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve IV Details
L_N5_R int 4 √ null

Right Cranial Nerves - Nerve V
L_N6_R int 4 √ null

Right Cranial Nerves - Nerve VI
L_N6_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve VI Details
L_N7_R int 4 √ null

Right Cranial Nerves - Nerve VII
L_N8_R int 4 √ null

Right Cranial Nerves - Nerve VIII
L_N9_R int 4 √ null

Right Cranial Nerves - Nerve IX
L_N9_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve IX Details
L_N10_R int 4 √ null

Right Cranial Nerves - Nerve X
L_N10_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve X Details
L_N11_R int 4 √ null

Right Cranial Nerves - Nerve XI
L_N11_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve XI Details
L_N12_R int 4 √ null

Right Cranial Nerves - Nerve XII
L_N12_DETAILS_R varchar 255 √ null

Right Cranial Nerves - Nerve XII Details
L_CORNEAL_R int 4 √ null

Right Corneal Sensation
L_MASSETER_R int 4 √ null

Right Masseter Function
L_SENSATION_R varchar 255 √ null

Right Facial Sensation
L_FACIAL_R int 4 √ null

Right Type of Facial Palsy
L_HOUSE_R int 4 √ null

Right House-Brackman
L_HEARING_R int 4 √ null

Right Impaired Hearing
L_VESTIBULAR_R varchar 255 √ null

Right Vestibular Function
L_GAG_R int 4 √ null

Right Gag Reflex
L_PHARYNGEAL_R int 4 √ null

Right Pharyngeal Sensation
L_ANAEMIA bit 1 ((0))

General Examination - No Anaemia
L_OEDEMA bit 1 ((0))

General Examination - No Oedema
L_HR int 4 √ null

General Examination - Heart Rate
L_SYSTOLIC_BP real 4 √ null

Blood Pressure (Systolic BP)
L_DIASTOLIC_BP real 4 √ null

Blood Pressure(Diastolic BP)
L_BRUITS bit 1 ((0))

No Carotid Bruits
L_JVP bit 1 ((0))

JVP
L_HEART_SOUNDS bit 1 ((0))

Normal Heart Sound
L_PULSES bit 1 ((0))

Normal Peripheral Pulses
L_BREATH_SOUNDS bit 1 ((0))

Normal Breath Sounds
L_DYSPNOEA bit 1 ((0))

No Dyspnoea
L_ABDO bit 1 ((0))

Normal Abdo Exam
L_RECTAL bit 1 ((0))

Normal Rectal Exam
L_DRUGS int 4 √ null

Past Medical History - Drugs
L_STATINS int 4 √ null

Cholesterol Lowering Drugs
L_PLATELETS int 4 √ null

Anti-Platelets
L_DEPRESSANTS int 4 √ null

Anti-Depressants
L_BETA_BLOCKERS int 4 √ null

Beta Blockers
L_DIURETICS int 4 √ null

Thiazide Diuretics
L_COAGULANTS int 4 √ null

Anti-Coagulants
L_INHIBITORS int 4 √ null

ACE-Inhibitors
L_CALCIUM_BLOCKERS int 4 √ null

Calcium Channel Blockers
L_ANTIOTENSINS int 4 √ null

Angiotensin 2 Inhibitors
L_ANTICONVULSANTS int 4 √ null

Anticonvulsants
L_OTHER_DRUGS int 4 √ null

Other Drugs
L_ANAESTHETIC varchar 255 √ null

Anaesthetic Problems
L_GENERAL_EXAM text 2147483647 √ null

Abnormal Findings & Comments
L_PLAN text 2147483647 √ null

Plan
LifeThreateningSymptoms int 4 √ null
ltblYN.YN_ID FK_tblINITIAL_BRAIN_ltblYNR

Indexes

Constraint Name Type Sort Column(s)
PK_tblINITIAL_BRAIN Primary key Asc CARE_ID

Relationships

Close relationships within degrees of separation