Revision 1161
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 890 | 890 |
name text NOT NULL, |
| 891 | 891 |
description text, |
| 892 | 892 |
accessioncode text, |
| 893 |
lengthunits text, |
|
| 894 | 893 |
diameterheight double precision, |
| 895 | 894 |
mindiameter double precision, |
| 896 | 895 |
maxdiameter double precision, |
| ... | ... | |
| 898 | 897 |
maxheight double precision, |
| 899 | 898 |
observationtype text, |
| 900 | 899 |
observationmeasure text, |
| 901 |
observationmeasureunits text, |
|
| 902 | 900 |
covermethod_id int(11), |
| 903 | 901 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
| 904 | 902 |
coverbasis text, |
| ... | ... | |
| 941 | 939 |
|
| 942 | 940 |
|
| 943 | 941 |
-- |
| 944 |
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: - |
|
| 945 |
-- |
|
| 946 |
|
|
| 947 |
|
|
| 948 |
|
|
| 949 |
|
|
| 950 |
-- |
|
| 951 | 942 |
-- Name: COLUMN method.diameterheight; Type: COMMENT; Schema: public; Owner: - |
| 952 | 943 |
-- |
| 953 | 944 |
|
| ... | ... | |
| 997 | 988 |
|
| 998 | 989 |
|
| 999 | 990 |
-- |
| 1000 |
-- Name: COLUMN method.observationmeasureunits; Type: COMMENT; Schema: public; Owner: - |
|
| 1001 |
-- |
|
| 1002 |
|
|
| 1003 |
|
|
| 1004 |
|
|
| 1005 |
|
|
| 1006 |
-- |
|
| 1007 | 991 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: - |
| 1008 | 992 |
-- |
| 1009 | 993 |
|
Also available in: Unified diff
vegbien.sql: method: Removed lengthunits and instead require all length- or area-related measurements throughout VegBIEN to be converted to SI base units, e.g. cm -> m, ha -> m^2. Adjusted ERD to avoid some densely packed lines.