VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
««more pages | «previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | page 8 | 9 | 10 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Plant Usage | Class System | classSystem | no | varchar (50) | n/a | open | This is the name of the classification system wherein the name is applied (e.g., EnglishCommon or Scientific). |
Plant Usage | Plant Status | PLANTSTATUS_ID | no | Integer | FK | no | Plant Status which applies to this plantUsage. |
Address | ID | ADDRESS_ID | no | serial | PK | no | Database generated identifier assigned to each unique party address (note that a single party may have multiple addresses but that only one may be 'current'). |
Address | Party | party_ID | required | Integer | FK | no | Link to the party to which this address applies |
Address | Organization | organization_ID | no | Integer | FK | no | Link to an organization with which a party is affiliated |
Address | Organization Position | orgPosition | no | varchar (50) | n/a | no | Position of party within organization. |
Address | no | varchar (100) | n/a | no | email address | ||
Address | Delivery Point | deliveryPoint | no | varchar (200) | n/a | no | Address line for the location (Street name, box number, suite). |
Address | City | city | no | varchar (50) | n/a | no | City of the location. |
Address | Administrative Area | administrativeArea | no | varchar (50) | n/a | no | State, province of the location. |