Revision 4827
Added by Aaron Marcuse-Kubitza over 12 years ago
schemas/vegbien.my.sql | ||
---|---|---|
2279 | 2279 |
sourceaccessioncode text, |
2280 | 2280 |
plantobservation_id int(11) NOT NULL, |
2281 | 2281 |
authorstemcode text, |
2282 |
tag text, |
|
2283 |
tags text, |
|
2282 | 2284 |
xposition_m double precision, |
2283 | 2285 |
yposition_m double precision, |
2284 | 2286 |
diameterbreastheight_m double precision, |
... | ... | |
2301 | 2303 |
|
2302 | 2304 |
|
2303 | 2305 |
-- |
2306 |
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: - |
|
2307 |
-- |
|
2308 |
|
|
2309 |
|
|
2310 |
|
|
2311 |
|
|
2312 |
-- |
|
2304 | 2313 |
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
2305 | 2314 |
-- |
2306 | 2315 |
|
schemas/vegbien.sql | ||
---|---|---|
2801 | 2801 |
sourceaccessioncode text, |
2802 | 2802 |
plantobservation_id integer NOT NULL, |
2803 | 2803 |
authorstemcode text, |
2804 |
tag text, |
|
2805 |
tags text, |
|
2804 | 2806 |
xposition_m double precision, |
2805 | 2807 |
yposition_m double precision, |
2806 | 2808 |
diameterbreastheight_m double precision, |
... | ... | |
2823 | 2825 |
|
2824 | 2826 |
|
2825 | 2827 |
-- |
2828 |
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: - |
|
2829 |
-- |
|
2830 |
|
|
2831 |
COMMENT ON COLUMN stemobservation.tags IS 'Stores all tags when multiple tags provided. Older tags go first.'; |
|
2832 |
|
|
2833 |
|
|
2834 |
-- |
|
2826 | 2835 |
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
2827 | 2836 |
-- |
2828 | 2837 |
|
Also available in: Unified diff
schemas/vegbien.sql: stemobservation: Added tag, tags