Legal Entities Reorganization data model_EN

Schema

Legal Entities Reorganization tables are stored in the PRM database.

Table is used to store relation data between legal entities that is created after legal entity reorganization process.

Name	Type	M/O	Description and constraints

Name	Type	M/O	Description and constraints
id	UUID	M	System identifier of legal entites relation
merged_from_id	UUID	M	Identifier of reorganized legal entity
merged_to_id	UUID	M	Identifier of successor legal entity
is_active	boolean	M	Technical flag. By default is true
type	string	M	Reorganization type
reason	string	M	Reason to reorganize legal entitiy
reason_date	date	O	Date of reason to reorganize legal entity
inserted_at	TIMESTAMP	M	Time when legal entities relation was created
inserted_by	UUID	M	User who reorganized legal entity
updated_at	TIMESTAMP	M	Time when legal entities relation was updated
updated_by	UUID	M	User who updated legal entities relation