contain active and to provide a historical record of the content of the terminology at different points in time.
A relationship is inactive when the most recent row with the relationship.id in the has the value relationship.active = 0 (zero). The most recent row for a relationship is determined based on the relationship.effectiveTime value.
Terms derived from inactive relationships may still be present in past records but should no longer be returned by searches or user interface tools used to enter information into current records.