CREATE TABLE contact_details (
    contact_id INTEGER PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    address VARCHAR(255),
    email VARCHAR(255),
    phone_number VARCHAR(255)
);

CREATE TABLE volunteers (
    volunteer_id INTEGER PRIMARY KEY,
    contact_id INTEGER NOT NULL,
    experience_years INTEGER NOT NULL,
    FOREIGN KEY (contact_id) REFERENCES contact_details(contact_id)
);

CREATE TABLE organizations (
    organization_id INTEGER PRIMARY KEY,
    organization_type VARCHAR(255),
    contact_id INTEGER NOT NULL,
    FOREIGN KEY (contact_id) REFERENCES contact_details(contact_id)
);

CREATE TABLE projects (
    project_id INTEGER PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    organization_id INTEGER NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL,
    budget REAL,
    FOREIGN KEY (organization_id) REFERENCES organizations(organization_id)
);

CREATE TABLE assignments (
    assignment_id INTEGER PRIMARY KEY,
    volunteer_id INTEGER NOT NULL,
    project_id INTEGER NOT NULL,
    assignment_date DATE NOT NULL,
    title VARCHAR(255) NOT NULL,
    status VARCHAR(255),
    FOREIGN KEY (volunteer_id) REFERENCES volunteers(volunteer_id),
    FOREIGN KEY (project_id) REFERENCES projects(project_id)
);

CREATE TABLE feedback (
    feedback_id INTEGER PRIMARY KEY,
    project_id INTEGER NOT NULL,
    feedback_text VARCHAR(255),
    FOREIGN KEY (project_id) REFERENCES projects(project_id)
);



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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



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

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

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

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

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

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

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

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

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

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



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

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

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

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

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

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

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

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

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

INSERT INTO organizations (organization_id, organization_type, contact_id)
VALUES (1009, 'Community service organization', 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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);



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');

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

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');

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

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');

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

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

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

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

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

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

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

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');

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

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

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');

INSERT INTO assignments (assignment_id, project_id, volunteer_id, title, assignment_date, status)
VALUES (1170, 30, 7, 'Budget management', DATE '2024-09-12', 'pending');


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

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

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

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

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

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

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

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

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

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

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

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.');

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

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

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

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

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

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

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

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

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.');

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.');

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