pharmacy_db
Tables (11)
audit_log
- audit_id — INT
- user_id — INT
- action_type — VARCHAR(50)
- action_target — VARCHAR(255)
- target_id — INT
- action_time — DATETIME
- details — TEXT
customer
- customer_id — INT
- name — VARCHAR(255)
- birth_date — DATE
- phone_number — VARCHAR(20)
medicine
- medicine_id — INT
- name — VARCHAR(255)
- manufacturer — VARCHAR(255)
- form — VARCHAR(100)
- efficacy — TEXT
- category_id — INT
- unit — VARCHAR(50)
- product_code — VARCHAR(100)
medicine_category
- category_id — INT
- category_name — VARCHAR(255)
medicine_disposal
- disposal_id — INT
- medicine_id — INT
- stock_id — INT
- disposal_date — DATE
- quantity — INT
- reason — TEXT
medicine_stock
- stock_id — INT
- medicine_id — INT
- purchase_date — DATE
- expiration_date — DATE
- supplier_name — VARCHAR(255)
- purchase_price — DECIMAL(10,2)
- quantity — INT
- minimum_stock — INT
prescription
- prescription_id — INT
- customer_id — INT
- doctor_name — VARCHAR(255)
- hospital_name — VARCHAR(255)
- issued_date — DATE
- expiration_date — DATE
- file_path — VARCHAR(255)
prescription_item
- item_id — INT
- prescription_id — INT
- medicine_id — INT
- quantity — INT
- dispensed_quantity — INT
- status — VARCHAR(50)
- dispensed_at — DATETIME
sale
- sale_id — INT
- customer_id — INT
- sale_date — DATETIME
- prescription_id — INT
- total_amount — DECIMAL(10,2)
sale_item
- item_id — INT
- sale_id — INT
- medicine_id — INT
- quantity — INT
- unit_price — DECIMAL(10,2)
- subtotal — DECIMAL(10,2)
user
- user_id — INT
- username — VARCHAR(255)
- role — VARCHAR(100)