Hi, I have used the following model here: http://www.resource-scheduler.co.nz
Event: ID, start time, end time, event details, EventSeriesID Event Schedule: ID, Event Series ID, type of repeat (weekly, monthly, day in month), repeat details: day of week, week in month, day in month and combinations Event Series: start time, end time, event series details Calendar table: day (eg from 2010-01-01 to 2020-12-31), weekday, day in month, week in month, week in year - this is used for quick series calculation Time slot table: time slot (eg. 2010-01-01 00:00, 00:15, 00:30), this is used for discretising events and calculating conflicts (time and other resource based) HTH Kind Regards, Jochen Daum Chief Automation Officer Automatem Ltd Phone: 09 630 3425 Mobile: 021 567 853 Email: [email protected] Skype: jochendaum Website: www.automatem.co.nz http://twitter.com/automatem http://www.xing.com/go/invite/3425509.181107 http://php.meetup.com/10 P.S.: We are upgrading our phone system and there may be short outages on our landlines. Please ring my mobile or email me, if you experience difficulty getting through. On Mon, Jan 11, 2010 at 11:35 AM, .Net2Php <[email protected]> wrote: > Does anyone have any suggestions on how I can represent singular/ > recurring events in a database? I'm looking for a solution that would > allow me to support an interface similar to Outlook's event scheduler. > I think it may be iCal compliant. > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] >
-- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
