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

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