jeff5656 Posted December 9, 2008 Share Posted December 9, 2008 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 More sharing options...
crtreedude Posted December 9, 2008 Share Posted December 9, 2008 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. Link to comment https://forums.phpfreaks.com/topic/136212-help-with-date-field-and-normalization/#findComment-710523 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.