member_seen_to_member_seen_match

Describes matches between rows in member_seen.

Primary Key:

• member_seen_id_first
• member_seen_id_second

Checks:

• member_seen_to_member_seen_match_check - (member_seen_id_first < member_seen_id_second)

Foreign Keys:

• member_seen_id_second => member_seen.member_seen_id
• member_seen_id_first => member_seen.member_seen_id

Indexes:

• member_seen_to_member_seen_match_member_seen_id_second_idx - member_seen_id_second

Column	Data Type	Nullable	Indexed	Description
member_seen_id_first	bigint	No	Yes	-
member_seen_id_second	bigint	No	Yes	-
match_score	numeric	Yes	No	-
match_metadata	jsonb	Yes	No	Information about what matches between member_seen and member record