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

151010

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)	classContributor
Table	Classification Contributor
Field	Community Classification
DB Field Name	COMMCLASS_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commClass.COMMCLASS_ID
List?	no
Notes	Foreign key into the commClass table.
Definition	Observation classification event to which the contributor is associated.

 

Table (DB Name)	classContributor
Table	Classification Contributor
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 that contributed to the classification event.

 

Table (DB Name)	classContributor
Table	Classification Contributor
Field	Role
DB Field Name	ROLE_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	Foreign key into the aux_Role table
Definition	Foreign key that identifies the role that the party had in the classification event (e.g., classifier, consultant, research advisor).

 

Table (DB Name)	commClass
Table	Community Classification
Field	ID
DB Field Name	COMMCLASS_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the commClass table.
Definition	Database generated identifier assigned to each unique observation classification event.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Observation
DB Field Name	OBSERVATION_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	observation.OBSERVATION_ID
List?	no
Notes	Foreign key into the observation table
Definition	Link to the observation table identifying which observation is being classified.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Classification Start Date
DB Field Name	classStartDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Start date for the application of a vegetation class to a plot observation by one or more parties.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Classification Stop Date
DB Field Name	classStopDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Stop date for the application of a vegetation class to a plot observation by one or more parties.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Inspection
DB Field Name	inspection
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Classification informed by simple inspection of data.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Table Analysis
DB Field Name	tableAnalysis
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Classification informed by inspection of floristic composition tables.

 

Table (DB Name)	commClass
Table	Community Classification
Field	Multivariate Analysis
DB Field Name	multivariateAnalysis
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Classification informed by use of multivariate numerical tools.