Schema
Tables
Forbidden group tables are stored in the PRM database
forbidden_groups
Table used to store forbidden group attributes
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | System identifier of the forbidden group |
name | varchar | M | Name of the forbidden group |
creation_reason | varchar | M | Reason for creating forbidden group |
deactivation_reason | varchar | O | Reason for deactivating forbidden group |
is_active | bool | M | Technical flag. By default is true |
inserted_by | uuid | M | User who created a group |
inserted_at | timestamp | M | Time when a group was created |
updated_by | uuid | M | The last user by who the group was updated |
updated_at | timestamp | M | The last time the group was updated |
forbidden_group_codes
Table used to store codes included to forbidden groups
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | System identifier of the forbidden group inclusion |
forbidden_group_id | uuid | M | The group the code belongs to |
code | varchar | M | Code from dictionary. Unique within system if is_active=true |
system | varchar | M | Dictionary system |
creation_reason | varchar | M | Reason for adding code to the forbidden group |
deactivation_reason | varchar | O | Reason for deactivating code in the forbidden group |
is_active | bool | M | Technical flag. By default is true |
inserted_by | uuid | M | User who added code to the group |
inserted_at | timestamp | M | Time when a the code was added to the group |
updated_by | uuid | M | The last user by who the record was updated |
updated_at | timestamp | M | The last time the record was updated |
forbidden_group_services
Table used to store services included to forbidden groups
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | System identifier of the forbidden group inclusion |
forbidden_group_id | uuid | M | The group the service belongs to |
service_id | uuid | O | Service identifier. Should be set if service_group_id is absent. Should not be set if service_group_id is present. Unique for records with is_active=true |
service_group_id | uuid | O | Service group identifier. Should be set if service_id is absent. Should not be set if service_id is present. Unique for records with is_active=true |
creation_reason | varchar | M | Reason for adding service/service_group to the forbidden group |
deactivation_reason | varchar | O | Reason for deactivating service/service_group in the forbidden group |
is_active | bool | M | Technical flag. By default is true |
inserted_by | uuid | M | User who added service to the group |
inserted_at | timestamp | M | Time when a the service was added to the group |
updated_by | uuid | M | The last user by who the record was updated |
updated_at | timestamp | M | The last time the record was updated |