MatchingIDs
From Species File Help
(Difference between revisions)
m (Maehr moved page MatchingTaxonNameIDs to MatchingIDs) |
(new page name to reflect actual changes in the database as per MB) |
||
Line 1: | Line 1: | ||
− | '''tblMatchingIDs''', related ID values in the same table | + | '''tblMatchingIDs''', related ID values in the same table. |
*TableID, integer, 4 bytes = tblTables.TableID | *TableID, integer, 4 bytes = tblTables.TableID |
Revision as of 10:34, 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