ЕСОЗ - публічна документація
Legal Entities Reorganization data model_EN
- Oleg Brizhatiy (Unlicensed)
- Oleksandr Zhuk (SoE eHealth) (Unlicensed)
Schema
Tables
Legal Entities Reorganization tables are stored in the PRM database.
related_legal_entities
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 |
|---|---|---|---|
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 |
ЕСОЗ - публічна документація