Refs

Revision as of 10:13, 31 August 2012

tblRefs, references

   RefID, integer, 4 bytes, identifier for reference
   FileID, integer, 4 bytes, = tblFiles.FileID
   ContainingRefID, integer, 4 bytes, when the reference is included within a different reference, it is = tblReference.ID for the different reference.  When ContainingRefID > 0, ActualYear and StatedYear must = values for row where RefID = ContainingRefID, PubID must = 0, Volume must = "".  Title and RefPages may have values separate from the row where RefID = ContainingRefID.
   Title, text, 600 characters maximum, title of reference
   PubID, integer, 4 bytes, = tblPubs.PubID for publication containing the reference
   Series, text, 25 characters maximum, series number or other identification for a series
   Volume, text, 30 characters maximum, volume of the publication (older data often includes issue number in parentheses after the volume)
   Issue, 25 characters maximum, issue number or other identification within a volume.
   RefPages, text, 70 characters maximum, pages in the reference plus any plates, etc. that lack page numbers
   ActualYear, text, 10 bytes maximum
   StatedYear, text, 10 bytes maximum, null string except where different from ActualYear
   AccessCode, integer, 4 bytes
   Flags, integer, 2 bytes, internal use only:  local copy, loan copy, 0 = no copy of reference on site, 1 = have copy on site
   Note, text, 1024 characters maximum
   LinkID, integer, 4 bytes, = tblLinks.LinkID, represents the location of an electronic copy of the reference.
   CiteDataStatus, integer, 2 bytes, with bitwise flags indicating least status among the citations to this reference in tblCites.DataStatus:
       1 = concept flags recorded, may need review.
       2 = concept flags recorded, considered done (When this bit is on, the bit in the previous line is also on.)
       4 = nomen flags recorded, may need review.
       8 = nomen flags recorded, considered done (When this bit is on, the bit in the previous line is also on.)
       0x10 (16) = info flags recorded, may need review
       0x20 (32) = info flags recorded, considered done (When this bit is on, the bit in the previous line is also on.)
   Verbatim, text, 1000 character maximum, unparsed text from reference being imported, possible future use as cheat column to reduce execution time
   LastUpdate, smalldatetime, date and time of last update
   ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
   CreatedOn, smalldatetime, date and time row was created
   CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row