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_tabledescriptionaux_rolewhere_tablenameaux_role

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	aux_Role
Table	Role
Notes	This table stores valid role codes for use in contributor tables
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID ROLE_ID no serial PK no Database assigned value for a unique role code Role Code roleCode required varchar (30) n/a no constraining list of role codes for *Contributor tables Role Description roleDescription no varchar (200) n/a no Description of the 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).