BlockCharStates

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

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

tblBlockCharStates, linking table to match block character (specific to block) with key character (pool of all characters)

   BlockID, integer, 2 bytes, = tblKeyBlocks.BlockID and tblKeyBlockChars.BlockID
   CharIndex, integer, 2 bytes, = tblKeyBlockChars.CharIndex
   CharStateIndex, integer, 2 bytes, 0-based index giving position of character state within character; BlockID, CharIndex and CharStateIndex form a composite primary key.  CharStateIndex is zero based.  Values range from 0 to 125.  Value of 126 is reserved for header information for the character.  Value of 127 is reserved for swapping the indices of two character states.
   KeyCharID, integer, 4 bytes, = tblKeyChars.KeyCharID and tblKeyCharStates.KeyCharID
   KeyCharStateID, integer, 4 bytes, = tblKeyCharStates.KeyCharStateID
   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