=== Database Test ===

treatment_records count: 20
farms count: 9
antimicrobials count: 20
users count: 13

Sample treatment record:
Array
(
    [treatment_id] => 1
    [prescription_id] => 1
    [farm_id] => 1
    [animal_id] => 1
    [medicine_id] => 17
    [treated_by] => 2
    [treatment_date] => 2024-11-15 11:00:00
    [treatment_type] => therapeutic
    [reason] => Mastitis treatment
    [dosage_given] => 10ml
    [route] => intramammary
    [batch_number] => CLX-2024-A01
    [withdrawal_end_date] => 2024-11-18
    [is_withdrawal_complete] => 1
    [notes] => Left rear quarter
    [created_at] => 2025-12-31 15:52:40
    [updated_at] => 2025-12-31 15:52:40
)

=== treatment_records structure ===
treatment_id - int
prescription_id - int
farm_id - int
animal_id - int
medicine_id - int
treated_by - int
treatment_date - timestamp
treatment_type - enum('therapeutic','prophylactic','metaphylactic','feed_additive')
reason - text
dosage_given - varchar(100)
route - enum('injection','oral','topical','feed','water','intramammary')
batch_number - varchar(50)
withdrawal_end_date - date
is_withdrawal_complete - tinyint(1)
notes - text
created_at - timestamp
updated_at - timestamp