Login | Datasets | Logout
 

VegBank Data Dictionary - Search Fields

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

   Search VegBank Tables Here

««more pages

«previous  | 11 | 12 | 13 | page 14 | 15 | 16 | 17 | 18 | 19 | 20 |  next»
records 131 through 140 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Reference Party Suffix suffix no varchar (250) n/a no A suffix or suffix abbreviation that follows a name. Examples: Jr., Senior, III, etc.
Reference Party Organization Name organizationName no varchar (250) n/a no The responsible party field contains the full name of the organization that is associated with the resource. This field is intended to describe which institution or overall organization is associated with the resource being described. Note that this field, used in conjunction with 'individualName' and 'positionName' make up a single logical originator. Because of this, an originator with only the individualName of 'Joe Smith' is NOT the same as an originator with the name of 'Joe Smith' and the organizationName of 'NSF'. Also, the positionName should not be used in conjunction with individualName unless only that individual at that position would be considered an originator for the data package. If a positionName is used in conjunction with an organizationName, then that implies that any person who currently occupies said positionName at organizationName is the originator of the data package. Example(s): National Center for Ecological Analysis and Synthesis
Reference Party Current Name currentParty_ID no Integer FK no Recursive Foreign key into the referenceParty table to indicate the current name of the party.
Reference Party 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).
Reference Journal ID referenceJournal_ID required serial PK no Primary key for the referenceJournal table.
Reference Journal 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
Reference Journal 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
Reference Journal 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
Reference Journal 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).
Classification Contributor ID CLASSCONTRIBUTOR_ID no serial PK no Database generated identifier assigned to each unique contribution to the classification of a plot observation.

««more pages

«previous  | 11 | 12 | 13 | page 14 | 15 | 16 | 17 | 18 | 19 | 20 |  next»
records 131 through 140 of 503

more pages»»