mysql> show create database lexicon_25062010j;
+-------------------+------------------------------------------------------------------------------+
| Database          | Create Database                                                              |
+-------------------+------------------------------------------------------------------------------+
| lexicon_25062010j | CREATE DATABASE `lexicon_25062010j` /*!40100 DEFAULT CHARACTER SET latin1 */ | 
+-------------------+------------------------------------------------------------------------------+
1 row in set (0.00 sec)


mysql> show create table object;
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| object | CREATE TABLE `object` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `language_id` int(10) unsigned NOT NULL,
  `ontology_id` int(10) unsigned NOT NULL,
  `type_id` int(10) unsigned default NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `latest_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `object_name_idx` (`name`),
  KEY `object_description_idx` (`description`(255)),
  KEY `object_language_id_idx` (`language_id`),
  KEY `object_ontology_id_idx` (`ontology_id`),
  KEY `object_type_id_idx` (`type_id`),
  KEY `object_latest_id_idx` (`latest_id`),
  CONSTRAINT `object_language_id_fk` FOREIGN KEY (`language_id`) REFERENCES `language` (`id`),
  CONSTRAINT `object_latest_id_fk` FOREIGN KEY (`latest_id`) REFERENCES `object_edition` (`id`) ON DELETE CASCADE,
  CONSTRAINT `object_ontology_id_fk` FOREIGN KEY (`ontology_id`) REFERENCES `ontology` (`id`),
  CONSTRAINT `object_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `object` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3069466 DEFAULT CHARSET=utf8 | 
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table relation;
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| relation | CREATE TABLE `relation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `mother_id` int(10) unsigned NOT NULL,
  `daughter_id` int(10) unsigned NOT NULL,
  `type_id` int(10) unsigned NOT NULL,
  `latest_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  KEY `relation_mother_id_idx` USING BTREE (`mother_id`),
  KEY `relation_daughter_id_idx` USING BTREE (`daughter_id`),
  KEY `relation_type_id_idx` USING BTREE (`type_id`),
  KEY `relation_latest_id_idx` (`latest_id`),
  CONSTRAINT `relation_daughter_id_fk` FOREIGN KEY (`daughter_id`) REFERENCES `object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relation_latest_id_fk` FOREIGN KEY (`latest_id`) REFERENCES `relation_edition` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relation_mother_id_fk` FOREIGN KEY (`mother_id`) REFERENCES `object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `relation_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3372426 DEFAULT CHARSET=utf8 | 
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


mysql> show create table dimension;
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table     | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dimension | CREATE TABLE `dimension` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `relation_id` int(10) unsigned default NULL,
  `object_id` int(10) unsigned NOT NULL,
  `latest_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `dimension_unique_idx` (`object_id`,`relation_id`),
  KEY `dimension_object_id_idx` USING BTREE (`object_id`),
  KEY `dimension_relation_id_idx` USING BTREE (`relation_id`),
  KEY `dimension_latest_id_idx` (`latest_id`),
  CONSTRAINT `dimension_latest_id_fk` FOREIGN KEY (`latest_id`) REFERENCES `dimension_edition` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dimension_object_id_fk` FOREIGN KEY (`object_id`) REFERENCES `object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dimension_relation_id_fk` FOREIGN KEY (`relation_id`) REFERENCES `relation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15100995 DEFAULT CHARSET=utf8 | 
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)