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