Project

General

Profile

« Previous | Next » 

Revision 11192

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset: renamed data_source to dataset_source for clarity

View differences:

schemas/VegCore/ERD/document.mwb.xml
231 231
                      <value type="int" key="precision">-1</value>
232 232
                      <value type="int" key="scale">-1</value>
233 233
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
234
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).</value>
234
                      <value type="string" key="comment">this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).</value>
235 235
                      <value type="string" key="name">parent</value>
236 236
                      <value type="string" key="oldName">parent</value>
237 237
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
......
646 646
                  <value type="int" key="commentedOut">0</value>
647 647
                  <value type="string" key="createDate">2013-04-16 14:58</value>
648 648
                  <value _ptr_="0xba4cf98" type="dict" key="customData"/>
649
                  <value type="string" key="lastChangeDate">2013-10-09 11:09</value>
649
                  <value type="string" key="lastChangeDate">2013-10-09 11:19</value>
650 650
                  <value type="int" key="modelOnly">0</value>
651 651
                  <value type="string" key="name">dataset</value>
652 652
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17500 17500
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17501 17501
        <value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17502 17502
        <value _ptr_="0xb0204c8" type="dict" key="syncProfiles">
17503
          <value type="object" struct-name="db.mgmt.SyncProfile" id="261c5266-310d-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17504
            <value _ptr_="0xd233de8" type="dict" key="lastKnownDBNames">
17503
          <value type="object" struct-name="db.mgmt.SyncProfile" id="07822cb2-310e-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17504
            <value _ptr_="0xcd50588" type="dict" key="lastKnownDBNames">
17505 17505
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17506 17506
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17507 17507
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18126 18126
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18127 18127
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18128 18128
      <value type="string" key="caption">New Model</value>
18129
      <value type="string" key="dateChanged">2013-10-09 11:09</value>
18129
      <value type="string" key="dateChanged">2013-10-09 11:19</value>
18130 18130
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18131 18131
      <value type="string" key="description"></value>
18132 18132
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
124 124
  `id` varbinary(767) NOT NULL,
125 125
  `name` varbinary(767) NOT NULL,
126 126
  `contacts` varbinary(767) NOT NULL COMMENT 'contact person(s) to ask about attribution questions. there should always be at least one contact person. if unknown, the person loading the data should set this to themselves.',
127
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).',
127
  `parent` varbinary(767) DEFAULT NULL COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).',
128 128
  `dataset_source` varbinary(767) DEFAULT NULL COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable); = Brad.vegpath.org?attribution.proximate_data_provider',
129 129
  `first_publisher` varbinary(767) DEFAULT NULL COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider',
130 130
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
......
135 135
  KEY `fk_dataset_source2_idx` (`dataset_source`),
136 136
  KEY `fk_dataset_dataset1_idx` (`parent`),
137 137
  KEY `fk_source_party2_idx` (`first_publisher`),
138
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
138 141
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139 142
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 143
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
144
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
145 145
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
146 146
/*!40101 SET character_set_client = @saved_cs_client */;
147 147

  
schemas/VegCore/VegCore.pg.sql
126 126
  "id" text NOT NULL,
127 127
  "name" text NOT NULL,
128 128
  "contacts" text NOT NULL /*COMMENT 'contact person(s) to ask about attribution questions. there should always be at least one contact person. if unknown, the person loading the data should set this to themselves.'*/,
129
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by data_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the data_source).'*/,
129
  "parent" text DEFAULT NULL /*COMMENT 'this provides a containment relationship, which differs from the attribution relationship provided by dataset_source. e.g. the GBIF.ARIZ dataset is contained within the GBIF dataset (the parent), but was obtained from ARIZ (the dataset_source).'*/,
130 130
  "dataset_source" text DEFAULT NULL /*COMMENT 'where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable); = Brad.vegpath.org?attribution.proximate_data_provider'*/,
131 131
  "first_publisher" text DEFAULT NULL /*COMMENT '= Brad.vegpath.org?attribution.data_publisher, Brad.vegpath.org?data_provenance.primarydataprovider'*/,
132 132
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
......
137 137
  /*KEY "fk_dataset_source2_idx" ("dataset_source")*/CHECK (true),
138 138
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),
139 139
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
140
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
140 143
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141 144
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143 145
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
146
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
147 147
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;
148 148
/*!40101 SET character_set_client = @saved_cs_client */;
149 149

  

Also available in: Unified diff