member_canonical_archive

An archive of old member_canonical records. Rows in this table are created when a user merges two member_canonical, effectively deleting one.

Primary Key:

• member_canonical_id

Foreign Keys:

• archived_by => login.login_id
• canonical_member_seen_id => member_seen.member_seen_id

Indexes:

• member_canonical_archive_archived_by_idx - archived_by
• member_canonical_archive_canonical_member_seen_id_idx - canonical_member_seen_id

Column	Data Type	Nullable	Indexed	Description
member_canonical_id	bigint	No	Yes	-
canonical_member_seen_id	bigint	No	Yes	Snowflake ID of the canonical member.
archived_at	timestamp with time zone	No	No	-
archived_by	bigint	No	Yes	-