Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

81010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Class System
DB Field Name	classSystem
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	open
Notes	closed list
Definition	This is the name of the classification system wherein the name is applied (e.g., EnglishCommon or Scientific).
open List of Values: Value Description Sorting Scientific   1 Scientific without authors   2 Code   3 English Common   4 Spanish Common   5 Other   6 French Common   7

 

Table (DB Name)	plantUsage
Table	Plant Usage
Field	Plant Status
DB Field Name	PLANTSTATUS_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	plantStatus.PLANTSTATUS_ID
List?	no
Notes	n/a
Definition	Plant Status which applies to this plantUsage.

 

Table (DB Name)	address
Table	Address
Field	ID
DB Field Name	ADDRESS_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the address table.
Definition	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').

 

Table (DB Name)	address
Table	Address
Field	Party
DB Field Name	party_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	Foreign key into the party table.
Definition	Link to the party to which this address applies

 

Table (DB Name)	address
Table	Address
Field	Organization
DB Field Name	organization_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	Foreign key into the party table
Definition	Link to an organization with which a party is affiliated

 

Table (DB Name)	address
Table	Address
Field	Organization Position
DB Field Name	orgPosition
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Position of party within organization.

 

Table (DB Name)	address
Table	Address
Field	Email
DB Field Name	email
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	email address

 

Table (DB Name)	address
Table	Address
Field	Delivery Point
DB Field Name	deliveryPoint
Req'd?	no
Data Type	varchar (200)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Address line for the location (Street name, box number, suite).

 

Table (DB Name)	address
Table	Address
Field	City
DB Field Name	city
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	City of the location.

 

Table (DB Name)	address
Table	Address
Field	Administrative Area
DB Field Name	administrativeArea
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	State, province of the location.