"parent" text DEFAULT NULL,

  "name" text NOT NULL,

  "first_publisher" text DEFAULT NULL,

  "contacts" text DEFAULT NULL,

  "info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),

  /*KEY "fk_source1_idx" ("parent")*/CHECK (true),

  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),

  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),

  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_source1" FOREIGN KEY ("parent") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=reference&entity=dba_tabledescription&where=where_tablename)'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="oldName">owners</value>

                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                    </value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

                      <value type="string" key="comment"></value>

                      <value type="string" key="name">contacts</value>

                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="e5155806-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">

                      <value type="int" key="isPrimary">0</value>

                      <value type="string" key="name">fk_source_party1_idx</value>

                      <value type="int" key="unique">0</value>

                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>

                    </value>

                  </value>

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-16 14:58</value>

                  <value _ptr_="0xb1fbb70" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <value type="string" key="name">source</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

              <value type="int" key="visible">1</value>

              <value type="string" key="name"></value>

            </value>

            <value type="int" key="updateBlocked">0</value>

            <value type="real" key="width">1.6215e+03</value>

            <value type="real" key="x">0.e+00</value>

        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>

        <value _ptr_="0xb1fe950" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xa6bbd20" type="dict" key="syncProfiles">

              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>

              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>

              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>

              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>

              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>

              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>

              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>

              <value type="string" key="8e2b8e78-1dec-11e3-b571-080027bcf912">fk_record_source2</value>

              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>

              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>

              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>

              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>

              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>

              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>

              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>

    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">

      <value type="string" key="author">Aaron Marcuse-Kubitza</value>

      <value type="string" key="caption">New Model</value>

      <value type="string" key="dateCreated">2012-01-19 14:06</value>

      <value type="string" key="description"></value>

      <value type="string" key="project">Name of the project</value>

  `parent` varbinary(767) DEFAULT NULL,

  `name` varbinary(767) NOT NULL,

  `first_publisher` varbinary(767) DEFAULT NULL,

  `contacts` varbinary(767) DEFAULT NULL,

  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `source_unique` (`parent`,`name`),

  KEY `fk_source1_idx` (`parent`),

  KEY `fk_source_party2_idx` (`first_publisher`),

  KEY `fk_source_party1_idx` (`contacts`),

  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source1` FOREIGN KEY (`parent`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=reference&entity=dba_tabledescription&where=where_tablename)';

/*!40101 SET character_set_client = @saved_cs_client */;