Schema

Tables

The provision of medical programs by pharmacy divisions has been stored in following table:

Name	Type	M/O	Description and constraints

Name	Type	M/O	Description and constraints
id	uuid	M	System identifier
medical_program_id	uuid	M	Medical program identifier
division_id	uuid	M	Division which provide a medical program
contract_number	varchar	M	Contract number according to which the medical program has been provided by division.
is_active	bool	M	Status of the record. By default is true
deactivate_reason	varchar	O	Fills according to PROVISON_DEACTIVATE_REASON dicitionary. Deactivation reasons: MANUAL_DEACTIVATION - deactivated by user via API AUTO_DIVISION_DEACTIVATION - deactivate in case division is closed AUTO_DIVISION_DLS_NOT_VERIFIED - deactivate in case division become DLS unverified AUTO_LEGAL_ENTITY_DEACTIVATION - deactivate in case legal entity has been closed (reorganized) AUTO_MEDICAL_PROGRAM_DEACTIVATION - deactivate in case medical program has been deactivated by NHS AUTO_CONTRACT_TERMINATION - deactivate in case related contract is terminated
inserted_by	uuid	M	User who created the record
inserted_at	timestamp	M	Time when the record was created
updated_by	uuid	M	The last user by who updated the record
updated_at	timestamp	M	The last time the record was updated

Bucket name
- Legal entity identifier
  - Medical program identifier
    - Folder with name “provision_create“
      - File with signed content from Create Medical program provision method with list of divisions. Has name with timestamp which match to inserted_at timestamp of created records in table.