 SET character_set_client = utf8;
 CREATE TABLE `taxa` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `guid` varchar(32) character set ascii NOT NULL,
+  `guid` varchar(32) character set ascii NOT NULL COMMENT 'this guid is generated by EOL. A 32 character hexadecimal',
   `taxon_kingdom` varchar(255) NOT NULL,
   `taxon_phylum` varchar(255) NOT NULL,
   `taxon_class` varchar(255) NOT NULL,
   `taxon_order` varchar(255) NOT NULL,
   `taxon_family` varchar(255) NOT NULL,
   `scientific_name` varchar(255) NOT NULL,
-  `name_id` int(10) unsigned NOT NULL,
-  `hierarchy_entry_id` int(10) unsigned NOT NULL,
+  `name_id` int(10) unsigned NOT NULL COMMENT 'the id of the string corresponding with this taxon\'s scientific name. If the scientific name of this taxon doesn\'t exist one will be created',
+  `hierarchy_entry_id` int(10) unsigned NOT NULL COMMENT 'each taxon in this table will be associated with a hierarchy entry created specifically for the associated resource',
   `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `updated_at` timestamp NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`),
   KEY `name_id` (`name_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='For taxa definitions coming from content partner\'s resources';
 SET character_set_client = @saved_cs_client;
 
 --

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `random_taxa` (
  `id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL,
  `data_object_id` int(11) NOT NULL,
  `name_id` int(11) NOT NULL,
  `image_url` varchar(255) character set ascii NOT NULL,
  `thumb_url` varchar(255) character set ascii NOT NULL,

SET character_set_client = utf8;
CREATE TABLE `normalized_qualifiers` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `label` varchar(50) NOT NULL COMMENT 'Possible qualifiers: name, author, year',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Identifies the role the name part plays in the larger name string';
SET character_set_client = @saved_cs_client;

--
