Makriyal Apiary
A 16-table relational apiary management core operating across chestnut and linden foraging belts, decoupling living bee colonies from physical wooden hive boxes.
APPLICATION / RESEARCH DOSSIER
Working context
When spring swarm prevention, splits, and merges moved living colonies across wooden boxes, box-keyed logs left regional Caucasian queen (Apis mellifera caucasica) history stranded on the old hardware, while defaulting rain-skipped Varroa checks to '0' created false reassurance.
Under SPEC-01, living colonies (`colonies`) and wooden boxes (`hives`) were separated and linked via time-bounded `hive_occupancies` intervals, backed by append-only `colony_events` triggers and a 5-state (`NULL`, `N/A`, `UNKNOWN`, `SUSPECT`, `VERIFIED`) schema.
Multi-season maternal lineage graphs (DAG), 10-frame cross-sections, and harvest lot traceability run continuously in field production, eliminating misdirected colony interventions.