Jump to content

help with date field and normalization


jeff5656

Recommended Posts

I am making many tables in an attempt to normalize my relataional database.  I cannot figure out how to handle the date - the billing data changes each day - not sure where to store this.  Here are my tables:

 

patient_table: has pt_id, patient name, medical record number date of admission etc.

billing_table has: billing_id, HP (enum L,M,H), consult (also enum L,M,H), and some others.

 

Now each day someone will choose the billing level (radio button).  Which table would each day get stored in?  Do I make a new table or add a column to one of the above tables? 

If this is unclear let me know.  I have other tables (i.e list of diagnoses, but I left that out).

Link to comment
https://forums.phpfreaks.com/topic/136212-help-with-date-field-and-normalization/
Share on other sites

It would seem to me that you need a detail table, which uses both your patient and billing table (since it appears your billing table is billable codes or something)

 

You need a table for the invoice, and then you would have the detail for the invoice.

 

Or so I would think.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.