How do I set up the relation between 1. CalendarEntry 2. CalendarField 3. CalendarFieldValue?
where CalendarField consists of type names like “Teacher”,“Subject”,“Room”,“Weekday”,“Timing”.
CalendarFieldValue consists of all the possible values of above fields like Teacher1,Teacher2,Subject1,Subject2 etc with each having a foriegn id maybe to tell its Field.
Now CalendarEntry is each possible entry in the calender which has a reference to each CalendarFieldValue. For example CalendarValue1 can have Subject1,Teacher2,Weekday3 and Room1 as references.
Right now I am creating a dynamic table for each field and stuffing the values into that dynamic table.
Is this a right design?