Recent Changes - Search:

CONGO

PmWiki

edit SideBar

V2 /

ConfigSessions

A list of Sessions being held at an Event

Schema

 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
) ENGINE=InnoDB DEFAULT CHARSET=latin1

See Also

Edit - History - Print - Recent Changes - Search
Page last modified on January 21, 2012, at 04:29 PM