ConfigSessions

  `session_status` enum('PROPOSED','ACTIVE','CANCELLED') DEFAULT NULL,

A list of Sessions being held at an Event

[@ CREATE TABLE `config_sessions` (

  `session_id` int(8) NOT NULL AUTO_INCREMENT,
  `session_cid` int(8) NOT NULL DEFAULT '0',
  `session_title` varchar(20) DEFAULT NULL,
  `session_description` text,
  `session_notes` varchar(200) DEFAULT NULL,
  `session_tags` varchar(200) DEFAULT NULL,
  `session_department` int(8) NOT NULL DEFAULT '0',
  `session_category` int(8) NOT NULL DEFAULT '0',
  `session_room` int(8) NOT NULL DEFAULT '0',
  `session_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `session_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `session_duration` int(8) NOT NULL DEFAULT '0',
  `session_maxattendees` int(4) DEFAULT NULL,
  `session_detail` text,
  `session_cost` decimal(8,2) DEFAULT NULL,
  `session_owner` int(8) DEFAULT NULL,
  `session_status` enum('PROPOSED,'ACTIVE','CANCELLED') DEFAULT NULL,
  `session_public` tinyint(1) DEFAULT '0',
  `session_lastupdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `session_lasteditedby` int(8) DEFAULT NULL,
  KEY `indexid` (`session_id`),
  KEY `indextype` (`session_cid`),
  KEY `config_sessions_ibfk_2` (`session_owner`),
  KEY `config_sessions_ibfk_3` (`session_lasteditedby`),
  CONSTRAINT `config_sessions_ibfk_1` FOREIGN KEY (`session_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE,
  CONSTRAINT `config_sessions_ibfk_2` FOREIGN KEY (`session_owner`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL,
  CONSTRAINT `config_sessions_ibfk_3` FOREIGN KEY (`session_lasteditedby`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL

[@ CREATE TABLE `config_events` (

  `event_id` int(8) NOT NULL AUTO_INCREMENT,
  `event_cid` int(8) NOT NULL DEFAULT '0',
  `event_name` varchar(20) DEFAULT NULL,
  `event_description` varchar(100) DEFAULT NULL,
  `event_type` varchar(20) DEFAULT NULL,
  `event_category` varchar(20) DEFAULT NULL,
  `event_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `event_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `event_maxattendees` int(4) DEFAULT NULL,
  `event_location` varchar(100) DEFAULT NULL,
  `event_detail` text,
  `event_cost` decimal(8,2) DEFAULT NULL,
  `event_owner` int(8) DEFAULT NULL,
  `event_lastupdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `event_lasteditedby` int(8) DEFAULT NULL,
  KEY `indexid` (`event_id`),
  KEY `indextype` (`event_cid`),
  KEY `config_events_ibfk_2` (`event_owner`),
  KEY `config_events_ibfk_3` (`event_lasteditedby`),
  CONSTRAINT `config_events_ibfk_1` FOREIGN KEY (`event_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE,
  CONSTRAINT `config_events_ibfk_2` FOREIGN KEY (`event_owner`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL,
  CONSTRAINT `config_events_ibfk_3` FOREIGN KEY (`event_lasteditedby`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL

) ENGINE=InnoDB? DEFAULT CHARSET=latin1

A list of Events being held at an Event

Schema

See Also

• Scheduling - Scheduling home page