Re: Determining best database structure
Somehow, I think I am making this too complicated.
The only information that will write to the database for each customer is which employee started the particular task and date started and who finished the task, and date finished.
So, I am thinking it makes more sense to have a table for each customer.
The fields would be employee_id_start, date_start, employee_id_end and date_end?
then the rows contain each of the 240 tasks?
Does that sound right?
Subject
Written By
Posted
Re: Determining best database structure
August 07, 2005 11:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.