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))

Foreign Keys:

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

Indexes:

• member_canonical_lock_lock_begin_idx - lock_begin
• member_canonical_lock_lock_end_idx - lock_end
• member_canonical_lock_matching_session_id_idx - matching_session_id
• member_canonical_lock_member_canonical_id_idx (Unique) - member_canonical_id

Column	Data Type	Nullable	Indexed	Description
member_canonical_id	bigint	Yes	Yes	- Generated through expression:
member_canonical_archive_id	bigint	Yes	No	- Generated through expression:
matching_session_id	bigint	No	Yes	- Generated through expression:
lock_begin	timestamp with time zone	No	Yes	- Generated through expression:
lock_end	timestamp with time zone	Yes	Yes	- Generated through expression:
is_active	boolean	No	No	- Generated through expression: (lock_end IS NULL)