KeyBlockBranches

From Species File Help
Revision as of 11:26, 30 August 2012 by Maehr (Talk | contribs)

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

tblKeyBlockBranches, subordinate to tblKeyBlocks, list giving group selected for each branch

   KeyBlockID, integer, 4 bytes, = tblKeyBlocks.KeyBlockID
   BranchIndex, integer, 1 byte; KeyBlockID and BranchIndex form a composite primary key.  BranchIndex is zero based.  Values range from 0 to 126.  Value of 127 is reserved for swapping the indices of two branches.
   KeyGroupID, integer, 4 bytes, = tblKeyGroups.KeyGroupID, the destination group if this branch is selected
   LastUpdate, smalldatetime, date and time row last updated
   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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox