Files

From Species File Help
Revision as of 09:53, 31 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

tblFiles contains data about the status of various species files, a single table in SFSdb.

   FileID, integer, 2 bytes, identifier for the file
   ServerName, text, 15 bytes maximum, name of the server that contains the database
   DatabaseName, text, 30 bytes maximum, name of the database file
   FileTypeID, integer, 1 byte, = tblFileTypes.FileTypeID, type of database file
   WebsiteName, text, 30 bytes maximum, name of the website as used in the URL [WebsiteName].speciesfile.org
   AboveID, integer, 2 bytes, = FileID of the species file above it in the taxonomic hierarchy
   Description, text, 1000 bytes maximum, description as found in tblConstants of the database
   DateStarted, text, 20 bytes maximum
   NumSpecies, integer, 4 bytes, number of valid species
   NumNames, integer, 4 bytes, total number of names
   NumCites, integer, 4 bytes, number of citations
   NumImages, integer, 4 bytes, number of images
   NumSpecimens, integer, 4 bytes, number of specimen records
   NumKeyEndPoints, integer, 4 bytes, number of end points in keys
   FileVersion, text, 20 bytes maximum, version for the file specific portion
   CommonVersion, integer, 2 bytes, major version number for the shared common code
   ServicePack, integer, 2 bytes, service pack number applied to the common code
   Flags, integer, 2 bytes, used to manage which files use features under development
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox