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

21010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	commCorrelation
Table	Community Correlation
Field	Correlation Stop
DB Field Name	correlationStop
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This is the stop date for recognition by a party of a correlation between two concepts.

 

Table (DB Name)	commLineage
Table	Community Lineage
Field	ID
DB Field Name	COMMLINEAGE_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the commLineage table.

 

Table (DB Name)	commLineage
Table	Community Lineage
Field	Parent Community Status
DB Field Name	parentCommStatus_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commStatus.COMMSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the commStatus table "pointing" to a parent concept.

 

Table (DB Name)	commLineage
Table	Community Lineage
Field	Child Community Status
DB Field Name	childCommStatus_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commStatus.COMMSTATUS_ID
List?	no
Notes	n/a
Definition	This is the foreign key into the commStatus table "pointing" to a child concept.

 

Table (DB Name)	commName
Table	Community Name
Field	ID
DB Field Name	COMMNAME_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the commName table.

 

Table (DB Name)	commName
Table	Community Name
Field	Community Name
DB Field Name	commName
Req'd?	required
Data Type	text
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The community name.

 

Table (DB Name)	commName
Table	Community Name
Field	Reference
DB Field Name	reference_ID
Req'd?	no
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	Foreign key into reference to identify the source of the name.

 

Table (DB Name)	commName
Table	Community Name
Field	Date Entered
DB Field Name	dateEntered
Req'd?	no
Data Type	Date
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Field stores the date that the name was entered into the database.

 

Table (DB Name)	commStatus
Table	Community Status
Field	ID
DB Field Name	COMMSTATUS_ID
Req'd?	no
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Database assigned value to each unique record in the commStatus table.

 

Table (DB Name)	commStatus
Table	Community Status
Field	Community Concept
DB Field Name	COMMCONCEPT_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	commConcept.COMMCONCEPT_ID
List?	no
Notes	n/a
Definition	Foreign key to identify the concept to which a party assigns a status