Revision 6475
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 610 | 610 |
`speciesBinomial` varchar(255), |
| 611 | 611 |
`scientificName` varchar(255), |
| 612 | 612 |
`scientificNameAuthorship` varchar(255), |
| 613 |
`scientificNameWithMorphospecies` varchar(255) NOT NULL,
|
|
| 613 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 614 | 614 |
threatened int(1), |
| 615 | 615 |
`identifiedBy` varchar(255), |
| 616 | 616 |
`growthForm` varchar(255), |
| ... | ... | |
| 651 | 651 |
`speciesBinomial` varchar(255), |
| 652 | 652 |
`scientificName` varchar(255), |
| 653 | 653 |
`scientificNameAuthorship` varchar(255), |
| 654 |
`scientificNameWithMorphospecies` varchar(255) NOT NULL,
|
|
| 654 |
`scientificNameWithMorphospecies` varchar(255), |
|
| 655 | 655 |
threatened int(1), |
| 656 | 656 |
`identifiedBy` varchar(255), |
| 657 | 657 |
`growthForm` varchar(255), |
| ... | ... | |
| 664 | 664 |
`organismX_m` double precision, |
| 665 | 665 |
`organismY_m` double precision, |
| 666 | 666 |
`recordedBy` varchar(255), |
| 667 |
`recordNumber` varchar(255) NOT NULL
|
|
| 667 |
`recordNumber` varchar(255) |
|
| 668 | 668 |
); |
| 669 | 669 |
|
| 670 | 670 |
|
| ... | ... | |
| 4271 | 4271 |
|
| 4272 | 4272 |
|
| 4273 | 4273 |
-- |
| 4274 |
-- Name: analytical_aggregate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4275 |
-- |
|
| 4276 |
|
|
| 4277 |
ALTER TABLE analytical_aggregate |
|
| 4278 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`); |
|
| 4279 |
|
|
| 4280 |
|
|
| 4281 |
-- |
|
| 4282 |
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4283 |
-- |
|
| 4284 |
|
|
| 4285 |
ALTER TABLE analytical_stem |
|
| 4286 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY (`institutionCode`, `plotName`, `dateCollected`, `scientificNameWithMorphospecies`, `recordNumber`); |
|
| 4287 |
|
|
| 4288 |
|
|
| 4289 |
-- |
|
| 4290 | 4274 |
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4291 | 4275 |
-- |
| 4292 | 4276 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1320 | 1320 |
"speciesBinomial" text, |
| 1321 | 1321 |
"scientificName" text, |
| 1322 | 1322 |
"scientificNameAuthorship" text, |
| 1323 |
"scientificNameWithMorphospecies" text NOT NULL,
|
|
| 1323 |
"scientificNameWithMorphospecies" text, |
|
| 1324 | 1324 |
threatened boolean, |
| 1325 | 1325 |
"identifiedBy" text, |
| 1326 | 1326 |
"growthForm" growthform, |
| ... | ... | |
| 1361 | 1361 |
"speciesBinomial" text, |
| 1362 | 1362 |
"scientificName" text, |
| 1363 | 1363 |
"scientificNameAuthorship" text, |
| 1364 |
"scientificNameWithMorphospecies" text NOT NULL,
|
|
| 1364 |
"scientificNameWithMorphospecies" text, |
|
| 1365 | 1365 |
threatened boolean, |
| 1366 | 1366 |
"identifiedBy" text, |
| 1367 | 1367 |
"growthForm" growthform, |
| ... | ... | |
| 1374 | 1374 |
"organismX_m" double precision, |
| 1375 | 1375 |
"organismY_m" double precision, |
| 1376 | 1376 |
"recordedBy" text, |
| 1377 |
"recordNumber" text NOT NULL
|
|
| 1377 |
"recordNumber" text |
|
| 1378 | 1378 |
); |
| 1379 | 1379 |
|
| 1380 | 1380 |
|
| ... | ... | |
| 5322 | 5322 |
|
| 5323 | 5323 |
|
| 5324 | 5324 |
-- |
| 5325 |
-- Name: analytical_aggregate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 5326 |
-- |
|
| 5327 |
|
|
| 5328 |
ALTER TABLE ONLY analytical_aggregate |
|
| 5329 |
ADD CONSTRAINT analytical_aggregate_pkey PRIMARY KEY ("institutionCode", "plotName", "dateCollected", "scientificNameWithMorphospecies");
|
|
| 5330 |
|
|
| 5331 |
|
|
| 5332 |
-- |
|
| 5333 |
-- Name: analytical_stem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 5334 |
-- |
|
| 5335 |
|
|
| 5336 |
ALTER TABLE ONLY analytical_stem |
|
| 5337 |
ADD CONSTRAINT analytical_stem_pkey PRIMARY KEY ("institutionCode", "plotName", "dateCollected", "scientificNameWithMorphospecies", "recordNumber");
|
|
| 5338 |
|
|
| 5339 |
|
|
| 5340 |
-- |
|
| 5341 | 5325 |
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 5342 | 5326 |
-- |
| 5343 | 5327 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Removed primary keys and NOT NULL constraints on columns that sometimes have NULL values