Login | Datasets | Logout
 

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 VegBank Fields Here

Show field labels | Show database names

DB Table Name party
Table Party
Notes Party contributing to collection or interpretation of a plot; may be either an individual or an organization.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PARTY_ID no serial PK no Database generated identifier assigned to each unique party.
Salutation salutation no varchar (20) n/a no Salutation preceding one's given name.
Given Name givenName no varchar (50) n/a no One's first name.
Middle Name middleName no varchar (50) n/a no One's middle name or initial, if any.
Surname surName no varchar (50) n/a no Name shared in common to identify the members of a family, as distinguished from each member's given name.
Organization Name organizationName no varchar (100) n/a no Name of an organization.
Current Name currentName_ID no Integer FK no Recursive foreign key to current name of this party.
Contact Instructions contactInstructions no text n/a no Instructions for contacting a 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).
Party Type partyType no varchar (40) n/a closed The type of party this is.
Party is public? partyPublic no Boolean denorm no This party may be displayed on the website. Not used for parties that are not contributing anywhere and have only signed up as users.
Plot Count d_obscount no Integer denorm no Number of observations associated with this entity.