Revision 1433
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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 |
|
Also available in: Unified diff
vegbien.sql: taxonoccurrence: Added iscultivated, isnative. Moved accessioncode to bottom.