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

detailplantusagedba_tabledescriptionwhere_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. Plant Concept PLANTCONCEPT_ID no Integer FK no This field is the foreign key into the plantConcept 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). Plant Name plantName no varchar (220) denorm no This is the plant name that the party uses for this plant concept, in the name system indicated in classSystem. 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). Party PARTY_ID no Integer FK no Foreign key that identifies the party that uses the concept with the name. Plant Status PLANTSTATUS_ID no Integer FK no Plant Status which applies to this plantUsage.