Page Comparison

Table of Contents

Schema

...

Forbidden group tables are stored in the PRM database

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

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

Table used to store services included to forbidden groups

...