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