# Groups: ActiveCampaign Groups
- Catalog: `ActiveCampaign`
- Schema: `V3`
- Primary Keys: `id`
- Label: Groups
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `Groups` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `descript` | `varchar2` | Description | ☐ | |
| `id` | `int64` | ID | ☑ | |
| `optinconfirm` | `int64` | Opt-in Confirm | ☑ | |
| `p_admin` | `int64` | | ☑ | |
| `pg_user_add` | `int64` | | ☑ | |
| `pg_user_delete` | `int64` | | ☑ | |
| `pg_user_edit` | `int64` | | ☑ | |
| `pgAutomationManage` | `int64` | | ☑ | |
| `pgContactActions` | `int64` | | ☑ | |
| `pgContactAdd` | `int64` | | ☑ | |
| `pgContactApprove` | `int64` | | ☑ | |
| `pgContactDelete` | `int64` | | ☑ | |
| `pgContactEdit` | `int64` | | ☑ | |
| `pgContactExport` | `int64` | | ☑ | |
| `pgContactFields` | `int64` | | ☑ | |
| `pgContactFilters` | `int64` | | ☑ | |
| `pgContactImport` | `int64` | | ☑ | |
| `pgContactMerge` | `int64` | | ☑ | |
| `pgContactSync` | `int64` | | ☑ | |
| `pgDeal` | `int64` | | ☑ | |
| `pgDealDelete` | `int64` | | ☑ | |
| `pgDealGroupAdd` | `int64` | | ☑ | |
| `pgDealGroupDelete` | `int64` | | ☑ | |
| `pgDealGroupEdit` | `int64` | | ☑ | |
| `pgDealReassign` | `int64` | | ☑ | |
| `pgFormEdit` | `int64` | | ☑ | |
| `pgGroupAdd` | `int64` | | ☑ | |
| `pgGroupDelete` | `int64` | | ☑ | |
| `pgGroupEdit` | `int64` | | ☑ | |
| `pgListAdd` | `int64` | | ☑ | |
| `pgListBounce` | `int64` | | ☑ | |
| `pgListDelete` | `int64` | | ☑ | |
| `pgListEdit` | `int64` | | ☑ | |
| `pgListEmailaccount` | `int64` | | ☑ | |
| `pgListHeaders` | `int64` | | ☑ | |
| `pgMessageAdd` | `int64` | | ☑ | |
| `pgMessageDelete` | `int64` | | ☑ | |
| `pgMessageEdit` | `int64` | | ☑ | |
| `pgMessageSend` | `int64` | | ☑ | |
| `pgPersonalizationAdd` | `int64` | | ☑ | |
| `pgPersonalizationDelete` | `int64` | | ☑ | |
| `pgPersonalizationEdit` | `int64` | | ☑ | |
| `pgReportsCampaign` | `int64` | | ☑ | |
| `pgReportsList` | `int64` | | ☑ | |
| `pgReportsTrend` | `int64` | | ☑ | |
| `pgReportsUser` | `int64` | | ☑ | |
| `pgSavedResponsesManage` | `int64` | | ☑ | |
| `pgStartupGettingstarted` | `int64` | | ☑ | |
| `pgStartupReports` | `int64` | | ☑ | |
| `pgTemplateAdd` | `int64` | | ☑ | |
| `pgTemplateDelete` | `int64` | | ☑ | |
| `pgTemplateEdit` | `int64` | | ☑ | |
| `reqApproval` | `int64` | | ☑ | |
| `reqApproval1st` | `int64` | | ☑ | |
| `reqApprovalNotify` | `varchar2` | | ☐ | |
| `sdate` | `datetime` | | ☐ | |
| `socialdata` | `int64` | Social Data | ☑ | |
| `title` | `varchar2` | Title | ☑ | |
| `unsubscribelink` | `int64` | Unsubscribe Link | ☑ | |