Files

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(bullets)
(marked six columns as not in active use)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
 
'''tblFiles''' contains data about the status of various species files, a single table in SFSdb.
 
'''tblFiles''' contains data about the status of various species files, a single table in SFSdb.
  
*FileID, integer, 2 bytes, identifier for the file
+
* FileID, integer, 2 bytes, identifier for the file
*ServerName, text, 15 bytes maximum, name of the server that contains the database
+
* ServerName, text, 15 bytes maximum, name of the server that contains the database
*DatabaseName, text, 30 bytes maximum, name of the database file
+
* DatabaseName, text, 30 bytes maximum, name of the database file
*FileTypeID, integer, 1 byte, = tblFileTypes.FileTypeID, type of database file
+
* [[FileTypes|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
+
* 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
+
* [[Files|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
+
* Description, text, 1000 bytes maximum, description as found in tblConstants of the database
*DateStarted, text, 20 bytes maximum
+
* DateStarted, text, 20 bytes maximum
*NumSpecies, integer, 4 bytes, number of valid species
+
* NumSpecies, integer, 4 bytes, number of valid species, not in active use
*NumNames, integer, 4 bytes, total number of names
+
* NumNames, integer, 4 bytes, total number of names, not in active use
*NumCites, integer, 4 bytes, number of citations
+
* NumCites, integer, 4 bytes, number of citations, not in active use
*NumImages, integer, 4 bytes, number of images
+
* NumImages, integer, 4 bytes, number of images, not in active use
*NumSpecimens, integer, 4 bytes, number of specimen records
+
* NumSpecimens, integer, 4 bytes, number of specimen records, not in active use
*NumKeyEndPoints, integer, 4 bytes, number of end points in keys
+
* NumKeyEndPoints, integer, 4 bytes, number of end points in keys, not in active use
*FileVersion, text, 20 bytes maximum, version for the file specific portion
+
* FileVersion, text, 20 bytes maximum, version for the file specific portion
*CommonVersion, integer, 2 bytes, major version number for the shared common code
+
* CommonVersion, integer, 2 bytes, major version number for the shared common code
*ServicePack, integer, 2 bytes, service pack number applied to the 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
+
* Flags, integer, 2 bytes, used to manage which files use features under development
  
 
[[Category:AdminTables]]
 
[[Category:AdminTables]]
 +
[[Category:Tables]]

Latest revision as of 17:30, 8 March 2013

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, not in active use
  • NumNames, integer, 4 bytes, total number of names, not in active use
  • NumCites, integer, 4 bytes, number of citations, not in active use
  • NumImages, integer, 4 bytes, number of images, not in active use
  • NumSpecimens, integer, 4 bytes, number of specimen records, not in active use
  • NumKeyEndPoints, integer, 4 bytes, number of end points in keys, not in active use
  • 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