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