Defines the relationship between registrants and events they have signed up for. A mapping table.
CREATE TABLE reg_events (
event_rid int(8) NOT NULL,
event_eid int(8) NOT NULL,
event_cid int(8) NOT NULL,
KEY eventsrid (event_rid),
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_rid`) REFERENCES `reg_master` (`master_rid`) ON DELETE CASCADE,
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_eventid`) REFERENCES `config_events` (`event_id`) ON DELETE CASCADE,
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE
) TYPE=InnoDB;