MatchingIDs
From Species File Help
(Difference between revisions)
(new page name to reflect actual changes in the database as per MB) |
|||
| Line 2: | Line 2: | ||
*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 | ||
| + | *ID2, integer, 4 bytes. The first four columns constitute the primary key. | ||
*Status, integer, 1 byte, explained in tblIDrelationships. | *Status, integer, 1 byte, explained in tblIDrelationships. | ||
| − | *LastUpdate, smalldatetime, date and time row last | + | *LastUpdate, smalldatetime, date and time row last updated |
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | ||
*CreatedOn, smalldatetime, date and time row was created | *CreatedOn, smalldatetime, date and time row was created | ||
Revision as of 16:20, 24 February 2013
tblMatchingIDs, related ID values in the same table.
- TableID, integer, 4 bytes = tblTables.TableID
- IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
- ID1, integer, 4 bytes
- ID2, integer, 4 bytes. The first four columns constitute the primary key.
- 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
