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

detaildba_tabledescriptionpartywhere_tablenameparty

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	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.