Revision 10974
Added by Aaron Marcuse-Kubitza over 10 years ago
| VegCore.my.sql | ||
|---|---|---|
| 811 | 811 |
`parent` varbinary(767) DEFAULT NULL, |
| 812 | 812 |
`name` varbinary(767) NOT NULL, |
| 813 | 813 |
`first_publisher` varbinary(767) DEFAULT NULL, |
| 814 |
`owners` varbinary(767) DEFAULT NULL,
|
|
| 814 |
`data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
|
|
| 815 | 815 |
`contacts` varbinary(767) DEFAULT NULL, |
| 816 | 816 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 817 | 817 |
PRIMARY KEY (`id`), |
| 818 | 818 |
UNIQUE KEY `source_unique` (`parent`,`name`), |
| 819 | 819 |
KEY `fk_source1_idx` (`parent`), |
| 820 | 820 |
KEY `fk_source_party2_idx` (`first_publisher`), |
| 821 |
KEY `fk_source_party_list1_idx` (`owners`), |
|
| 821 |
KEY `fk_source_party_list1_idx` (`data_owners`),
|
|
| 822 | 822 |
KEY `fk_source_party1_idx` (`contacts`), |
| 823 |
CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 823 | 824 |
CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 824 | 825 |
CONSTRAINT `fk_source1` FOREIGN KEY (`parent`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 825 |
CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 826 |
CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 826 |
CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 827 | 827 |
) 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)';
|
| 828 | 828 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 829 | 829 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: source.owners: renamed to data_owners for clarity. documented that this is the parties who must be given attribution, such as copyrightholders.