member_canonical_reconfiguration

Checks:

• member_canonical_reconfiguration_only_one_canonical_set_check - ((member_canonical_id IS NULL) <> (member_canonical_archive_id IS NULL))

Foreign Keys:

• matching_session_id => matching_session.matching_session_id
• member_canonical_archive_id => member_canonical_archive.member_canonical_id
• member_canonical_id => member_canonical.member_canonical_id

Indexes:

• member_canonical_reconfiguration_matching_session_id_idx - matching_session_id
• member_canonical_reconfiguration_matching_session_id_member_can (Unique) - matching_session_id, member_canonical_id, member_canonical_archive_id

Column	Data Type	Nullable	Indexed	Description
matching_session_id	bigint	No	Yes	- Generated through expression:
member_canonical_id	bigint	Yes	Yes	- Generated through expression:
member_canonical_archive_id	bigint	Yes	Yes	- Generated through expression:
old_member_seen_ids	bigint[]	No	No	The old member seen ids associated to this before reconfiguration. Generated through expression:
new_member_seen_ids	bigint[]	No	No	- Generated through expression: