| Status | ||
|---|---|---|
|
...
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 | |
| type | varchar | M | medication, service | NEW |
| legal_entity_types | jsonb | M | Used for service programs, array of legal_entity_types dictionary values. Program can be set on service request if it were created by an employee from legal entity with one of types listed in array | NEW |
Program_services (new table)
Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ||
| service_id | uuid | O | service_id OR service_group_id is mandatory | |
| medical_program_id | uuid | M | ||
| service_group_id | uuid | O | service_id OR service_group_id is mandatory | |
request_allowed | boolean | M | ||
| consumer_price | double | M | ||
| description | text | O | used for text description of un-automated conditions which should be checked for program member vs patient qualification (e.g. sex or age of patient) | |
| is_active | boolean | M | ||
| inserted_at | timestamp | M | ||
| inserted_by | uuid | M | ||
| updated_at | timestamp | M | ||
| updated_by | uuid | M |
contract_program_services (new table)
Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ||
| contract_id | uuid | M | FK(contract_id) | |
| program_services_id | uuid | M | FK(program_services) | |
| is_active | boolean | M | ||
| inserted_at | timestamp | M | ||
| inserted_by | uuid | M | ||
| updated_at | timestamp | M | ||
| updated_by | uuid | M |
Endpoint response tree structure
Node 1service_groups w/o sub-groups, w/o parent_group_idservice_groups with sub-groups, w/o parent_group_idservices which aren't included in any service_groups
Node 2service_groups with parent_group_id with service_groups of the first nodeservices which are included in the service_groups of the Node 1
Node 3service_groups with parent_group_id with service_groups from the second nodeservices which are included in the service_groups of the Node 2
Node 4service_groups with parent_group_id with service_groups from the third nodeservices which are included in the service_groups of the Node 3
Node 5services which are included in the service_groups of the Node 4