Correction - for

In "Merge Zone" (November), the database diagram contained an error. The correct diagram has an additional table, field_user, that is used for the dynamic filtering criteria.

Ted Daley

December 2, 1999

1 Min Read
ITPro Today logo

In "Merge Zone" (November), the database diagram contained an error. The correct diagram has an additional table, field_user, that is used for the dynamic filtering criteria. The current field_user table in the diagram should be called field_user/events and represents the many-to-many relationship between field users and events. So the field_ user/events and field_user tables are joined on their respective rep_id columns; field_user/events and events are joined on each table's event_id column. In other words, event_id in field_user/events is a foreign key whose matching primary key is event_id in events; rep_id in field_user/events is the foreign key whose matching primary key is rep_id in field_user.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like