ER dell'Agenda

---

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 modello generale



indietro - avanti