MatchingIDs
From Species File Help
(Difference between revisions)
| Line 1: | Line 1: | ||
'''tblMatchingIDs''', related ID values in the same table. | '''tblMatchingIDs''', related ID values in the same table. | ||
| + | *The primary key is composed of TableID, IDrelationshipID, ID1 and ID2. | ||
*TableID, integer, 4 bytes = tblTables.TableID | *TableID, integer, 4 bytes = tblTables.TableID | ||
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship | *IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship | ||
*ID1, integer, 4 bytes | *ID1, integer, 4 bytes | ||
| − | *ID2, integer, 4 bytes | + | *ID1FileID, integer, 4bytes |
| + | *ID2, integer, 4 bytes | ||
| + | *ID2FileID, integer, 4bytes | ||
*Status, integer, 1 byte, explained in tblIDrelationships. | *Status, integer, 1 byte, explained in tblIDrelationships. | ||
*LastUpdate, smalldatetime, date and time row last updated | *LastUpdate, smalldatetime, date and time row last updated | ||
Revision as of 11:52, 18 October 2013
tblMatchingIDs, related ID values in the same table.
- The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.
- TableID, integer, 4 bytes = tblTables.TableID
- IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
- ID1, integer, 4 bytes
- ID1FileID, integer, 4bytes
- ID2, integer, 4 bytes
- ID2FileID, integer, 4bytes
- Status, integer, 1 byte, explained in tblIDrelationships.
- 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
