CharStateDetails

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

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

tblCharStateDetails, subordinate to tblKeyCharStates, display details for character states (allows for multiple display components for a single character state)

   KeyCharID, integer, 4 bytes, = tblKeyChars.KeyCharID
   KeyCharStateID, integer, 4 bytes, = tblKeyCharStates.KeyCharStateID
   SeqNum, integer, 1 byte, 1-based sequence number for display components.  CharID, CharStateID and SeqNum form a composite primary key
   Type, integer, 2 bytes
       1 = text
       2 = image
       3 = sound
       4 = list of image coordinates (not yet implemented)
   Text, 1500 characters maximum
   ImageID, integer, 4 bytes, = tblImages.ImageID
   SoundID, integer, 4 bytes, = tblSounds.SoundID
   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