-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical project sizes and architect workloads in the industry, ensuring a balance between bridge lengths and mill designs to maximize the objective function.

-- Realistic data for bridge
INSERT INTO bridge (bridge_id, length_meters, architect_id) VALUES (1, 150.0, 1);
INSERT INTO bridge (bridge_id, length_meters, architect_id) VALUES (2, 250.0, 2);
INSERT INTO bridge (bridge_id, length_meters, architect_id) VALUES (3, 180.0, 3);

-- Realistic data for architect_assignments
INSERT INTO architect_assignments (architect_id, bridge_id, mill_id) VALUES (1, 1, 1);
INSERT INTO architect_assignments (architect_id, bridge_id, mill_id) VALUES (2, 2, 2);
INSERT INTO architect_assignments (architect_id, bridge_id, mill_id) VALUES (3, 3, 3);

-- Realistic data for mills
INSERT INTO mills (mill_id, designed) VALUES (1, True);
INSERT INTO mills (mill_id, designed) VALUES (2, True);
INSERT INTO mills (mill_id, designed) VALUES (3, False);

