matching_session

An append-only table of sessions

Primary Key:

• matching_session_id

Checks:

• matching_session_check - ((claim_member_id IS NULL) <> (member_seen_id IS NULL))
• matching_session_check1 - (is_active = (session_end_reason IS NULL))
• matching_session_check2 - (is_active = (ended_by_user_id IS NULL))
• matching_session_check3 - ((session_end_reason <> 'Matched successfully'::claims.session_end_reason_type) OR ((selected_match_status IS NOT NULL) AND (selected_member_canonical_id IS NOT NULL) AND (created_member_canonical IS NOT NULL)))

Foreign Keys:

• claim_member_id => claim_member.claim_member_id
• ended_by_user_id => login.login_id
• member_seen_id => member_seen.member_seen_id
• selected_member_canonical_id => member_canonical.member_canonical_id
• session_user_id => login.login_id

Indexes:

• matching_session_claim_member_id_idx - claim_member_id
• matching_session_claim_member_id_uniq_idx (Unique) - claim_member_id
• matching_session_member_seen_id_idx - member_seen_id
• matching_session_member_seen_id_uniq_idx (Unique) - member_seen_id
• matching_session_session_user_id_uniq_idx (Unique) - session_user_id

Column	Data Type	Nullable	Indexed	Description
matching_session_id	bigint	No	Yes	- Generated through expression:
claim_member_id	bigint	Yes	Yes	- Generated through expression:
member_seen_id	bigint	Yes	Yes	- Generated through expression:
member_type	member_type	No	No	- Generated through expression:  CASE WHEN (claim_member_id IS NOT NULL) THEN 'Claim'::claims.member_type ELSE 'Eligibility'::claims.member_type END
selected_match_status	match_status_type	Yes	No	The match status selected in this session. During normal operation this is always set before a session ends but an admin can force a session to be ended. Generated through expression:
selected_member_canonical_id	bigint	Yes	No	The canonical member selected in this session. During normal operation this is always set before a session ends but an admin can force a session to be ended. Generated through expression:
created_member_canonical	boolean	Yes	No	Whether the selected_member_canonical_id was created for this session. Generated through expression:
session_user_id	bigint	No	Yes	- Generated through expression:
session_begin	timestamp with time zone	No	No	- Generated through expression:
session_end	timestamp with time zone	Yes	No	- Generated through expression:
session_end_reason	session_end_reason_type	Yes	No	Why this session was ended. NULL if the session has not yet been ended. Generated through expression:
ended_by_user_id	bigint	Yes	No	Who ended the session. NULL if the session has not yet been ended. Generated through expression:
is_active	boolean	No	No	- Generated through expression: (session_end IS NULL)