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  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | page 9 | 10 |  next»
records 81 through 90 of 503

more pages»»

show labels | show db fields
Table Field DB Field Name Req'd? Data Type Misc Flag List? Definition
Address Postal Code postalCode no varchar (10) n/a no Zip code or other postal code.
Address Country country no varchar (50) n/a no Country of the physical address.
Address Address is Current? currentFlag no Boolean n/a no This flag signifies whether the address is the current address of the party.
Address Address Start Date addressStartDate no Date n/a no The first database date on which the address/organization information applied (have a discrete date on which address is known to applied - not necessarily the first date on which the address applied).
Role ID ROLE_ID no serial PK no Database assigned value for a unique role code
Role Role Code roleCode required varchar (30) n/a no constraining list of role codes for *Contributor tables
Role Role Description roleDescription no varchar (200) n/a no Description of the role
Role 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 ID reference_ID required serial PK no Primary key for the reference table.
Reference Short Name shortName no varchar (250) n/a no The 'shortName' field provides a concise or abbreviated name that describes the resource that is being documented.

««more pages

«previous  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | page 9 | 10 |  next»
records 81 through 90 of 503

more pages»»