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_tabledescriptionplantusagewhere_tablenameplantUsage

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	plantUsage
Table	Plant Usage
Notes	This table links a plant name with a concept.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID PLANTUSAGE_ID no serial PK no Database assigned value to each unique record in the plantUsage table. Plant Name PLANTNAME_ID required Integer FK no This field is the foreign key into the plantName table. Usage Start usageStart no Date n/a no This is the date on which the party applied the name to the concept. Usage Stop usageStop no Date n/a no This is the date on which the party ceased to apply the name to the concept. Plant Name Status plantNameStatus no varchar (20) n/a closed This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined). Class System classSystem no varchar (50) n/a open This is the name of the classification system wherein the name is applied (e.g., EnglishCommon or Scientific). Plant Status PLANTSTATUS_ID no Integer FK no Plant Status which applies to this plantUsage.