Clinic_Info ============
INSERT INTO Clinic_Info (clinic_id, clinic_name, registration_no,
address,motto,tin_number, last_renew, last_aduit, phone_no, email)
VALUES (1281000,'LIFE CARE CLINIC',159357, '271 Green Road','we take care our
patients health',852654, '01-Dec-2020','06-May-
2022','+13454600','
[email protected]');
Departments =============
INSERT INTO Departments (department_id,department_name)
VALUES (201,'physician');
INSERT INTO Departments (department_id,department_name)
VALUES (202,'Immunologists');
INSERT INTO Departments (department_id,department_name)
VALUES (203,'Anesthesiologists');
INSERT INTO Departments (department_id,department_name)
VALUES (204,'Cardiologists');
INSERT INTO Departments (department_id,department_name)
VALUES (205,'Critical Care Medicine Specialists');
INSERT INTO Departments (department_id,department_name)
VALUES (206,'Dermatologists');
INSERT INTO Departments (department_id,department_name)
VALUES (207,'Endocrinologists');
INSERT INTO Departments (department_id,department_name)
VALUES (208,'Emergency Medicine Specialists');
INSERT INTO Departments (department_id,department_name)
VALUES (209,'Gastroenterologists');
INSERT INTO Departments (department_id,department_name)
VALUES (210,'Hematologists');
INSERT INTO Departments (department_id,department_name)
VALUES (211,'Neurologists');
INSERT INTO Departments (department_id,department_name)
VALUES (212,'Ophthalmologists');
INSERT INTO Departments (department_id,department_name)
VALUES (213,'Pathologists');
INSERT INTO Departments (department_id,department_name)
VALUES (214,'Radiologists');
INSERT INTO Departments (department_id,department_name)
VALUES (215,'General Surgeons');
INSERT INTO Departments (department_id,department_name)
VALUES (216,'Urologists');
JOBS ==============
INSERT INTO JOBS (Job_id,Job_title)
VALUES (601,'Doctor');
INSERT INTO JOBS (Job_id,Job_title)
VALUES (602,'Nurse');
INSERT INTO JOBS (Job_id,Job_title)
VALUES (603,'Accountant');
INSERT INTO JOBS (Job_id,Job_title)
VALUES (604,'Cliner');
INSERT INTO JOBS (Job_id,Job_title)
VALUES (605,'Receptionist');
INSERT INTO JOBS (Job_id,Job_title)
VALUES (604,'clinical assistants');
Employees =============
INSERT INTO Employees
(employee_id,job_id,employee_name,email,hire_date,mobile_no,salary,comm_pct,fathers
_name,mothers_name,marital_status)
VALUES (101,601,'Alex','
[email protected]','01-Jan-
2020',01515641785,35000,0.2,'Alexgender','Maria','Single');
INSERT INTO Employees
(employee_id,job_id,employee_name,email,hire_date,mobile_no,salary,comm_pct,fathers
_name,mothers_name,marital_status)
VALUES (102,602'Zahed','
[email protected]','05-April-
2021',01715641796,17000,0.3,'Ahmedullah','Sultana','Married');
INSERT INTO Employees
(employee_id,job_id,employee_name,email,hire_date,mobile_no,salary,comm_pct,fathers
_name,mothers_name,marital_status)
VALUES (103,603'Rafiq','
[email protected]','20-May-
2018',01765641787,22000,0.0,'Tarek','Khadija','Single');
INSERT INTO Employees
(employee_id,job_id,employee_name,email,hire_date,mobile_no,salary,comm_pct,fathers
_name,mothers_name,marital_status)
VALUES (104,604'Azhar','
[email protected]','01-Feb-
2024',01815641784,24000,0.5,'Tanvir','Sultana','Married');
ROOMS ===========
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (1,'Consultation', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (2,'Waiting', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (3,'Consultation', 2nd, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (4,'Consultation', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (5,'Waiting', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (6,'Consultation', 2nd, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (7,'Waiting', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (8,'Consultation', 2nd, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (9,'Consultation', 1st, );
INSERT INTO rooms (room_id, room_type, floor, employee_id )
VALUES (10,'Consultation', 1st, );
DEPARTMENT_ROOMS ===============
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (1, 1);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (2, 2);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (3, 3);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (4 ,4);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (5, 5);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (6, 6);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (7, 7);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (8, 8);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (9, 9);
INSERT INTO department_rooms (department_room_id,department_id, room_id)
VALUES (10, 10);
Doctor_Schedule =================
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (10,'Part-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (11,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (12,'Part-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (13,'Part-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (14,'Part-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (15,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (15,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (17,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (18,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (19,'Full-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
INSERT INTO doctor_schedule (schedule_id,doc_type,employee_id, schedule_date,
start_time, end_time, available)
VALUES (20,'Part-time', , DATE '2024-07-06', TIMESTAMP '2024-07-06 09:00:00',
TIMESTAMP '2024-07-06 17:00:00',1);
MEDICINE_CATEGORY ============
INSERT INTO medicine_category (m_category_id, m_category_name, description,
created_date, last_upd_date, availability)
VALUES (1, 'Painkillers', 'Medicines used to relieve pain.', SYSDATE, SYSDATE,
'Available');
INSERT INTO medicine_category (category_id, category_name, description,
created_date, last_upd_date, availability)
VALUES (2, 'Antibiotics', 'Medicines used to treat bacterial infections.', SYSDATE,
SYSDATE, 'Available');
Test_info ==========
insert into test_info
(test_id,test_name,t_category_id ,patient_id,employee_id,
test_cost,test_date,status,
result,precaution,default_value)
values(1,'Typhidot',1,10,100,500,'02-JULY-24',null,'Positive',null,null);
insert into test_info
(test_id,test_name,t_category_id ,patient_id,employee_id,
test_cost,test_date,status,
result,precaution,default_value)
values(2,'Hb%',2,20,101,300,'03-JULY-24',null,'Negative',null,null);
insert into test_info
(test_id,test_name,t_category_id ,patient_id,employee_id,
test_cost,test_date,status,
result,precaution,default_value)
values(3,'CBC',3,30,102,400,'05-JULY-24',null,'Negative',null,null);
insert into test_info
(test_id,test_name,t_category_id ,patient_id,employee_id,
test_cost,test_date,status,
result,precaution,default_value)
values(4,'Dengue Test',4,40,103,500,'06-JULY-24',null,'Negative',null,null);
insert into test_info
(test_id,test_name,t_category_id ,patient_id,employee_id,
test_cost,test_date,status,
result,precaution,default_value)
values(5,'Blood Urea Nitrogen (BUN)',5,50,104,600,'07-JULY-
24',null,'Negative',null,null);
Test_category ==============
insert into test_category
(T_CATEGORY_ID,T_CATEGORY_NAME,DESCRIPTION,CREATED_DATE,LAST_UPD_DATE,AVAILABILITY)
values(1,'Blood',null,'6-MAR-23',SYSDATE,'YES');
insert into test_category
(T_CATEGORY_ID,T_CATEGORY_NAME,DESCRIPTION,CREATED_DATE,LAST_UPD_DATE,AVAILABILITY)
values(2,'Thyroid function',null,'7-MAR-23',SYSDATE,'YES');
insert into test_category
(T_CATEGORY_ID,T_CATEGORY_NAME,DESCRIPTION,CREATED_DATE,LAST_UPD_DATE,AVAILABILITY)
values(3,'Thyroid function',null,'8-MAR-23',SYSDATE,'No');
insert into test_category
(T_CATEGORY_ID,T_CATEGORY_NAME,DESCRIPTION,CREATED_DATE,LAST_UPD_DATE,AVAILABILITY)
values(4,'toxicology',null,'8-MAR-23',SYSDATE,'No');
insert into test_category
(T_CATEGORY_ID,T_CATEGORY_NAME,DESCRIPTION,CREATED_DATE,LAST_UPD_DATE,AVAILABILITY)
values(5,'Hormone',null,'8-MAR-23',SYSDATE,'No');
setup ======
insert into setup
(setup_id,opd_tkt_value,created_date,last_upd_date)
values(1,20,'20-JAN-21','10-JAN-20');
insert into setup
(setup_id,opd_tkt_value,created_date,last_upd_date)
values(2,30,'20-JAN-21','10-JAN-21');
insert into setup
(setup_id,opd_tkt_value,created_date,last_upd_date)
values(3,40,'20-JAN-21','10-JAN-22');
insert into setup
(setup_id,opd_tkt_value,created_date,last_upd_date)
values(4,50,'20-JAN-21','10-JAN-23');
insert into setup
(setup_id,opd_tkt_value,created_date,last_upd_date)
values(5,60,'20-JAN-21','10-JAN-24');
supplier =========
insert into supplier
(supplier_id,supplier_name,address,phone_number,email)
values(10101,'Abel','mirpur-1','01730921414','abel@gmai');
insert into supplier
(supplier_id,supplier_name,address,phone_number,email)
values(10102,'King','mirpur-1','01730921415','king@gmai');
insert into supplier
(supplier_id,supplier_name,address,phone_number,email)
values(10103,'Cimi','mirpur-1','01730921416','cimi@gmai');
insert into supplier
(supplier_id,supplier_name,address,phone_number,email)
values(10104,'Kel','mirpur-1','01730921417','kel@gmai');
insert into supplier
(supplier_id,supplier_name,address,phone_number,email)
values(10105,'Noya','mirpur-1','01730921417','noya@gmai');
medicine_info =============
insert into medicine_info
(medicine_id,medicine_name,m_category_id,generic_name,brand_name,description,
indication,side_effects, batch_number,production_date,
expiry_date,cost)
values(101,'Napa',1,'Paracetamol','beximco pharma',null,'fever','no',321131,
'12-MAR-21','20-JUN-2025',5);
insert into medicine_info
(medicine_id,medicine_name,m_category_id,generic_name,brand_name,description,
indication,side_effects, batch_number,production_date,
expiry_date,cost)
values(101,'Sergel',2,'Esomeprazole','beximco pharma',null,'Gastric','no',321413,
'12-MAR-21','20-JUN-2025',10);
insert into medicine_info
(medicine_id,medicine_name,m_category_id,generic_name,brand_name,description,
indication,side_effects, batch_number,production_date,
expiry_date,cost)
values(101,'Ecosprin',2,'Aspirin','ACME
Laboratories',null,'infarction','no',322410,
'12-MAR-21','20-JUN-2025',8);
