Revision 1433
Added by Aaron Marcuse-Kubitza almost 13 years ago
schemas/vegbien.my.sql | ||
---|---|---|
2310 | 2310 |
CREATE TABLE taxonoccurrence ( |
2311 | 2311 |
taxonoccurrence_id int(11) NOT NULL, |
2312 | 2312 |
locationevent_id int(11), |
2313 |
accessioncode text, |
|
2314 | 2313 |
verbatimcollectorname text, |
2315 |
growthform text |
|
2314 |
growthform text, |
|
2315 |
iscultivated int(1), |
|
2316 |
isnative int(1), |
|
2317 |
accessioncode text |
|
2316 | 2318 |
); |
2317 | 2319 |
|
2318 | 2320 |
|
... | ... | |
2324 | 2326 |
|
2325 | 2327 |
|
2326 | 2328 |
-- |
2329 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - |
|
2330 |
-- |
|
2331 |
|
|
2332 |
|
|
2333 |
|
|
2334 |
|
|
2335 |
-- |
|
2336 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - |
|
2337 |
-- |
|
2338 |
|
|
2339 |
|
|
2340 |
|
|
2341 |
|
|
2342 |
-- |
|
2327 | 2343 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
2328 | 2344 |
-- |
2329 | 2345 |
|
schemas/vegbien.sql | ||
---|---|---|
2718 | 2718 |
CREATE TABLE taxonoccurrence ( |
2719 | 2719 |
taxonoccurrence_id integer NOT NULL, |
2720 | 2720 |
locationevent_id integer, |
2721 |
accessioncode text, |
|
2722 | 2721 |
verbatimcollectorname text, |
2723 |
growthform growthform |
|
2722 |
growthform growthform, |
|
2723 |
iscultivated boolean, |
|
2724 |
isnative boolean, |
|
2725 |
accessioncode text |
|
2724 | 2726 |
); |
2725 | 2727 |
|
2726 | 2728 |
|
... | ... | |
2732 | 2734 |
|
2733 | 2735 |
|
2734 | 2736 |
-- |
2737 |
-- Name: COLUMN taxonoccurrence.iscultivated; Type: COMMENT; Schema: public; Owner: - |
|
2738 |
-- |
|
2739 |
|
|
2740 |
COMMENT ON COLUMN taxonoccurrence.iscultivated IS 'cultivated or wild'; |
|
2741 |
|
|
2742 |
|
|
2743 |
-- |
|
2744 |
-- Name: COLUMN taxonoccurrence.isnative; Type: COMMENT; Schema: public; Owner: - |
|
2745 |
-- |
|
2746 |
|
|
2747 |
COMMENT ON COLUMN taxonoccurrence.isnative IS 'native or exotic'; |
|
2748 |
|
|
2749 |
|
|
2750 |
-- |
|
2735 | 2751 |
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
2736 | 2752 |
-- |
2737 | 2753 |
|
Also available in: Unified diff
vegbien.sql: taxonoccurrence: Added iscultivated, isnative. Moved accessioncode to bottom.