Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| parent_group_id | BIGINT | 19 | null |
|
|
|||||
| child_group_id | BIGINT | 19 | null |
|
|
|||||
| 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
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | parent_group_id + child_group_id |
| child_group_id_is_team_membership_parent_group_id_expires_at | Performance | Asc/Asc/Asc/Asc | child_group_id + is_team_membership + parent_group_id + expires_at |
Relationships
Close relationships within degrees of separation
