Revision 1102
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1569 | 1569 |
CREATE TABLE plantstatus ( |
| 1570 | 1570 |
plantstatus_id int(11) NOT NULL, |
| 1571 | 1571 |
plantconcept_id int(11) NOT NULL, |
| 1572 |
party_id int(11), |
|
| 1573 |
plantlevel text, |
|
| 1572 | 1574 |
plantparent_id int(11), |
| 1573 |
plantlevel text,
|
|
| 1575 |
plantconceptstatus text DEFAULT 'undetermined',
|
|
| 1574 | 1576 |
reference_id int(11), |
| 1575 |
plantconceptstatus text DEFAULT 'undetermined', |
|
| 1576 | 1577 |
plantpartycomments text, |
| 1577 | 1578 |
plantparentname text, |
| 1578 |
party_id int(11), |
|
| 1579 | 1579 |
startdate timestamp NULL, |
| 1580 | 1580 |
stopdate timestamp NULL, |
| 1581 | 1581 |
accessioncode text |
| schemas/vegbien.sql | ||
|---|---|---|
| 1813 | 1813 |
CREATE TABLE plantstatus ( |
| 1814 | 1814 |
plantstatus_id integer NOT NULL, |
| 1815 | 1815 |
plantconcept_id integer NOT NULL, |
| 1816 |
party_id integer, |
|
| 1817 |
plantlevel text, |
|
| 1816 | 1818 |
plantparent_id integer, |
| 1817 |
plantlevel text,
|
|
| 1819 |
plantconceptstatus text DEFAULT 'undetermined'::text NOT NULL,
|
|
| 1818 | 1820 |
reference_id integer, |
| 1819 |
plantconceptstatus text DEFAULT 'undetermined'::text NOT NULL, |
|
| 1820 | 1821 |
plantpartycomments text, |
| 1821 | 1822 |
plantparentname text, |
| 1822 |
party_id integer, |
|
| 1823 | 1823 |
startdate timestamp with time zone, |
| 1824 | 1824 |
stopdate timestamp with time zone, |
| 1825 | 1825 |
accessioncode text |
Also available in: Unified diff
vegbien.sql: Reordered plantstatus fields to put the most important fields at the top, which will be visible in the ERD