Representing Appointment/Meeting Dates

Sucoyant · #1 (**permalink**) 07-14-06, 10:29

How would I go about representing appointment dates that could either occur once, multiple times, or indefinitely?
For example, I'd like to know how an application like Microsoft Outlook stores its appointment/meeting date information.

Thanks!

andrewst · #2 (**permalink**) 07-16-06, 16:30

This was heavily discussed here on comp.databases.theory recently.

honestbleeps · #3 (**permalink**) 07-17-06, 11:14

Quote:

Originally Posted by andrewst

This was heavily discussed here on comp.databases.theory recently.

That doesn't seem to be the thread you meant to link - that's about "Impossible Database Design" ...

I think maybe you're looking for this thread?

andrewst · #4 (**permalink**) 07-17-06, 12:13

Quote:

Originally Posted by honestbleeps

That doesn't seem to be the thread you meant to link - that's about "Impossible Database Design" ...

I think maybe you're looking for this thread?

Well that's interesting too, but no, I meant to post the thread I did. Here is how it begins:

Quote:

I was just wondering if it is possible to create a database design
where you can have

1. Infinite repeating events like "every year, every last monday,..."

Internet Services

Web Development

Digital Marketing

Consumer Tech