Revision 6425
Added by Aaron Marcuse-Kubitza almost 12 years ago
| 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 |
-- |
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