MatchingIDs
From Species File Help
(Difference between revisions)
(formatting, cat) |
|||
| Line 1: | Line 1: | ||
| − | ''' | + | '''tblMatchingIDs''', related ID values in the same table |
| − | * | + | *TableID, integer, 4 bytes = tblTables.TableID |
| − | * | + | *ID1, integer, 4 bytes |
| + | *ID2, integer, 4 bytes | ||
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship | *IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship | ||
*Status, integer, 1 byte, explained in tblIDrelationships. | *Status, integer, 1 byte, explained in tblIDrelationships. | ||
Revision as of 17:53, 9 February 2013
tblMatchingIDs, related ID values in the same table
- TableID, integer, 4 bytes = tblTables.TableID
- ID1, integer, 4 bytes
- ID2, integer, 4 bytes
- IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
- Status, integer, 1 byte, explained in tblIDrelationships.
- LastUpdate, smalldatetime, date and time row last updateddd
- 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
