Re: Impossible Database Design?

x wrote:
> >Maybe we should try indiscrete models for a change ?
> Do you mean Paris Hilton and the likes? :)

that would probably fresh it all up a little... Axel Schwenk suggested a design around these lines:

CREATE TABLE event {
  id INT PRIMARY KEY,
  desc_short VARCHAR(30),
  desc_long VARCHAR(255)
}

CREATE TABLE eventrule {
  id INT PRIMARY KEY,
  event_id INT REFERENCES event.id ON DELETE CASCADE,

  time_start TIME,
  time_end   TIME,
  date_start DATE NOT NULL,
  date_end   DATE,
  type       ENUM ('single', 'exception', 'daily', 'weekly', ...)

CREATE TABLE timeslot {

  start      DATETIME,
  end        DATETIME,
  rule_id    INT REFERENCES eventrule.id ON DELETE CASCADE,
  event_id   INT REFERENCES event.id     ON DELETE CASCADE

I think it makes sense as well only event rules get a little tricky... Received on Thu May 18 2006 - 18:36:51 CEST