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

311010

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)	observationSynonym
Table	Observation Synonym
Field	Primary Observation
DB Field Name	primaryObservation_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 the preferred synonym for the observation being reduced to synonym.

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
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 reduction to synonym.

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
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 synonomization (e.g., plot author, data manager, publication author, researcher, generic user, etc.).

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
Field	Start Date
DB Field Name	classStartDate
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Start date for the synonymization event.

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
Field	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 synonymization event.

 

Table (DB Name)	observationSynonym
Table	Observation Synonym
Field	Synonym Comment
DB Field Name	synonymComment
Req'd?	no
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Notes about the reason for the synonymization.

 

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

 

Table (DB Name)	party
Table	Party
Field	Salutation
DB Field Name	salutation
Req'd?	no
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Salutation preceding one's given name.

 

Table (DB Name)	party
Table	Party
Field	Given Name
DB Field Name	givenName
Req'd?	no
Data Type	varchar (50)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	One's first name.