KeyGroups
From Species File Help
(Difference between revisions)
(created page) |
(formatting) |
||
Line 1: | Line 1: | ||
'''tblKeyGroups''', group of one or more taxa that can be separated by using a key block (only one row in table per group) | '''tblKeyGroups''', group of one or more taxa that can be separated by using a key block (only one row in table per group) | ||
− | + | *KeyGroupID, integer, 4 bytes, identifier for group | |
− | + | *TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, identifier for taxon that group is based upon. | |
− | + | *CompCode, integer, 1 byte, component code: | |
− | + | **1 = group matches this taxon | |
− | + | **2 = group includes only the taxa enumerated in tblGroupTaxa (all subordinate to the taxon identified by TaxonNameID) | |
− | + | **3 = group includes all the taxa subordinate to the taxon identified by TaxonNameID except those listed tblGroupTaxa. | |
− | + | *OtherInfo, string, 200 characters, qualifying information for the group (may be null string) | |
− | + | *AccessCode, integer, 4 bytes | |
− | + | *ImpairedFlags, integer, 4 bytes interpreted bitwise, reasons for impairment (taxonomist review needed to check if revision of related key blocks is needed). Bit values: | |
− | + | **Flags under editor control | |
− | + | ***1 = An editor marked it as under development. | |
− | + | ***2 = An editor marked it as needing more work. | |
− | + | ***4 = A new member was added to the group. | |
− | + | ***8 = A member was removed from the group. | |
− | + | **Flags under program control | |
− | + | ***16 = Encompassing taxon is at higher rank than necessary. | |
− | + | ***32 = Component is not subordinate to encompassing member. | |
− | + | ***64 = A listed taxon is not a valid or temporary name. | |
− | + | ***128 = Count of components is inconsistent with CompCode. | |
− | + | ***256 = There is no taxon left in group after the list of exclusions. | |
− | + | ***512 = Included component list matches content of encompassing taxon. | |
− | + | ***1024 = A listed component is the same as or subordinate to another listed component. | |
− | + | *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:53, 5 September 2012
tblKeyGroups, group of one or more taxa that can be separated by using a key block (only one row in table per group)
- KeyGroupID, integer, 4 bytes, identifier for group
- TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, identifier for taxon that group is based upon.
- CompCode, integer, 1 byte, component code:
- 1 = group matches this taxon
- 2 = group includes only the taxa enumerated in tblGroupTaxa (all subordinate to the taxon identified by TaxonNameID)
- 3 = group includes all the taxa subordinate to the taxon identified by TaxonNameID except those listed tblGroupTaxa.
- OtherInfo, string, 200 characters, qualifying information for the group (may be null string)
- AccessCode, integer, 4 bytes
- ImpairedFlags, integer, 4 bytes interpreted bitwise, reasons for impairment (taxonomist review needed to check if revision of related key blocks is needed). Bit values:
- Flags under editor control
- 1 = An editor marked it as under development.
- 2 = An editor marked it as needing more work.
- 4 = A new member was added to the group.
- 8 = A member was removed from the group.
- Flags under program control
- 16 = Encompassing taxon is at higher rank than necessary.
- 32 = Component is not subordinate to encompassing member.
- 64 = A listed taxon is not a valid or temporary name.
- 128 = Count of components is inconsistent with CompCode.
- 256 = There is no taxon left in group after the list of exclusions.
- 512 = Included component list matches content of encompassing taxon.
- 1024 = A listed component is the same as or subordinate to another listed component.
- Flags under editor control
- 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