OAFs Calendar oafsRelEventCat Table

From OAFsWiki
Jump to: navigation, search

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.