BranchCharStates
From Species File Help
(Difference between revisions)
(created page) |
(cat) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
'''tblBranchCharStates''', linking table for block to match branch with character state. This is used for matrix blocks, but not for dichotomous blocks. | '''tblBranchCharStates''', linking table for block to match branch with character state. This is used for matrix blocks, but not for dichotomous blocks. | ||
| − | + | *KeyBlockID, integer, 2 bytes, = tblKeyBlocks.KeyBlockID | |
| − | + | *CharIndex, integer, 2 bytes, = tblBlockCharStates.CharIndex | |
| − | + | *CharStateIndex, 2 bytes, = tblBlockCharStates.CharStateIndex | |
| − | + | *BranchIndex, integer, 1 byte, = tblKeyBlockBranches.BranchIndex; KeyBlockID, CharIndex, CharStateIndex and BranchIndex form a composite primary key | |
| − | + | *Code, integer, 1 byte, relationship of character state to branch | |
| − | + | **0 = not specified | |
| − | + | **1 = state in branch unknown; if a branch has this setting for one state, it must have this for all states of that character | |
| − | + | **2 = not applicable to this branch; if a branch has this setting for one state, it must have this for all states of that character | |
| − | + | **3 = state never found in branch; if all but one state for a character have this setting, then the remaining state for the branch must be 6 | |
| − | + | **4 = state found only rarely in branch | |
| − | + | **5 = states found commonly in branch | |
| − | + | **6 = sole state found in branch; if a branch has this setting for one state, all other states for that character must be 3 | |
| − | + | *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]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 16:42, 8 September 2012
tblBranchCharStates, linking table for block to match branch with character state. This is used for matrix blocks, but not for dichotomous blocks.
- KeyBlockID, integer, 2 bytes, = tblKeyBlocks.KeyBlockID
- CharIndex, integer, 2 bytes, = tblBlockCharStates.CharIndex
- CharStateIndex, 2 bytes, = tblBlockCharStates.CharStateIndex
- BranchIndex, integer, 1 byte, = tblKeyBlockBranches.BranchIndex; KeyBlockID, CharIndex, CharStateIndex and BranchIndex form a composite primary key
- Code, integer, 1 byte, relationship of character state to branch
- 0 = not specified
- 1 = state in branch unknown; if a branch has this setting for one state, it must have this for all states of that character
- 2 = not applicable to this branch; if a branch has this setting for one state, it must have this for all states of that character
- 3 = state never found in branch; if all but one state for a character have this setting, then the remaining state for the branch must be 6
- 4 = state found only rarely in branch
- 5 = states found commonly in branch
- 6 = sole state found in branch; if a branch has this setting for one state, all other states for that character must be 3
- 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
