Revision 490
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1054 | 1054 |
CREATE TABLE individualplant ( |
| 1055 | 1055 |
individualplant_id integer NOT NULL, |
| 1056 | 1056 |
aggregateoccurrence_id integer NOT NULL, |
| 1057 |
stemdiameter double precision,
|
|
| 1058 |
stemdiameteraccuracy double precision,
|
|
| 1059 |
stemheight double precision,
|
|
| 1060 |
stemheightaccuracy double precision,
|
|
| 1061 |
stemtaxonarea double precision,
|
|
| 1057 |
diameter double precision, |
|
| 1058 |
diameteraccuracy double precision, |
|
| 1059 |
height double precision, |
|
| 1060 |
heightaccuracy double precision, |
|
| 1061 |
taxonarea double precision, |
|
| 1062 | 1062 |
emb_individualplant integer, |
| 1063 | 1063 |
authorcode character varying(20) |
| 1064 | 1064 |
); |
| ... | ... | |
| 2294 | 2294 |
stem_id integer NOT NULL, |
| 2295 | 2295 |
individualplant_id integer NOT NULL, |
| 2296 | 2296 |
authorcode character varying(20), |
| 2297 |
stemxposition double precision,
|
|
| 2298 |
stemyposition double precision,
|
|
| 2299 |
stemhealth character varying(50),
|
|
| 2297 |
xposition double precision, |
|
| 2298 |
yposition double precision, |
|
| 2299 |
health character varying(50), |
|
| 2300 | 2300 |
emb_stem integer, |
| 2301 |
stemdiameter double precision,
|
|
| 2302 |
stemheight double precision,
|
|
| 2303 |
stemheightaccuracy double precision,
|
|
| 2301 |
diameter double precision, |
|
| 2302 |
height double precision, |
|
| 2303 |
heightaccuracy double precision, |
|
| 2304 | 2304 |
age double precision |
| 2305 | 2305 |
); |
| 2306 | 2306 |
|
Also available in: Unified diff
VegBIEN: Removed stem* prefix from stem measurements because it's redundant and because these same field names were reused in non-stem tables