Revision 684
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 63 | 63 |
coverindex_id integer, |
| 64 | 64 |
); |
| 65 | 65 |
|
| 66 |
CREATE TABLE plant -- A physical, tagged plant. |
|
| 67 |
( |
|
| 68 |
plant_id serial NOT NULL, |
|
| 69 |
); |
|
| 70 |
|
|
| 71 | 66 |
CREATE TABLE planttag |
| 72 | 67 |
( |
| 73 | 68 |
planttag_id serial NOT NULL, |
| 74 |
plant_id integer NOT NULL, |
|
| 69 |
plantobservation_id integer NOT NULL,
|
|
| 75 | 70 |
tag character varying(255) NOT NULL, |
| 71 |
iscurrent boolean NOT NULL DEFAULT true, |
|
| 76 | 72 |
); |
| 77 | 73 |
|
| 74 |
CREATE TABLE plant -- A physical, tagged plant. |
|
| 75 |
( |
|
| 76 |
plant_id serial NOT NULL, |
|
| 77 |
); |
|
| 78 |
|
|
| 78 | 79 |
CREATE TABLE plantobservation -- VegBank's stemcount table. |
| 79 | 80 |
( |
| 80 | 81 |
plantobservation_id serial NOT NULL, |
Also available in: Unified diff
vegbien.sql: Made planttag a child of plantobservation instead of plant, since tags change over time