VegBank

submodule,TableName,FieldName,LeeTake,Nulls,key,dataType,FieldSize,References,ClosedList,FieldNotes,FieldDefinition

commtaxa,commConcept,COMMNAME_ID,Reqd,No,FK,Long Integer,,commName.COMMNAME_ID,no,na,Foreign key into the commName table providing the name used for the community when it was defined by usage in a publication (which could be this database).

commtaxa,commCorrelation,COMMCONCEPT_ID,Reqd,NO,FK,Long Integer,,commConcept.COMMCONCEPT_ID,no,n/a,"This is the foreign key into the communityConcept table ""pointing"" to a concept recognized by the party as a ""standard"" concept."

commtaxa,commCorrelation,commConvergence,Reqd,NO,n/a,text,20,n/a,yes,n/a,This is the descriptive attribute that is used to relate the congruence between two concepts.

commtaxa,commCorrelation,COMMSTATUS_ID,Reqd,NO,FK,Long Integer,,commStatus.COMMSTATUS_ID,no,n/a,"This is the foreign key into the CommStatus table ""pointing"" to a concept no longer viewed as standard by the party. "

commtaxa,commCorrelation,correlationStart,Reqd,NO,n/a,date/time,,n/a,no,n/a,This is the start date for recognition by a party of a correlation between two concepts.

commtaxa,commLineage,COMMSTATUS1_ID,Reqd,No,FK,Long Integer,,commStatus.COMMSTATUS_ID,no,n/a,"This is the foreign key into the commStatus table 

""pointing"" to a parent concept."

commtaxa,commLineage,COMMSTATUS2_ID,Reqd,No,FK,Long Integer,,commStatus.COMMSTATUS_ID,no,n/a,"This is the foreign key into the commStatus table 

""pointing"" to a child concept."

commtaxa,commName,commName,Reqd,No,n/a,text,500,n/a,no,n/a,The community name.

commtaxa,commStatus,COMMCONCEPT_ID,Reqd,No,FK,Long Integer,,commConcept.COMMCONCEPT_ID,no,n/a,Foreign key to identify the concept to which a party assigns a status

commtaxa,commStatus,commConceptStatus,Reqd,No,n/a,text,20,n/a,yes,closed list,"Status of the concept by the party (accepted, not accepted, undetermined)"

commtaxa,commStatus,COMMPARTY_ID,Reqd,No,FK,Long Integer,,commParty.COMMPARTY_ID,no,n/a,Foreign key that identifies the party that made the status assignment

commtaxa,commStatus,startDate,Reqd,No,n/a,date/time,,n/a,no,n/a,This is the date for which the status assignment by the party started.

commtaxa,commUsage,COMMCONCEPT_ID,Reqd,No,FK,Long Integer,,commConcept.COMMCONCEPT_ID,no,n/a,This field is the foreign key into the commConcept table.

commtaxa,commUsage,COMMNAME_ID,Reqd,No,FK,Long Integer,,commName.COMMNAME_ID,no,n/a,This field is the foreign key into the commName table.

commtaxa,commUsage,commNameStatus,Reqd,No,n/a,text,20,n/a,yes,closed list,"This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined)."

commtaxa,commUsage,COMMPARTY_ID,Reqd,No,FK,Long Integer,,commParty.COMMPARTY_ID,no,n/a,Foreign key that identifies the party that used the class concept with the name.

commtaxa,commUsage,usageStart,Reqd,No,n/a,date/time,,n/a,no,n/a,This is the date on which the party applied the name to the concept.

planttaxa,plantConcept,PLANTNAME_ID,Reqd,No,FK,Long Integer,,plantName.PLANTNAME_ID,no,n/a,"This is a foreign key into the plant name list, the entery in which when combined wiht a reference constitutes a concept."

planttaxa,plantConcept,PLANTREFERENCE_ID,Reqd,No,FK,Long Integer,,plantReference.PLANTREFERENCE_ID,no,n/a,"This is a foreign key to the reference in which the name was used, thereby defining a concept."

planttaxa,plantCorrelation,correlationStart,Reqd,No,n/a,date/time,,n/a,no,n/a,This is the start date for recognition by a party of a correlation between two concepts.

planttaxa,plantCorrelation,PLANTCONCEPT_ID,Reqd,No,FK,Long Integer,,plantConcept.PLANTCONCEPT_ID,no,n/a,"This is the foreign key into the plantConcept table ""pointing"" to a concept recognized by the party as a ""standard"" concept."

planttaxa,plantCorrelation,plantConvergence,Reqd,No,n/a,text,20,n/a,yes,closed list,This is the descriptive attribute that is used to relate the congruence between two concepts.

planttaxa,plantCorrelation,PLANTSTATUS_ID,Reqd,No,FK,Long Integer,,plantStatus.PLANTSTATUS_ID,no,n/a,"This is the foreign key into the plantStatus table ""pointing"" to a concept no longer viewed as standard by the party."

planttaxa,plantLineage,PLANTSTATUS1_ID,Reqd,NO,FK,Long Integer,,plantStatus.PLANTSTATUS_ID,no,n/a,"This is the foreign key into the plantStatus table 

""pointing"" to a child concept."

planttaxa,plantLineage,PLANTSTATUS2_ID,Reqd,NO,FK,Long Integer,,plantStatus.PLANTSTATUS_ID,no,n/a,"This is the foreign key into the plantStatus table 

""pointing"" to a parent concept."

planttaxa,plantName,plantName,Reqd,No,n/a,text,255,n/a,no,n/a,The plant name.

planttaxa,plantStatus,PLANTCONCEPT_ID,Reqd,No,FK,Long Integer,,plantConcept.PLANTCONCEPT_ID,no,n/a,Foreign key to identify the concept to which a party assigns a status

planttaxa,plantStatus,plantConceptStatus,Reqd,No,n/a,text,20,n/a,yes,closed list,"Status of the concept by the party (accepted, not accepted, undetermined)"

planttaxa,plantStatus,PLANTPARTY_ID,Reqd,No,FK,Long Integer,,plantParty.PLANTPARTY_ID,no,n/a,Foreign key that identifies the party that made the status assignment

planttaxa,plantStatus,startDate,Reqd,No,n/a,date/time,,n/a,no,n/a,This is the date for which the status assignment by the party started.

planttaxa,plantUsage,PLANTCONCEPT_ID,Reqd,No,FK,Long Integer,,plantConcept.PLANTCONCEPT_ID,no,n/a,This field is the foreign key into the plantConcept table.

planttaxa,plantUsage,PLANTNAME_ID,Reqd,No,FK,Long Integer,,plantName.PLANTNAME_ID,no,n/a,This field is the foreign key into the plantName table.

planttaxa,plantUsage,plantNameStatus,Reqd,No,n/a,text,20,n/a,yes,n/a,"This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined)."

planttaxa,plantUsage,PLANTPARTY_ID,Reqd,No,FK,Long Integer,,plantParty.PLANTPARTY_ID,no,n/a,Foreign key that identifies  the party that uses the concept with the name.

planttaxa,plantUsage,usageStart,Reqd,No,n/a,date/time,,n/a,no,n/a,This is the date on which the party applied the name to the concept.

vegplot,address,PARTY_ID,Reqd,No ,FK ,Long Integer,,party.PARTY_ID ,no,Foreign key into the party table. ,Link to the party to which this address applies

vegplot,aux_Role,roleCode,Reqd,No,n/a,text,30,n/a,no,n/a,constraining list of role codes for *Contributor tables

vegplot,classContributor,COMMCLASS_ID,Reqd,No ,FK ,Long Integer,,commClass.COMMCLASS_ID,no,Foreign key into the commClass table.,Observation classification event to which the contributor is associated.   

vegplot,classContributor,PARTY_ID,Reqd,No ,FK ,Long Integer,,party.PARTY_ID ,no,Foreign key into the party table.,Link to the party that contributed to the classification event.

vegplot,commClass,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the observation table,Link to the observation table identifying which observation is being classified.

vegplot,commInterpretation,COMMCLASS_ID,Reqd,No ,FK,Long Integer,,commClass.COMMCLASS_ID,no,Foreign key into the commClassification table.,Link to the commClassification table identifying the specific classification event.

vegplot,commInterpretation,COMMCONCEPT_ID,Reqd,No ,FK,Long Integer,,commConcept.COMMCONCEPT_ID,no,Foreign key into the commConcept table.,Link to the communityConcept table identifying the specific community concept being applied.

vegplot,coverIndex,coverCode,Reqd,No ,n/a ,text,10,n/a ,no,n/a ,The name or label used in the coverclass scale for this specific specific coverclass.

vegplot,coverIndex,COVERMETHOD_ID,Reqd,No,FK ,Long Integer,,coverMethod.COVERMETHOD_ID,no,Foreign key into the coverMethod table.,Links to a specific cover scale. 

vegplot,coverIndex,coverPercent,Reqd,No,n/a,Double,8,n/a,no,n/a,A middle value (usually mean or geometric mean) between the upperLimit and lowerLimt stored by the database for each taxon observation and used for all coverclass conversions and interpretations.  This is assigned by the author of the cover class schema.

vegplot,coverMethod,coverType,Reqd,No ,n/a ,text,30,n/a ,no,n/a,"Name of the coverclass method (e.g., Braun-Blanquet, Barkman, Domin, Daubenmire, Carolina Vegetation Survey, etc.)."

vegplot,definedValue,tableRecord_ID,Reqd,No,n/a,Long Integer,,n/a ,no,Pseudokey for the table with which this value should be associated ,The numeric value of the record number (primary key) that this user-defined value would have if it were in the table identified by USERDEFINED_ID.

vegplot,definedValue,USERDEFINED_ID,Reqd,No,FK,Long Integer,,userDefined.USERDEFINED_ID,no,n/a,Link to a specific user-defined variable defined in the userDefined table.

vegplot,definedValue,value,Reqd,No,n/a,text,255,n/a,no,n/a ,The value of the user-defined variable.

vegplot,disturbanceObs,disturbanceType,Reqd,No,n/a,text,30,n/a,yes,closed list,The type of disturbance being reported

vegplot,disturbanceObs,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key that points to the parent observation for this disturbance record,Link to the observation event with which this report of a disturbance event is associated.

vegplot,graphic,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the observation table.,Link from a graphic file to a specific plot observation.

vegplot,namedPlace,placeName,Reqd,No,n/a ,text,100,n/a ,yes,"open or closed list, depending on the system","The name of a place in or at which a plot is located. The system ""placenames"" is an open list defined within this table.  The other systems are generally closed lists constrained by aux_tables.  These include at least USGSQuad, Continent, Country, State, "

vegplot,note,NOTELINK_ID,Reqd,No,FK,Long Integer,,noteLink.NOTELINK_ID,no,Foreign key into the notelink table,"Link to the noteLink table via which a note is associated with a table, record and attribute."

vegplot,note,noteText,Reqd,No,n/a,Memo,,n/a,no,actual note text,The text of the note.

vegplot,note,noteType,Reqd,No,n/a ,text,20,n/a ,yes,closed list,"The type of note:  Database Management, Observation Author, Database User and Internal.  ""Database Managment"" notes are those added by the management team and may be queried and viewed by the public. ""Database Use"" notes are those entered by the users of "

vegplot,note,PARTY_ID,Reqd,No,FK,Long Integer,,party.PARTY_ID,no,Foreign key into the party table,Link to the party table to identify the party that contributed the note.

vegplot,note,ROLE_ID,Reqd,No,FK,Long Integer,,aux_Role.ROLE_ID,no,Foreign key into the aux_role table,What role was the party palying when the note was applied?

vegplot,noteLink,attributeName,Reqd,No,n/a,text,50,n/a,no,n/a,Name of the attribute in the table (stored in tableName) that the note is associated with.  

vegplot,noteLink,tableName,Reqd,No,n/a ,text,50,n/a ,no,n/a,Name of the table that the note is associated with. 

vegplot,noteLink,tableRecord,Reqd,No,n/a,Long Integer,,n/a,no,n/a,The record number (row) containing the value with which the note is associated (which translates to the primary key value for the table wherein the record is stored).

vegplot,observation,autoTaxonCover,what if no cover?,No,n/a,yes/no,,n/a,no,default = FALSE,TRUE indicates that taxonObservation.taxonCover was automatically calculated from the values of all stratumObservation.taxonStratumCover

vegplot,observation,coverDispersion,what if no cover?,No,n/a,text,30,n/a,yes,closed list; default = contiguous,"Were cover values for the total taxon list collected from one contiguous area or dispersed subplots (e.g., continguous, dispersed-regular, dispered-random)?"

vegplot,observation,COVERMETHOD_ID,what if no cover?,No ,FK,Long Integer,,coverMethod.COVERMETHOD_ID,no,Foreign key into the coverMethod table.,"Link to the scale used to estimate taxon cover. The database stores estimated cover to the nearest percent, but the conversion details are recovered by reference to the specific scale employed."

vegplot,observation,PLOT_ID,Reqd,No,FK,Long Integer,,plot.PLOT_ID,no,Foreign key into the plot table. ,Link to data and metadata that do not change between observations and which are stored in the plot table.

vegplot,observation,STRATUMMETHOD_ID,what if no strata?,No,FK,Long Integer,,stratumMethod.STRATUMMETHOD_ID,no,Foreign key into the stratumMethod table,Link to the definitions of strata used in recording taxon-specific values of cover.

vegplot,observation,taxonObservationArea,what if plotless?,No,n/a,Double,8,n/a,no,default = plot.area,"the total surface area (in m2) used for cover estimates and for which a complete species list is provided.  If subplots were used, this would be the total area of the subplots without intersticial space."

vegplot,observationContributor,OBSERVATION_ID,Reqd,No ,FK,Long Integer,,Observation.OBSERVATION_ID,no,This is tforeign key into the Observation table. ,Foreign key pointing to a given plot observation event to which the contribution was made.

vegplot,observationContributor,PARTY_ID,Reqd,No ,FK ,Long Integer,,party.PARTY_ID ,no,This is the foreign key into the party table.,Foreign key pointing to the specific party that made the contribution.

vegplot,observationContributor,ROLE_ID,Reqd,No ,FK,Long Integer,,aux_Role.ROLE_ID,no,This is the foreign key into the aux_Role table,"Foreign key that identifies the role that the party had in the plot obsevation (e.g.,  PI, contact, research advisor, field assistant, taxonomist, owner, guide, etc.).  "

vegplot,observationSynonym,classStartDate,ok,No,n/a,date/time,,n/a,no,n/a ,Start date for the synonymization event.

vegplot,observationSynonym,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the observation table,Link to the observation table identifying which observation is being reduced to synonymy.

vegplot,observationSynonym,PARTY_ID,Reqd,No ,FK ,Long Integer,,party.PARTY_ID ,no,This is the foreign key into the party table.,Foreign key pointing to the specific party that made the reduction to synonym.

vegplot,observationSynonym,PRIMARYOBS_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the observation table,Link to the observation table identifying which observation is the prefered synonym for the observation being reduced to synonym.

vegplot,observationSynonym,ROLE_ID,Reqd,No ,FK,Long Integer,,aux_Role.ROLE_ID,no,This is the foreign key into the aux_Role table,"Foreign key that identifies the role that the party had in the plot synonomization (e.g., plot author, data manager, publication author, researcher, generic user, etc.).  "

vegplot,party,owner,ok,No,FK,Long Integer,,party.PARTY_ID,no,n/a,Recursive foreign key to the Party who owns this party record and who has exclusive rights to update the information content.

vegplot,place,NAMEDPLACE_ID,Reqd,No,FK,Long Integer,,namedPlace.NAMEDPLACE_ID ,no,Foreign key into the namedPlace table,Link to a specific named place or region

vegplot,place,PLOT_ID,Reqd,No,FK,Long Integer,,plot.PLOT_ID  ,no,Foreign key into the plot table.,Link to a specific plot.

vegplot,plot,area,what if plotless?,No ,n/a,Double,8,n/a,no,n/a,"Total area of the plot in m2.  If many subplots, this area includes the subplots and the intersticial space

		"

vegplot,plot,authorPlotCode,Reqd,No,n/a ,text,30,n/a ,no,n/a,"Author's Plot number/code, or the original plot number if taken from literature. "

vegplot,plot,confidentialityReason,what if public?,No,n/a,text,200,n/a,no,n/a,"The reason for confidentiality.  This field should not be open to public view.  Reasons might include specific rare species, ownership, prepublication embargo, or many other reason"

vegplot,plot,confidentialityStatus,ok,No,n/a,Long Integer,,n/a,yes,"closed list, default=0","Are the data to be considered confidential? 0=no, 1= 1km radius, 2=10km radius, 3=100km radius, 4=location embargo, 5=public embargo on all plot data, 6=full embargo on all plot data. This applies also to region. "

vegplot,plot,Latitude,ok,No,n/a ,Double,8,n/a ,no,n/a,"Latitude of the plot origin in degrees and decimals, datum =WGS84, fuzzing applied "

vegplot,plot,Longitude,ok,No,n/a,Double,8,n/a,no,n/a,"Longitude of the plot origin in degrees and decimals, datum = WGS84, fuzzing applied"

vegplot,plot,realLatitude,ok,No ,n/a ,Double,8,n/a ,no,n/a,"Latitude of the plot origin in degrees and decimals, datum =WGS84 "

vegplot,plot,realLongitude,ok,No,n/a,Double,8,n/a,no,n/a,"Longitude of the plot origin in degrees and decimals, datum = WGS84"

vegplot,project,projectName,Reqd,No ,n/a,text,150,n/a,no,n/a,Project name as defined by the principal investigator.

vegplot,projectContributor,PARTY_ID,Reqd,No ,FK ,Long Integer,,party.PARTY_ID ,no,Foreign key into the party table,Foreign key linking the contribution to a specific party.

vegplot,projectContributor,PROJECT_ID,Reqd,No ,FK ,Long Integer,,project.PROJECT_ID,no,Foreign key into the project table,Foreign key linking the contribution to a specific project.

vegplot,projectContributor,ROLE_ID,Reqd,No ,FK,Long Integer,,aux_Role.ROLE_ID,no,Foreign key into aux_Role table,"Foreign key that identifies the role that a specific party played in the project (e.g.,  PI, coPI, contact, author, research advisor, etc.)."

vegplot,revision,previousValueText,Reqd,No,n/a ,text,500,n/a ,no,n/a ,The previous value as a character string.

vegplot,revision,previousValueType,Reqd,No,n/a,text,20,n/a ,no,n/a ,The data type of the attribute changed.

vegplot,revision,revisionDate,Reqd,No,n/a,date/time,,n/a ,no,n/a ,The date on which the revision was made.

vegplot,revision,tableAttribute,Reqd,No,n/a ,text,50,n/a ,no,n/a ,The name of the attribute where the chance occurred. 

vegplot,revision,tableName,Reqd,No,n/a,text,50,n/a,no,n/a,Name of the table where the change occurred.

vegplot,revision,tableRecord,Reqd,No,n/a ,Long Integer,,n/a ,no,n/a ,"The number of the record in which the change occurred (i.e., the value of the primary key associated with the value in which the change occured)"

vegplot,soilObs,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key to parent plot,Link to the observation event to which this soil observation is associated.

vegplot,soilObs,soilHorizon,ok,No,n/a,text,15,n/a,yes,closed list - USDA,The horizon to which this observation applies.

vegplot,soilTaxon,soilLevel,ok,No,n/a,Long Integer,,n/a,no,n/a,"Hierarchical level; 1=Order, 2=Suborder, 3=GreatGroup, 4=SubGroup, 5=Family, 6=Series"

vegplot,soilTaxon,soilName,Reqd,No,n/a,text,100,n/a,no,n/a,Name of soil type

vegplot,stemCount,stemCount,ok,No,n/a ,Long Integer,,n/a ,no,"The default value is 1.  This field is not logically necessary, but allows for more compact entry and storage of tree stem tally data.",The number of stems of a single species that have these specific stem diameter and height data in common.

vegplot,stemCount,TAXONOBSERVATION_ID,Reqd,No,FK,Long Integer,,taxonObservation.TAXONOBSERVATION_ID,no,Foreign key into the taxonObservation table,"Foreign key into the taxonObservation table, thereby associating a taxon identification with the tree stem(s)."

vegplot,stemLocation,STEMCOUNT_ID,Reqd,No,FK,Long Integer,,stemCount.STEMCOUNT_ID,no,Foreign key into the stemSize table,"Foreign key into the stemSize table, thereby assigning a location to a particular stem of a specific size"

vegplot,stratum,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the observation table.,Link to the plot observation event with which this stratum observation is associated.

vegplot,stratum,STRATUMTYPE_ID,Reqd,No,FK,Long Integer,,stratumType.STRATUMTYPE_ID,no,Foreign key into the stratumType table.,This attribute will link to the definition of the specific stratum observed. 

vegplot,stratumComposition,STRATUM_ID,Reqd,No,FK,Long Integer,,stratum.STRATUM_ID,no,Foreign key into the stratum table.,"Link to the specific stratum in which the taxon occurs.  Because a single taxon may occur in more than one stratum, this attribute has a many to one relationship with a single taxon observation."

vegplot,stratumComposition,TAXONOBSERVATION_ID,Reqd,No,FK,Long Integer,,taxonObservation.TAXONOBSERVATION_ID,no,"Foreign key into the taxonObservation table, which identifies the taxon.",Link to the identification of the taxon being observed.

vegplot,stratumComposition,taxonStratumCover,ok,No,n/a,Double,8,n/a,no,n/a,Percent cover of taxon in stratum

vegplot,stratumMethod,stratumMethodName,ok,No ,n/a ,text,30,n/a ,no,n/a,"Name of the stratum method (e.g., Braun-Blanquet, TNC-ABI, NC Vegetation Survey #1, NC Vegetation Survey #2, etc.)"

vegplot,stratumType,stratumIndex,ok,No,n/a,text,10,n/a,no,n/a,Short code used to identify the stratum

vegplot,stratumType,STRATUMMETHOD_ID,Reqd,No,FK,Long Integer,,stratumMethod.STRATUMMETHOD_ID,no,Foreign key into the stratumMethod table.,This attribute will link to the stratum to the stratum methodology used. 

vegplot,taxonInterpretation,currentInterpretation,ok,No,n/a,yes/no,,n/a,no,n/a,This interpretation is the most accurate and precise interpretation currently available.

vegplot,taxonInterpretation,interpretationDate,ok,No ,n/a ,date/time,,n/a ,no,n/a ,The date that the interpretation was made. 

vegplot,taxonInterpretation,originalInterpretation,ok,No,n/a,yes/no,,n/a,no,n/a,"This interpretation corrsponds to the original interpretation of the plot author, as best as can be determined.  There is no requirement that the authority match the authority of the author; only that the concepts are synonymous."

vegplot,taxonInterpretation,PARTY_ID,Reqd,No,FK ,Long Integer,,party.PARTY_ID ,no,Foreign key into the party table. ,"Foreign key that identifies the party that made the interpretation, which could be the observation author. "

vegplot,taxonInterpretation,PLANTCONCEPT_ID,Reqd,No,FK,Long Integer,,plantConcept.PLANTCONCEPT_ID     ,no,Foreign key into the plantConcept table.,"Link to a taxon in the plantConcept table. The entry in the plantConcept table will in turn point to a reference and a name used in the reference, thereby defining the taxon concept.  The name that should be applied to the plantConcept will be party speci"

vegplot,taxonInterpretation,ROLE_ID,Reqd,No,FK,Long Integer,,aux_Role.ROLE_ID,no,Foreign key into aux_Role table,"Foreign key that identifies the role of the party making the interpretation (e.g.,  plot author, publication author, database manager, automated, plot contributor). "

vegplot,taxonInterpretation,TAXONOBSERVATION_ID,Reqd,No,FK,Long Integer,,taxonObservation.TAXONOBSERVATION_ID ,no,Foreign key into the taxonObservation table. ,Link  to a particular taxon observation.

vegplot,taxonObservation,OBSERVATION_ID,Reqd,No,FK,Long Integer,,observation.OBSERVATION_ID,no,Foreign key into the Observation table.,Link to the parent observation event of this taxon observation.

vegplot,taxonObservation,PLANTNAME_ID,Reqd,No,FK,Long Integer,,plantName.PLANTNAME_ID,no,Foreign key into plantName table. ,The taxon name that the author of the plot used to refer to a taxon observed within the plot. 

vegplot,taxonObservation,PLANTREFERENCE_ID,Reqd,No,FK,Long Integer,,plantReference.PLANTREFERENCE_ID,no,Foreign key into the plantReference table.,"The authority for the taxon that was used by the plot author.  If the authority is unknown  the author of the plot is the authority. For other than legacy data, this field plus plantName_ID will be sufficient to determine taxonInterpretation.plantConcept_"

vegplot,telephone,PARTY_ID,Reqd,No,FK ,Long Integer,,party.PARTY_ID,no,Foreign key into the party table,This is the 'link' between a PARTY and an entry in the TELEPHONE table.

vegplot,telephone,phoneNumber,ok,No,n/a,text,30,n/a,no,n/a,Telephone number.

vegplot,telephone,phoneType,ok,No,n/a,text,20,n/a,yes,closed list,"This is the type of telephone: home, work, fax, cell, secretary, other."

vegplot,userDefined,tableName,Reqd,No,n/a,text,50,n/a,no,n/a ,Name of table with which this user-defined variable is associated.  For example soilBHorizonColor may be defined by the data contributor as associated with the observation table.

vegplot,userDefined,userDefinedType,ok,No,n/a,text,20,n/a,no,n/a ,Database data type of the user-defined variable.