group_membership_changes


Description

Stores the history of group membership changes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id BIGINT 19 null
groups.id fk_group_membership_changes_group_id_groups_id C
member_id BIGINT 19 null
groups.id fk_group_membership_changes_member_id_groups_id C
at DATETIME 23 CURRENT_TIMESTAMP(3)

Time of the action
action enum('invitation_created', 'invitation_withdrawn', 'invitation_refused', 'invitation_accepted', 'join_request_created', 'join_request_withdrawn', 'join_request_refused', 'join_request_accepted', 'leave_request_created', 'leave_request_withdrawn', 'leave_request_refused', 'leave_request_accepted', 'left', 'removed', 'joined_by_code', 'added_directly', 'expired', 'joined_by_badge', 'removed_due_to_approval_change') 30 √ null
initiator_id BIGINT 19 √ null
users.group_id fk_group_membership_changes_initiator_id_users_group_id N

The user who initiated the action (if any), typically the group owner/manager or the member himself

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc group_id + member_id + at
fk_group_membership_changes_initiator_id_users_group_id Performance Asc initiator_id
group_id_at_desc_member_id Performance Asc/Desc/Asc group_id + at + member_id
group_id_at_member_id Performance Asc/Asc/Asc group_id + at + member_id
group_id_member_id_at_desc Performance Asc/Asc/Desc group_id + member_id + at
member_id_at_desc_group_id Performance Asc/Desc/Asc member_id + at + group_id
member_id_at_group_id Performance Asc/Asc/Asc member_id + at + group_id

Relationships

Close relationships within degrees of separation