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:

Name	Type	Notes
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.