Hi everyone, I’m studying the visit detail table now and I have a question.
There are two different columns (preceding_visit_detail_id, visit_detail_parent_id) in visit detail table.
- preceding_visit_detail_id : FK to the VISIT DETAIL table of the visit immediately preceding this visit
- visit_detail_parent_id : FK to the VISIT DETAIL table record to represent the immediate parent visit_detail record
I thought the parent is visit_occurrence of visit_detail(child)
but in 2) it is not about the visit_occurrence but visit_detail. it’s a little confusing.
how can we distinguish these two columns?