Difference between revisions of "Database"

From Seth's Wiki
Jump to navigation Jump to search
Line 4: Line 4:
 
=Simple Example=
 
=Simple Example=
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
−
! Disease !! Chest Pain !! Precipitated by Stress !! Tenderness !! Reflux !! Radiation to shoulder !! Radiation to back !! Fever !! Leukocytosis !! Elevated troponin !! ST elevation !! HDUS !! Absent breath sounds
+
! Disease !! Risk Factors !! Associated Conditions !! Complications !! Symptoms !! Vitals !! Signs !! Labs !! Imaging !! Studies
 
|-
 
|-
−
| Stable angina  || 1 || 1 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0
+
| 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
−
|-
 
−
| NSTEMI || 1 || 0 || 0 || 1 || 0  || 0 || 0 || 1 || 0 || 0 || 0
 
−
|-
 
−
| STEMI || 1 || 0 || 0 || 1 || 0 || 0 || 0 || 1 || 1 || 0 || 0
 
−
|-
 
−
| GERD || 1 || 0 || 1 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0
 
−
|-
 
−
| Esophageal rupture || 1 || 0 || 0 || 1 || 1 || 0 || 0 || 0 || 0 || 1 || 0
 
−
|-
 
−
| Pericarditis || 1 || 0 || 0 || 0 || 0 || 1 || 1 || 0 || 0 || 0 || 0
 
−
|-
 
−
| Costochondritis || 1 || 1 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0
 
−
|-
 
−
| Pneumothorax || 1 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 0 || 1 || 1
 
−
|-
 
−
| Pneumonia || 1 || 0 || 0 || 0 || 0 || 1 || 1 || 0 || 0 || 0 || 0
 
−
|-
 
−
| Aortic dissection || 1 || 0 || 0 || 0 || 1 || 0 || 0 || 0 || 0 || 1 || 0
 
 
|}
 
|}

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 of useful imaging findings LIST relevant echo/ECG/PFT/sleep/etc studies
Retrieved from "http://www.sethvogel.com/wiki/index.php?title=Database&oldid=632"