Project

General

Profile

CTFS

ERD

Note that the ERD is for a past version of the CTFS database

Tables

45 total

34 with data:

  • Census
  • CensusQuadrat
  • Country
  • CurrentObsolete
  • DataCollection
  • DFtemp
  • Family
  • Genus
  • LogMAttrHistory
  • LogMAttrHistoryd
  • LogMeasurementHistory
  • LogMeasurementHistoryd
  • LogSpeciesInventory
  • LogTreeHistory
  • LogTreeHistoryd
  • Measurement
  • MeasurementAttributes
  • Personnel
  • Quadrat
  • Reference
  • RemeasAttribs
  • Remeasurement
  • RoleReference
  • Site
  • Species
  • SpeciesInventory
  • Stem
  • SubSpecies
  • TAX1temp
  • TAX2temp
  • TAX3temp
  • Tree
  • TreeTaxChange
  • TSMAttributes

11 empty:

  • DataEntry
  • LogTreeAttrHistory
  • ReviewChange
  • ReviewNewSpecies
  • Specimen
  • SqlLog
  • StageSource
  • StageTarget
  • StageTargetNew
  • StageTaxonomicChanges
  • TreeAttributes

Columns

See *CTFS data dictionary*