Demographic Improvements

From OpenEMR Project Wiki

Summary

Create a new contact info system.
Focus of project is on centralizing and improving contact info in OpenEMR.
Create and normalize tables with contact information.
Functional Result:
Multiple addresses per patient.
Multiple phone numbers per patient.
Multiple email addresses per patient.
But, I want to expand to much more. . .
Create tables:
"Person"
This will point to contact info for all people, not just patients.
"Business"
Business contact info.
"Contact"
Contact table to be used for every address in OpenEMR.
"Address"
"Telephone_Number"
"Email_Address"
Demographic Screen Tabs:
Who
Address (new)
Phone/Internet (new)
Secondary Contacts (new)
Insurance
Pharmacy (new)
Medical Providers (new)
Send Results To (new)
Employer
Choices
Stats
Misc
Keeping Old Data:
Not only able to store multiple phone numbers, addresses, etc, but also store old numbers, addresses.
Old data does not need to be deleted.
Proposed Schema:
alt text