Effective dating: links that stop being true — Tips

• Leave the to empty for the current arrangement — an open-ended period is the normal case, not a special one. • Use by day unless you genuinely need sub-day precision; it makes the half-open rule easy to reason about at a glance. • Keep overlap on reject for hierarchies (a record with one parent) and relax it only for genuinely many-to-many history.