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_tabledescriptionplantconceptwhere_tablenameplantconcept

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	plantConcept
Table	Plant Concept
Notes	This table store the concepts that are linked to plant names through the plantUsage table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID PLANTCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table. Plant Name PLANTNAME_ID required Integer FK no This is a foreign key into the plant name list, the entry in which when combined with a reference constitutes a concept. Reference reference_ID required Integer FK no This is a foreign key to the reference in which the name was used, thereby defining a concept. Plant Description plantDescription no text n/a no The plantDescription is a description of the plantConcept by the party contributing the plantConcept. 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).