====== ER del Meeting ======

{{:meeting_er3.jpg|}}

----
\\
SQL delle tabelle:
\\
\\
**MEETINGS**
\\
  CREATE TABLE IF NOT EXISTS `meetings` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `main_motion` int(11) NOT NULL,
  `floor_timer` int(11) NOT NULL,
  `id_oob` int(11) NOT NULL,
  `suspend` int(11) NOT NULL,
  `quorum` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**MEETING_ODG** - Descrizione ordine del giorno.
\\
  CREATE TABLE IF NOT EXISTS `meeting_odg` (
  `id` int(11) NOT NULL auto_increment,
  `meeting_id` int(11) NOT NULL,
  `timestamp` datetime NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**MEETING MESSAGES**
\\
  CREATE TABLE IF NOT EXISTS `meeting_messages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `text` text NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `motion_id` int(10) unsigned NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**MEETING RULES**
\\
  CREATE TABLE IF NOT EXISTS `meeting_rules` (
  `description` text NOT NULL,
  `id` int(11) NOT NULL,
  `interrupt` tinyint(1) NOT NULL,
  `secondable` tinyint(1) NOT NULL,
  `debateable` tinyint(1) NOT NULL,
  `vote` int(11) NOT NULL,
  `amendable` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**MEETING MOTIONS**
\\
  CREATE TABLE IF NOT EXISTS `meeting_motions` (
  `id` int(11) NOT NULL auto_increment,
  `testo` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `meeting_id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `main_motion` int(11) NOT NULL,
  `seconded` int(11) NOT NULL,
  `debated` int(11) NOT NULL,
  `vote` int(11) NOT NULL,
  `closed` tinyint(1) NOT NULL,
  `oob_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**USERS** vedi [[il modello generale | modello generale]]
\\
\\
\\
[[la consultazione certificata | indietro]] - [[la DI | avanti]]