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_tabledescriptioncommcorrelationwhere_tablenamecommcorrelation

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	commCorrelation
Table	Community Correlation
Notes	This table correlates multiple community concepts as they change through time in the perception of a party
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID COMMCORRELATION_ID no serial PK no Database assigned value to each unique record in the communityCorrelation table. Community Status COMMSTATUS_ID required Integer FK no This is the foreign key into the CommStatus table "pointing" to a concept no longer viewed as standard by the party. Community Concept COMMCONCEPT_ID required Integer FK no This is the foreign key into the communityConcept table "pointing" to a concept recognized by the party as a "standard" concept. Community Convergence commConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two concepts. Correlation Start correlationStart required Date n/a no This is the start date for recognition by a party of a correlation between two concepts. Correlation Stop correlationStop no Date n/a no This is the stop date for recognition by a party of a correlation between two concepts.