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

301010

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)	observation
Table	Observation
Field	Notes Public
DB Field Name	notesPublic
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that public notes pertaining to this plot exist in "vegPlot.note"

 

Table (DB Name)	observation
Table	Observation
Field	Notes Mgt
DB Field Name	notesMgt
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that nonpublic management notes pertaining to this plot exist in "vegPlot.note"

 

Table (DB Name)	observation
Table	Observation
Field	Revisions
DB Field Name	revisions
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE indicates that revisions exist in vegPlot.Revision

 

Table (DB Name)	observationContributor
Table	Observation Contributor
Field	ID
DB Field Name	OBSERVATIONCONTRIBUTOR_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database generated identifier assigned to each unique contribution to an observation event.

 

Table (DB Name)	observationContributor
Table	Observation Contributor
Field	Observation
DB Field Name	OBSERVATION_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	observation.OBSERVATION_ID
List?	no
Notes	This is the foreign key into the Observation table.
Definition	Foreign key pointing to a given plot observation event to which the contribution was made.

 

Table (DB Name)	observationContributor
Table	Observation Contributor
Field	Party
DB Field Name	PARTY_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	party.PARTY_ID
List?	no
Notes	This is the foreign key into the party table.
Definition	Foreign key pointing to the specific party that made the contribution.

 

Table (DB Name)	observationContributor
Table	Observation Contributor
Field	Role
DB Field Name	ROLE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	This is the foreign key into the aux_Role table
Definition	Foreign key that identifies the role that the party had in the plot observation (e.g., PI, contact, research advisor, field assistant, taxonomist, owner, guide, etc.).

 

Table (DB Name)	observationContributor
Table	Observation Contributor
Field	Contribution Date
DB Field Name	contributionDate
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The date of the specific contribution, which will generally be within the time span of the plot observation event defined by the obsStartDate and obsStopDate

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
Field	ID
DB Field Name	OBSERVATIONSYNONYM_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary Key for the observationSynonym table.
Definition	Database generated identifier assigned to each unique interpretation of an observation as a synonym.

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
Field	Synonym Observation
DB Field Name	synonymObservation_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 reduced to synonymy.