RegEvents

        event_eid      int(8) NOT NULL,

[@ CREATE TABLE reg_events (

@]

See Also

• Scheduling - Scheduling home page

Description

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

Schema

Database Schema

 CREATE TABLE reg_events (
        event_rid       int(8) NOT NULL,
        event_eventid   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?;

Description

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