Store support groups
Data model
Fields
| Field | Type | Description |
|---|---|---|
| code* | VARCHAR (40) | Unique group code |
| description* | NVARCHAR (510) | Description of the support group |
| description_parent | NVARCHAR (510) | Parent Support Group Description |
| end_date | DATETIME | Date on which the materialized registration ended its validity |
| group_support_id* | INT | Integer Type Primary Key Table Support Group Materialized |
| id* | INT | Integer Type Primary Key |
| is_current* | BIT | Flag indicating whether the current registration is current |
| name* | NVARCHAR (120) | Group Name |
| name_parent | NVARCHAR (120) | Parent Group Name |
| parent_id | INT | Parent Support Group ID |
| session_support* | BIT | If the support group has support sessions functionality active |
| start_date* | DATETIME | Date on which the materialized registration began its validity |
Primary Key
| PK01_AVS_AUDIT_GROUP_SUPPORT |
|---|
| id |