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

51010

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)	plantConcept
Table	Plant Concept
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)	plantCorrelation
Table	Plant Correlation
Field	ID
DB Field Name	PLANTCORRELATION_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the plantCorrelation table.

 

Table (DB Name)	plantCorrelation
Table	Plant Correlation
Field	Plant Status
DB Field Name	PLANTSTATUS_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantStatus.PLANTSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the plantStatus table "pointing" to a concept no longer viewed as standard by the party.

 

Table (DB Name)	plantCorrelation
Table	Plant Correlation
Field	Plant Concept
DB Field Name	PLANTCONCEPT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantConcept.PLANTCONCEPT_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the plantConcept table "pointing" to a concept recognized by the party as a "standard" concept.

 

Table (DB Name)	plantCorrelation
Table	Plant Correlation
Field	Plant Convergence
DB Field Name	plantConvergence
Req'd?	required
Data Type	varchar (20)
Misc Flag	n/a
References	n/a
List?	closed
Notes	closed list
Definition	This is the descriptive attribute that is used to relate the congruence between two concepts. The concept that is represented in the party perspective, via the Status_ID field is [this field, i.e. <,>,=] the concept represented in Concept_ID field. As normally used, (no Longer Valid Concept) [convergence] (Valid Concept). For example, if a concept is split, the convergence would be 'greater than' (The old concept is 'greater than' the new concept).
closed List of Values: Value Description Sorting equal The two concepts are exactly the same. 1 greater than The reference concept (referenced in table:Status) fully contains the correlated concept (referenced in table:Concept), but also includes additional entities. 2 less than The reference concept is fully included in the correlated concept, but the latter concept contains additional entities. 3 not equal The two concepts, are not exactly the same. This leaves the possibilities that the reference concept is greater than, less than, overlapping, similar, or disjunct relative to the correlated concept. 4 overlapping The two concepts contain at least one common individual, and each concept also contains at least one individual that the other does not contain. Neither concept is fully contained in the other. 5 similar The two concepts contain at least one common individual. 6 disjunct The two concepts in question contain no common individuals. 7 undetermined Although some correlation is likely, the party responsible for the this correlation has not made a determination. 8

 

Table (DB Name)	plantCorrelation
Table	Plant Correlation
Field	Correlation Start
DB Field Name	correlationStart
Req'd?	required
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the start date for recognition by a party of a correlation between two concepts.

 

Table (DB Name)	plantCorrelation
Table	Plant Correlation
Field	Correlation Stop
DB Field Name	correlationStop
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the stop date for recognition by a party of a correlation between two concepts.

 

Table (DB Name)	plantLineage
Table	Plant Lineage
Field	ID
DB Field Name	PLANTLINEAGE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the plantLineage table.

 

Table (DB Name)	plantLineage
Table	Plant Lineage
Field	Child Plant Status
DB Field Name	childPlantStatus_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantStatus.PLANTSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the plantStatus table "pointing" to a child concept.

 

Table (DB Name)	plantLineage
Table	Plant Lineage
Field	Parent Plant Status
DB Field Name	parentPlantStatus_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	plantStatus.PLANTSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the plantStatus table "pointing" to a parent concept.