MatchingIDs

Revision as of 10:27, 15 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