You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
142 lines
4.4 KiB
142 lines
4.4 KiB
-- 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'); |