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

Database