OAFs Calendar oafsRelEventCat Table
Rows in this table are used to represent the many-to-many relationship between calendar events and categories. One row in this table represents a single event being mapped to a single category. An event can be mapped to zero or more categories simply by having multiple relationship rows in the table.
This is a trivial table that contains only relationship information, no additional data. The fields are:
|id||unsigned integer||auto-incremented, primary key for this table|
|eventId||unsigned integer||key of event being related|
|catId||unsigned integer||key of category being related|
Note there is no need for a "lastUpdated" attribute in this table as used in the others to detect update collisions. That's because rows in this table are never updated - they either exist, indicating a relationship, or they don't exist, indicating no relationship. They are only ever inserted or deleted.