-- Iteration 2 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical player-coach dynamics in a riding club, ensuring compatibility scores are realistic and coach capacities are reasonable.

-- Realistic data for compatibility_scores
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (1, 1, 0.85);
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (1, 2, 0.65);
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (2, 1, 0.75);
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (2, 3, 0.6);
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (3, 2, 0.9);
INSERT INTO compatibility_scores (Player_ID, Coach_ID, compatibility_score) VALUES (3, 3, 0.7);

-- Realistic data for coach_constraints
INSERT INTO coach_constraints (Coach_ID, max_players) VALUES (1, 5);
INSERT INTO coach_constraints (Coach_ID, max_players) VALUES (2, 4);
INSERT INTO coach_constraints (Coach_ID, max_players) VALUES (3, 6);

-- Realistic data for assignments
INSERT INTO assignments (Player_ID, Coach_ID, assignment) VALUES (1, 1, True);
INSERT INTO assignments (Player_ID, Coach_ID, assignment) VALUES (2, 1, False);
INSERT INTO assignments (Player_ID, Coach_ID, assignment) VALUES (2, 3, True);
INSERT INTO assignments (Player_ID, Coach_ID, assignment) VALUES (3, 2, True);

