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

detailcommusagedba_tabledescriptionwhere_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. Community Name commName no text denorm no This is the community Name that the party uses for this community, of the type indicated in classSystem. Community Concept COMMCONCEPT_ID no Integer FK no This field is the foreign key into the commConcept 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). Party PARTY_ID no Integer FK no Foreign key that identifies the party that used the class concept with the name. Comm Status COMMSTATUS_ID no Integer FK no Comm Status which applies to this commUsage.