Revision 11054
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/VegCore/ERD/document.mwb.xml | ||
|---|---|---|
| 601 | 601 |
<value type="int" key="commentedOut">0</value> |
| 602 | 602 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
| 603 | 603 |
<value _ptr_="0xb401dc8" type="dict" key="customData"/> |
| 604 |
<value type="string" key="lastChangeDate">2013-09-15 04:36</value>
|
|
| 604 |
<value type="string" key="lastChangeDate">2013-09-22 04:31</value>
|
|
| 605 | 605 |
<value type="int" key="modelOnly">0</value> |
| 606 | 606 |
<value type="string" key="name">dataset</value> |
| 607 | 607 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 608 | 608 |
<value type="string" key="temp_sql"></value> |
| 609 |
<value type="string" key="comment">something requiring attribution</value>
|
|
| 609 |
<value type="string" key="comment">a collection of records from the same place, with the same attribution requirements</value>
|
|
| 610 | 610 |
<value type="string" key="oldName">dataset</value> |
| 611 | 611 |
</value> |
| 612 | 612 |
<value type="object" struct-name="db.mysql.Table" id="be8df962-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
| ... | ... | |
| 12726 | 12726 |
<value type="string" key="name">record</value> |
| 12727 | 12727 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 12728 | 12728 |
<value type="string" key="temp_sql"></value> |
| 12729 |
<value type="string" key="comment">a collection of data relating to the same entity. this doesn't have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.</value>
|
|
| 12729 |
<value type="string" key="comment">a collection of data relating to the same entity. this doesn't have to be a row in a table, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.</value>
|
|
| 12730 | 12730 |
<value type="string" key="oldName">record</value> |
| 12731 | 12731 |
</value> |
| 12732 | 12732 |
<value type="object" struct-name="db.mysql.Table" id="afc401d4-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x1a403946"> |
| ... | ... | |
| 18254 | 18254 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 18255 | 18255 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 18256 | 18256 |
<value type="string" key="caption">New Model</value> |
| 18257 |
<value type="string" key="dateChanged">2013-09-22 04:07</value>
|
|
| 18257 |
<value type="string" key="dateChanged">2013-09-22 04:31</value>
|
|
| 18258 | 18258 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 18259 | 18259 |
<value type="string" key="description"></value> |
| 18260 | 18260 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 134 | 134 |
KEY `fk_source_party2_idx` (`first_publisher`), |
| 135 | 135 |
KEY `fk_source_party_list1_idx` (`data_owners`), |
| 136 | 136 |
KEY `fk_source_party1_idx` (`contacts`), |
| 137 |
CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 138 |
CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 137 | 139 |
CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 138 |
CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`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_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 141 | 141 |
CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 142 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something requiring attribution';
|
|
| 142 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
|
|
| 143 | 143 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 144 | 144 |
|
| 145 | 145 |
-- |
| ... | ... | |
| 709 | 709 |
KEY `fk_record_source1_idx` (`dataset`), |
| 710 | 710 |
CONSTRAINT `fk_record_source10` FOREIGN KEY (`dataset`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 711 | 711 |
CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 712 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.';
|
|
| 712 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be a row in a table, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.';
|
|
| 713 | 713 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 714 | 714 |
|
| 715 | 715 |
-- |
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 136 | 136 |
/*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
|
| 137 | 137 |
/*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),
|
| 138 | 138 |
/*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
|
| 139 |
/*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 140 |
/*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 139 | 141 |
/*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 140 |
/*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("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_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 143 | 143 |
/*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 144 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something requiring attribution'*/;
|
|
| 144 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;
|
|
| 145 | 145 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 146 | 146 |
|
| 147 | 147 |
-- |
| ... | ... | |
| 711 | 711 |
/*KEY "fk_record_source1_idx" ("dataset")*/CHECK (true),
|
| 712 | 712 |
/*CONSTRAINT "fk_record_source10" FOREIGN KEY ("dataset") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 713 | 713 |
/*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 714 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.'*/;
|
|
| 714 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be a row in a table, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.'*/;
|
|
| 715 | 715 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 716 | 716 |
|
| 717 | 717 |
-- |
Also available in: Unified diff
schemas/VegCore/ERD/VegCore.ERD.mwb: record: clarified that "an actual data record" means "a row in a table". dataset: made definition more specific ("a collection of records from the same place, with the same attribution requirements").