Project

General

Profile

« Previous | Next » 

Revision 11191

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset.contacts: documented that this is the 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.

View differences:

schemas/VegCore/ERD/document.mwb.xml
212 212 
                      <value type="int" key="precision">-1</value>
213 213 
                      <value type="int" key="scale">-1</value>
214 214 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
215 
                      <value type="string" key="comment"></value>
215 
                      <value type="string" key="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.</value>
216 216 
                      <value type="string" key="name">contacts</value>
217 217 
                      <value type="string" key="oldName">contacts</value>
218 218 
                      <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:03</value>
649 
                  <value type="string" key="lastChangeDate">2013-10-09 11:09</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>
......
17485 17485 
              <value type="int" key="visible">1</value>
17486 17486 
              <value type="string" key="name"></value>
17487 17487 
            </value>
17488 
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17488 
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17489 
              <link type="object">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
17490 
            </value>
17489 17491 
            <value type="int" key="updateBlocked">0</value>
17490 17492 
            <value type="real" key="width">1.6215e+03</value>
17491 17493 
            <value type="real" key="x">0.e+00</value>
......
18124 18126 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18125 18127 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18126 18128 
      <value type="string" key="caption">New Model</value>
18127 
      <value type="string" key="dateChanged">2013-10-09 11:03</value>
18129 
      <value type="string" key="dateChanged">2013-10-09 11:09</value>
18128 18130 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18129 18131 
      <value type="string" key="description"></value>
18130 18132 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
123 123 
CREATE TABLE `dataset` (
124 124 
  `id` varbinary(767) NOT NULL,
125 125 
  `name` varbinary(767) NOT NULL,
126 
  `contacts` varbinary(767) NOT NULL,
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 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).',
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',
......
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,
138 
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 140 
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 141 
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142 142 
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143 
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`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
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
    
  





  125
  125
  
    
CREATE TABLE "dataset" (


  		




  126
  126
  
    
  "id" text NOT NULL,


  		




  127
  127
  
    
  "name" text NOT NULL,


  		




  128
  
  
    
  "contacts" text NOT NULL,


  		




  
  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
  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).'*/,


  		




  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'*/,


  		




  ......




  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),


  		




  
  140
  
    
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  142
  142
  
    
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




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


  		




  144
  144
  
    
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  145
  
  
    
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  146
  
  
    
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("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)


  		




  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