April 25th, 2000, 11:51 AM
I have got a database with customer info and some extra fields 4 per day, 7 days per week.
So in general: id; cust info; mon_m_s; mon_m_e; etc.; timestamp.
mon_m_s = monday morning start
mon_m_e = monday morning end
The follwing question:
I want to log the default openingtimes in the main database above.
But I also want to log and search when a customer is closed or has extra openingtimes.
I thought to create two extra tables:
unique_id;ID (the link id form the main db); open_s(datetime);open_e(datetime).
unique_id; ID (the link id from the main db);
Is this the way to go???
How do I query them, for example; what is open today?