Overview
Live snapshot of the pharmacy, read from Neo4j AuraDB.
Low stock below 80 units
Recent sales
Inventory
All medicines with supplier, price, stock and expiry.
| ID | Medicine | Category | Supplier | Price | Stock | Expiry |
|---|
Add medicine
Saving an existing ID updates that medicine (Cypher MERGE).
Alerts
Medicines that need restocking or are close to expiry.
Low stock below 80 units
Expiring before 2028
Sales
Transactions with the customer, the employee who handled them, and the amount.
| Sale | Date | Customer | Handled by | Payment | Status | Amount |
|---|
Purchase trace Customer → Sale → Medicine ← Supplier
| Customer | Sale | Medicine | Qty | Supplied by |
|---|
Suppliers & Prescriptions
Who supplies what, and prescriptions on record.
Suppliers
| Supplier | Phone | Medicines | Supplies |
|---|
Prescriptions
| ID | Customer | Doctor | Date |
|---|
Analytics
Sales performance from the CONTAINS relationships.
Units sold by medicine
Revenue per sale ₹
Stock level by medicine
Graph
The whole pharmacy database as nodes and relationships. Drag nodes to explore.