Table that stores support groups
Data model
Fields
| Field | Type | Description |
|---|---|---|
| code* | VARCHAR (40) | Unique group code |
| description* | NVARCHAR (510) | Description of the support group |
| id* | INT | Integer Type Primary Key |
| name* | NVARCHAR (120) | Group Name |
| parent | INT | Parent Support Group ID |
| session_support* | BIT | If the support group has support sessions functionality active |
Primary Key
| PK01_AVS_GROUP_SUPPORT |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| parent | dbo.AVS_GROUP_SUPPORT | id | FK01_AVS_GROUP_SUPPORT |