Re: 2 tables - days of week and events - best structure?
Posted by:
Date: July 06, 2011 02:54PM

Thanks Pete

So basically I need to split it into 3 tables consisting of:

daysofweek(day_id, day_name)
offer(offer_id, offer_details)
daysoffers(dayoffer_id, day_id, offer_id)

where daysoffers references the primary keys from the other 2 tables?

thanks

gav

Options: ReplyQuote


Subject
Written By
Posted
Re: 2 tables - days of week and events - best structure?
July 06, 2011 02:54PM


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.