member_canonical_lock
A lock corresponding to a human currently matching using a member_canonical record. This does not correspond to any Postgres lock as no continuous connection is held during the duration of the matching but updates are still not allowed.
Checks:member_canonical_lock_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_id=>member_canonical.member_canonical_id
member_canonical_lock_lock_begin_idx-lock_beginmember_canonical_lock_lock_end_idx-lock_endmember_canonical_lock_matching_session_id_idx-matching_session_idmember_canonical_lock_member_canonical_id_idx-member_canonical_idmember_canonical_lock_member_canonical_id_uq(Unique) -member_canonical_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
member_canonical_id | bigint | Yes | Yes | - |
member_canonical_archive_id | bigint | Yes | No | - |
matching_session_id | bigint | No | Yes | - |
lock_begin | timestamp with time zone | No | Yes | - |
lock_end | timestamp with time zone | Yes | Yes | - |
is_active | boolean | No | No | - Generated through expression: (lock_end IS NULL) |