CharStateDetails

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