Difference between revisions of "Database"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
! Disease !! Risk Factors !! Associated Conditions !! Complications !! Symptoms !! Vitals !! Signs !! Labs !! Imaging !! Studies | ! Disease !! Risk Factors !! Associated Conditions !! Complications !! Symptoms !! Vitals !! Signs !! Labs !! Imaging !! Studies | ||
|- | |- | ||
| − | | Primary Key || LIST of epidemiologic risk factors (age, sex, race, family history) || problem LIST at time of presentation || LIST of possible complications (screening and anticipatory guidance) || LIST of symptoms (keep it broad: chest pain rather than substernal acute pressure-like chest pain with radiation) || LIST of vital abnormalities || LIST of pertinent positive/negative physical exam findings || LIST of useful imaging findings || LIST relevant echo/ECG/PFT/sleep/etc studies | + | | Primary Key || LIST of epidemiologic risk factors (age, sex, race, family history) || problem LIST at time of presentation || LIST of possible complications (screening and anticipatory guidance) || LIST of symptoms (keep it broad: chest pain rather than substernal acute pressure-like chest pain with radiation) || LIST of vital abnormalities || LIST of pertinent positive/negative physical exam findings || LIST relevant lab abnormalities || LIST of useful imaging findings || LIST relevant echo/ECG/PFT/sleep/etc studies |
|} | |} | ||
Revision as of 22:35, 7 February 2023
- Disease -> Multiple symptoms
- Symptom -> Multiple diseases
Simple Example
| Disease | Risk Factors | Associated Conditions | Complications | Symptoms | Vitals | Signs | Labs | Imaging | Studies |
|---|---|---|---|---|---|---|---|---|---|
| Primary Key | LIST of epidemiologic risk factors (age, sex, race, family history) | problem LIST at time of presentation | LIST of possible complications (screening and anticipatory guidance) | LIST of symptoms (keep it broad: chest pain rather than substernal acute pressure-like chest pain with radiation) | LIST of vital abnormalities | LIST of pertinent positive/negative physical exam findings | LIST relevant lab abnormalities | LIST of useful imaging findings | LIST relevant echo/ECG/PFT/sleep/etc studies |