CharStateDetails
From Species File Help
(Difference between revisions)
(created page) |
(formatting) |
||
Line 1: | Line 1: | ||
'''tblCharStateDetails''', subordinate to tblKeyCharStates, display details for character states (allows for multiple display components for a single character state) | '''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 | |
[[Category:KeyTables]] | [[Category:KeyTables]] |
Revision as of 09:42, 5 September 2012
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