Revision 1433
Added by Aaron Marcuse-Kubitza almost 13 years ago
| 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.