| TTVisitationRegistrationContactHistoryID |
primary key |
| TTVisitationRegistrationContactID |
foreign key |
| Created |
a creation date |
| DisplayOrder |
a datetime field for ordering |
| StartDate |
First valid date |
| EndDate |
Last valid date. If contact doesnt have an end date, then the contact is still ongoing. If it does have a enddate the kontaktforløb is finished/closed. But its possible to create a new one if needed. |
| tblUsersID |
foreign key |
| Corrected |
Timestamp for the correction |
| CorrectionUserID |
foreign key |
| CorrectionText |
The reason for the correction |
| ParentTTVisitationRegistrationContactHistoryID |
A parent id of visitation registration contact history. Null if not relevant. |
| TimeStamp |
the timestamp |
| CorrectionAuthorityID |
The authority that made a correction. Null if not relevant. |
| TTCommonAuthorityId |
foreign key |
| TTVisitationCaseID |
foreign key |