3 replies to this topic

[vegasjoe]

I am creating a program that will help schedule youth groups into 14 weeks of the summer to use a recreational property.

One of the first tasks is to create a master calendar for a Recreational property. This master calendar will have every day listed for the year. I will need to know what the date of each day of the year. I will need to know the week that each day is in. I will need to know the property status for each day of the year. The property status will be "Available" or "Not Available" or others. I want it flexible to add different attributes easily to my days.

So this is my table definition for calendar. I have a table that has 365 columns. Each row will represent a year. When a scheduler program creates a 'year' then it will update the columns with an XML string. The XML String will contain the following DTD:
<Day =X>
<date>YYYY/MM/DD</date>
<status>Avail</status>
<week>X</week>
</Day>

This information will be cached in the programs memory and re-cached when updated.

Is this an efficient design given that I have not supplied all the details?


Thanks,

[WingedPanther]

What language will you be doing all this in? Many of them provide functions for much of this.

[vegasjoe]

PHP and/or Java.

[WingedPanther]

I would just store the dates when a reservation exists, and probably store the reservations in XML or a database.