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

61010

VegBank Data Dictionary: Tables

Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Table >>

Search VegBank Fields Here

Show field labels | Show database names

DB Table Name	referenceJournal
Table	Reference Journal
Notes	This table stores information about journals used as part of a reference.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID referenceJournal_ID required serial PK no Primary key for the referenceJournal table. Journal journal required varchar (250) n/a no The name of the journal, magazine, newspaper, zine, etc... in which the article was published. Example(s): Ecology, New York Times, Harper's, Canadian Journal of Botany/Revue Canadienne de Botanique ,The Journal of the American Medical Association ISSN issn no varchar (250) n/a no The ISSN, or International Standard Serial Number that has been assigned to this literature resource. Example(s): ISSN 1234-5679 Abbreviation abbreviation no varchar (250) n/a no Standard abbreviation or shorter name of the journal. Example(s): Can. J. Bot./Rev. Can. Bot., JAMA Accession Code accessionCode no varchar (100) n/a no 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).

 

DB Table Name	commConcept
Table	Community Concept
Notes	This table store the concepts (assertions) that are linked to community names through the commUsage table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table. Community Name COMMNAME_ID required Integer FK no Foreign key into the commName table providing the name used for the community when it was defined by usage in a publication (which could be this database). Reference reference_ID no Integer FK no Foreign key into the Reference table to identify a reference in which the community was identified by a name. This could be a regular publication, or a self reference created by completing the commDescription field in reference Community Description commDescription no text n/a no The commDescription is a description of the community concept by the party that contributed the concept. Accession Code accessionCode no varchar (100) n/a no 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).

 

DB Table Name	commCorrelation
Table	Community Correlation
Notes	This table correlates multiple community concepts as they change through time in the perception of a party
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMCORRELATION_ID no serial PK no Database assigned value to each unique record in the communityCorrelation table. Community Status COMMSTATUS_ID required Integer FK no This is the foreign key into the CommStatus table "pointing" to a concept no longer viewed as standard by the party. Community Concept COMMCONCEPT_ID required Integer FK no This is the foreign key into the communityConcept table "pointing" to a concept recognized by the party as a "standard" concept. Community Convergence commConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two concepts. Correlation Start correlationStart required Date n/a no This is the start date for recognition by a party of a correlation between two concepts. Correlation Stop correlationStop no Date n/a no This is the stop date for recognition by a party of a correlation between two concepts.

 

DB Table Name	commLineage
Table	Community Lineage
Notes	This table stores tracks the lineage of vegetation community concepts.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMLINEAGE_ID no serial PK no Database assigned value to each unique record in the commLineage table. Parent Community Status parentCommStatus_ID required Integer FK no This is the foreign key into the commStatus table "pointing" to a parent concept. Child Community Status childCommStatus_ID required Integer FK no This is the foreign key into the commStatus table "pointing" to a child concept.

 

DB Table Name	commName
Table	Community Name
Notes	This table stores vegetation community names
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMNAME_ID no serial PK no Database assigned value to each unique record in the commName table. Community Name commName required text n/a no The community name. Reference reference_ID no Integer FK no Foreign key into reference to identify the source of the name. Date Entered dateEntered no Date n/a no Field stores the date that the name was entered into the database.