Active |
Defines if the row contains active data. Inactive means logically deleted. |
ChangedBy |
The ID of the user who last edited this data. FK to HH.Users |
ChangedOn |
The datetime this data was last edited |
ChildAddressBookId |
The child AddressBookEntry in the relationship. FK to HH.AddressBookEntry |
CreatedBy |
The ID of the user who first created this data. FK to HH.Users |
CreatedOn |
The datetime this data was first created |
ParentAddressBookId |
The ID of the top level Contact of this relationship. FK to HH.AddressBookEntry |
RelationshipRoleId |
The ID of the relationship role |
Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |