Revision 6425
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 689 | 689 |
`elevationInMeters` double precision, |
| 690 | 690 |
`plotArea_ha` double precision, |
| 691 | 691 |
`samplingProtocol` text, |
| 692 |
`dateCollected` date, |
|
| 692 |
`dateCollected` date NOT NULL,
|
|
| 693 | 693 |
`higherPlantGroup` text, |
| 694 | 694 |
family text, |
| 695 | 695 |
genus text, |
| ... | ... | |
| 729 | 729 |
`elevationInMeters` double precision, |
| 730 | 730 |
`plotArea_ha` double precision, |
| 731 | 731 |
`samplingProtocol` text, |
| 732 |
`dateCollected` date, |
|
| 732 |
`dateCollected` date NOT NULL,
|
|
| 733 | 733 |
`higherPlantGroup` text, |
| 734 | 734 |
family text, |
| 735 | 735 |
genus text, |
| ... | ... | |
| 4177 | 4177 |
-- |
| 4178 | 4178 |
|
| 4179 | 4179 |
ALTER TABLE analytical_aggregate |
| 4180 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY (`institutionCode`, `plotName`, `scientificNameWithMorphospecies`); |
|
| 4180 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`);
|
|
| 4181 | 4181 |
|
| 4182 | 4182 |
|
| 4183 | 4183 |
-- |
| ... | ... | |
| 4185 | 4185 |
-- |
| 4186 | 4186 |
|
| 4187 | 4187 |
ALTER TABLE analytical_stem |
| 4188 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`institutionCode`, `plotName`, `scientificNameWithMorphospecies`, `recordNumber`); |
|
| 4188 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`, `recordNumber`);
|
|
| 4189 | 4189 |
|
| 4190 | 4190 |
|
| 4191 | 4191 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 1374 | 1374 |
"elevationInMeters" double precision, |
| 1375 | 1375 |
"plotArea_ha" double precision, |
| 1376 | 1376 |
"samplingProtocol" text, |
| 1377 |
"dateCollected" date, |
|
| 1377 |
"dateCollected" date NOT NULL,
|
|
| 1378 | 1378 |
"higherPlantGroup" higher_plant_group, |
| 1379 | 1379 |
family text, |
| 1380 | 1380 |
genus text, |
| ... | ... | |
| 1414 | 1414 |
"elevationInMeters" double precision, |
| 1415 | 1415 |
"plotArea_ha" double precision, |
| 1416 | 1416 |
"samplingProtocol" text, |
| 1417 |
"dateCollected" date, |
|
| 1417 |
"dateCollected" date NOT NULL,
|
|
| 1418 | 1418 |
"higherPlantGroup" higher_plant_group, |
| 1419 | 1419 |
family text, |
| 1420 | 1420 |
genus text, |
| ... | ... | |
| 5192 | 5192 |
-- |
| 5193 | 5193 |
|
| 5194 | 5194 |
ALTER TABLE ONLY analytical_aggregate |
| 5195 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY ("institutionCode", "plotName", "scientificNameWithMorphospecies");
|
|
| 5195 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY ("institutionCode", "plotName", "dateCollected", "scientificNameWithMorphospecies");
|
|
| 5196 | 5196 |
|
| 5197 | 5197 |
|
| 5198 | 5198 |
-- |
| ... | ... | |
| 5200 | 5200 |
-- |
| 5201 | 5201 |
|
| 5202 | 5202 |
ALTER TABLE ONLY analytical_stem |
| 5203 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY ("institutionCode", "plotName", "scientificNameWithMorphospecies", "recordNumber");
|
|
| 5203 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY ("institutionCode", "plotName", "dateCollected", "scientificNameWithMorphospecies", "recordNumber");
|
|
| 5204 | 5204 |
|
| 5205 | 5205 |
|
| 5206 | 5206 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: analytical_* pkeys: Added dateCollected because the records are actually unique within the location*event*, not the location