Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Both sides previous revision Previous revision Next revision | Previous revision | ||
le_risorse [19/07/2010 17:35] |
le_risorse [05/06/2013 17:08] (versione attuale) |
||
---|---|---|---|
Linea 1: | Linea 1: | ||
====== ER delle Risorse ====== | ====== ER delle Risorse ====== | ||
\\ | \\ | ||
- | {{:risorse_er.jpg|}} | + | {{:risorse_er_2.jpg|}} |
+ | \\ | ||
+ | ---- | ||
+ | \\ | ||
+ | SQL delle tabelle: | ||
+ | \\ | ||
+ | \\ | ||
+ | **RESOURCES** | ||
+ | \\ | ||
+ | CREATE TABLE IF NOT EXISTS `resources` ( | ||
+ | `id` int(10) unsigned NOT NULL auto_increment, | ||
+ | `title` varchar(255) NOT NULL, | ||
+ | `description` text NOT NULL, | ||
+ | `created` datetime NOT NULL, | ||
+ | `modified` datetime NOT NULL, | ||
+ | `user_id` int(10) unsigned default NULL, | ||
+ | `anonymous_id` int(10) unsigned default NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | \\ | ||
+ | **OWNER RESOURCES** | ||
+ | \\ | ||
+ | CREATE TABLE IF NOT EXISTS `owner_resources` ( | ||
+ | `owner` varchar(45) NOT NULL, | ||
+ | `owner_id` int(10) unsigned NOT NULL, | ||
+ | `resource_id` int(10) unsigned NOT NULL, | ||
+ | `public` tinyint(1) default NULL, | ||
+ | `id` int(10) unsigned NOT NULL auto_increment, | ||
+ | `status` tinyint(1) default NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
+ | \\ | ||
+ | **LINKS** | ||
+ | \\ | ||
+ | CREATE TABLE IF NOT EXISTS `links` ( | ||
+ | `id` int(10) unsigned NOT NULL auto_increment, | ||
+ | `title` varchar(255) NOT NULL, | ||
+ | `url` varchar(255) NOT NULL, | ||
+ | `resource_id` int(11) NOT NULL, | ||
+ | `created` datetime NOT NULL, | ||
+ | `modified` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | \\ | ||
+ | **ATTACHMENTS** | ||
+ | \\ | ||
+ | CREATE TABLE IF NOT EXISTS `attachments` ( | ||
+ | `id` int(10) unsigned NOT NULL auto_increment, | ||
+ | `name` varchar(255) NOT NULL, | ||
+ | `fsname` varchar(255) NOT NULL, | ||
+ | `size` int(10) unsigned NOT NULL, | ||
+ | `type` varchar(255) NOT NULL, | ||
+ | `resource_id` int(10) unsigned NOT NULL, | ||
+ | `created` datetime NOT NULL, | ||
+ | `modified` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | \\ | ||
+ | **VIDEOS** | ||
+ | \\ | ||
+ | CREATE TABLE IF NOT EXISTS `videos` ( | ||
+ | `id` int(10) unsigned NOT NULL auto_increment, | ||
+ | `title` varchar(255) NOT NULL, | ||
+ | `url` varchar(255) NOT NULL, | ||
+ | `type` varchar(255) NOT NULL, | ||
+ | `resource_id` int(11) NOT NULL, | ||
+ | `created` datetime NOT NULL, | ||
+ | `modified` datetime NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | \\ | ||
+ | **USERS** vedi [[il modello generale | modello generale]] | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | [[la di | indietro]] |