-- Alice Johnson
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (21, 'Alice Johnson', '789 Oak St', '345-678-9012');

-- Michael Brown
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (22, 'Michael Brown', '101 Pine St', '456-789-0123');

-- Emily Davis
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (23, 'Emily Davis', '202 Cedar St', '567-890-1234');

-- James Wilson
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (24, 'James Wilson', '303 Maple St', '678-901-2345');

-- Linda Anderson
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (25, 'Linda Anderson', '404 Birch St', '789-012-3456');

-- William Martinez
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (26, 'William Martinez', '505 Walnut St', '890-123-4567');

-- Susan Taylor
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (27, 'Susan Taylor', '606 Oakwood St', '901-234-5678');

-- David Thomas
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (28, 'David Thomas', '707 Elmwood St', '012-345-6789');

-- Patricia Lee
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (29, 'Patricia Lee', '808 Pinecrest St', '123-456-7890');

-- Richard Garcia
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (30, 'Richard Garcia', '909 Cedarwood St', '234-567-8901');

-- Organization1
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (1, 'Organization1', '12321 Oak St', '334-678-9012');

-- Organization2
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (2, 'Organization2', '10100 Pine St', '454-789-0123');

-- Organization3
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (3, 'Organization3', '20200 Cedar St', '564-890-1234');

-- Organization4
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (4, 'Organization4', '30300 Maple St', '674-901-2346');

-- Organization5
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (5, 'Organization5', '40400 Birch St', '784-012-3457');

-- Organization6
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (6, 'Organization6', '50500 Walnut St', '894-123-4568');

-- Organization7
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (7, 'Organization7', '60600 Oakwood St', '904-234-5679');

-- Organization8
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (8, 'Organization8', '70700 Elmwood St', '014-345-6780');

-- Organization9
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (9, 'Organization9', '80800 Pinecrest St', '124-456-7891');

-- Organization10
INSERT INTO contact_details (contact_id, name, address, phone_number)
VALUES (10, 'Organization10', '90900 Cedarwood St', '234-567-8902');














-- Volunteer 3
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (3, 21, 3);

-- Volunteer 4
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (4, 22, 6);

-- Volunteer 5
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (5, 23, 4);

-- Volunteer 6
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (6, 24, 2);

-- Volunteer 7
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (7, 25, 8);

-- Volunteer 8
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (8, 26, 5);

-- Volunteer 9
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (9, 27, 3);

-- Volunteer 10
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (10, 28, 7);

-- Volunteer 11
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (11, 29, 4);

-- Volunteer 12
INSERT INTO volunteers (volunteer_id, contact_id, experience_years)
VALUES (12, 30, 6);



 
-- Organization 1000
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1000, 'non-profitable', 1);

-- Organization 1001
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1001, 'profitable', 2);

-- Organization 1002
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1002, 'Community service organization', 3);

-- Organization 1003
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1003, 'charity', 4);

-- Organization 1004
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1004, 'NGO', 5);

-- Organization 1005
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1005, 'non-profitable', 6);

-- Organization 1006
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1006, 'non-profitable', 7);

-- Organization 1007
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1007, 'Non-Governmental Organization', 8);

-- Organization 1008
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1008, 'non-profitable', 9);

-- Organization 1009
INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1009, 'Community service organization', 10);
 
-- Project 10
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (10, 1001, 'cleaning the beach', TO_DATE('2022-05-04', 'YYYY-MM-DD'), TO_DATE('2023-05-23', 'YYYY-MM-DD'), 500);

-- Project 30
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (30, 1001, 'senior care support project', TO_DATE('2024-07-23', 'YYYY-MM-DD'), TO_DATE('2024-08-23', 'YYYY-MM-DD'), 2500);

-- Project 20
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (20, 1002, 'event org', TO_DATE('2023-05-04', 'YYYY-MM-DD'), TO_DATE('2023-08-23', 'YYYY-MM-DD'), 2500);

-- Project 40
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (40, 1000, 'taking stray animals to shelter', TO_DATE('2023-07-25', 'YYYY-MM-DD'), TO_DATE('2024-09-25', 'YYYY-MM-DD'), 10000);

-- Project 50
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (50, 1003, 'Food distribution program', TO_DATE('2024-06-15', 'YYYY-MM-DD'), TO_DATE('2024-09-15', 'YYYY-MM-DD'), 3000);

-- Project 60
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (60, 1004, 'Education for all', TO_DATE('2024-08-01', 'YYYY-MM-DD'), TO_DATE('2025-07-31', 'YYYY-MM-DD'), 5500);

-- Project 70
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (70, 1005, 'Healthcare awareness campaign', TO_DATE('2022-05-04', 'YYYY-MM-DD'), TO_DATE('2024-10-10', 'YYYY-MM-DD'), 1500);

-- Project 80
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (80, 1006, 'Community clean-up day', TO_DATE('2023-07-01', 'YYYY-MM-DD'), TO_DATE('2024-07-01', 'YYYY-MM-DD'), 200);

-- Project 90
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (90, 1007, 'Support for refugees', TO_DATE('2022-05-01', 'YYYY-MM-DD'), TO_DATE('2024-12-31', 'YYYY-MM-DD'), 10000);

-- Project 100
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (100, 1008, 'Youth empowerment program', TO_DATE('2022-09-01', 'YYYY-MM-DD'), TO_DATE('2025-08-31', 'YYYY-MM-DD'), 3500);

-- Project 110
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (110, 1009, 'Environmental conservation project', TO_DATE('2023-05-26', 'YYYY-MM-DD'), TO_DATE('2025-10-15', 'YYYY-MM-DD'), 6000);

-- Project 120
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (120, 1000, 'Homeless shelter renovation', TO_DATE('2022-08-01', 'YYYY-MM-DD'), TO_DATE('2024-12-31', 'YYYY-MM-DD'), 2000);

-- Project 130
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (130, 1001, 'Child education support', TO_DATE('2023-11-01', 'YYYY-MM-DD'), TO_DATE('2025-10-31', 'YYYY-MM-DD'), 4000);

-- Project 140
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (140, 1002, 'Community garden project', TO_DATE('2024-09-15', 'YYYY-MM-DD'), TO_DATE('2024-12-15', 'YYYY-MM-DD'), 1500);

-- Project 150
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (150, 1003, 'Women empowerment workshops', TO_DATE('2022-09-01', 'YYYY-MM-DD'), TO_DATE('2024-11-30', 'YYYY-MM-DD'), 7800);

-- Project 160
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (160, 1004, 'Healthcare for underprivileged', TO_DATE('2024-10-01', 'YYYY-MM-DD'), TO_DATE('2025-09-30', 'YYYY-MM-DD'), 4000);

-- Project 170
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (170, 1005, 'Animal welfare awareness campaign', TO_DATE('2024-11-15', 'YYYY-MM-DD'), TO_DATE('2024-12-15', 'YYYY-MM-DD'), 1200);

-- Project 180
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (180, 1006, 'Youth sports development', TO_DATE('2022-08-15', 'YYYY-MM-DD'), TO_DATE('2025-08-15', 'YYYY-MM-DD'), 3000);

-- Project 190
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (190, 1007, 'Disaster relief support', TO_DATE('2024-06-01', 'YYYY-MM-DD'), TO_DATE('2024-12-31', 'YYYY-MM-DD'), 8000);

-- Project 200
INSERT INTO projects (project_id, organization_id, title, start_date, end_date, budget)
VALUES (200, 1008, 'Elderly care program', TO_DATE('2022-09-15', 'YYYY-MM-DD'), TO_DATE('2025-09-15', 'YYYY-MM-DD'), 3500);
 
-- Assignment 1010
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1010, 10, 5, 'Beach cleaning', DATE '2024-04-29', 'in progress');

-- Assignment 1020
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1020, 20, 3, 'Event planning', DATE '2024-05-05', 'pending');

-- Assignment 1030
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1030, 30, 5, 'Senior care support', DATE '2024-05-10', 'completed');

-- Assignment 1040
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1040, 40, 3, 'Event setup', DATE '2024-05-15', 'pending');

-- Assignment 1050
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1050, 20, 4, 'Data collection', DATE '2024-05-20', 'in progress');

-- Assignment 1060
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1060, 130, 5, 'Coordination', DATE '2024-05-25', 'pending');

-- Assignment 1070
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1070, 20, 12, 'Volunteer coordination', DATE '2024-05-30', 'completed');

-- Assignment 1080
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1080, 140, 7, 'Resource procurement', DATE '2024-06-05', 'pending');

-- Assignment 1090
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1090, 20, 8, 'Poster design', DATE '2024-06-10', 'completed');

-- Assignment 1100
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1100, 200, 6, 'Organizing', DATE '2024-06-15', 'in progress');

-- Assignment 1110
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1110, 20, 10, 'Photography', DATE '2024-06-20', 'pending');

-- Assignment 1120
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1120, 160, 4, 'Videography', DATE '2024-06-25', 'completed');

-- Assignment 1130
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1130, 190, 3, 'Community engagement', DATE '2024-06-30', 'in progress');

-- Assignment 1140
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1140, 150, 4, 'Task1', DATE '2024-07-05', 'pending');

-- Assignment 1150
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1150, 170, 11, 'Budget management', DATE '2024-07-10', 'completed');

-- Assignment 1160
INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1160, 30, 12, 'Sponsor coordination', DATE '2024-07-15', 'in progress');

-- Feedback 4
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (4, 20, 'The event was well organized. Thank you!');

-- Feedback 5
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (5, 30, 'Great project! Enjoyed participating');

-- Feedback 1
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (1, 10, 'Exhausting work but nice company');

-- Feedback 2
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (2, 30, 'Looking forward to participating again');

-- Feedback 3
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (3, 40, 'Great experience, would love to volunteer again!');

-- Feedback 6
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (6, 50, 'It was rewarding to be part of this project.');

-- Feedback 7
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (7, 60, 'Excellent organization and impactful project.');

-- Feedback 8
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (8, 70, 'I learned a lot from this experience.');

-- Feedback 9
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (9, 80, 'It was amazing to see the community come together.');

-- Feedback 10
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (10, 90, 'The support we provided made a real difference.');

-- Feedback 11
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (11, 100, 'A fulfilling experience, would recommend to everyone.');

-- Feedback 12
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (12, 110, 'This project has a real impact on the environment, proud to be a part of it.');

-- Feedback 13
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (13, 120, 'The renovated shelter looks amazing, glad to have contributed.');

-- Feedback 14
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (14, 130, 'The education support provided by this project is invaluable.');

-- Feedback 15
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (15, 140, 'The community garden project brought people together and beautified the neighborhood.');

-- Feedback 16
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (16, 150, 'Empowering women is essential, this project is making a real difference.');

-- Feedback 17
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (17, 160, 'This healthcare project is vital for our community.');

-- Feedback 18
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (18, 170, 'The animal welfare campaign raised much-needed awareness.');

-- Feedback 19
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (19, 180, 'The youth sports program helped keep kids off the streets and engaged.');

-- Feedback 20
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (20, 190, 'The disaster relief support provided was prompt and effective.');

-- Feedback 21
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (21, 200, 'The elderly care program is making a real difference in the lives of seniors.');

-- Feedback 22
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (22, 10, 'It was a great experience to be part of the beach cleaning project.');



-- Feedback 23
INSERT INTO feedback (feedback_id, project_id, feedback_text)
VALUES (23, 30, 'I enjoyed every moment of volunteering for the senior care support project.');