Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| parent_group_id | BIGINT | 19 | null |
|
|
|||
| child_group_id | BIGINT | 19 | null |
|
|
|||
| child_group_type | enum('Class', 'Team', 'Club', 'Friends', 'Other', 'User', 'Session', 'Base', 'ContestParticipants') | 19 | null |
|
|
The type of the child group in the relationship (we duplicate groups.type to improve performance) |
||
| expires_at | DATETIME | 19 | 9999-12-31 23:59:59 |
|
|
The group membership expires at the specified time |
||
| is_team_membership | BIT | 1 | 0 |
|
|
true if the parent group is a team |
||
| personal_info_view_approved_at | DATETIME | 19 | √ | null |
|
|
||
| personal_info_view_approved | BIT | 1 | null |
|
|
personal_info_view_approved_at as boolean |
||
| lock_membership_approved_at | DATETIME | 19 | √ | null |
|
|
||
| lock_membership_approved | BIT | 1 | null |
|
|
lock_membership_approved_at as boolean |
||
| watch_approved_at | DATETIME | 19 | √ | null |
|
|
||
| watch_approved | BIT | 1 | null |
|
|
watch_approved_at as boolean |
Table contained 0 rows