data_insertion.sql

-- ======================
-- DUMMY DATA INSERTS
-- ======================

-- Admin
INSERT INTO Admin (Admin_ID, Admin_Name, Admin_Mobile, Admin_Password) VALUES
(1, 'Rushil', '1894849649', 'strongpass123'),
(2, 'Mohit', '9876936589', 'securepwd456'),
(3, 'Nihar', '1398856421', 'mypassword789'),
(4, 'Amit', '1234567890', 'adminpass001'),
(5, 'Sara', '2345678901', 'adminpass002'),
(6, 'Lara', '3456789012', 'adminpass003'),
(7, 'David', '4567890123', 'adminpass004'),
(8, 'Maya', '5678901234', 'adminpass005'),
(9, 'Paul', '6789012345', 'adminpass006'),
(10, 'Linda', '7890123456', 'adminpass007'),
(11, 'John', '8901234567', 'adminpass008'),
(12, 'Emma', '9012345678', 'adminpass009'),
(13, 'Chris', '9123456789', 'adminpass010'),
(14, 'Olivia', '9234567890', 'adminpass011'),
(15, 'Sophia', '9345678901', 'adminpass012'),
(16, 'James', '9456789012', 'adminpass013'),
(17, 'Isabella', '9567890123', 'adminpass014'),
(18, 'Mason', '9678901234', 'adminpass015'),
(19, 'Ella', '9789012345', 'adminpass016'),
(20, 'Jacob', '9890123456', 'adminpass017');

-- Company
INSERT INTO Company (Company_Name, Company_Address, Company_ContactPerson, Company_Mobile) VALUES
('Company1', 'Spring Street', 'Alice Brown', '4986153288'),
('Company2', 'Senator Street', 'Bob Martin', '6238966499'),
('Company3', 'Sand Hill Street', 'Cathy Lee', '6132644829'),
('Company4', 'Walnut Street', 'David Smith', '9366339890'),
('Company5', 'Main Street', 'Evelyn Clark', '3284995852'),
('Company6', 'Oak Avenue', 'Frank Moore', '4567891234'),
('Company7', 'Maple Road', 'Grace Kim', '5678912345'),
('Company8', 'Pine Lane', 'Henry Lee', '6789123456'),
('Company9', 'Elm Street', 'Isabel Nguyen', '7891234567'),
('Company10', 'Cedar Drive', 'Jack White', '8912345678'),
('Company11', 'Birch Boulevard', 'Kate Green', '9123456789'),
('Company12', 'Aspen Way', 'Liam Scott', '9234567890'),
('Company13', 'Chestnut Circle', 'Mia Young', '9345678901'),
('Company14', 'Willow Court', 'Noah King', '9456789012'),
('Company15', 'Poplar Place', 'Olivia Adams', '9567890123'),
('Company16', 'Fir Terrace', 'Peter Turner', '9678901234'),
('Company17', 'Spruce Path', 'Quinn Baker', '9789012345'),
('Company18', 'Hemlock Alley', 'Rachel Hall', '9890123456'),
('Company19', 'Cottonwood Way', 'Samuel Evans', '9901234567'),
('Company20', 'Sycamore Street', 'Tina Perez', '9912345678');

-- Medicine
INSERT INTO Medicine (Medicine_SlotID, Medicine_Name, Medicine_Detail, Medicine_Price, Company_Name, Medicine_ExpiryDate) VALUES
(101, 'Paracetamol', 'Pain relief medicine', 5.50, 'Company1', '2026-12-31'),
(102, 'Amoxicillin', 'Antibiotic medicine', 12.00, 'Company2', '2025-08-30'),
(103, 'Cetirizine', 'Allergy relief', 7.25, 'Company3', '2027-03-15'),
(104, 'Ibuprofen', 'Anti-inflammatory', 6.75, 'Company4', '2025-11-10'),
(105, 'Vitamin C', 'Dietary supplement', 10.00, 'Company5', '2028-01-01'),
(106, 'Aspirin', 'Blood thinner', 8.50, 'Company6', '2026-04-20'),
(107, 'Metformin', 'Diabetes medication', 15.00, 'Company7', '2027-09-10'),
(108, 'Loratadine', 'Allergy relief', 9.25, 'Company8', '2026-05-15'),
(109, 'Omeprazole', 'Acid reducer', 14.00, 'Company9', '2025-12-31'),
(110, 'Simvastatin', 'Cholesterol control', 20.00, 'Company10', '2027-07-30'),
(111, 'Hydrocortisone', 'Steroid cream', 11.50, 'Company11', '2028-10-05'),
(112, 'Prednisone', 'Anti-inflammatory', 13.00, 'Company12', '2027-06-25'),
(113, 'Levothyroxine', 'Thyroid hormone', 18.75, 'Company13', '2026-09-15'),
(114, 'Azithromycin', 'Antibiotic', 17.00, 'Company14', '2025-10-20'),
(115, 'Clindamycin', 'Antibiotic', 16.50, 'Company15', '2026-03-12'),
(116, 'Furosemide', 'Diuretic', 12.25, 'Company16', '2027-01-01'),
(117, 'Gabapentin', 'Neuropathic pain', 22.00, 'Company17', '2027-11-20'),
(118, 'Melatonin', 'Sleep aid', 9.50, 'Company18', '2028-04-10'),
(119, 'Doxycycline', 'Antibiotic', 15.75, 'Company19', '2026-02-28'),
(120, 'Tamsulosin', 'Urinary retention', 21.00, 'Company20', '2027-08-15');

-- Employee
INSERT INTO Employee (Employee_ID, Employee_Name, Employee_Mobile, Employee_Salary) VALUES
(201, 'John Doe', '5551234567', 45000),
(202, 'Jane Smith', '5559876543', 47000),
(203, 'Mike Johnson', '5557654321', 50000),
(204, 'Emily Davis', '5554567890', 48000),
(205, 'David Wilson', '5552345678', 51000),
(206, 'Linda Brown', '5553456789', 46000),
(207, 'James Taylor', '5556789012', 52000),
(208, 'Patricia Miller', '5557890123', 49000),
(209, 'Robert Anderson', '5558901234', 47000),
(210, 'Jennifer Thomas', '5559012345', 53000),
(211, 'Michael Jackson', '5550123456', 54000),
(212, 'Mary White', '5551230987', 45000),
(213, 'William Harris', '5552340987', 55000),
(214, 'Elizabeth Martin', '5553450987', 56000),
(215, 'Richard Thompson', '5554560987', 57000),
(216, 'Barbara Garcia', '5555670987', 58000),
(217, 'Charles Martinez', '5556780987', 59000),
(218, 'Susan Robinson', '5557890987', 60000),
(219, 'Joseph Clark', '5558900987', 61000),
(220, 'Sarah Rodriguez', '5559010987', 62000);

-- Customer
INSERT INTO Customer (Customer_ID, Customer_Name, Customer_Mobile, Bill_BillNo) VALUES
(1, 'Joseph', '4632984629', 'B12'),
(2, 'Penny', '9761534978', 'B13'),
(3, 'Sheldon', '6318496255', 'B14'),
(4, 'Leonard', '9788881538', 'B15'),
(5, 'Yash', '5297894548', 'B16'),
(6, 'Raj', '7984635598', 'B17'),
(7, 'Rajesh', '6446589213', 'B18'),
(8, 'Kiren', '8879825415', 'B19'),
(9, 'Megan', '3658945288', 'B20'),
(10, 'Diana', '9649955589', 'B21'),
(11, 'Oliver', '5512345678', 'B22'),
(12, 'Amelia', '5523456789', 'B23'),
(13, 'Ethan', '5534567890', 'B24'),
(14, 'Ava', '5545678901', 'B25'),
(15, 'Mason', '5556789012', 'B26'),
(16, 'Sophia', '5567890123', 'B27'),
(17, 'Logan', '5578901234', 'B28'),
(18, 'Isabella', '5589012345', 'B29'),
(19, 'Lucas', '5590123456', 'B30'),
(20, 'Mia', '5501234567', 'B31');

-- Purchase
INSERT INTO Purchase (Bill_BillNo, Medicine_Price, Medicine_Quantity, Medicine_Name, Company_Name, Bill_Total) VALUES
('B12', 5.50, 2, 'Paracetamol', 'Company1', 11.00),
('B13', 12.00, 1, 'Amoxicillin', 'Company2', 12.00),
('B14', 7.25, 3, 'Cetirizine', 'Company3', 21.75),
('B15', 6.75, 4, 'Ibuprofen', 'Company4', 27.00),
('B16', 10.00, 1, 'Vitamin C', 'Company5', 10.00),
('B17', 8.50, 5, 'Aspirin', 'Company6', 42.50),
('B18', 15.00, 2, 'Metformin', 'Company7', 30.00),
('B19', 9.25, 1, 'Loratadine', 'Company8', 9.25),
('B20', 14.00, 3, 'Omeprazole', 'Company9', 42.00),
('B21', 20.00, 1, 'Simvastatin', 'Company10', 20.00),
('B22', 11.50, 2, 'Hydrocortisone', 'Company11', 23.00),
('B23', 13.00, 3, 'Prednisone', 'Company12', 39.00),
('B24', 18.75, 1, 'Levothyroxine', 'Company13', 18.75),
('B25', 17.00, 4, 'Azithromycin', 'Company14', 68.00),
('B26', 16.50, 2, 'Clindamycin', 'Company15', 33.00),
('B27', 12.25, 5, 'Furosemide', 'Company16', 61.25),
('B28', 22.00, 1, 'Gabapentin', 'Company17', 22.00),
('B29', 9.50, 3, 'Melatonin', 'Company18', 28.50),
('B30', 15.75, 2, 'Doxycycline', 'Company19', 31.50),
('B31', 21.00, 1, 'Tamsulosin', 'Company20', 21.00);

-- Pharmacy
INSERT INTO Pharmacy (PhID, Name, City, Fax, Phone) VALUES
(1, 'City Pharmacy', 'New York', '2125551234', '2125555678'),
(2, 'HealthPlus', 'Los Angeles', '3105551234', '3105555678'),
(3, 'WellCare', 'Chicago', '3125551234', '3125555678'),
(4, 'GoodHealth', 'Houston', '7135551234', '7135555678'),
(5, 'FamilyMed', 'Phoenix', '6025551234', '6025555678'),
(6, 'CarePlus', 'Philadelphia', '2155551234', '2155555678'),
(7, 'MediTrust', 'San Antonio', '2105551234', '2105555678'),
(8, 'HealthFirst', 'San Diego', '6195551234', '6195555678'),
(9, 'LifeCare', 'Dallas', '2145551234', '2145555678'),
(10, 'WellnessPharma', 'San Jose', '4085551234', '4085555678'),
(11, 'PrimeCare', 'Austin', '5125551234', '5125555678'),
(12, 'Medix', 'Jacksonville', '9045551234', '9045555678'),
(13, 'CareWell', 'Fort Worth', '8175551234', '8175555678'),
(14, 'TotalHealth', 'Columbus', '6145551234', '6145555678'),
(15, 'QuickMed', 'Charlotte', '7045551234', '7045555678'),
(16, 'AllHealth', 'San Francisco', '4155551234', '4155555678'),
(17, 'CarePoint', 'Indianapolis', '3175551234', '3175555678'),
(18, 'MediHelp', 'Seattle', '2065551234', '2065555678'),
(19, 'HealthWay', 'Denver', '3035551234', '3035555678'),
(20, 'PharmaPlus', 'Washington', '2025551234', '2025555678');

-- Doctor
INSERT INTO Doctor (DID, DName, Speciality, Age, Mobile, Gender) VALUES
(1, 'Dr. Alice Green', 'Cardiology', 45, '5551002000', 'Female'),
(2, 'Dr. Bob White', 'Neurology', 50, '5551003000', 'Male'),
(3, 'Dr. Carol Black', 'Pediatrics', 38, '5551004000', 'Female'),
(4, 'Dr. David Brown', 'Dermatology', 42, '5551005000', 'Male'),
(5, 'Dr. Emily Davis', 'Oncology', 55, '5551006000', 'Female'),
(6, 'Dr. Frank Wilson', 'Gastroenterology', 47, '5551007000', 'Male'),
(7, 'Dr. Grace Lee', 'Orthopedics', 43, '5551008000', 'Female'),
(8, 'Dr. Henry Martin', 'Psychiatry', 39, '5551009000', 'Male'),
(9, 'Dr. Irene Clark', 'Endocrinology', 46, '5551010000', 'Female'),
(10, 'Dr. Jack Lewis', 'Nephrology', 48, '5551011000', 'Male'),
(11, 'Dr. Karen Walker', 'Ophthalmology', 44, '5551012000', 'Female'),
(12, 'Dr. Larry Hall', 'Rheumatology', 52, '5551013000', 'Male'),
(13, 'Dr. Monica Young', 'Urology', 41, '5551014000', 'Female'),
(14, 'Dr. Nathan Scott', 'Pulmonology', 49, '5551015000', 'Male'),
(15, 'Dr. Olivia Adams', 'Hematology', 53, '5551016000', 'Female'),
(16, 'Dr. Peter Baker', 'Allergy', 37, '5551017000', 'Male'),
(17, 'Dr. Quinn Turner', 'Infectious Disease', 50, '5551018000', 'Female'),
(18, 'Dr. Rachel Hall', 'Immunology', 42, '5551019000', 'Female'),
(19, 'Dr. Samuel Evans', 'Neurology', 45, '5551020000', 'Male'),
(20, 'Dr. Tina Perez', 'Cardiology', 40, '5551021000', 'Female');

-- Customer_P
INSERT INTO Customer_P (PID, Name, Sex, City, Phone, Age, DID) VALUES
(1, 'Emily Clark', 'Female', 'New York', '5551112222', 30, 1),
(2, 'James Brown', 'Male', 'Los Angeles', '5553334444', 40, 2),
(3, 'Samantha Green', 'Female', 'Chicago', '5555556666', 28, 3),
(4, 'Michael Johnson', 'Male', 'Houston', '5557778888', 50, 4),
(5, 'Laura Martinez', 'Female', 'Phoenix', '5559990000', 35, 5),
(6, 'Brian Lee', 'Male', 'Philadelphia', '5552223333', 45, 6),
(7, 'Jessica Kim', 'Female', 'San Antonio', '5554445555', 27, 7),
(8, 'Kevin White', 'Male', 'San Diego', '5556667777', 38, 8),
(9, 'Sarah Lopez', 'Female', 'Dallas', '5558889999', 33, 9),
(10, 'David Clark', 'Male', 'San Jose', '5550001111', 42, 10),
(11, 'Rachel Adams', 'Female', 'Austin', '5551112223', 29, 11),
(12, 'Paul Walker', 'Male', 'Jacksonville', '5553334445', 46, 12),
(13, 'Megan Scott', 'Female', 'Fort Worth', '5555556667', 31, 13),
(14, 'Eric Baker', 'Male', 'Columbus', '5557778889', 39, 14),
(15, 'Angela Turner', 'Female', 'Charlotte', '5559990001', 34, 15),
(16, 'Ryan Evans', 'Male', 'San Francisco', '5552223334', 41, 16),
(17, 'Stephanie Perez', 'Female', 'Indianapolis', '5554445556', 36, 17),
(18, 'Mark Hall', 'Male', 'Seattle', '5556667778', 43, 18),
(19, 'Kimberly Lewis', 'Female', 'Denver', '5558889990', 30, 19),
(20, 'Jason King', 'Male', 'Washington', '5550001112', 44, 20);

-- Manufacturer
INSERT INTO Manufacturer (CID, Name, Email, Mobile, City, PharID) VALUES
(1, 'MedSupply Co.', 'contact@medsupply.com', '5552223333', 'New York', 1),
(2, 'HealthCorp', 'info@healthcorp.com', '5554445555', 'Los Angeles', 2),
(3, 'PharmaPlus', 'sales@pharmaplus.com', '5556667777', 'Chicago', 3),
(4, 'WellnessMeds', 'contact@wellnessmeds.com', '5558889999', 'Houston', 4),
(5, 'CareMeds', 'info@caremeds.com', '5551112222', 'Phoenix', 5),
(6, 'MediTrust', 'support@meditrust.com', '5553334444', 'Philadelphia', 6),
(7, 'GlobalPharma', 'sales@globalpharma.com', '5555556666', 'San Antonio', 7),
(8, 'HealthWay', 'contact@healthway.com', '5557778888', 'San Diego', 8),
(9, 'LifeCare', 'info@lifecare.com', '5559990000', 'Dallas', 9),
(10, 'PrimeMeds', 'support@primemeds.com', '5552221111', 'San Jose', 10),
(11, 'TotalHealth', 'sales@totalhealth.com', '5553332222', 'Austin', 11),
(12, 'CarePoint', 'contact@carepoint.com', '5554443333', 'Jacksonville', 12),
(13, 'MediHelp', 'info@medihelp.com', '5555554444', 'Fort Worth', 13),
(14, 'HealthPlus', 'support@healthplus.com', '5556665555', 'Columbus', 14),
(15, 'PharmaWorks', 'sales@pharmaworks.com', '5557776666', 'Charlotte', 15),
(16, 'MediSource', 'contact@medisource.com', '5558887777', 'San Francisco', 16),
(17, 'Global Supplies', 'info@globalsupplies.com', '5559998888', 'Indianapolis', 17),
(18, 'CareWell', 'support@carewell.com', '5552229999', 'Seattle', 18),
(19, 'WellCare', 'sales@wellcare.com', '5553339999', 'Denver', 19),
(20, 'QuickMed', 'contact@quickmed.com', '5554449999', 'Washington', 20);

-- MediEquipment
INSERT INTO MediEquipment (Code, Trade_Name, Product_Type, Mfg_Date, Exp_Date, Price, CID) VALUES
(1001, 'X-Ray Machine', 'Diagnostic', '2022-01-10', '2027-01-09', 50000.00, 1),
(1002, 'ECG Monitor', 'Monitoring', '2023-05-15', '2028-05-14', 15000.00, 2),
(1003, 'Ultrasound Device', 'Imaging', '2021-07-20', '2026-07-19', 35000.00, 3),
(1004, 'MRI Scanner', 'Imaging', '2020-03-25', '2025-03-24', 120000.00, 4),
(1005, 'Defibrillator', 'Emergency', '2022-11-11', '2027-11-10', 8000.00, 5),
(1006, 'Ventilator', 'Respiratory', '2023-01-05', '2028-01-04', 45000.00, 6),
(1007, 'Syringe Pump', 'Infusion', '2021-09-15', '2026-09-14', 3000.00, 7),
(1008, 'Pulse Oximeter', 'Monitoring', '2022-05-10', '2027-05-09', 2000.00, 8),
(1009, 'Anesthesia Machine', 'Surgical', '2020-12-01', '2025-11-30', 60000.00, 9),
(1010, 'Patient Monitor', 'Monitoring', '2023-04-20', '2028-04-19', 25000.00, 10),
(1011, 'Surgical Light', 'Surgical', '2021-06-07', '2026-06-06', 12000.00, 11),
(1012, 'Infusion Pump', 'Infusion', '2022-08-22', '2027-08-21', 4000.00, 12),
(1013, 'Blood Gas Analyzer', 'Diagnostic', '2020-10-30', '2025-10-29', 30000.00, 13),
(1014, 'Sterilizer', 'Sterilization', '2021-12-15', '2026-12-14', 7000.00, 14),
(1015, 'Incubator', 'Neonatal', '2023-02-18', '2028-02-17', 15000.00, 15),
(1016, 'Autoclave', 'Sterilization', '2022-07-01', '2027-06-30', 9000.00, 16),
(1017, 'ECG Electrodes', 'Monitoring', '2021-04-10', '2026-04-09', 500.00, 17),
(1018, 'Oxygen Concentrator', 'Respiratory', '2020-09-20', '2025-09-19', 3500.00, 18),
(1019, 'Hemodialysis Machine', 'Nephrology', '2022-03-05', '2027-03-04', 40000.00, 19),
(1020, 'Surgical Table', 'Surgical', '2021-11-25', '2026-11-24', 10000.00, 20);

-- Supplier
INSERT INTO Supplier (Name, City, Mobile, Email, CID, PharID) VALUES
('Global Supplies', 'New York', 5556667777, 'global@supplies.com', 1, 1),
('MediSource', 'Los Angeles', 5558889999, 'contact@medisource.com', 2, 2),
('HealthFirst', 'Chicago', 5557778888, 'sales@healthfirst.com', 3, 3),
('CareMeds', 'Houston', 5555556666, 'info@caremeds.com', 4, 4),
('MedEquip', 'Phoenix', 5554443333, 'support@medequip.com', 5, 5),
('PharmaLine', 'Philadelphia', 5553332222, 'contact@pharmaline.com', 6, 6),
('SafeHealth', 'San Antonio', 5552221111, 'sales@safehealth.com', 7, 7),
('BioMedix', 'San Diego', 5551110000, 'info@biomedix.com', 8, 8),
('MediHub', 'Dallas', 5550009999, 'support@medihub.com', 9, 9),
('MedChain', 'San Jose', 5559998888, 'sales@medchain.com', 10, 10),
('CarePoint', 'Austin', 5558887777, 'info@carepoint.com', 11, 11),
('MediQuick', 'Jacksonville', 5557776666, 'contact@mediquick.com', 12, 12),
('PharmaTech', 'Fort Worth', 5556665555, 'support@pharmatech.com', 13, 13),
('LifeSupply', 'Columbus', 5555554444, 'sales@lifesupply.com', 14, 14),
('MediTrust', 'Charlotte', 5554443333, 'info@meditrust.com', 15, 15),
('WellnessSupply', 'San Francisco', 5553332222, 'support@wellnesssupply.com', 16, 16),
('GlobalMed', 'Indianapolis', 5552221111, 'contact@globalmed.com', 17, 17),
('HealthWay', 'Seattle', 5551110000, 'info@healthway.com', 18, 18),
('QuickMed', 'Denver', 5550009999, 'sales@quickmed.com', 19, 19),
('TotalHealth', 'Washington', 5559998888, 'support@totalhealth.com', 20, 20);

-- Employee_P
INSERT INTO Employee_P (Name, City, DOJ, Mobile, Salary, Age, Sex, PharID) VALUES
('Emily Smith', 'New York', '2020-01-15', '5551234567', 55000, 29, 'F', 1),
('John Doe', 'Los Angeles', '2019-03-20', '5552345678', 60000, 35, 'M', 2),
('Sarah Johnson', 'Chicago', '2021-06-10', '5553456789', 52000, 26, 'F', 3),
('Michael Brown', 'Houston', '2018-11-05', '5554567890', 65000, 38, 'M', 4),
('Jessica Lee', 'Phoenix', '2020-08-12', '5555678901', 58000, 31, 'F', 5),
('David Wilson', 'Philadelphia', '2017-09-30', '5556789012', 62000, 40, 'M', 6),
('Ashley Davis', 'San Antonio', '2022-02-01', '5557890123', 54000, 28, 'F', 7),
('James Martinez', 'San Diego', '2016-04-18', '5558901234', 67000, 42, 'M', 8),
('Amanda Garcia', 'Dallas', '2023-05-10', '5559012345', 51000, 25, 'F', 9),
('Robert Miller', 'San Jose', '2015-07-25', '5550123456', 70000, 45, 'M', 10),
('Emily Thomas', 'Austin', '2020-03-14', '5550987654', 56000, 30, 'F', 11),
('William Taylor', 'Jacksonville', '2019-12-22', '5551122334', 63000, 37, 'M', 12),
('Olivia Moore', 'Fort Worth', '2021-01-09', '5552233445', 52000, 27, 'F', 13),
('Daniel Anderson', 'Columbus', '2018-06-11', '5553344556', 66000, 39, 'M', 14),
('Sophia Jackson', 'Charlotte', '2017-08-17', '5554455667', 59000, 32, 'F', 15),
('Matthew White', 'San Francisco', '2022-04-05', '5555566778', 64000, 36, 'M', 16),
('Isabella Harris', 'Indianapolis', '2016-10-21', '5556677889', 50000, 24, 'F', 17),
('Joseph Martin', 'Seattle', '2023-07-19', '5557788990', 71000, 46, 'M', 18),
('Mia Thompson', 'Denver', '2020-11-30', '5558899001', 53000, 29, 'F', 19),
('Christopher Garcia', 'Washington', '2019-05-15', '5559900112', 68000, 41, 'M', 20);

-- Hospital
INSERT INTO Hospital (Hospital_ID, Hospital_Name, Location, Phone, Email)
VALUES
(1, 'CityCare Hospital', 'New York', 2121112222, 'info@citycare.com'),
(2, 'HealthPlus Center', 'Los Angeles', 3102223333, 'contact@healthplus.com'),
(3, 'MetroHealth Clinic', 'Chicago', 7733334444, 'admin@metrohealth.com'),
(4, 'Wellness Hospital', 'Houston', 7134445555, 'support@wellness.com'),
(5, 'Sunrise Medical', 'Phoenix', 6025556666, 'info@sunrise.com'),
(6, 'Trinity Care', 'Philadelphia', 2156667777, 'contact@trinity.com'),
(7, 'Evergreen Hospital', 'San Antonio', 2107778888, 'admin@evergreen.com'),
(8, 'Hope Clinic', 'San Diego', 6198889999, 'info@hopeclinic.com'),
(9, 'Cure Hospital', 'Dallas', 2149990000, 'support@cure.com'),
(10, 'HealWell Center', 'San Jose', 4080001111, 'contact@healwell.com'),
(11, 'NorthStar Medical', 'Austin', 5121112222, 'info@northstar.com'),
(12, 'Bright Health', 'Jacksonville', 9042223333, 'admin@brighthealth.com'),
(13, 'Lifeline Hospital', 'Fort Worth', 8173334444, 'contact@lifeline.com'),
(14, 'Pioneer Hospital', 'Columbus', 6144445555, 'info@pioneer.com'),
(15, 'Nova Care', 'Charlotte', 9805556666, 'support@novacare.com'),
(16, 'MedStar Clinic', 'San Francisco', 6286667777, 'admin@medstar.com'),
(17, 'Unity Hospital', 'Indianapolis', 3177778888, 'contact@unity.com'),
(18, 'Pathway Medical', 'Seattle', 2068889999, 'info@pathway.com'),
(19, 'NewHope Hospital', 'Denver', 7209990000, 'support@newhope.com'),
(20, 'VitalCare Center', 'Washington', 2020001111, 'admin@vitalcare.com');

-- Bill
INSERT INTO Bill (Bill_ID, Customer_ID, Total_Amount, Payment_Mode, Bill_Date)
VALUES
(1, 1, 150.75, 'Credit Card', '2024-01-10'),
(2, 2, 200.00, 'Cash', '2024-01-12'),
(3, 3, 340.50, 'Online', '2024-01-14'),
(4, 4, 500.00, 'Credit Card', '2024-01-15'),
(5, 5, 120.20, 'Debit Card', '2024-01-18'),
(6, 6, 75.00, 'Cash', '2024-01-20'),
(7, 7, 230.40, 'Credit Card', '2024-01-21'),
(8, 8, 180.30, 'Online', '2024-01-23'),
(9, 9, 199.99, 'Cash', '2024-01-24'),
(10, 10, 210.00, 'Credit Card', '2024-01-25'),
(11, 11, 90.00, 'Cash', '2024-01-26'),
(12, 12, 300.00, 'Online', '2024-01-27'),
(13, 13, 60.50, 'Cash', '2024-01-28'),
(14, 14, 330.00, 'Credit Card', '2024-01-29'),
(15, 15, 245.60, 'Debit Card', '2024-01-30'),
(16, 16, 120.99, 'Cash', '2024-01-31'),
(17, 17, 500.00, 'Online', '2024-02-01'),
(18, 18, 95.00, 'Credit Card', '2024-02-02'),
(19, 19, 310.10, 'Cash', '2024-02-03'),
(20, 20, 410.00, 'Debit Card', '2024-02-04');

-- Works
INSERT INTO Works (Employee_ID, Pharmacy_ID, Role)
VALUES
(1, 1, 'Pharmacist'),
(2, 2, 'Manager'),
(3, 3, 'Cashier'),
(4, 4, 'Technician'),
(5, 5, 'Pharmacist'),
(6, 6, 'Cashier'),
(7, 7, 'Manager'),
(8, 8, 'Technician'),
(9, 9, 'Pharmacist'),
(10, 10, 'Manager'),
(11, 11, 'Technician'),
(12, 12, 'Pharmacist'),
(13, 13, 'Cashier'),
(14, 14, 'Manager'),
(15, 15, 'Technician'),
(16, 16, 'Pharmacist'),
(17, 17, 'Cashier'),
(18, 18, 'Manager'),
(19, 19, 'Technician'),
(20, 20, 'Pharmacist');

-- Contract
INSERT INTO Contract (Contract_ID, Supplier_ID, Hospital_ID, Start_Date, End_Date)
VALUES
(1, 1, 1, '2023-01-01', '2024-01-01'),
(2, 2, 2, '2023-02-01', '2024-02-01'),
(3, 3, 3, '2023-03-01', '2024-03-01'),
(4, 4, 4, '2023-04-01', '2024-04-01'),
(5, 5, 5, '2023-05-01', '2024-05-01'),
(6, 6, 6, '2023-06-01', '2024-06-01'),
(7, 7, 7, '2023-07-01', '2024-07-01'),
(8, 8, 8, '2023-08-01', '2024-08-01'),
(9, 9, 9, '2023-09-01', '2024-09-01'),
(10, 10, 10, '2023-10-01', '2024-10-01'),
(11, 11, 11, '2023-11-01', '2024-11-01'),
(12, 12, 12, '2023-12-01', '2024-12-01'),
(13, 13, 13, '2024-01-01', '2025-01-01'),
(14, 14, 14, '2024-02-01', '2025-02-01'),
(15, 15, 15, '2024-03-01', '2025-03-01'),
(16, 16, 16, '2024-04-01', '2025-04-01'),
(17, 17, 17, '2024-05-01', '2025-05-01'),
(18, 18, 18, '2024-06-01', '2025-06-01'),
(19, 19, 19, '2024-07-01', '2025-07-01'),
(20, 20, 20, '2024-08-01', '2025-08-01');

-- Prescribe
INSERT INTO Prescribe (Doctor_ID, Customer_ID, Medicine_ID, Date)
VALUES
(1, 1, 1, '2024-01-01'),
(2, 2, 2, '2024-01-02'),
(3, 3, 3, '2024-01-03'),
(4, 4, 4, '2024-01-04'),
(5, 5, 5, '2024-01-05'),
(6, 6, 6, '2024-01-06'),
(7, 7, 7, '2024-01-07'),
(8, 8, 8, '2024-01-08'),
(9, 9, 9, '2024-01-09'),
(10, 10, 10, '2024-01-10'),
(11, 11, 11, '2024-01-11'),
(12, 12, 12, '2024-01-12'),
(13, 13, 13, '2024-01-13'),
(14, 14, 14, '2024-01-14'),
(15, 15, 15, '2024-01-15'),
(16, 16, 16, '2024-01-16'),
(17, 17, 17, '2024-01-17'),
(18, 18, 18, '2024-01-18'),
(19, 19, 19, '2024-01-19'),
(20, 20, 20, '2024-01-20');