member_canonical_reconfiguration
member_canonical_reconfiguration_only_one_canonical_set_check-((member_canonical_id IS NULL) <> (member_canonical_archive_id IS NULL))
matching_session_id=>matching_session.matching_session_idmember_canonical_archive_id=>member_canonical_archive.member_canonical_idmember_canonical_id=>member_canonical.member_canonical_id
member_canonical_reconfiguration_matching_session_id_idx-matching_session_idmember_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: |