RelationModel: populate.sql

INSERT INTO AppUser (ssn, email, password, firstName, lastName) VALUES
('1234567890123', 'john.doe@email.com', 'pass123', 'John', 'Doe'),
('2345678901234', 'jane.smith@email.com', 'pass456', 'Jane', 'Smith'),
('3456789012345', 'bob.wilson@email.com', 'pass789', 'Bob', 'Wilson'),
('4567890123456', 'alice.jones@email.com', 'pass321', 'Alice', 'Jones'),
('5678901234567', 'mike.brown@email.com', 'pass654', 'Mike', 'Brown'),
('6789012345678', 'sara.davis@email.com', 'pass987', 'Sara', 'Davis'),
('7890123456789', 'tom.miller@email.com', 'passabc', 'Tom', 'Miller'),
('8901234567890', 'emma.white@email.com', 'passdef', 'Emma', 'White'),
('9012345678901', 'james.black@email.com', 'passghi', 'James', 'Black'),
('0123456789012', 'lisa.green@email.com', 'passjkl', 'Lisa', 'Green');

INSERT INTO Patient (userId, patientId) VALUES
('1234567890123', 'P001'),
('2345678901234', 'P002'),
('3456789012345', 'P003'),
('4567890123456', 'P004'),
('5678901234567', 'P005'),
('6789012345678', 'P006'),
('7890123456789', 'P007'),
('8901234567890', 'P008'),
('9012345678901', 'P009'),
('0123456789012', 'P010');

INSERT INTO Doctor (userId, workingHours, licenseNumber, hospitalId) VALUES
('1234567890123', '9:00-17:00', 'L001', 'H001'),
('2345678901234', '8:00-16:00', 'L002', 'H001'),
('3456789012345', '10:00-18:00', 'L003', 'H002'),
('4567890123456', '9:00-17:00', 'L004', 'H002'),
('5678901234567', '8:00-16:00', 'L005', 'H003'),
('6789012345678', '10:00-18:00', 'L006', 'H003'),
('7890123456789', '9:00-17:00', 'L007', 'H004'),
('8901234567890', '8:00-16:00', 'L008', 'H004'),
('9012345678901', '10:00-18:00', 'L009', 'H005'),
('0123456789012', '9:00-17:00', 'L010', 'H005');

INSERT INTO Specialist (userId, licenseNumber, hospitalId) VALUES
('1234567890123', 'S001', 'H001'),
('2345678901234', 'S002', 'H001'),
('3456789012345', 'S003', 'H002'),
('4567890123456', 'S004', 'H002'),
('5678901234567', 'S005', 'H003'),
('6789012345678', 'S006', 'H003'),
('7890123456789', 'S007', 'H004'),
('8901234567890', 'S008', 'H004'),
('9012345678901', 'S009', 'H005'),
('0123456789012', 'S010', 'H005');

INSERT INTO Comment (commentId, createdBy, comment) VALUES
(1, '1234567890123', 'Great service!'),
(2, '2345678901234', 'Very professional'),
(3, '3456789012345', 'Excellent care'),
(4, '4567890123456', 'Quick response'),
(5, '5678901234567', 'Helpful staff'),
(6, '6789012345678', 'Good experience'),
(7, '7890123456789', 'Highly recommended'),
(8, '8901234567890', 'Professional team'),
(9, '9012345678901', 'Outstanding service'),
(10, '0123456789012', 'Very satisfied');

INSERT INTO Report (reportId, description, isFinished) VALUES
(1, 'Annual checkup report', true),
(2, 'Blood test results', true),
(3, 'X-ray analysis', false),
(4, 'Medical examination', true),
(5, 'Dental checkup', true),
(6, 'Eye examination', false),
(7, 'Physical therapy report', true),
(8, 'Psychiatric evaluation', true),
(9, 'Dermatology consultation', false),
(10, 'Cardiology report', true);

INSERT INTO MedicineRecepit (medicineRecepitId, reportId, medicineName, quantity) VALUES
(1, 3, 'Aspirin', 30),
(2, 4, 'Ibuprofen', 20),
(3, 5, 'Amoxicillin', 15),
(4, 1, 'Paracetamol', 25),
(5, 2, 'Omeprazole', 10),
(6, 3, 'Metformin', 60),
(7, 6, 'Lisinopril', 30),
(8, 7, 'Simvastatin', 28),
(9, 5, 'Amlodipine', 30),
(10, 3, 'Sertraline', 30);

INSERT INTO IsApprovedMedicineRecepit (approvalId, receiptId, approvedBy, IsApproved) VALUES
(1, 1, '1234567890123', true),
(2, 2, '2345678901234', true),
(3, 3, '3456789012345', false),
(4, 4, '4567890123456', true),
(5, 5, '5678901234567', true),
(6, 6, '6789012345678', true),
(7, 7, '7890123456789', false),
(8, 8, '8901234567890', true),
(9, 9, '9012345678901', true),
(10, 10, '0123456789012', true);

INSERT INTO Examination (examinationId, patientId, doctorId, specialistId) VALUES
(1, '1234567890123', '2345678901234', '3456789012345'),
(2, '2345678901234', '3456789012345', '4567890123456'),
(3, '3456789012345', '4567890123456', '5678901234567'),
(4, '4567890123456', '5678901234567', '6789012345678'),
(5, '5678901234567', '6789012345678', '7890123456789'),
(6, '6789012345678', '7890123456789', '8901234567890'),
(7, '7890123456789', '8901234567890', '9012345678901'),
(8, '8901234567890', '9012345678901', '0123456789012'),
(9, '9012345678901', '0123456789012', '1234567890123'),
(10, '0123456789012', '1234567890123', '2345678901234');

INSERT INTO Review (reviewId, patientId, doctorId, rank) VALUES
(1, '1234567890123', '2345678901234', 5),
(2, '2345678901234', '3456789012345', 4),
(3, '3456789012345', '4567890123456', 5),
(4, '4567890123456', '5678901234567', 3),
(5, '5678901234567', '6789012345678', 4),
(6, '6789012345678', '7890123456789', 5),
(7, '7890123456789', '8901234567890', 4),
(8, '8901234567890', '9012345678901', 5),
(9, '9012345678901', '0123456789012', 4),
(10, '0123456789012', '1234567890123', 5);