• View
• Edit
• History
• Print

RegEvents

Defines the relationship between registrants and events they have signed up for. A mapping table.

Schema

 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;

See Also

• Scheduling - Scheduling home page