unhighlight
highlightVegBank 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. |