====== ER della Discussione Informata ======
{{:infodisc_er2.jpg|}}
\\
\\
Inoltre le tabelle
    * AGENDA_TOOLS
    * WIKI_DOCUMENTS
    * RATING
    * OWNER_RESOURCES
sono collegate 'indirettamente' alla discussione informata in quanto ognuna di queste si può riferire nel proprio campo 'tool' o 'owner' allo strumento infodisc.
\\
----
\\
SQL delle tabelle:
\\
\\
**INFODISCS**
\\
  CREATE TABLE IF NOT EXISTS `infodiscs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `introduction_url` varchar(255) NOT NULL,
  `status` tinyint(3) unsigned NOT NULL,
  `location_id` int(11) NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `discussions` int(11) default NULL,
  `markerset_id` int(11) default NULL,
  `moderation` int(11) default NULL,
  `mapview` tinyint(1) default NULL,
  `points` tinyint(4) default NULL,
  `lines` tinyint(4) default NULL,
  `polygons` tinyint(4) default NULL,
  `default_location` text,
  `default_marker` int(11) default NULL,
  `default_geolocation` int(11) default NULL,
  `multiple_marker` int(11) default NULL,
  `advanced_resource` tinyint(4) NOT NULL default '1',
  `default_shape_color` varchar(7) NOT NULL default '#000000',
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**INFODISCS POSTS**
\\
  CREATE TABLE IF NOT EXISTS `infodiscs_posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `parent_id` int(10) unsigned NOT NULL default '0',
  `title` text character set latin1 collate latin1_general_ci NOT NULL,
  `body` text character set latin1 collate latin1_general_ci NOT NULL,
  `status` tinyint(3) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `infodisc_id` int(10) unsigned NOT NULL default '0',
  `discussion_id` int(10) unsigned NOT NULL default '0',
  `geolocation_id` int(10) unsigned default NULL,
  `user_id` int(10) unsigned NOT NULL default '0',
  `anonymous_id` int(10) unsigned NOT NULL default '0',
  `argument` int(11) default NULL,
  PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
\\
**GEOMAP** e **USERS** vedi [[il modello generale | modello generale]]
\\
\\
\\
\\
[[il meeting online | indietro]] - [[le risorse | avanti]]
\\
\\