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_tabledescriptioncommusagewhere_tablenamecommusage

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	commUsage
Table	Community Usage
Notes	This table links a community name with a concept.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMUSAGE_ID no serial PK no Database assigned value to each unique record in the communityUsage table. Community Name COMMNAME_ID required Integer FK no This field is the foreign key into the commName 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. Community Name Status commNameStatus 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., Scientific, Spanish common). Comm Status COMMSTATUS_ID no Integer FK no Comm Status which applies to this commUsage.