DRAFT
Schema
Examples
Services - Service Groups relations example
Composite Service example - TBC
Data Model
Service
| Name | Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | |
| code | string | M | |
| name | string | M | |
| is_active | boolean | M | |
| parent_id | UUID | O | for future use (composition_id) |
| category | string | M | enum |
| is_composition | boolean | M | for future use |
| request_allowed | boolean | M | |
| inserted_at | datetime | M | |
| inserted_by | datetime | M | |
| updated_at | datetime | M | |
| updated_by | datetime | M |
Service group
| Name | Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | |
| code | string | M | |
| name | string | M | |
| is_active | boolean | M | |
| parent_id | UUID | O | |
| request_allowed | boolean | M | |
| inserted_at | datetime | M | |
| inserted_by | datetime | M | |
| updated_at | datetime | M | |
| updated_by | datetime | M |
Service in group
| Name | Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | |
| service_id | UUID | M | |
| group_id | UUID | M | |
| alias | string | O | |
| is_active | boolean | M | |
| inserted_at | datetime | M | |
| inserted_by | datetime | M | |
| updated_at | datetime | M | |
| updated_by | datetime | M |
Medical_programs (existing Reimbursement table is used)
This entity defines medical programs information structure.
Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ||
| is_active | boolean | M | ||
| name | varchar | M | ||
| inserted_at | timestamp | M | ||
| inserted_by | uuid | M | ||
| updated_at | timestamp | M | ||
| updated_by | uuid | M | ||
same_mnn_in_treatment_period | boolean | M | Not used for service programs | |
| program_type | varchar | M | medication, service | NEW |
| legal entity types | jsonb | M | Used for service programs | NEW |