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

331010

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)	partyMember
Table	Party Member
Field	Role
DB Field Name	role_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	aux_Role.ROLE_ID
List?	no
Notes	n/a
Definition	Link to the role which defines the child's role in the parent party.

 

Table (DB Name)	partyMember
Table	Party Member
Field	Member Start
DB Field Name	memberStart
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Start date for the child's membership in the parent party.

 

Table (DB Name)	partyMember
Table	Party Member
Field	Member Stop
DB Field Name	memberStop
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Stop date for the child's membership in the parent party.

 

Table (DB Name)	place
Table	Place
Field	ID
DB Field Name	PLOTPLACE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	Primary key for the place table
Definition	Database generated identifier assigned to each unique plot occurrence at a place.

 

Table (DB Name)	place
Table	Place
Field	Plot
DB Field Name	PLOT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plot.PLOT_ID
List?	no
Notes	Foreign key into the plot table.
Definition	Link to a specific plot.

 

Table (DB Name)	place
Table	Place
Field	Calculated?
DB Field Name	calculated
Req'd?	no
Data Type	Boolean
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	TRUE If occurrence is calculated based on geo-coordinates, FALSE if assigned by the author (If, both methods used, the author assigned value takes priority).

 

Table (DB Name)	place
Table	Place
Field	Place Name
DB Field Name	NAMEDPLACE_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	namedPlace.NAMEDPLACE_ID
List?	no
Notes	Foreign key into the namedPlace table
Definition	Link to a specific named place or region

 

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

 

Table (DB Name)	plot
Table	Plot
Field	Author Plot Code
DB Field Name	authorPlotCode
Req'd?	required
Data Type	varchar (30)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Author's Plot number/code, or the original plot number if taken from literature.

 

Table (DB Name)	plot
Table	Plot
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	Foreign key into the reference table
Definition	Link to the source reference from which this plot record was taken