# groups

0 rows

### Description

Each record represents a group.

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
assign_overrides.groupid | assiover_gro2_fkR
groupings_groups.groupid | grougrou_gro4_fkR
groups_members.groupid | groumemb_gro2_fkR
lesson_overrides.groupid | lessover_gro2_fkR
quiz_overrides.groupid | quizover_gro2_fkR
courseid | BIGINT | 19 |  |  | null |  |
course.id | grou_cou3_fkR
idnumber | VARCHAR | 100 |  |  |  |  |  |
name | VARCHAR | 254 |  |  |  |  |  | Short human readable unique name for the group.
description | LONGTEXT | 2147483647 | √ |  | null |  |  |
descriptionformat | TINYINT | 3 |  |  | 0 |  |  |
enrolmentkey | VARCHAR | 50 | √ |  | null |  |  |
picture | BIGINT | 19 |  |  | 0 |  |  |
visibility | BIT | 1 |  |  | 0 |  |  | Visibility of group membership
participation | BIT | 1 |  |  | 1 |  |  | Can this group be selected when participating in activities?
timecreated | BIGINT | 19 |  |  | 0 |  |  |
timemodified | BIGINT | 19 |  |  | 0 |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
grou_cou_ix | Performance | Asc | courseid
grou_idn_ix | Performance | Asc | idnumber

### Relationships