Archivability

In most cases in this application, we do not physically delete records (entities) from the database. Instead, we use an archiving mechanism that changes the entity status to “archived” or “inactive”. This allows us to maintain a complete data history, which enables:

• Recovery of accidentally archived data.
• Auditing and tracking changes in the system.
• Ensuring consistency of references between entities.

How Does Archiving Work?

When editing or “deleting” data, records are not physically removed from the database – instead they are marked as archived. Such data still appears on lists (e.g., in admin panels), allowing them to be viewed and potentially restored. However, in the context of prescription dispensing, archived records are not available – they cannot be selected or associated with a new prescription. This way we maintain data integrity and change history, while preventing the use of outdated information in the prescription dispensing process.

Examples

Editing an Ingredient

Note

If you dispense a prescription with a sample ingredient, and then that ingredient is edited (e.g., you change its name or other data), then:

• When viewing this prescription you will see the old version of the ingredient and its old data.
• When editing or cloning this prescription the field where the ingredient was selected will be empty and you will need to select the ingredient again.

This is because the old version of the ingredient was archived and is no longer available for selection in new or edited prescriptions.