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

211010

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)	namedPlace
Table	Named Place
Field	Owner
DB Field Name	owner
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Although somewhat redundant with the owner information contained in observationContributor with roleCode of owner, this allows the program to provide ownership information automatically. The ownership field supercedes this field in priority.

 

Table (DB Name)	namedPlace
Table	Named Place
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 a reference that contains further information on the named place.

 

Table (DB Name)	namedPlace
Table	Named Place
Field	Accession Code
DB Field Name	accessionCode
Req'd?	no
Data Type	varchar (100)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

Table (DB Name)	namedPlaceCorrelation
Table	Named Place Correlation
DB Field Name	NAMEDPLACECORRELATION_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary Key.

 

Table (DB Name)	namedPlaceCorrelation
Table	Named Place Correlation
Field	Parent Place
DB Field Name	PARENTPLACE_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 parent geographical region.

 

Table (DB Name)	namedPlaceCorrelation
Table	Named Place Correlation
Field	Child Place
DB Field Name	CHILDPLACE_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 child geographical region.

 

Table (DB Name)	namedPlaceCorrelation
Table	Named Place Correlation
Field	Place Convergence
DB Field Name	placeConvergence
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	This is the descriptive attribute that is used to relate the congruence between two places, Parent [convergence value] child (generally greater than).
closed List of Values: Value Description Sorting equal The two places are exactly the same. 1 greater than The parent place fully contains the child place, and also includes additional space. 2 less than The parent place is fully included in the child place, but the child place contains additional space. 3 not equal The two places are not exactly the same. This leaves the possibilities that the parent place is greater than, less than, overlapping, similar, or disjunct relative to the child place. 4 overlapping The two places contain at least some common area, and each place also contains at least some area that the other does not contain. Neither place is fully contained in the other. 5 similar The two places contain at least some common area. 6 disjunct The two places in question contain no common area. 7 undetermined Although some correlation is likely, the correlation has not been determined. 8

 

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

 

Table (DB Name)	note
Table	Note
Field	Note Link
DB Field Name	NOTELINK_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	noteLink.NOTELINK_ID
List?	no
Notes	Foreign key into the notelink table
Definition	Link to the noteLink table via which a note is associated with a table, record and attribute.

 

Table (DB Name)	note
Table	Note
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 table to identify the party that contributed the note.