Revision 8634
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 1022 | 1022 |
PRIMARY KEY (`id`) , |
| 1023 | 1023 |
CONSTRAINT `fk_place_path_record10` |
| 1024 | 1024 |
FOREIGN KEY (`id` ) |
| 1025 |
REFERENCES `record` (`id` )
|
|
| 1025 |
REFERENCES `method` (`id` )
|
|
| 1026 | 1026 |
ON DELETE CASCADE |
| 1027 | 1027 |
ON UPDATE CASCADE) |
| 1028 | 1028 |
ENGINE = InnoDB |
| ... | ... | |
| 1070 | 1070 |
|
| 1071 | 1071 |
|
| 1072 | 1072 |
-- ----------------------------------------------------- |
| 1073 |
-- Table `plot_stratum` |
|
| 1074 |
-- ----------------------------------------------------- |
|
| 1075 |
DROP TABLE IF EXISTS `plot_stratum` ; |
|
| 1076 |
|
|
| 1077 |
CREATE TABLE IF NOT EXISTS `plot_stratum` ( |
|
| 1078 |
`id` VARBINARY(767) NOT NULL , |
|
| 1079 |
`stratum` VARBINARY(767) NOT NULL , |
|
| 1080 |
PRIMARY KEY (`id`) , |
|
| 1081 |
INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) , |
|
| 1082 |
CONSTRAINT `fk_subplot_place10` |
|
| 1083 |
FOREIGN KEY (`id` ) |
|
| 1084 |
REFERENCES `place` (`id` ) |
|
| 1085 |
ON DELETE CASCADE |
|
| 1086 |
ON UPDATE CASCADE, |
|
| 1087 |
CONSTRAINT `fk_plot_stratum_stratum1` |
|
| 1088 |
FOREIGN KEY (`stratum` ) |
|
| 1089 |
REFERENCES `stratum` (`id` ) |
|
| 1090 |
ON DELETE CASCADE |
|
| 1091 |
ON UPDATE CASCADE) |
|
| 1092 |
ENGINE = InnoDB |
|
| 1093 |
DEFAULT CHARACTER SET = utf8 |
|
| 1094 |
COLLATE = utf8_bin; |
|
| 1095 |
|
|
| 1096 |
|
|
| 1097 |
-- ----------------------------------------------------- |
|
| 1098 | 1073 |
-- Table `4. matched` |
| 1099 | 1074 |
-- ----------------------------------------------------- |
| 1100 | 1075 |
DROP TABLE IF EXISTS `4. matched` ; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: made stratum extend method, so that any observation event can have an associated stratum. removed no longer needed plot_stratum, since strata are now represented as sampling methods (i.e. using height classes) rather than a variant of subplots.