Process automation

Databases
1

I am making a bookings(appointments) app.The user will be able to see the available appointment slots for a business.

The available appointments slots is the result of a query that “looks” in a table that holds all possible appointments(date and time columns) for a period of ten months.From the data in that table I remove the already booked appointments plus that I filter it according to the schedule(found in another table) of the business.

As I see it this table that holds all possible slots must be updated every once and a while with slots that reflect future dates.
My rationale is that the use will be able to book appts as far as 7 months ahead…so I put slots of 10 months in the table so I can have time of 3 months to update the table

  1. What do you think overall of the above logic?

  2. Can I automate the above process?

2

  1. i prefer to store only the appointments, and process the requested time slot against them… no “available slots” table needed

  2. sure, why not…

3

Ok surely there is another way, cause though it is going to take me time to change things I will stay with the current implementation.

And by the way,what do you think of mine implementation…is it OK?

Ca I automate the the current scheme?

P.S You answer…I think had to do with you idea.

4

[quote=“designtrooper, post:3, topic:230358, full:true”]Ca I automate the the current scheme?
[/quote]

sure, why not

:wink:

5

can you give me some more info it?

For example…would that require a server side language script?(I develop in PHP)

Or it can be accomplished solely with an SQL statement which I doubt it.

6

https://dev.mysql.com/doc/refman/5.7/en/events-overview.html

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.