Suggestion on table design

[kmf165]

Hi everyone,

I am going to store every single day's working status into my database. It mean 365days's working status(Public Holiday,half day, full day....) and may keep up to unlimited year if they want.

And i am designing my table structure like below.

==========
table name = tbl_working_calender
field1 = year
field2 = jan01
field3 = jan02
field4 = jan03
:
:
:
field365 = dec31

==========

So any suggestion on this? To make it work better and faster?

[cgraz]

why not just do

id event day

and for each event, id is set as primary key auto increment, then day you just put the day the event falls on. You'd only have records for days with events. I'm guessing you don't have an event for all 365 days, and even if you did, this would still work. You could also have more than one event per day.

I don't really know what you're doing, but hopefully this will get you going.

Cgraz