====== ER dell'Agenda ======

{{:agenda_er.jpg|}}

----
\\
SQL delle tabelle:
\\
\\
**AGENDA**
\\
  CREATE TABLE IF NOT EXISTS `agendas` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `real_start` datetime NOT NULL,
  `real_end` datetime NOT NULL,
  `status` tinyint(3) unsigned NOT NULL,
  `location_id` int(10) unsigned NOT NULL,
  `introduction_url` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**AGENDA TOOLS**
\\
  CREATE TABLE IF NOT EXISTS `agenda_tools` (
  `agenda_id` int(10) unsigned NOT NULL,
  `tool` varchar(255) NOT NULL,
  `tool_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `dependences` text NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `real_start` datetime NOT NULL,
  `real_end` datetime NOT NULL,
  `status` tinyint(3) unsigned NOT NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**GEOMAP** vedi [[il modello generale | modello generale]]
\\
\\
\\
\\
[[il modello generale | indietro]] - [[la consultazione certificata | avanti]]