Revision 676
Added by Aaron Marcuse-Kubitza almost 13 years ago
schemas/vegbien.for_ERD.my.sql | ||
---|---|---|
404 | 404 |
stratumheight double precision, |
405 | 405 |
stratumbase double precision, |
406 | 406 |
stratumcover double precision, |
407 |
area double precision, |
|
407 | 408 |
CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ), |
408 | 409 |
CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) |
409 | 410 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
schemas/vegbien.for_wiki.sql | ||
---|---|---|
165 | 165 |
stratumheight double precision, |
166 | 166 |
stratumbase double precision, |
167 | 167 |
stratumcover double precision, |
168 |
area double precision, |
|
168 | 169 |
); |
169 | 170 |
|
170 | 171 |
CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms. |
schemas/vegbien.for_ERD.sql | ||
---|---|---|
404 | 404 |
stratumheight double precision, |
405 | 405 |
stratumbase double precision, |
406 | 406 |
stratumcover double precision, |
407 |
area double precision, |
|
407 | 408 |
CONSTRAINT stratum_pkey PRIMARY KEY (stratum_id ), |
408 | 409 |
CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) |
409 | 410 |
REFERENCES locationevent (locationevent_id) MATCH SIMPLE |
schemas/vegbien.sql | ||
---|---|---|
2488 | 2488 |
stratumtype_id integer NOT NULL, |
2489 | 2489 |
stratumheight double precision, |
2490 | 2490 |
stratumbase double precision, |
2491 |
stratumcover double precision |
|
2491 |
stratumcover double precision, |
|
2492 |
area double precision |
|
2492 | 2493 |
); |
2493 | 2494 |
|
2494 | 2495 |
|
Also available in: Unified diff
vegbien.sql: Added stratum.area