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

391010

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)	revision
Table	Revision
Field	ID
DB Field Name	REVISION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the revision table
Definition	Database generated identifier assigned to each unique revision.

 

Table (DB Name)	revision
Table	Revision
Field	Table Name
DB Field Name	tableName
Req'd?	required
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Name of the table where the change occurred.

 

Table (DB Name)	revision
Table	Revision
Field	Table Attribute
DB Field Name	tableAttribute
Req'd?	required
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The name of the attribute where the chance occurred.

 

Table (DB Name)	revision
Table	Revision
Field	Table Record
DB Field Name	tableRecord
Req'd?	required
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The number of the record in which the change occurred (i.e., the value of the primary key associated with the value in which the change occurred)

 

Table (DB Name)	revision
Table	Revision
Field	Revision Date
DB Field Name	revisionDate
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The date on which the revision was made.

 

Table (DB Name)	revision
Table	Revision
Field	Previous Value Text
DB Field Name	previousValueText
Req'd?	required
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The previous value as a character string.

 

Table (DB Name)	revision
Table	Revision
Field	Previous Value Type
DB Field Name	previousValueType
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The data type of the attribute changed.

 

Table (DB Name)	revision
Table	Revision
Field	Previous Revision
DB Field Name	previousRevision_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	revision.REVISION_ID
List?	no
Notes	Recursive foreign key
Definition	Pointer to a previous record of a revision.

 

Table (DB Name)	soilObs
Table	Soil Observation
Field	ID
DB Field Name	SOILOBS_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for observation
Definition	Database generated identifier assigned to each unique soil observation.

 

Table (DB Name)	soilObs
Table	Soil Observation
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 to parent plot
Definition	Link to the observation event to which this soil observation is associated.