-- Insert ADMIN data
INSERT INTO ADMIN (admin_name, password) VALUES
('Admin1', 'Password1'),
('Admin2', 'Password2'),
('Admin3', 'Password3'),
('Admin4', 'Password4'),
('Admin5', 'Password5'),
('Admin6', 'Password6'),
('Admin7', 'Password7'),
('Admin8', 'Password8'),
('Admin9', 'Password9'),
('Admin10', 'Password10');

-- Insert ACCOUNT data
INSERT INTO ACCOUNT (type, status) VALUES
('Coach', 'Active'),
('Student', 'Active'),
('Coach', 'Inactive'),
('Student', 'Inactive'),
('Coach', 'Active'),
('Student', 'Active'),
('Coach', 'Active'),
('Student', 'Active'),
('Coach', 'Inactive'),
('Student', 'Inactive');

-- Insert VENUE data
INSERT INTO VENUE (name, capacity) VALUES
('Training Field A', 20),
('Training Field B', 25),
('Theory Classroom 1', 30),
('Theory Classroom 2', 35),
('Rest Room', 15),
('Meeting Room', 10),
('Reception Area', 5),
('Parking Lot', 50),
('Office', 8),
('Storage Room', 10);

-- Insert STUDENT data
INSERT INTO STUDENT (student_id, name, password) VALUES
(1, 'John Doe', 'StudentPass1'),
(2, 'Jane Smith', 'StudentPass2'),
(3, 'Alice Johnson', 'StudentPass3'),
(4, 'Bob Brown', 'StudentPass4'),
(5, 'Charlie Davis', 'StudentPass5'),
(6, 'Diana Evans', 'StudentPass6'),
(7, 'Ethan Foster', 'StudentPass7'),
(8, 'Fiona Gates', 'StudentPass8'),
(9, 'George Hill', 'StudentPass9'),
(10, 'Hannah Irving', 'StudentPass10');

-- Insert COACH data
INSERT INTO COACH (coach_id, name, password) VALUES
(1, 'Mr. Lee', 'CoachPass1'),
(2, 'Mrs. Chen', 'CoachPass2'),
(3, 'Mr. Huang', 'CoachPass3'),
(4, 'Ms. Xu', 'CoachPass4'),
(5, 'Dr. Zhu', 'CoachPass5'),
(6, 'Prof. Jin', 'CoachPass6'),
(7, 'Mr. Lu', 'CoachPass7'),
(8, 'Ms. Liang', 'CoachPass8'),
(9, 'Dr. Shen', 'CoachPass9'),
(10, 'Prof. Han', 'CoachPass10');

-- Insert APPOINTMENT data
INSERT INTO APPOINTMENT (student_id, coach_id, venue_id, period, status) VALUES
(1, 1, 1, 'Morning', 'Scheduled'),
(2, 2, 2, 'Afternoon', 'Completed'),
(3, 3, 1, 'Morning', 'Cancelled'),
(4, 4, 3, 'Evening', 'Pending'),
(5, 5, 4, 'Morning', 'In Progress'),
(6, 6, 5, 'Afternoon', 'Completed'),
(7, 7, 1, 'Morning', 'Scheduled'),
(8, 8, 2, 'Afternoon', 'Completed'),
(9, 9, 3, 'Evening', 'Cancelled'),
(10, 10, 4, 'Morning', 'Pending');

-- Insert FEEDBACK data
INSERT INTO FEEDBACK (content, date) VALUES
('Very satisfied with the teaching method of the coach.', '2023-10-01'),
('Hope for more practical opportunities.', '2023-10-02'),
('The coach patiently answered my questions.', '2023-10-03'),
('Facility conditions need improvement.', '2023-10-04'),
('Teaching content arrangement is reasonable.', '2023-10-05'),
('Suggest adding interactive segments to theory classes.', '2023-10-06'),
('The coach has a good attitude.', '2023-10-07'),
('Facilities are complete.', '2023-10-08'),
('Hope for more course options.', '2023-10-09'),
('Overall experience is good.', '2023-10-10');

-- Insert INVOICE data
INSERT INTO INVOICE (amount, date) VALUES
(500.00, '2023-10-01'),
(600.00, '2023-10-02'),
(550.00, '2023-10-03'),
(700.00, '2023-10-04'),
(650.00, '2023-10-05'),
(500.00, '2023-10-06'),
(600.00, '2023-10-07'),
(550.00, '2023-10-08'),
(700.00, '2023-10-09'),
(650.00, '2023-10-10');

-- Insert PERSONAL_INFO data
INSERT INTO PERSONAL_INFO (student_id, phone, email) VALUES
(1, '13800138000', 'johndoe@example.com'),
(2, '13800138001', 'janesmith@example.com'),
(3, '13800138002', 'alicejohnson@example.com'),
(4, '13800138003', 'bobbrown@example.com'),
(5, '13800138004', 'charliedavis@example.com'),
(6, '13800138005', 'dianaevans@example.com'),
(7, '13800138006', 'ethanfoster@example.com'),
(8, '13800138007', 'fiangates@example.com'),
(9, '13800138008', 'georgehill@example.com'),
(10, '13800138009', 'hannahirving@example.com');

-- Insert TRAINING_RECORD data
INSERT INTO TRAINING_RECORD (student_id, coach_id, feedback) VALUES
(1, 1, 'The coach is very professional and explains clearly.'),
(2, 2, 'Increased my confidence.'),
(3, 3, 'The facility is nice.'),
(4, 4, 'Will come back next time.'),
(5, 5, 'Made significant progress.'),
(6, 6, 'Looking forward to the next session.'),
(7, 7, 'Thank you, coach.'),
(8, 8, 'Learned a lot.'),
(9, 9, 'Keep it up.'),
(10, 10, 'Trustworthy.');

-- Insert BOOKING_SLOT data
INSERT INTO BOOKING_SLOT (start_time, end_time) VALUES
('09:00:00', '10:00:00'),
('10:00:00', '11:00:00'),
('11:00:00', '12:00:00'),
('13:00:00', '14:00:00'),
('14:00:00', '15:00:00'),
('15:00:00', '16:00:00'),
('16:00:00', '17:00:00'),
('17:00:00', '18:00:00'),
('18:00:00', '19:00:00'),
('19:00:00', '20:00:00');