INSERT INTO public.patients VALUES ('6391e266-b555-4756-a65f-ca61bc88fbd1', 'BA009', NULL, 0.000000, 'Bahriye', 'Atış', 'FEMALE', NULL, NULL, NULL, '19081664858', 'Bursa', '1965-05-14', 'Bursa', 'Osmangazi', 'İstiklal mah Pars sok Downtown Atış yapı G Blok K:11 D:41', NULL, 'Vazoxen 5 mg - Glifor 1000 mg -Ecoprin - irdoprin plus 300mg -xanax 1mg- Cipralex 10 mg', 'CİS(1) SAFRA KESESİ -UMBLİKAL HERNİ- Servikal Disk Hernisi- lomber disk herkesi - tetik parmak', 'Mevsimsel Allerji', 'Hipertansiyon- Diyabet- Kolesterol', '-', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e7d74420-9d65-4915-90d0-e242da4e6ef1', 'EL010', NULL, 0.000000, 'Elif', 'Sevinç', 'FEMALE', '+905439182621', NULL, NULL, '36361081570', 'Bursa', '1984-10-05', 'Bursa', 'Nilüfer', 'Geçit', 'Serum', 'Yoı', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('70623788-43c7-4f32-949b-8060ffb9cd3f', 'NE012', NULL, 0.000000, 'Nevzat', 'yılmaz', 'MALE', '+905300830539', NULL, NULL, '24031862680', 'Bursa', '1997-03-24', 'Bursa', 'Nilüfer', 'Yunuseli', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a1f149e8-c304-44dd-81ad-a82f56ebf441', 'HA052', NULL, 0.000000, 'HATİCE', 'DOĞANER', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b680a02f-7aa7-445a-96f5-644a5f61512f', 'HA050', NULL, 0.000000, 'HABİL', 'SEZER', 'MALE', NULL, NULL, NULL, '21122357902', NULL, NULL, 'Bursa', 'MUDANYA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('cb7e0ab0-54b1-40eb-8304-2d065422afb2', 'HA049', NULL, 0.000000, 'Habibullah', 'Güneç', 'MALE', '+905061692726', NULL, NULL, '29299509544', 'Diyarbakır', '1994-09-30', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum', 'Yok ', 'Yoo', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('58ade82a-706d-491a-91ba-89ab051d85fa', 'SE056', NULL, 0.000000, 'Senanur', 'Himmet', 'FEMALE', '+905335065084', NULL, NULL, '10690973690', 'Bursa', '2003-06-09', 'Bursa', 'Nilüfer', 'Yunuseli', 'Serum', 'Yok', 'Sezeryan', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ce46ef33-0169-452d-a685-6f289fbc8be1', 'SE057', NULL, 0.000000, 'SENA', 'BURAK', 'FEMALE', '+905534590719', NULL, NULL, '36313097338', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e51a4e8f-eab2-4a25-bf52-bb40c8e52d35', 'SU006', NULL, 0.000000, 'Sueda naz', 'Sağlık', 'FEMALE', '+905535197412', NULL, NULL, '12072116336', 'Bursa', '2006-05-03', 'Bursa', 'Nilüfer', 'Korupark', 'Serum', 'Yok', 'Yok', 'Yok', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('eab39764-b05b-48de-9130-3c7cde3b12fb', 'DE004', NULL, 0.000000, 'Demhat', 'Kaçhan', 'MALE', '+905422449780', NULL, NULL, '11897002030', 'Diyarbakır', '2006-04-03', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum', 'Yoı', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9d03953d-7607-4856-b1f5-6f05e42f6998', 'HA051', NULL, 0.000000, 'Hasan ', 'Akkan', 'MALE', '+905382433797', NULL, NULL, '35947102258', 'Bursa', '1951-05-04', 'Bursa', 'Nilüfer', 'Gümüşteoe', 'Serum', 'Yok', 'Yık', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('12cddece-6788-46f9-bf5c-a3f810629867', 'ZE017', NULL, 0.000000, 'ZEYNEP', 'ATAY', 'FEMALE', '+905547536174', NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1ae650fb-81aa-4f6d-a6cd-717575fd33bd', 'FU003', NULL, 0.000000, 'Furkan', 'Kayacı', 'MALE', '+905392530230', NULL, NULL, '37822051996', 'Bursa', '1998-08-11', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serun', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e8580264-540c-4fa1-98e4-5cff24d33ef9', 'AY020', NULL, 0.000000, 'Aydan ', 'Kaygun', 'FEMALE', '+905432272049', NULL, NULL, NULL, NULL, '1942-01-14', 'Bursa', 'Osmangazi', 'Çağlayan mah ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('79b9d15e-fcc4-40c5-895c-e484c566b3fc', 'BA010', NULL, 0.000000, 'BARKIN', 'KILIÇ', 'MALE', '+905324308575', NULL, NULL, '48745885582', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('c33cc1e6-2452-4205-bd68-cc8796da688e', 'GÜ014', NULL, 0.000000, 'Gültaze', 'Güneşdoğdu', 'FEMALE', '+905058247109', NULL, NULL, '14242898424', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('32328c0c-a56f-4074-866f-62e0ba8d4203', 'GÖ008', NULL, 0.000000, 'Gönül', 'Durmuş', 'FEMALE', '+905377005440', NULL, NULL, '36388099770', 'Buraa', '1971-12-26', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8e8fbfa4-ac0c-4285-9b75-216ba672844e', 'AN001', NULL, 0.000000, 'Anıl', 'Erdirk', 'MALE', '+905070099397', NULL, NULL, '30094298342', 'Bursa', '2003-10-13', 'Bursa', 'Nilüfer', NULL, 'Serum ', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('13383756-45dc-42a5-a729-13fd70c81023', 'SE055', NULL, 0.000000, 'Sedat', 'Çelenk', 'MALE', '+905307768154', NULL, NULL, '38551612922', NULL, '1979-05-28', 'Bursa', 'Osmangazi', 'İstiklal Mah Pars Sok Downtown Atış Yapı D Blok Kat:11 D:55', 'Testesteron Propınate1 ml -crypto 1ml 
IM enjeksiyon uygulandı', NULL, NULL, NULL, NULL, NULL, NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('d79fcdfb-991b-4fd9-81a3-283421416c44', 'HA048', NULL, 0.000000, 'Hayriye', 'Yurdakul', 'FEMALE', '+905513904458', NULL, NULL, '55387507482', 'Sivas', '1963-11-10', 'Bursa', 'Nilüfer', 'Kayapa', 'Kolostomi', 'Ypk', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('da2b0579-d39d-44da-9f93-8e08575ee3ee', 'PI003', NULL, 0.000000, 'Pınar ', 'Erdem', 'FEMALE', '+905322780586', NULL, NULL, '23971509938', 'Bursa', '1987-01-15', 'Bursa', 'Nilüfer', 'Fsm', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4c3591be-b4ca-41e8-8e5f-10d643074f60', 'BE020', NULL, 0.000000, 'Berkay', 'Özcan', 'MALE', '+905050230380', NULL, NULL, '10519964892', NULL, '2005-09-19', 'Bursa', 'Nilüfee', 'Park natura', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('55115259-d600-4b4e-8b98-0103269d6ecb', 'İB005', NULL, 0.000000, 'İBRAHİM', 'ŞAHİN ', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8bd1cd3a-53df-4fee-8c29-d44cd24bffc1', 'AY021', NULL, 0.000000, 'AYTEN', 'KARTAL', 'FEMALE', '+905365865216', NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a25865c9-b29b-4b81-997b-a8d96c09b991', 'AL020', NULL, 0.000000, 'ALA', 'CEVDET', 'FEMALE', '+905350324855', NULL, NULL, '64900426292', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7843fc29-7ff0-4f2b-bb2e-5123c3630d2c', 'HÜ014', NULL, 0.000000, 'Hüseyin ', 'Bollu', 'MALE', '+905302049962', NULL, NULL, '17221738292', 'Bursa', '1992-01-31', 'Bursa', 'Nilüfer', 'Balat', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('52f6cbd7-c9c8-4e27-936b-097bcb467500', 'SE058', NULL, 0.000000, 'SEVİNÇ ', 'AYDIN', 'FEMALE', '+905354037858', NULL, NULL, '33286181934', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('c3759144-ffee-4604-bc63-f3c5133fae7b', 'ŞA005', NULL, 0.000000, 'ŞAZİYE ', 'İMAMOĞLU', 'FEMALE', '+905366302770', NULL, NULL, '33031209326', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('01d468e0-2b35-4694-9c9f-c895f7c9c975', 'AL019', NULL, 0.000000, 'ALİ MJYJ', 'ALWAZZON', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7408a706-6e95-49b1-af9b-44730fcc29c0', 'ŞE014', NULL, 0.000000, 'ŞERİFE', 'ŞEN', 'FEMALE', '+905323544875', NULL, NULL, '57706103122', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a9ec6eae-9879-4d6d-a35d-e7612ea05a60', 'NA012', NULL, 0.000000, 'NAZAN ', 'BAYRAMÇAM', 'FEMALE', '+905325683719', NULL, NULL, '34123175130', NULL, NULL, 'Bursa', NULL, NULL, 'Alerji
', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('03c90901-19cd-4f4a-9cd4-23b190757371', 'ME044', NULL, 0.000000, 'MERYEM', 'YILDIZTAÇ', 'FEMALE', '+905434429126', NULL, NULL, '12247920850', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('bf6fe6bc-3490-49e7-8901-8c88fb1b98a8', 'ZE018', NULL, 0.000000, 'ZEYCAN', 'KALYONCU', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('03acddfe-00d3-41ea-9664-f7fcf2696444', 'ÖN002', NULL, 0.000000, 'ÖNDER KADİR', 'BOROND', 'MALE', '+905552103311', NULL, NULL, '26971408928', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a5015095-85a8-4fb5-a3a5-80e8c77aef0a', 'SE059', NULL, 0.000000, 'Sevtgo', 'Kalyoncu', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d8605ceb-38ed-46c9-81e6-6e9587d16ad1', 'SA020', NULL, 0.000000, 'Salwa', 'Selim', 'MALE', '+905389161800', NULL, NULL, '98317101640', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('f25e1be1-7f16-4071-bab2-315bbfc7bbe5', 'FÜ001', NULL, 0.000000, 'Füsun', 'Çay', 'FEMALE', '+905345771117', NULL, NULL, '21781601422', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('14e4df89-3995-45c3-970a-62fc87abddd1', 'ZE019', NULL, 0.000000, 'Zekeriya', 'Bozkurt', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2591bce7-fa6d-422d-bc0e-ec1ecb894c63', 'AB011', NULL, 0.000000, 'Abdulmajeed', 'Rami', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('99a35381-f4de-414b-b53e-86bf11d66f05', 'GÖ009', NULL, 0.000000, 'GÖKHAN', 'DİNÇER', 'MALE', '+905332020859', NULL, NULL, '55462470650', 'BURSA', '1983-03-04', 'Bursa', 'MUDANYA', 'ÇAGRISAN MH.NO.6 MUDANYA', 'EKSİK BİLGİ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7b03e071-c6e4-4af5-a522-caad8ffadc99', 'EB002', NULL, 0.000000, 'Ebrar', 'Kılıç', 'FEMALE', '+905324308575', NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('df661d48-74d7-4f1e-8f5b-9cf2b55945be', 'MA004', NULL, 0.000000, 'Madawi', 'Alquahs', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('15590f83-47ce-4f56-8e13-7008ae1c2f92', 'IR001', NULL, 0.000000, 'Irmak Su', 'Güçlü', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('5abc7c54-85fe-4ab7-8d75-ede1cae1b2eb', 'TU011', NULL, 0.000000, 'Tuğba ', 'Koç', 'FEMALE', '+905353397591', NULL, NULL, '20206082112', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e4d5ea14-669d-4d5d-8278-bf481130b19a', 'AH018', NULL, 0.000000, 'Ahmet', 'Ateş', 'MALE', '+905393440768', NULL, NULL, '15919780516', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1bd20a56-7beb-400e-921f-a911147ec7ef', 'BA011', NULL, 0.000000, 'Barat ', 'Julian', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8249af59-2dd1-4962-a32e-3f7a28398d6a', 'Mİ003', NULL, 0.000000, 'Mithat', 'Sağlık', 'MALE', '+905422750202', NULL, NULL, '13261118452', NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown E blok k:6 d:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('73540970-d41b-4fa8-8579-593889f2d381', 'HA053', NULL, 0.000000, 'Hakan ', 'Yağlı', 'MALE', '+905376486662', NULL, NULL, '47707631274', NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown c blok d:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2c02edac-e88a-4aeb-9be3-e2eabe45ba80', 'KÜ004', NULL, 0.000000, 'Kübra', 'Yılmaz', 'FEMALE', '+905303260143', NULL, NULL, '13855865786', NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown D blok d:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1bdc602d-7b92-477d-8810-b48d6d04611c', 'NE013', NULL, 0.000000, 'Neva', 'Karataş', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1bc3faeb-1453-4785-a3b7-acdfb076a38f', 'DA002', NULL, 0.000000, 'Dalal', 'Al sala', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown H blok k:8 D:61', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8eaf28b5-4c82-4556-b898-64dce4f8ff4b', 'GE001', NULL, 0.000000, 'Gençay', 'Genç', 'MALE', '+905357636303', NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown H blok K:7 D:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4df9fd69-965d-4ba9-bc8f-62b2b24b27ae', 'FA022', NULL, 0.000000, 'Fawas Faleh', 'Shamre', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Nilüfer', 'Downtown A blok D:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b8233b73-13a3-4076-856c-be35d7bc98c8', 'GA002', NULL, 0.000000, 'Gamze', 'Arıkan', 'FEMALE', '+905546253121', NULL, NULL, '22381423762', NULL, NULL, 'Bursa', 'Osmangazi', 'Downtown C blok D:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('274239b5-64e7-48e4-8487-829aec4d6bbd', 'MO001', NULL, 0.000000, 'Mohammad', 'Alhadah', 'MALE', '+905380912340', NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Osmangazi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('cee20f5d-a06f-4924-b11e-15cbfad5a3b7', 'ES009', NULL, 0.000000, 'Esra ', 'Şen', 'FEMALE', '+905467291234', NULL, NULL, '34048177790', NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('0d35ef00-45e2-4668-b47e-a7765708946f', 'YU012', NULL, 0.000000, 'YUSUF', 'TUĞRUL KARATAŞ', 'MALE', '+905352683874', NULL, NULL, '17278739778', 'BURSA', NULL, 'Bursa', NULL, NULL, 'HASTA BİLGİSİ EKSİK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('189caf57-c5b9-4e3c-962e-b1c87d7ccdad', 'AY022', NULL, 0.000000, 'Ayçe', 'Polat', 'FEMALE', '+905333134872', NULL, NULL, '10960942494', NULL, NULL, 'Bursa', 'Osmangazi', 'Downtown A blok K:11 D:64', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6ef7c513-213c-4ff3-aa9a-315f756fa38d', 'Bİ011', NULL, 0.000000, 'Biray', 'Bekçe', 'MALE', '+905353642013', NULL, NULL, '24619451732', NULL, NULL, 'Bursa', 'Osmangazi', 'Downtown D blok K:8 D:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('434b4a1f-d1fd-4f37-8708-df937f9e302c', 'SA021', NULL, 0.000000, 'SAİD', 'ATMANLIOGLU', 'MALE', '+905345915914', NULL, NULL, '41261075826', 'BURSA', NULL, 'Bursa', NULL, NULL, 'BİLGİ EKSİK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6824f1ba-5314-40a8-bff5-eb4d11d35935', 'SE060', NULL, 0.000000, 'Serra Maya', 'Polat', 'FEMALE', '+905335254872', NULL, NULL, '11332941824', NULL, NULL, 'Bursa', 'Osmangazi', 'Downtown A blok K:11 D:64', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6040a6fe-3704-456d-b3da-0399a65c52ae', 'NE015', NULL, 0.000000, 'Nesibe', 'Hasan', 'FEMALE', '+905345651444', NULL, NULL, '24643480012', NULL, '1972-02-11', 'Bursa', 'Yıldırım', 'Zümrütevler', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('215591cd-79e9-46aa-8842-daf46156bc2c', 'RE008', NULL, 0.000000, 'Recai', 'Obut', 'MALE', '+905322216811', NULL, NULL, '30073788680', 'Siirt', '1957-12-31', 'Bursa', 'Nilüfer', 'Gümüştepe', 'Serum', 'Yok', 'Yoo', 'Yoo', 'Dm 
Stent', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7504ac9e-7778-4527-b34b-f995173aced9', 'AY023', NULL, 0.000000, 'Ayşe suheda', 'Köroğlu', 'FEMALE', '+905300968703', NULL, NULL, '39358018658', 'Bursa', '2009-04-19', 'Bursa', 'Yıldırım', 'Arabayatağı', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9861ff6b-2f50-42a6-9b4a-15a00d0ae6e3', 'ZE020', NULL, 2000.000000, 'Zehranur Efşan', 'Alpaslan', 'FEMALE', '+905411415857', NULL, NULL, '25756444502', NULL, '2006-10-18', 'Bursa', 'Nilüfer', 'Bakgör city1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('cfe27181-c125-4000-9ce8-edea009cb721', 'FE007', NULL, 0.000000, 'Feyza', 'Hakyemez', 'FEMALE', '+905310800855', NULL, NULL, '63367277652', 'Bursa', '1995-07-07', 'Bursa', 'Osmangazi', 'Küçükbalıklı', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b3b49801-e6c2-4f1e-9123-f1ca887dd8e0', 'Hİ005', NULL, 0.000000, 'Hikmet', 'Kırmızıkan', 'MALE', '+905442330490', NULL, NULL, '10815065590', 'Bursa', '1978-10-09', 'Bursa', 'Kestel', NULL, 'Kan ', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b8cc9470-f176-43d0-a4f8-538cb57e0c7c', 'KA012', NULL, 0.000000, 'Kamile', 'Pekdemir', 'FEMALE', '+905344502055', NULL, NULL, '47248746260', NULL, '1973-01-11', 'Bursa', 'Osmangazi', 'Bağlarbaşı ', NULL, 'İnsülin 
Tansiyon ilacı
Antidepresan', NULL, NULL, 'H. Tansiyon 
Dm ', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ac479472-5033-418e-ba62-e92e267258f0', 'SE061', NULL, 0.000000, 'Sercan', 'Sevinç', 'MALE', '+905337654928', NULL, NULL, '37540048056', 'Bursa', '1990-10-20', 'Bursa', 'Nilüfer', '23 nisan', 'Serın', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('415bb016-6e9a-4180-8bfd-0715c7c9f292', 'BA012', NULL, 0.000000, 'Başak', 'Güler', 'FEMALE', '+905365846373', NULL, NULL, '33877789686', 'İstanbul', '1991-01-30', 'Bursa', 'Nilüfer', 'Özlüce', 'Serum', 'Yok', 'Yk', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('f68cdf7c-f790-4cbc-9f3c-7adaebee21f2', 'ZE021', NULL, 0.000000, 'Zerda', 'Demir', 'FEMALE', '+905367375045', NULL, NULL, '15116320706', 'Van', '2003-08-12', 'Bursa', 'Nilüfer', 'Karaman', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yoo', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('67bfb104-a34e-4cc0-a1b7-2421ee0609d8', 'Hİ006', NULL, 0.000000, 'Hilal', 'Akçacı', 'FEMALE', '+905517950501', NULL, NULL, '30874279448', 'Bursa', '1994-07-03', 'Bursa', 'Osmangazi', 'Hamitler toki', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('c58572ec-a541-4cc7-bb9d-e1f69446772b', 'AH019', NULL, 0.000000, 'Ahmet ', 'Özdamar ', 'MALE', '+905335020102', NULL, NULL, '21718602164', NULL, '2025-10-15', 'Bursa', 'Mudanya ', NULL, NULL, NULL, 'Burun ameliyatı 
', 'Yok', 'Tsh nödüller ', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8d547081-1a70-44a6-8482-7cc39a7681c7', 'BU009', NULL, 4500.000000, 'Burak', 'Özden', 'MALE', '+905435036642', NULL, NULL, '12345678891', 'Bursa', '1993-07-07', 'Bursa', 'Osmangazi', 'Çekirge', 'Serum 
Glutatyon', 'Yok', 'Yok', 'Ypk', 'Yok', 'Yk', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('560e8839-3035-45cf-9761-3e42524fdf4c', 'AY024', NULL, 0.000000, 'Ayşe', 'Tatlı', 'FEMALE', '+905349417915', NULL, NULL, '10015406186', 'Adana', '2000-11-25', 'Bursa', 'Nilüfer', 'Karaman', 'Serum', 'Yok', 'Ypk', 'Ypk', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4fe1928f-1af1-43a2-a65e-f9b4704b081e', 'HA054', NULL, 0.000000, 'Hayrettin', 'Pekdemir', 'MALE', '+905327090755', NULL, NULL, '47272745468', NULL, '1971-02-25', 'Bursa', 'Osmangazi', 'Bağlarbaşı ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('3f846010-c765-4f22-bd3e-5dae4b5e99b6', 'HA055', NULL, 0.000000, 'Hatice ', 'Yeşilbaş', 'FEMALE', '+905393844937', NULL, NULL, '41245206802', NULL, '1979-09-19', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı', 'Personel', '-', '-', '-', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('5cc4e388-bdb7-4d9c-8efa-4843ce3ca34c', 'ME045', NULL, 0.000000, 'Melike sümeyye', 'Özel', 'FEMALE', '+905348589409', NULL, NULL, '57331450288', 'Sivas', '1995-11-20', 'Bursa', 'Nilüfer', 'Balat', 'Serum', 'Yok', 'Yoı', 'Yoo', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8c2dcbe9-15d7-46bb-9af1-c306ad4b6f87', 'İL008', NULL, 0.000000, 'İlay ceren ', 'Yılmaz', 'FEMALE', '+905323005994', NULL, NULL, '11717106824', 'Bursa', '1987-04-24', 'Bursa', 'Nilüfer', 'Görükle', 'Serum', 'Yok', 'Yok', 'Penisilim', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('da53e321-a110-460a-be56-baeb8f961cb5', 'Dİ003', NULL, 0.000000, 'Dikek', 'Topaloğlu', 'FEMALE', '+905419710388', NULL, NULL, '43303228320', 'Bursa', '1988-06-09', 'Bursa', 'Nilüfer', 'Fsm', 'Serum', 'Yok', 'Fıtık', 'Parol', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e2ed4371-1bbd-4949-a1c3-34f3099e87b4', 'BA013', NULL, 0.000000, 'Başak', 'Frunç', 'MALE', '+905336994474', NULL, NULL, '12345678922', 'Bursa', '2025-09-30', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('0de64302-d637-4e72-9b46-4ca866d89639', 'FU004', NULL, 5000.000000, 'FUAT', 'ALPASLAN', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('0df00271-d467-4250-8a88-c4abd1d66c15', 'GA003', NULL, 8140.000000, 'Gamze', 'Gökçepişki', 'FEMALE', '+905312834135', NULL, NULL, '41455675894', 'Konya', '1990-09-16', 'Bursa', 'Nilüfer', 'Yüzüncüyıl', 'Serun', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a63e22d0-d9b9-437a-aa53-3a3122649fd6', 'OS005', NULL, 0.000000, 'Osman', 'Kılınç', 'MALE', '+905348465342', NULL, NULL, '19393679434', NULL, '1991-09-18', 'Bursa', 'Nilüfer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('48768355-3211-4f23-8271-eeb18bf89512', 'HÜ015', NULL, 0.000000, 'Hülya', 'Şen', 'FEMALE', '+905538071642', NULL, NULL, '25921362808', 'Bursa', '1971-02-28', 'Bursa', 'Nilüfer', 'Ataevler', 'Serum', 'Yok', 'Ypk', 'Yoo', 'Yoı', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('f123c5fd-4349-49f9-bc07-e5142603a70b', 'FE006', NULL, 0.000000, 'Feyiz', 'Köroğlu', 'MALE', '+905322829873', NULL, NULL, '10201989202', 'Yunanistan', '1977-08-26', 'Bursa', 'Yıldırım', 'Arabayatağı', 'Serum', 'Yok', 'Yok', 'Yok', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8ca94840-a777-4689-817a-cabbba4faead', 'MA005', NULL, 0.000000, 'Mahmut', 'Eren', 'MALE', '+905333502736', NULL, NULL, '25016343958', 'Siirt', '1981-09-09', 'Bursa', 'Nilüfu', 'Ertuğrul', 'Serum ödem fazlalığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('66eb882f-8534-4f53-a232-9ed27b0542d1', 'FI001', NULL, 0.000000, 'Fırat', 'Altun', 'MALE', '+905441574147', NULL, NULL, '48826074706', NULL, '1987-01-02', 'Bursa', 'Osmangazi', 'Yenibaşlar ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d9269fea-8391-4f29-8e29-c1e9fc844050', 'NE014', NULL, 0.000000, 'NECİP', 'KEREM POLAT', 'MALE', '+905333134872', NULL, NULL, '34897158162', 'BURSA', NULL, 'Bursa', NULL, NULL, 'BİLGİ EKSİK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fddef7a4-93b1-4a88-a593-da8691d21a50', 'KE007', NULL, 0.000000, 'Kerem', 'Kutlucan', 'MALE', '+905320107710', NULL, NULL, '15781799906', 'Bursa', '2000-08-06', 'Bursa', 'Nilüfer''in', 'Çağrışan', 'Serum
Bulantı kusma', 'Yok', 'Yok', 'Yoo', 'Yok', 'Yoo', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b0643eee-7bd2-4491-96cb-9b0d50d8cab3', 'YA014', NULL, 0.000000, 'Yaren', 'Peker', 'FEMALE', '+905445435510', NULL, NULL, '43921036222', 'Edirne', '2000-12-08', 'Bursa', 'Osmabgazi', 'Dikkaldırım', 'Serun', 'Yoı', 'Yoı', 'Yok', 'Yok', 'Yoı', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('5c2e919d-a329-4a0e-abc7-a11f10188e3b', 'BU010', NULL, 0.000000, 'Buse ', 'Güleç', 'FEMALE', '+905442893839', NULL, NULL, '12345667812', 'bursa', '2025-09-30', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('15bed304-c79c-4c0c-8aeb-d8ec3d23be90', 'Cİ004', NULL, 0.000000, 'Cihat', 'Gündüz', 'MALE', '+905470030115', NULL, NULL, '37381338736', 'İstanbul', '1994-05-27', 'Bursa', 'Osmangazi', 'Alemdar mah. ', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fb64ccb6-9ec0-49b6-bc70-301d3b982da6', 'AY025', NULL, 0.000000, 'Ayşe', 'Demirel', 'FEMALE', '+905535970595', NULL, NULL, '10012228354', 'Kars', '1961-10-11', 'Bursa', 'Nilüfer', 'Fsm', 'Serum', 'Zaldiar
Symra 25 mg
Levotrion 75 mg', 'Yoo', 'Novalgin', 'Ht', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4efa5410-2fbd-4a27-9518-c3b9e30c28de', 'FA023', NULL, 0.000000, 'Fatih', 'Kaynak', 'MALE', '+905321524816', NULL, NULL, '59329267328', 'Muş', '1985-05-12', 'Bursa', 'Osmangazi', 'Demirtaş', 'Serum', 'Yoo', 'Yoo', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('5fa5d112-f909-48db-ab94-0b09320633ce', 'RE009', NULL, 0.000000, 'Recep', 'Er', 'MALE', '+905330330174', NULL, NULL, '37318065452', 'Bursa', '1980-11-26', 'Bursa', 'Yıldırım', 'Ortabağlar', 'Serum ', 'Yok', 'Yok', 'Yok', 'Yook', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('3dc6853d-4a70-4a40-8207-dd7c6038b4e5', 'HÜ016', NULL, 0.000000, 'Hüseyin ', 'Orhan', 'MALE', '+905372688703', NULL, NULL, '22174573012', 'Bursa', '1992-05-26', 'Bursa', 'Osmangazi', 'Soğanlı', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1acdadef-d3bd-420d-94f4-2d8354b64e9f', 'UL002', NULL, 0.000000, 'Ulaş', 'Karabey', 'MALE', '+905550570716', NULL, NULL, '58072173306', 'Bursa', '1983-05-25', 'Bursa', 'Nilüfer', 'Kayapa', 'Serum
Soğuk algınlığı', 'Yoo', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('be8c94a5-ca13-451d-b21b-ccfdf22aa369', 'ER012', NULL, 0.000000, 'Ersin', 'Erdem', 'MALE', '+905340602919', NULL, NULL, '25939207412', 'Bursa', '1998-01-09', 'Bursa', 'Yıldırım', 'Gürsu', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b069563b-1340-4553-9e00-abde6955e59d', 'NU019', NULL, 0.000000, 'Nuriye ', 'Aydil', 'FEMALE', '+905324976512', NULL, NULL, '12308666024', NULL, '1955-01-10', 'Bursa', 'Osmangazi', 'Çeltikköy', NULL, NULL, 'Omurilik ', 'Penisilin ', 'Kalp 
Ht 
Dm ', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7a144eb6-522b-4339-acdf-96592d3a2e4c', 'ME046', NULL, 0.000000, 'Merve', 'Koç', 'FEMALE', '+905366781711', NULL, NULL, '26497428776', 'Bursa', '1995-05-15', 'Bursa', 'Nilüfer', 'Yaylacık', 'Enjeksiyon', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('20e087b4-2fff-4229-bfe5-e6d697690b07', 'SE064', NULL, 0.000000, 'Selin', 'Arkın', 'FEMALE', '+905010022098', NULL, NULL, '17215738352', 'Bursa', '1998-01-19', 'Bursa', 'Nilüfer', 'Fsm', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9f5e32cf-0ecb-4d81-93ba-a3380ec2c605', 'AS009', NULL, 0.000000, 'Aslıhan', 'Ergün', 'FEMALE', '+905393533319', NULL, NULL, '10247294346', 'Bursa', '2000-09-17', 'Bursa', 'Nilüfer', 'Fsm', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1901fde1-bf3a-418c-8627-02fb801d6f26', 'HA056', NULL, 0.000000, 'Hasan burak', 'Cesur', 'MALE', '+905363010531', NULL, NULL, '50080192690', 'Bursa', '1988-08-02', 'Bursa', 'Nilüfer', '23 nisan', 'Serum 
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('de0a16ca-2db5-498a-9285-279d5280ce83', 'İL009', NULL, 0.000000, 'İlayda', 'İşmen', 'FEMALE', '+905332531726', NULL, NULL, '36844101726', NULL, '2008-06-16', 'Bursa', 'Yıldırım ', 'Zümrütevler', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('a7efb96b-3e81-46ee-ab00-3959c60d4930', 'SE062', NULL, 0.000000, 'Seda', 'Meriç', 'FEMALE', '+905061415980', NULL, NULL, '14459011678', 'Bursa', '1985-07-01', 'Bursa', 'Nilüfer', 'Kayapa', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('735a35d4-3cc1-4374-b3d1-63e7a8a12b88', 'EL011', NULL, 0.000000, 'Elif güneş', 'Yeşilyudt', 'MALE', '+905072616182', NULL, NULL, '10172928224', 'Ordu', '2002-02-01', 'Bursa', 'Nilüfer', 'Ertuğrul', 'Serum
Soğuk algınlığı', 'Yok ', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7bf9fb06-feee-45d7-ba86-2c2cbef6a3cb', 'CA008', NULL, 0.000000, 'CANSU ', 'BADİN ', 'FEMALE', NULL, NULL, NULL, '12388913926', NULL, '1991-08-20', 'Bursa', 'NİLÜFER', 'BEŞEVLER CAD NO:172', 'GEBELİK İKİZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('72531de4-b056-4468-af17-a9dc6af88b5f', 'AL021', NULL, 0.000000, 'ALPASLAN', 'ALPASLAN ', 'MALE', NULL, NULL, NULL, NULL, NULL, '2016-12-01', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('df1fb246-6b28-4d08-8d04-1250a87d6627', 'ŞE015', NULL, 0.000000, 'Şevket', 'Deniz', 'MALE', '+905304707629', NULL, NULL, '17680230030', 'Adıyaman', '1986-02-21', 'Bursa', 'Nilüfer', 'Görükle', 'Enjeksiyon', 'Yok', 'Yok', 'Yok', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('aa1b00b8-1b2d-42dc-92fe-305929465bc8', 'NU018', NULL, 2000.000000, 'Nuran', 'Bağban', 'FEMALE', '+905326143924', NULL, NULL, '19180632932', NULL, '1957-08-08', 'Bursa', 'Nilüfer', NULL, 'bilgilendirme yetkili kişi 
raşit ceylan 
0 532 614 39 24', NULL, NULL, NULL, 'Lenfoma', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('15beef67-a967-41c0-99ea-07dfd2e63ddb', 'Hİ007', NULL, 0.000000, 'Hilal Nur', 'Kartal', 'FEMALE', '+905388609889', NULL, NULL, '22591557770', NULL, '1998-06-01', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D Blok D:57', NULL, '-', '-', '-', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('2c1ca2c7-7e7c-425e-a9bf-8cde25bd4324', 'RE010', NULL, 0.000000, 'Remziye', 'Ceylan', 'FEMALE', '+905366443383', NULL, NULL, '41317098878', NULL, '1980-08-02', 'Bursa', 'Nilüfer', 'Ondokuz mayıs mah ', NULL, NULL, NULL, NULL, 'Dm 
', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ef6d223d-8be1-46f3-88e3-cf0e12225751', 'KE008', NULL, 0.000000, 'Kerem ', 'Gürdal', 'MALE', '+905357173377', NULL, NULL, '24724485400', NULL, '1994-07-16', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D Blok K:11 D:55', NULL, '-', '-', 'Kedi Çimen Polen ', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('9318cf01-a8b0-4535-97b7-41d93fe2dcd4', 'SO001', NULL, 0.000000, 'Soykan', 'Ağsan', 'MALE', '+905394933839', NULL, NULL, '10003980742', 'Bursa', '2000-10-18', 'Bursa', 'Nilüfer', 'Altınşehir', 'Serum
Soğuk algınlığı', 'Ypk', 'Yok', 'Yoo', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('092c3022-eb29-4967-b6a5-82a73a379667', 'SA022', NULL, 0.000000, 'Salih', 'Semizoğlu', 'MALE', '+905324905387', NULL, NULL, '45532796236', 'Samsun', '1970-03-29', 'Bursa', 'Osmangazi', 'Korupark', 'Serum 
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yoı', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('01fb1eec-d965-4925-9b06-e0c72f85280a', 'EM024', NULL, 0.000000, 'emriye ', 'sarımsak ', 'FEMALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2eb31cc0-dd8e-4d6e-b2f9-c9da26ef2125', 'NE016', NULL, 0.000000, 'Necmiye ', 'İşmen', 'FEMALE', '+905377954368', NULL, NULL, '30079325032', NULL, '1975-08-09', 'Bursa', 'Yıldırım', 'Huzur apt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d5ad486c-5b1e-4292-86be-d8319ec1a1f5', 'SE063', NULL, 0.000000, 'Selver ', 'Küçükkarakoç', 'FEMALE', '+905414078016', NULL, NULL, '23569541432', NULL, '1983-04-18', 'Bursa', 'Osmangazi', 'İstiklal mah Pars sok Downtown atış yapı D Blok K:7 D:32', NULL, 'Eutrox 75 mg', 'CIS (2) ', '-', 'Tiroit', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('051c6da0-9242-43b9-a697-749cb4840730', 'HÜ017', NULL, 0.000000, 'Hüsna', 'Akıncı', 'FEMALE', '+905057588475', NULL, NULL, '39421269758', 'Erzurum', '1995-11-24', 'Bursa', 'Osmangazi', 'Bağlarbaşı', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ea6b7c7d-eb3d-47db-90bf-ea48e874a909', 'ŞE016', NULL, 0.000000, 'Şenol', 'Göçmençelebi', 'MALE', '+905323449455', NULL, NULL, '39445011750', NULL, '1979-06-13', 'Bursa', 'Osmangazi', 'Göçmen Çelebi apt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7038f295-1b87-4a66-9101-12d76cb2e489', 'NE017', NULL, 0.000000, 'Nedime', 'Bakır', 'FEMALE', '+905075587210', NULL, NULL, '34907231762', 'Bursa', '1990-08-21', 'Bursa', 'Nilüfer', 'Ataevler', 'Serum
Soğuk algınlığı', 'Ypk', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('02b582c3-a44f-4231-af06-04150defc7eb', 'HA057', NULL, 0.000000, 'Halim', 'Koçaslan', 'MALE', '+905332526782', NULL, NULL, '12345678965', 'Bursa', '1993-07-01', 'Bursa', 'Nilüfer', 'Demirci', 'Serum', 'Ypk', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1676d0b1-9fc3-4ad9-a1a4-37eecd5ba672', 'ER013', NULL, 0.000000, 'Erdal ', 'Selçuk', 'MALE', '+905067286877', NULL, NULL, '16936913772', 'Diyarbakır', '1970-04-09', 'Bursa', 'Nilüfer', 'Özlüce', 'Serum 
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('0c2c1708-45e2-4a21-87e4-7761d68abf80', 'DE005', NULL, 0.000000, 'DEMET ', 'SİNAĞ', 'FEMALE', '+905013660506', NULL, NULL, '19909662394', NULL, '1982-07-10', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6d29148d-18fe-4374-bd72-dd9f3f03aaf4', 'TA009', NULL, 18000.000000, 'TALİYE', 'KANDEMİR', 'FEMALE', NULL, NULL, NULL, NULL, NULL, '1945-01-19', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('91b99ebf-0d95-43c5-9346-242bc403d5d8', 'ME047', NULL, 7500.000000, 'Mehmet', 'Kandemir', 'MALE', '+905322112707', NULL, NULL, '50431611528', 'Rize', '1937-06-30', 'Bursa', 'Nilüfer', NULL, 'Serum 
Hava
Kan
', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('44272652-4fe1-4ec1-b764-14e8149ad0f9', 'ME048', NULL, 0.000000, 'Mesut ', 'Küçük', 'MALE', '+905323921608', NULL, NULL, '16180536864', 'Bursa', '1990-01-22', 'Bursa', 'Nilüfer', '23 nisan', 'Serum 
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9d968cab-cda0-4bd8-9e3c-c2589bda1ff4', 'AL022', NULL, 0.000000, 'Ali said', 'Adiloğlu', 'MALE', '+905325621666', NULL, NULL, '32575226158', 'Bursa', '1981-09-02', 'Bursa', 'Yıldırım', 'Millet ', 'Serum', 'Yok', 'Yok', 'Yoo', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('994ab3c0-0e9a-4102-9757-c7468fa7f67b', 'ES011', NULL, 0.000000, 'Eslem', 'Ayyıldız', 'FEMALE', '+905016696610', NULL, NULL, '29665163592', 'İstanbul', '1998-04-01', 'Bursa', 'Nilüfer', 'Özlüce', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4a55b867-d913-4665-aaeb-ddd1a38bc4b6', 'ES010', NULL, 0.000000, 'Esra', 'Saha', 'FEMALE', '+905334833110', NULL, NULL, '53041490286', NULL, '2013-11-19', 'Bursa', 'Nilüfer', 'Esenkent sitesi b1 blok', NULL, 'Kepra 500 mg', 'Skolyoz
', 'Astım ', NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('5951e0e2-2f03-469e-b13c-4c9e8079ec2b', 'RA011', NULL, 0.000000, 'Rahime', 'Porsuk', 'FEMALE', '+905366793893', NULL, NULL, '40718171234', 'Adana', '1971-11-29', 'Bursa', 'Osmangazi', 'Yenibağlar', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Ht', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6ce5a519-8224-4e74-9ed0-f0a6c02716f4', 'AS010', NULL, 0.000000, 'Assia', 'Elhaouari', 'FEMALE', '+905457839819', NULL, NULL, '99395820386', 'Fas', '1996-01-16', 'Bursa', 'Osmangazi', 'Çarşamba', 'Serum
Soğuk algınlığı', 'Yok ', 'Yok ', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('74147ace-a285-4ef6-803d-89c09c785973', 'DU006', NULL, 0.000000, 'Duygu ', 'Gülenç', 'FEMALE', '+905419667462', NULL, NULL, '21862584736', NULL, '2000-02-16', 'Bursa', 'Osmangazi', 'Çağlayan mah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e34f0ed9-3491-46fa-a073-1004c328c302', 'SE065', NULL, 0.000000, 'Sedra', 'Tello', 'FEMALE', '+905356936261', NULL, NULL, '99332354424', NULL, '2006-01-18', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı d blok', NULL, 'Glikofer1000 lik arada kullanıyor', 'Sağ Kol kırığı ', '-', 'Anemi ', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('e0d7693f-2620-49cd-b1a5-5bc70204ea41', 'DA003', NULL, 0.000000, 'Damlanur', 'Aydın', 'FEMALE', '+905525961516', NULL, NULL, '36910061084', 'Bursa', '2025-10-16', 'Bursa', 'Nilüfer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('cae29b52-5c15-4e56-b069-46eff8b9bf56', 'AY027', NULL, 0.000000, 'Ayşe', 'Arğın', 'FEMALE', '+905398454131', NULL, NULL, '36400099382', 'Bursa', '1964-05-03', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('51a8cb03-3e4c-4736-af09-d01e09824956', 'GÜ016', NULL, 0.000000, 'Gülşen ', 'Uçar', 'FEMALE', '+905386786934', NULL, NULL, NULL, 'Uşak', '1957-02-28', 'Bursa', 'Nilüfer', 'Bilginler cad yasemin sok mavera park sitesi A Blok K:9 D:25 nilüfer', NULL, 'Concor 10 mg - Hyzaar fort 100mg/25mg- fomodin 40 mg - Fixdual 5mg/10mg', 'Umblikal herni apandisit safra kesesi', 'Deterjan', 'Hipertansiyon Astım', '-', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4dc76388-58a8-45bb-bbd0-4355ffbade4a', 'GÜ017', NULL, 0.000000, 'Gülsüm ', 'Kıraçova', 'FEMALE', '+905312190400', NULL, NULL, '36070110042', NULL, '1989-06-16', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı C Blok K:14 D:84', NULL, 'Aripa 5mg (Doktor kontrolünde sürekli almıyor) ', 'Safra kesesi - göğüs toparlama silikon- vajina daraltma ', 'Bahar allerjisi', 'Yok', 'Yok', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('337d0a14-1b2d-48c5-9a69-2146ee0e6009', 'EL012', NULL, 0.000000, 'Elif ', 'Ölmez', 'FEMALE', '+905421931644', NULL, NULL, '23672531986', NULL, '1993-10-09', 'Bursa', 'Osmangazi', 'Yenibaşlar ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('16b7f84b-e2b3-4a18-9e6d-1c6897ecaa07', 'SA024', NULL, 0.000000, 'Salih', 'Altun', 'MALE', '+905323300871', NULL, NULL, '17276935772', NULL, '1980-01-25', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı E Blok K:6 D:36', NULL, '-', '-', '-', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('1be32244-f065-417b-99b9-2e04ffedaa95', 'GÜ015', NULL, 0.000000, 'Gülşen ', 'Uçar', 'FEMALE', '+905386786934', NULL, NULL, '46624878106', 'Uşak', '1957-02-28', 'Bursa', 'Nilüfer', 'Bilginler cad yasemin sok mavera park sitesi a blok d:25', NULL, 'Hipertansiyon için astım için ', 'Umblikal herni apandisit safra kesesi', 'Çamaşır suyu deterjan', 'Hipertansiyon astım', '-', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d91cf0a3-81ed-4d4f-b6d8-85a675eca1e1', 'EF002', NULL, 0.000000, 'Efe', 'Akçay', 'MALE', '+905432801802', NULL, NULL, '14056859390', 'Bursa', '2003-03-23', 'Bursa', 'Osmangazi', 'Demirtaş cumhuriyet mah. ', 'Serum
Soğuk algınlığı', 'Yoo', 'Ypk', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('300f7a3d-52ac-4978-99a4-b9eca6f141f2', 'SE066', NULL, 2000.000000, 'Sena', 'Kandır', 'FEMALE', '+905550186081', NULL, NULL, '12670872474', 'Bursa', '1997-10-14', 'Bursa', 'Nilüfer', 'Görükle', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('245a0333-d2ec-487f-8fb7-ec0f26793e56', 'GÜ018', NULL, 0.000000, 'Gülçiçek', 'Genç', 'FEMALE', '+905325521421', NULL, NULL, '45817948848', 'Trabzon', '1956-07-05', 'Bursa', 'Osmangazi', 'Panayır', 'Enjeksiyon', 'Ypk', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('7ce6bebe-a141-4436-9838-ca78e7af9a70', 'ZE023', NULL, 0.000000, 'Zeynep neva', 'Karataş', 'FEMALE', '+905352683874', NULL, NULL, '20632627086', NULL, '2023-01-31', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D Blok K:12 D:61', NULL, 'Zinco şurup vitobal şurup', '-', '-', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('af2d99fa-8f3e-4b30-bd0f-11bcd24f2743', 'SA023', NULL, 0.000000, 'Saffet ', 'Gülay ', 'MALE', '+905464417110', NULL, NULL, '17881730780', NULL, '1967-04-20', 'Bursa', 'Nilüfer', 'Tata servis egs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('0a971bc0-e65b-4604-9fd9-181e42bf3ca5', 'AB012', NULL, 0.000000, 'Abdullah', 'Çetintaş', 'MALE', '+905319294416', NULL, NULL, '16003780016', NULL, '1997-08-15', 'Bursa', 'Osmangazi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('3a5f6473-e64a-4e11-993f-2c1aa2b8614b', 'HA058', NULL, 0.000000, 'hamza', 'gıcıllı', 'MALE', NULL, NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('612f73ba-eb01-4542-b844-690cbeabf440', 'ME049', NULL, 0.000000, 'Mehmet', 'Kurtuluş', 'MALE', '+905331575810', NULL, NULL, '66550118732', 'Bursa', '1980-04-09', 'Bursa', 'Nilüfer', 'İhsaniye', 'Serum', 'Yok', 'Yok', 'Yoo', 'Ht
Dm', 'Yoo', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('461f4201-4860-49e9-8af8-a70fbd3ccb4e', 'FU005', NULL, 0.000000, 'Fulden', 'Oral', 'FEMALE', '+905327030252', NULL, NULL, '16876736622', 'Bursa', '1983-05-31', 'Bursa', 'Nilüfer', 'Balat', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1168d9e0-ddc6-4384-9285-c5528449a432', 'SE067', NULL, 0.000000, 'Serhat', 'Tok', 'MALE', '+905388978878', NULL, NULL, '51136345176', 'İsviçre', '1987-03-30', 'Bursa', 'Nilüfer', '23 nisan', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6475f29e-6cb0-44fd-aae9-44998ba90fa3', 'BÜ009', NULL, 0.000000, 'Büşra', 'Uzgur', 'FEMALE', '+905334037093', NULL, NULL, '10033951248', 'Bursa', '1991-12-02', 'Bursa', 'Nilüfer', 'Üçevler', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('92d7329c-255e-41d5-afd7-48b2e10b778b', 'EL013', NULL, 2000.000000, 'Elif', 'Yılmaz', 'FEMALE', '+905522055435', NULL, NULL, '20899443122', 'Balıkesir', '2001-09-01', 'Bursa', 'Osmangazi', 'Çekirge', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8fe5d062-11be-416d-a166-a0a9087cb674', 'FA021', NULL, 15180.000000, 'Faruk', 'Şahin', 'MALE', '+905312834135', NULL, NULL, '36442415638', 'Gaziantep', '1960-12-30', 'Bursa', 'Nilüfer', 'Hosab', 'Serum', 'Yok', 'Yok', 'Yoo', 'Ht ', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('15bbf631-ae24-4017-b693-4147504706a8', 'ŞA006', NULL, 0.000000, 'Şakir ', 'Şen', 'MALE', '+905387906258', NULL, NULL, '13162887488', 'Bulgaristan', '1988-04-06', 'Bursa', 'Yıldırım', 'Millet mah. ', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('1d7cc174-b319-4b2e-8aeb-f598bebc27ae', 'İL010', NULL, 12100.000000, 'İlknur', 'Zafer', 'FEMALE', '+905303948060', NULL, NULL, '25678429328', 'Bursa', '1979-10-30', 'Bursa', 'Nilüfer', NULL, 'Kan tahlili', 'Yok', 'Yoo', 'Yok', 'Yok', 'Yoı', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d3164d31-dfda-4eb1-85a6-4744489ed0af', 'ZE024', NULL, 0.000000, 'Zerrin ', 'Özer', 'FEMALE', '+905332988917', NULL, NULL, '15115115186', 'Bursa', '1991-03-24', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4c17b426-ba50-4b72-b4bf-c7036af2eb1d', 'ZE022', NULL, 0.000000, 'Zerrin', 'Özer', 'FEMALE', '+905332988917', NULL, NULL, '15155175886', 'Bursa', '1991-03-20', 'Bursa', 'Osmangazi', 'Panayır', 'Kan tahlili', 'Yoo', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('bcbc9ce8-0163-45bb-b26d-ca89f52aba7a', 'ZE025', NULL, 0.000000, 'Zeycan ', 'Kalyoncu', 'FEMALE', '+905323015680', NULL, NULL, '37807049918', NULL, '1950-11-24', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı H Blok K:6 D:44', NULL, 'Beloc 50 - kan sulandırıcı kullanıyor diğerlerini hatırlamıyor ', 'By-pass (4 damar değişikliği) -Rahim CA- Histerektomi - Apandisit', 'Yok', 'Haşimato-Kalp Damar Tıkanıklığı', 'Yok', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('fb26e0f4-fce5-4f09-9727-512591dd1fd8', 'AY006', NULL, 3000.000000, 'AYHAN ', 'GÖNÜLAÇAR ', 'FEMALE', '905306890672', NULL, NULL, '63643372880', 'BURSA', '1977-10-22', 'Bursa', 'NİLÜFER', 'BALAT CİTY 2 D BLOK KAT 5 DAİRE 20', NULL, 'YOK ', 'YOK', 'YOK', 'YOK', 'YOK', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('25a1f85a-f041-412c-b42b-085ab757a1c7', 'AY026', NULL, 2000.000000, 'Ayşenur', 'Yurttaş', 'FEMALE', '+905066404953', NULL, NULL, '47743376900', 'Bursa', '1998-01-14', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e7ee26ea-3dbd-490b-8442-89d02961b4fb', 'ZE026', NULL, 0.000000, 'Zeynep', 'Taşdemir', 'FEMALE', '+905427825024', NULL, NULL, '24964109128', 'Bursa', '1995-05-27', 'Bursa', 'Nilüfer', 'Işıktepe', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yoo', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d3b37614-421e-4804-b333-2fe4b0e7e281', 'EM026', NULL, 0.000000, 'Emine', 'Köse', 'FEMALE', '+905324712837', NULL, NULL, NULL, 'Trabzon', NULL, 'Bursa', 'Mudanya', 'Deniz kabuğu evleri', 'Serum', NULL, 'Yoo', NULL, 'Dm
Ht
Kolesterol', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8d03af7c-e9a9-49ed-a009-e3d4eb24b230', 'ZÜ005', NULL, 0.000000, 'Züleyha', 'Bilgin', 'FEMALE', '+905536417651', NULL, NULL, '11122233323', NULL, '1981-04-12', 'Bursa', 'Nilüfer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('818b9400-650b-4242-84b4-4a01ecf4b4f9', 'RE011', NULL, 0.000000, 'Recep ', 'Tuncer', 'MALE', '+905375855006', NULL, NULL, '22928096446', 'İstanbul', '2003-09-16', 'Bursa', 'Mudanya', 'Mudanya ', 'Serum', 'Yok', 'Yok', 'Yoo', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fb846a51-35c9-4b61-8281-81db100be3a3', 'GÖ010', NULL, 0.000000, 'Gökhan ', 'Vanlı', 'MALE', '+905327316802', NULL, NULL, '14657275636', NULL, '1984-03-29', 'Bursa', 'Osmangazi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('6cfd0363-dbc9-4106-a5ef-e228d1b06674', 'NU020', NULL, 0.000000, 'Nurten', 'Acar', 'FEMALE', '+905332003515', NULL, NULL, '11179935444', 'Bursa', '1970-04-20', 'Bursa', 'Osmangazi', 'Altıparmak', 'Serum', 'Ypk', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e86f4e6c-e1bf-4323-a166-7f83233c74d6', 'AH020', NULL, 0.000000, 'Ahmet', 'Yiğit', 'MALE', '+905536153959', NULL, NULL, '14810766216', NULL, '1990-04-09', 'Bursa', 'Nilüfer', 'Konak mah ', NULL, NULL, 'Apandist', NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('993373ea-65c9-449c-95d0-232c43b15c7e', 'MI001', NULL, 0.000000, 'Mıcheal Esad ezzat zakher', 'Gadalla', 'MALE', '+905344178971', NULL, NULL, '98824205558', NULL, '2006-11-10', 'Bursa', 'Nilüfer', 'Alfa sağlık', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9f76f652-4fbb-4d78-9672-971a1712b8ae', 'ŞE017', NULL, 0.000000, 'Şevkiye afet', 'Tüfekçi', 'MALE', '+905365889483', NULL, NULL, '44821939842', 'Uşak', '1936-04-25', 'Bursa', 'Nilüfer', 'Ataevler', 'Kan', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('22d8552d-8cac-41d7-989b-cc702c47972f', 'HA059', NULL, 0.000000, 'Hatice', 'Çetin', 'FEMALE', '+905395935343', NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Osmangazi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('27279f3b-3f25-46da-9dd6-c24cb192e112', 'EB003', NULL, 0.000000, 'Ebru', 'Koca', 'FEMALE', '+905411079196', NULL, NULL, '30241317742', NULL, '1999-06-19', 'Bursa', 'Osmangazi', NULL, NULL, NULL, NULL, 'Amiklovin grubu', NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('622f95ff-749c-495c-b149-889e2ed2f3fc', 'GÜ019', NULL, 0.000000, 'Güldeste', 'Ali', 'FEMALE', '+905318524617', NULL, NULL, '23754125437', 'Azerbeycan', '1960-03-09', 'Bursa', 'Yıldırım', 'Değirmenlikızık', 'Kan', 'Yok', 'Yoo', 'Yok', 'Yoı', 'Yoo', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fbca8a4f-c147-4012-9f07-0bb52f07e46a', 'GA004', NULL, 0.000000, 'Gamze', 'Çağlar', 'FEMALE', '+905337476444', NULL, NULL, '20923629126', 'Bursa', '1988-12-17', 'Bursa', 'Nilüfer', 'Bademli', 'Serum', 'Yok', 'Yoo', 'Yoo', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d5d0c649-2ca1-4942-99da-f8b6ba959b32', 'ZÜ006', NULL, 0.000000, 'Zülküf', 'Adanur', 'MALE', '+905364356204', NULL, NULL, '60538227362', 'Muş', '1948-12-31', 'Bursa', 'Yıldırım', 'Hamamlılızz', 'Serım', 'Yoo', 'Yok', 'Var', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d098f178-04f7-4ce9-adee-0b2bfc4b8ad4', 'MU022', NULL, 0.000000, 'Muhammed kayra', 'Yıldız', 'MALE', '+905071421898', NULL, NULL, '12305853748', 'Niğde', '2008-03-07', 'Bursa', 'Osmangazi', 'Soğukkuyu', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b84afb7e-5be6-4275-92ec-d1aebd8427e0', 'LE005', NULL, 0.000000, 'Leyla ', 'Kali', 'FEMALE', '+905354320957', NULL, NULL, '16525749942', NULL, '1967-02-28', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown Atış Yapı E Blok K:5 D:29', NULL, 'Venocsin ', 'Dış Gebelik - Histerektomi', '-', 'Hipertansiyon', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('5fe80826-f48d-4eec-bccc-07af03862b43', 'Sİ010', NULL, 0.000000, 'Sinan ', 'Aktaş', 'MALE', '+905399622277', NULL, NULL, '41902195708', 'Erzurum', '1992-04-04', 'Bursa', 'Yıldırım', 'Şirinevler', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9edfaaf2-65ac-4838-927e-222cda05c594', 'ÖM007', NULL, 0.000000, 'Ömer ', 'Yıldız', 'MALE', '+905320159636', NULL, NULL, '15287458932', 'Kars', '1985-03-03', 'Bursa', 'Osmangazi', 'Hamitler', 'Serum', 'Yok', 'Yok', 'Yok', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('044e1353-2a09-4c40-838c-744548d84cbb', 'İS007', NULL, 0.000000, 'İshak', 'Durmuş', 'MALE', '+905377005440', NULL, NULL, '36343101258', NULL, '1999-11-05', 'Bursa', 'Osmangazi', 'Çağlayan köyü', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2803a315-db70-418d-a889-b97967377985', 'Dİ004', NULL, 0.000000, 'Dilan', 'Uzun', 'FEMALE', '+905350759743', NULL, NULL, '40336364278', NULL, '2000-07-27', 'Bursa', 'Nilüfer', 'Görükle', NULL, NULL, NULL, 'Alerjik astım', NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2289a9b7-4aac-4899-84cf-fdfda46f7888', 'ME050', NULL, 0.000000, 'Metecan', 'Yükselen', 'MALE', NULL, NULL, NULL, '35455118956', NULL, '1993-04-05', 'Bursa', 'Nilüfer', 'Akçalar köyü', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2e10d25e-6d05-4497-ada3-3c457b18c777', 'HA060', NULL, 0.000000, 'Hakan', 'Kalınkara', 'MALE', '+905326961229', NULL, NULL, '25550311888', NULL, '1982-05-02', 'Bursa', 'Nilüfer', 'Görükle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('28cf1fb3-2d6a-459b-af8b-267a4acbd188', 'EY001', NULL, 0.000000, 'Eymen Murat', 'Akdeniz', 'MALE', '+905332988917', NULL, NULL, '31787218488', 'Bursa', '2013-09-27', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2e9161c8-f466-4a30-8a70-d4b5d1e4db47', 'SE070', NULL, 2530.000000, 'Sefa ', 'Tombaş ', 'MALE', '+905442241652', NULL, NULL, '62644187356', NULL, '1992-09-25', 'Bursa', 'Nilüfer', 'Kayapa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4a92263a-55a4-40af-b611-1484a3257dcd', 'SE068', NULL, 0.000000, 'Seher', 'Işık', 'FEMALE', '+905425621017', NULL, NULL, NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d9821edf-50f8-4ea9-a81f-0a249f3be11e', 'AR009', NULL, 0.000000, 'Arzu', 'Seymen', 'FEMALE', '+905333823158', NULL, NULL, '16642736634', 'Bursa', '1966-01-23', 'Bursa', 'Nilüfer', 'Beşevler', 'Serum', 'Yok', 'Yoo', 'Yok', 'Yoo', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fac8cbfe-5936-4b46-b226-b80e17631f85', 'AY028', NULL, 0.000000, 'Ayşe ', 'Odabaş', 'FEMALE', '+905367910771', NULL, NULL, '69340081988', NULL, '1962-12-27', 'Bursa', 'Yıldırım', 'Cumalıkızlık mah', NULL, NULL, 'Kalp ablasyon ', 'Penisilin 
Siprofloksasin 
', 'Dm ht ky verem geçmişi astım', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('c0f4b194-bc7f-4b0e-8968-3be2adba7079', 'SÜ006', NULL, 2200.000000, 'Sümeyra', 'Doğan', 'FEMALE', '+905306600816', NULL, NULL, '37765066842', NULL, '1991-05-14', 'Bursa', 'Yıldırım', 'Yıldırım mah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('fd821c91-1f85-4bf0-b1a1-9a4a9157dbd4', 'ME051', NULL, 0.000000, 'Mesut ', 'Sönmez', 'MALE', '+905324652916', NULL, NULL, '16516724620', NULL, '1983-10-12', 'Bursa', 'Nilüfer', 'Beşevler a blok d4 kat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('3eea5e23-9463-47f9-9c36-ca9e1c342ed4', 'GU001', NULL, 0.000000, 'Gulnora', 'Tonya', 'FEMALE', '+905423085957', NULL, NULL, '99972348876', NULL, '1988-04-13', 'Bursa', 'Osmangazi', 'Optimum sitesi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('bd12baa8-2e46-4027-bc38-cdd0a1ba4d00', 'Gİ003', NULL, 0.000000, 'Gizem rabia', 'Bayram', 'FEMALE', '+905491050909', NULL, NULL, '35395113370', 'Bursa', '1993-05-14', 'Bursa', 'Nilüfer', 'Kayapa', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('3be70fa2-29c0-46de-89d3-bd53a0f7d967', 'AY029', NULL, 0.000000, 'Ayfer', 'Aşkın', 'FEMALE', '+905319377400', NULL, NULL, '24064799922', NULL, '1981-06-05', 'Bursa', 'Nilüfer', 'İhsaniye mah', NULL, 'Antidepresan', NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ae9c41f0-87a1-4415-8c67-545cddf3eefa', 'AH021', NULL, 0.000000, 'Ahmet', 'Başkan', 'MALE', '+905301715418', NULL, NULL, '12146344566', NULL, '1985-06-05', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown Atış yapı C Blok K:9 D:54', NULL, 'Lansor', 'Deniz Eti - Bademcik', '-', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('873c6b5f-6c94-4180-8a66-f94a2f0993dd', 'YA015', NULL, 0.000000, 'Yasemin ', 'Bebekçi', 'FEMALE', '+905326786667', NULL, NULL, '26090068966', NULL, '1987-06-10', 'Bursa', 'Yıldırım', 'Sinan dede mah elmas sitesi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('14c72083-934f-4172-956a-d2ad2aae242b', 'EM027', NULL, 0.000000, 'Emrah ', 'Türkseven', 'MALE', '+905337157100', NULL, NULL, '13207871076', NULL, '1984-12-31', 'Bursa', 'Nilüfer', 'Balat turkuaz garden  b blok daire 18 kat 5', 'Mide koruyucu her seferınde yapılcak', NULL, NULL, NULL, 'Gut hastalığı 
Eklemlerde cok ağrı oluyor', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('ee92d3d1-2b9a-43fd-b911-23682b724084', 'SE069', NULL, 0.000000, 'Selime ', 'Oda', 'FEMALE', '+905452058122', NULL, NULL, '42331912072', NULL, '1969-03-29', 'Bursa', 'Yıldırım', 'Millet mah ', 'Panit atak', NULL, NULL, 'Agumentin antibiyotik', NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('2d51e34f-5ef5-4162-a4e7-db782209a9ad', 'TU012', NULL, 0.000000, 'Tuba ', 'Başkan', 'FEMALE', '+905419664513', NULL, NULL, '31189708692', NULL, '1992-05-04', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown Atış yapı C Blok K:9 D :54', NULL, 'Yok', 'CİS(2) GÖZ (LAZER) ', 'Atopik Dermatit', '-', '-', NULL, NULL, true, DEFAULT);
INSERT INTO public.patients VALUES ('b6699583-aad1-42fa-8704-376fe75ee159', 'NE018', NULL, 0.000000, 'Necati', 'Kaya', 'MALE', '+905530521665', NULL, NULL, '26824399946', NULL, '1966-03-17', 'Bursa', 'Nilüfer', 'Demirci mah', NULL, NULL, NULL, NULL, 'Dm 
Akc ve kolon CA', NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('31ec16ad-5a52-4377-9e7f-30a376d6f9dd', 'YI005', NULL, 0.000000, 'Yıldız', 'Sevinç', 'FEMALE', '+905462200494', NULL, NULL, '44281401262', 'İstanbul', '1964-06-07', 'Bursa', 'Nilüfer', 'Özlüce', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('897fbf59-e3a6-4f3e-9f72-c82b54984560', 'OR002', NULL, 0.000000, 'Orhan ', 'Çavunt', 'MALE', '+905323015049', NULL, NULL, '22585573748', 'Bursa', '1942-01-12', 'Bursa', 'Yıldırım', 'İncirli cad. ', 'Serum
Sonda
Dr. Muayenesi
Röntgen
Akciğerler de sıvı toplamq', 'Dilarete 6 mg 
', 'Yoo', 'Yok', 'Kalp de büyüme', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('69732253-c5bf-47eb-bfac-e299f0aa4e75', 'KA013', NULL, 0.000000, 'Kasım', 'Tuzcu', 'MALE', '+905468010016', NULL, NULL, '27292059646', NULL, '1974-01-16', 'Bursa', 'Osmangazi', 'Yeni bağlar mah', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('10caf570-8e89-452e-924e-80ed7ca6a3fc', 'EM021', NULL, 3500.000000, 'Emine', 'Vatansever', 'FEMALE', '+905416144788', NULL, NULL, '38830018292', NULL, '1956-05-26', 'Bursa', 'Osmangazi ', 'Hürriyet mah ', 'İleri demans', NULL, 'Rahim alındı', 'Antibiyotik 
', 'Demans başlangıcı 
Böbrek yetmezliği 
Tansiyon 
', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('26067cb2-a819-4e7b-bc02-40d21083f15f', 'RA012', NULL, 0.000000, 'raziye', 'parlak', 'FEMALE', '+905332342323', NULL, NULL, '22223423434', 'bursa', '1989-05-03', 'Bursa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b20d7b38-f035-45a0-9dab-d3e11e4eb2ab', 'MU023', NULL, 0.000000, 'Muhammed', 'Şenduva', 'MALE', '+905388419680', NULL, NULL, '99988932670', 'Halep', '1996-02-24', 'Bursa', 'Nilüfer', 'Küçük sanayi', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('8b384657-a212-4de6-993d-586b2bce5fb3', 'ME052', NULL, 0.000000, 'Mehmet', 'Işık', 'MALE', '+905424741616', NULL, NULL, '46822931634', NULL, '1963-12-31', 'Bursa', 'Nilüfer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('86c1c8b1-1c80-4a72-af41-ec7535487de0', 'ŞU001', NULL, 0.000000, 'Şule', 'Yılmaz', 'FEMALE', '+905445431000', NULL, NULL, NULL, 'Özbekistan', '1990-06-09', 'Bursa', 'Osmangazi', 'Çekirge cad. ', 'Serum', 'Yok', 'Yok', 'Yok', 'Yoı', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('bd22dc81-5826-4b97-8876-4ca9f3f7f7d9', 'SÜ007', NULL, 0.000000, 'Süleyman ', 'Taşar', 'MALE', '+905464111619', NULL, NULL, NULL, NULL, NULL, 'Bursa', 'Nilüfer ', 'Mosso sitesi 29 numara Nilüfer Bursa ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e2fff399-42f3-4e59-83f3-7f40477726f5', 'HA061', NULL, 100.000000, 'Hasan', 'Görmez', 'MALE', '+905326151228', NULL, NULL, '58663394004', 'Sivas', '1977-01-31', 'Bursa', 'Nilüfer', 'Podyum', 'Serum', 'Yok', 'Yok', 'Yoj', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('06ca2f29-d676-412c-a55c-ba7e531e175d', 'VE006', NULL, 0.000000, 'Veysel ', 'Çelik', 'MALE', '+905454170685', NULL, NULL, '36094528502', NULL, '1994-02-07', 'Bursa', 'Nilüfer', 'Görükle', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('d8350430-a19e-4ad3-b5cb-b6856ff11ebb', 'ME053', NULL, 2200.000000, 'Mehmet', 'Yıldız', 'MALE', '+905326920997', NULL, NULL, '25699452428', 'Kilis', '1965-12-31', 'Bursa', 'Nilüfer', 'Balat', 'Serum', 'Ht', 'Yok', 'Yok', 'Ht', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9e87e623-2ed9-4a5f-9495-de4570ba4ac6', 'MU024', NULL, 0.000000, 'Muazzez ', 'Alper', 'FEMALE', '+905388102496', NULL, NULL, '35155140868', 'Bursa', '1941-03-03', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum
Soğuk algınlığı', 'Yok', 'Yok', 'Yok', 'Ht', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('b71c6bfc-c6f2-4f80-aa71-608bda782411', 'AY030', NULL, 0.000000, 'Aytaç', 'Güleş', 'MALE', '+905414226908', NULL, NULL, '14926158028', 'Ankara', '1991-08-15', 'Bursa', 'Osmangazi', 'Geçit', 'Serum', 'Yoı', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('3cf57a76-9ff6-43e5-8e27-abdb87674056', 'SE071', NULL, 0.000000, 'Seren', 'Küçükyeğen', 'FEMALE', '+905325042364', NULL, NULL, '38554040234', 'Bursa', '1994-03-31', 'Bursa', 'nilüfer', 'Balat', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('4a34add0-69b0-460b-b2ef-6893800d8109', 'DE006', NULL, 0.000000, 'Deniz', 'Altınsoy', 'MALE', '+905326541668', NULL, NULL, '11083945584', 'Bursa', '2006-10-05', 'Bursa', 'Nilüfer', 'Bademli', 'Serm', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('9ced148e-2706-4982-b20e-0744a0aa462b', 'İS008', NULL, 0.000000, 'İsmail ', 'Aydoğdu', 'MALE', '+905337199488', NULL, NULL, '35275136888', 'Bursa', '1994-01-17', 'Bursa', 'Osmangazi', 'Çağlayan', 'Serum', 'Yok', 'Yok', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('71f5f9c4-c452-401c-aa06-ee27cd30eea6', 'UĞ004', NULL, 2200.000000, 'UĞUR', 'KÜÇÜKYEĞEN', 'MALE', '905309689020', NULL, NULL, '24962193006', 'BURSA', '1989-12-06', 'Bursa', 'OSMANGAZİ', 'YUNUSELİ MAH 795.SK NO5/A SELAM GOLD SİTESİ KAT4 DAİRE 20', NULL, 'YOK', 'YOK', 'YOK', 'YOK', 'YOK', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('e772be6c-f190-4f54-a0c7-57919a14db8d', 'GA005', NULL, 0.000000, 'Gamze ', 'Yeşilova', 'FEMALE', '+905326178562', NULL, NULL, '28861339336', 'Bursa', '1997-11-01', 'Bursa', 'Nilüfer', 'Özlüce', 'Serum ', 'Yok', 'Yoo', 'Yok', 'Yok', 'Yok', NULL, NULL, false, DEFAULT);
INSERT INTO public.patients VALUES ('061e53e9-0b73-4150-a848-e3a009e1ea6c', 'AZ002', NULL, 100.000000, 'Azime', 'Gezen', 'FEMALE', '+905052104448', NULL, NULL, '19198668862', NULL, NULL, 'Bursa', 'Nilüfer ', '19 mayıs mahallesi no:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, DEFAULT);


--
-- Data for Name: pre_registrations; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.pre_registrations VALUES ('6c2d0892-4d8b-40a5-b110-e77c6b100913', NULL, NULL, '1e79d958-9e84-4d3a-b352-64cf8aa9d18f', 'Halise', 'İzgi', 'FEMALE', '+905066722151', '16889931038', '1947-12-29', 'Bursa', 'Nilüfer', 'Gümüştepe', 'Serum', false, '2025-09-16 17:25:39.086+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('eac87eae-d337-4e38-85d5-2842290a9874', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Ebru ', 'Yangöz', 'FEMALE', '+905322759474', '31828266286', '1983-04-07', 'Bursa', 'Osmangazi', 'Korupark evleri  Çınar 4 D:24', NULL, false, '2025-09-17 15:43:58.491644+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('52327d60-8f98-405f-9146-aa9f9ce0d071', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Ahmad', 'Alenezi', 'MALE', NULL, '00005913505', '1979-09-30', 'Bursa', 'Osmangazi', 'Pars Sok. Downtown atış yapı C Blok Kat :12 D:72', NULL, false, '2025-09-17 10:20:20.961+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('7f63b399-3b21-43bd-a915-2e1d6be0a85c', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Ali Ege', 'Sağlık', 'MALE', '+905413017412', '14403038508', '2008-02-13', 'Bursa', 'Osmangazi', 'Para sok Downtown atış yapı D Blok K:6 D:27', NULL, false, '2025-09-19 12:04:05.518+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('72a931d0-add6-4406-a039-5fab6cd353b0', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Halil Talha ', 'Aktaş', 'MALE', '+905342196421', '31582249846', '2018-02-11', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown Atış Yapı E blok kat:5 D:27', 'Suprız antibiyotik alerjisi var', false, '2025-09-22 15:45:48.49755+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('d7ec13f9-6e0c-451c-bdb3-53e31244047e', NULL, NULL, '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'DOĞAN ', 'TOPUZ', 'MALE', NULL, NULL, NULL, 'Bursa', NULL, NULL, NULL, false, '2025-09-26 23:57:32.355+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('3184c662-2862-425c-821b-ef4684674335', NULL, NULL, '9c4ace49-3623-4871-8532-f6447f152593', 'Barış', 'Karabolu', 'MALE', NULL, '30532307698', '1992-01-18', 'Bursa', 'Nilüfer', NULL, NULL, false, '2025-10-01 14:32:54.504+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('b421d1d4-11ca-49fd-bebb-f988af476110', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Sedat ', 'Çelenk', 'MALE', '+905307768154', '38551612922', '1979-05-28', 'Bursa', 'Osmangazi', 'İstiklal mah pars şok Downtown Atış yapı D Blok K:11 D:55', NULL, false, '2025-10-03 18:30:13.586384+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('68998c5b-16de-4cfa-8f1b-c2aa5aa554a3', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Bahriye ', 'Atış', 'FEMALE', '+905339343682', '19081664858', '1965-05-14', 'Bursa', 'Osmangazi', 'İstiklal mah Pars sok Downtown Atış yapı G Blok K:11 D:41', NULL, false, '2025-10-06 17:37:26.866128+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('f05fbe99-18c2-45d4-acf2-118fa02ba24a', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Hatice ', 'Yeşilbaş', 'FEMALE', '+905393844937', '41245206802', '1979-09-19', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı ', 'Personel', false, '2025-10-10 13:55:21.96026+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('5994f784-100b-4e39-a9e4-59b7987de070', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Necip Kerem ', 'Polat', 'MALE', '+905533134872', '34897158162', '2016-05-09', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı A Blok K:11 D:64', NULL, false, '2025-10-11 20:48:17.559343+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('fe9b01b9-1ecf-4481-8608-eb3b7a59208d', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Sever ', 'Küçükkarakoç', 'FEMALE', '+905414078016', '23569541432', '1983-04-18', 'Bursa', 'Osmangazi', 'İstiklal Mah Pars Sok Downtown Atış Yapı D Blok K:7 D:32', NULL, false, '2025-10-14 14:56:28.685035+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('6c3bbbea-9bb4-472c-a71d-0bd3a460c0db', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Hilal Nur', 'Kartal', 'FEMALE', '+905388609889', '22591557770', '1998-06-01', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D Blok D:57', NULL, false, '2025-10-14 17:46:26.537103+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('5852be88-fa1d-47bb-92e5-fded287577d6', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Kerem ', 'Gürdal', 'MALE', '+905357173377', '24724485400', '1994-07-16', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D Blok K:11 D:55', NULL, false, '2025-10-16 11:00:34.041534+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('23411f70-4a34-40cc-bd3b-d23bb365ff50', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Emine ', 'Örs', 'FEMALE', '+905316638378', '47992925546', NULL, 'Bursa', 'Osmangazi', 'Cumhuriyet mah çevre yolu cad kapı :58 D:7 osmangazi', NULL, false, '2025-10-16 14:56:23.591602+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('05d7f652-eefd-45d8-bfaa-78899f8d471e', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Sedra ', 'Tello', 'FEMALE', NULL, '99332354424', '2006-01-18', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı d blok ', NULL, false, '2025-10-20 14:35:51.914933+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('06b8097f-4826-485d-b5fb-457ef4eff220', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Gülşen ', 'Uçar', 'FEMALE', '+905386786934', '46624878106', '1957-02-28', 'Bursa', 'Nilüfer', 'Bilginler cad. Yasemin sok mavera park sitesi A Blok k:9 d: 25', NULL, false, '2025-10-21 12:17:28.844426+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('00881334-d270-4b68-a224-9e09fbceda48', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Gülsüm', 'Kıraçova', 'FEMALE', '+905312190400', '36070110042', '1989-06-16', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı C Blok K:14 D:84', NULL, false, '2025-10-21 13:29:42.238379+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('fdd7cb97-677b-43ad-b249-1c12a153107d', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Zeynep neva', 'Karataş', 'FEMALE', '+905352683874', '20632627086', '2023-01-31', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı D blok K:12 D:61', NULL, false, '2025-10-21 16:34:07.562331+03', DEFAULT);
INSERT INTO public.pre_registrations VALUES ('cfdccf0d-fc09-4218-8b3e-2cae7633f7db', NULL, NULL, '3430ed10-b646-4d3e-be86-9583c7f8b62e', 'Salih ', 'Altun', 'MALE', '+905323300871', '17276935772', '1980-01-25', 'Bursa', 'Osmangazi', 'İstiklal mah pars sok Downtown atış yapı E Blok K:6 D:36', NULL, false, '2025-10-22 10:53:42.919909+03', DEFAULT);


--
-- Data for Name: prescription_items; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: prescriptions; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: purchase_items; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.purchase_items VALUES ('91e8fb5a-ecd6-4c08-a7c2-59ad91dc1031', '160f0956-4d87-49db-894c-4433b8f6e1cb', '59fde62a-8280-422f-923a-9c09b188b782', 4.000000, 'C62', 1200.000000, 0, 0, DEFAULT, NULL, '2025-09-19 12:09:40.635225+03');
INSERT INTO public.purchase_items VALUES ('6f4d7d73-1294-4b48-ac71-04287a1778d0', '160f0956-4d87-49db-894c-4433b8f6e1cb', '256d3e33-b5af-4356-96e2-21494ec828db', 2.000000, 'C62', 2880.000000, 0, 0, DEFAULT, NULL, '2025-09-19 12:09:40.635225+03');
INSERT INTO public.purchase_items VALUES ('c1f1ebf2-8e44-470c-953f-cc71b29ed3bb', '1c47b9e7-9ff8-48b4-a899-7f1abca1c910', '9b91e12f-498e-4793-b7e4-895beaee0429', 1.000000, 'C62', 2500.000000, 0, 0, DEFAULT, NULL, '2025-09-22 12:52:51.549299+03');
INSERT INTO public.purchase_items VALUES ('707a2927-2957-4000-8fc3-bc7885209209', '1ba215b9-87db-4b3a-940e-0b48728fea5d', '4f8dad3b-f8fb-4c3a-80ad-58c105e41eee', 1.000000, 'C62', 9312.500000, 0, 0, DEFAULT, NULL, '2025-09-22 18:29:01.70782+03');
INSERT INTO public.purchase_items VALUES ('f63978e8-6283-4038-ab94-71bc4ccaeca0', 'a51d15db-dff1-41fd-b443-4f5004c54bd2', 'ce1dd0fe-9f14-455e-9d4c-e4856c88d72e', 2.000000, 'C62', 254.000000, 0, 20, DEFAULT, NULL, '2025-09-22 18:40:48.536274+03');
INSERT INTO public.purchase_items VALUES ('4966bb1b-6e46-4ac3-afba-5dd4bfa6fda1', 'c9e4552e-f40e-49a5-ac8d-1ce8f0a07e15', 'c3a16408-0ca1-4d5e-8324-f90cdeb2059a', 1.000000, 'C62', 10000.000000, 0, 0, DEFAULT, NULL, '2025-09-26 18:26:14.567475+03');
INSERT INTO public.purchase_items VALUES ('567d580a-b892-42c7-9d2e-f446b46324c4', 'affcf8d1-316f-456a-9b0c-95d8c30ee1e4', '4367a830-cc7c-4297-a8c8-449083f6f94e', 1.000000, 'C62', 3500.000000, 0, 0, DEFAULT, NULL, '2025-09-26 23:05:34.880011+03');
INSERT INTO public.purchase_items VALUES ('532b132b-82de-4ab5-a41a-784f67fbcd26', 'e0a09531-df69-4316-8b66-62a90ad1ec74', '85192bc7-bd9c-461a-a0e1-13003aa1160f', 1.000000, 'C62', 35000.000000, 0, 0, DEFAULT, NULL, '2025-09-26 23:07:10.486146+03');
INSERT INTO public.purchase_items VALUES ('1a80a11b-bfb7-4732-8689-1c734323ba2d', '88da8056-9510-46ce-8769-525697a0df9f', '0293dc80-c95d-4d54-9231-fa450a31b4d0', 1.000000, 'C62', 1500.000000, 0, 0, DEFAULT, NULL, '2025-09-27 18:31:52.052524+03');
INSERT INTO public.purchase_items VALUES ('0f43745e-d456-429c-b941-036e2570844f', '0d98422c-432a-4ff1-bd6b-8aa056ac0f32', 'a9e0a93e-8db3-46a9-bb73-d31fb96b8016', 1.000000, 'C62', 2500.000000, 0, 0, DEFAULT, NULL, '2025-09-28 14:41:19.45845+03');
INSERT INTO public.purchase_items VALUES ('628479d4-3095-4d41-98d3-62097cd4f22f', '5a92d189-1c32-4a4b-b6da-b33364407dae', '07a45e0a-3722-4291-80cf-f1d35bfc6e7a', 5.000000, 'C62', 2000.000000, 0, 0, DEFAULT, NULL, '2025-09-29 02:54:41.780226+03');
INSERT INTO public.purchase_items VALUES ('c70b8e0c-9777-4192-90d9-a3734553ab08', '75fc07f0-6513-431f-b6a1-e08c4ab41ab3', '52634090-8cb4-4a56-846b-04b4176b3e34', 25.000000, 'C62', 80.000000, 0, 0, DEFAULT, NULL, '2025-09-29 17:48:28.780852+03');
INSERT INTO public.purchase_items VALUES ('20810630-4dfc-4e4d-977a-5ef73e246dab', '7a1a42ff-2060-4218-a4c9-8bd9f9dfd23c', 'd4db479e-9602-4955-a202-c4e4b0ec5aa0', 8.000000, 'C62', 800.000000, 0, 0, DEFAULT, NULL, '2025-09-30 16:23:15.114026+03');
INSERT INTO public.purchase_items VALUES ('ddbd03bb-bf56-4074-a80a-f4a804ca576a', '8acd13f8-c3a3-4fcb-b1ab-60365ce57ef9', '43781d3d-594a-4700-bcc3-557c2124aaa6', 1.000000, 'C62', 5000.000000, 0, 0, DEFAULT, NULL, '2025-10-03 21:04:56.899899+03');
INSERT INTO public.purchase_items VALUES ('8b4c120d-5351-4bd3-8e8a-958c903e7554', '204b6633-b9a9-4454-b2b1-f60f6feb1e99', '197cda9b-da7d-4978-aaec-9a9f4fa15687', 1.000000, 'C62', 2500.000000, 0, 0, DEFAULT, NULL, '2025-10-04 18:16:21.389268+03');
INSERT INTO public.purchase_items VALUES ('f61441e1-adfb-49f7-ab04-71fdafb4fde9', '0e9fb780-73d7-4622-86c2-8a66f6d38f39', '5f8f31bd-a7a3-40f8-ad1a-f036b3ede62e', 4.000000, 'C62', 1625.000000, 0, 0, DEFAULT, NULL, '2025-10-06 13:42:23.469672+03');
INSERT INTO public.purchase_items VALUES ('10bb4b97-2bb3-4ba2-be6c-777de40bde9a', 'd849a31c-517c-46ae-93b5-1ba7b3a0790f', 'a9a2cc24-5cd1-415f-becf-f1b84c141573', 1.000000, 'C62', 24000.000000, 0, 0, DEFAULT, NULL, '2025-10-07 12:54:53.177821+03');
INSERT INTO public.purchase_items VALUES ('7735e65b-71d3-475b-b553-ae2d94f41630', '66bee2d6-b757-4368-bd06-af8800128d79', '3b80d8ac-882d-4951-9668-80c44904100a', 1.000000, 'C62', 25000.000000, 0, 0, DEFAULT, NULL, '2025-10-08 16:30:35.915623+03');
INSERT INTO public.purchase_items VALUES ('4f21affd-ab23-4312-874b-e5ddd87a132d', 'a4df4c5a-fe63-4e09-8ac8-edcd0cc7aa8d', '1996321b-c795-4237-92af-5661efab992a', 1.000000, 'C62', 1500.000000, 0, 0, DEFAULT, NULL, '2025-10-08 18:28:10.135643+03');
INSERT INTO public.purchase_items VALUES ('33d29100-f89c-4444-a307-8384bf7d1aa6', 'bf184a77-ce56-4f79-aca4-1726378e48d1', 'e3bd5aa8-8bbb-4354-9d0e-fdfad1cacd38', 2.000000, 'C62', 2250.000000, 0, 0, DEFAULT, NULL, '2025-10-14 00:34:59.907727+03');
INSERT INTO public.purchase_items VALUES ('4910bbb2-4a22-447e-92f4-56f19a106def', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '443b623b-f1a8-48c4-9dd6-83850cf0c464', 10.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('ebefd5f8-0e6a-4b9b-a2d0-04daf665cd19', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '0dd19da6-8d21-4c41-a06c-397bfad065fa', 100.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('35b88029-9d25-4a4d-9cd6-0f413d74d3bb', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '761d528e-af33-4857-8785-dfa6877149fc', 50.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('09770a8e-a396-406f-8403-a658bbe832c5', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', 'eefbd5e7-d237-424c-8463-c5eaa5d638d5', 30.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('d12187b9-a16a-4874-b0bd-857257fcd9b9', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '5062b40e-af6a-4059-989e-146e24c4afc4', 50.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('68ca7ee9-2953-4734-9ee3-877503ae613c', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '85431284-e732-4bf3-978a-952ea3cb42a4', 20.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('06f83aea-e69a-4a45-97bf-14beff6b3d33', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '3c219f1b-2e6e-4213-8012-dcb7a82cde23', 20.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('063b1bf2-ae01-4c60-9ed5-f935f1b10fe6', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', 'dff5a359-ebe5-439c-8481-c9ba3e356ad9', 5.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('981de32a-c726-4420-883d-02329072f3d0', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '2a462d59-8e81-43a8-be93-b0db4ff8f944', 10.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('e94f14f5-bc38-409f-9c12-c9b0b923fc32', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '6e0944b3-4e88-4941-9f70-a2a61d38cc6d', 2.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('25b7db0f-6c7e-4772-a94e-28e420322454', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '6ab4883a-e8b2-417f-aa3e-1bfa8d0e50a4', 2.000000, 'C62', 0.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('c517cd28-2aa7-4a1b-937e-54363a933cf9', '8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '62b8df03-b1c4-46c6-ad78-253047ddff32', 96.000000, 'C62', 10.000000, 0, 0, DEFAULT, NULL, '2025-10-30 15:51:33.44512+03');
INSERT INTO public.purchase_items VALUES ('268d32af-866b-4b51-8eba-a2bdbba2b30f', 'b627d610-7d11-43d0-8999-be3c5c80ea3e', 'b28c1647-0841-4016-b146-d933ce208b15', 1.000000, 'C62', 7500.000000, 0, 0, DEFAULT, NULL, '2025-10-30 16:27:25.524542+03');


--
-- Data for Name: purchases; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.purchases VALUES ('160f0956-4d87-49db-894c-4433b8f6e1cb', '88776611-bbfe-48c8-b890-8d64fa608da6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-19 12:08:00.767+03', '2025-09-19 12:08:00.767+03', 10560.000000, NULL, '220 EOURA ', NULL);
INSERT INTO public.purchases VALUES ('1c47b9e7-9ff8-48b4-a899-7f1abca1c910', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-22 12:52:31.372+03', '2025-09-22 12:52:31.372+03', 2500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('1ba215b9-87db-4b3a-940e-0b48728fea5d', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-18 00:00:00+03', '2025-09-18 00:00:00+03', 9312.500000, NULL, 'FATMA SEMA TERCAN TOMOGRAFİ ', NULL);
INSERT INTO public.purchases VALUES ('a51d15db-dff1-41fd-b443-4f5004c54bd2', '2fea03b0-7f91-4866-8aa8-75a4accca33d', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-22 18:40:23.035+03', '2025-09-22 18:40:23.035+03', 609.600000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('c9e4552e-f40e-49a5-ac8d-1ce8f0a07e15', '5d22f6f0-8941-4e33-9761-fc6f19627141', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-26 18:25:56.4+03', '2025-09-26 18:25:56.4+03', 10000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('affcf8d1-316f-456a-9b0c-95d8c30ee1e4', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-26 23:04:53.655+03', '2025-09-26 23:04:53.655+03', 3500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('e0a09531-df69-4316-8b66-62a90ad1ec74', '7385ea97-14f5-4f4c-aff9-db860072a206', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-26 23:06:23.119+03', '2025-09-26 23:06:23.119+03', 35000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('88da8056-9510-46ce-8769-525697a0df9f', '86b6f8f4-a889-43e9-8cdd-f2ac844cc5f6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-27 18:31:38.264+03', '2025-09-27 18:31:38.264+03', 1500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('0d98422c-432a-4ff1-bd6b-8aa056ac0f32', '86b6f8f4-a889-43e9-8cdd-f2ac844cc5f6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-28 14:41:07.481+03', '2025-09-28 14:41:07.481+03', 2500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('5a92d189-1c32-4a4b-b6da-b33364407dae', 'b3645cd5-4e97-412e-a30f-3c199dcdd660', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-29 02:54:23.186+03', '2025-09-29 02:54:23.186+03', 10000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('75fc07f0-6513-431f-b6a1-e08c4ab41ab3', '0b0bc68e-a0a2-4ea9-ad72-cca5196ef7e9', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-29 17:46:52.612+03', '2025-09-29 17:46:52.612+03', 2000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('7a1a42ff-2060-4218-a4c9-8bd9f9dfd23c', '303463ee-512f-4cce-be8e-6e0e966c8261', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-30 16:22:59.537+03', '2025-09-30 16:22:59.537+03', 6400.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('8acd13f8-c3a3-4fcb-b1ab-60365ce57ef9', '0b0bc68e-a0a2-4ea9-ad72-cca5196ef7e9', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-03 21:04:25.239+03', '2025-10-03 21:04:25.239+03', 5000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('204b6633-b9a9-4454-b2b1-f60f6feb1e99', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-04 18:16:11.431+03', '2025-10-04 18:16:11.431+03', 2500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('0e9fb780-73d7-4622-86c2-8a66f6d38f39', 'a252db66-e6ae-45ff-ac7f-06e489319e40', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-06 13:40:42.317+03', '2025-10-06 13:40:42.317+03', 6500.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('8ea3138d-0669-4689-aad9-2a2f57ccc2a7', '25327682-2166-4236-8a5b-cb339cdbcfcb', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-30 15:48:38.108+03', '2025-10-30 15:48:38.108+03', 960.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('d849a31c-517c-46ae-93b5-1ba7b3a0790f', '135ad19f-7d6f-44e7-9ebf-4bfe5b8e12c5', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-07 12:50:05.613+03', '2025-10-07 12:50:05.613+03', 24000.000000, NULL, NULL, NULL);
INSERT INTO public.purchases VALUES ('66bee2d6-b757-4368-bd06-af8800128d79', '135ad19f-7d6f-44e7-9ebf-4bfe5b8e12c5', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-09-30 00:00:00+03', '2025-10-30 00:00:00+03', 25000.000000, NULL, 'agustos 19.00 eylülden 6 bin ', NULL);
INSERT INTO public.purchases VALUES ('b627d610-7d11-43d0-8999-be3c5c80ea3e', 'a252db66-e6ae-45ff-ac7f-06e489319e40', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-30 16:26:55.363+03', '2025-10-30 16:26:55.363+03', 7500.000000, NULL, 'emine konat', NULL);
INSERT INTO public.purchases VALUES ('a4df4c5a-fe63-4e09-8ac8-edcd0cc7aa8d', '3c321143-a928-40c2-8929-e3fe6faf56fb', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-08 18:27:32.387+03', '2025-10-08 18:27:32.387+03', 1500.000000, NULL, 'VEYSEL TERECCE', NULL);
INSERT INTO public.purchases VALUES ('bf184a77-ce56-4f79-aca4-1726378e48d1', '8258f008-950d-443d-8811-d949a8e00018', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '2025-10-14 00:34:18.888+03', '2025-10-14 00:34:18.888+03', 4500.000000, NULL, NULL, NULL);


--
-- Data for Name: registration_channels; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: registration_subjects; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.registration_subjects VALUES ('0c84d02e-696a-48e6-8396-e476ff300826', 'AHMET YESEVİ MAH.ISIRGAN SK.GEÇİTPARK STES.C17 ');


--
-- Data for Name: sale_items; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: sales; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Data for Name: service_items; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.service_items VALUES ('eef5fe56-0026-49c6-9493-784e40bd6844', 'b3df4694-c5bb-48a9-959b-3a0ad07c0b27', '7bf6a9cf-cc4a-40d6-8d65-e600f86df3b7', 1.000000, true);
INSERT INTO public.service_items VALUES ('452ba9a8-7653-44c8-9a29-f73386ef3af8', 'b3df4694-c5bb-48a9-959b-3a0ad07c0b27', '9f79085b-26b2-41a2-a219-936fbc7fd225', 1.000000, true);
INSERT INTO public.service_items VALUES ('a7340a98-2896-476a-a79b-d5e09699fab4', '19e331b0-f887-4475-8628-7fac030a2b37', 'f8054f9d-b944-498e-9211-b8459f0d750a', 1.000000, false);


--
-- Data for Name: services; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.services VALUES ('457ea2b5-cde1-4fdf-89e5-2cb645e9a06f', 'PA001', 'PANSUMAN ', 0.000000);
INSERT INTO public.services VALUES ('2f9bfa9f-6fa3-46ff-8132-11711700c0a9', 'SO001', 'SONDA TAKILMASI', 1200.000000);
INSERT INTO public.services VALUES ('316763be-9611-4d3e-bcf0-3afa8dc173a1', 'TI001', 'TIBBI LABORATUVAR HİZMETLERİ ', 0.000000);
INSERT INTO public.services VALUES ('1a4ed38c-d099-4053-bfcf-2089f21e9870', 'TI002', 'TIBBI GÖRÜNTÜLEME HİZMETLERİ ', 0.000000);
INSERT INTO public.services VALUES ('e6876472-31cc-4d67-a2c2-810988fa8cf0', 'PS001', 'PSİKOLOG HİZMETİ', 1750.000000);
INSERT INTO public.services VALUES ('b3df4694-c5bb-48a9-959b-3a0ad07c0b27', 'SE001', 'SERUM', 1400.000000);
INSERT INTO public.services VALUES ('9aec313e-4f30-4168-ae25-5986ac4fb5d9', 'Dİ001', 'DİYETİSYEN', 2100.000000);
INSERT INTO public.services VALUES ('fe8d0d6b-c3b4-48fa-acc8-d842d13199a3', 'Fİ001', 'FİZYOTERAPİST', 1800.000000);
INSERT INTO public.services VALUES ('dd8d7fe0-9a8f-4b28-9198-b6d1bace5b2d', 'HA001', 'HASTA REFAKATÇI 12 SAAT ', 1600.000000);
INSERT INTO public.services VALUES ('42a4341f-d995-4567-93a6-c9b9a98e35af', 'KA001', 'KADIN DOĞUM UZMANI MUAYENESİ', 2500.000000);
INSERT INTO public.services VALUES ('49b27fb7-914a-4a7f-8cf4-72558cc0b676', 'KU001', 'KULAK DELME TEK KULAK ', 650.000000);
INSERT INTO public.services VALUES ('443c99c5-14a5-40e6-ac10-8c8c32383119', 'KU002', 'KULAK YIKAMA', 1800.000000);
INSERT INTO public.services VALUES ('37a756b8-dc77-4ebc-8d1f-f6d407ed7fd7', 'YA001', 'YATILI HASTA BAKICI ', 40000.000000);
INSERT INTO public.services VALUES ('fa533fba-c857-454e-906f-498fa533510a', 'UZ002', 'UZMAN ORTOPEDİ DOKTOR MUANESİ', 3500.000000);
INSERT INTO public.services VALUES ('bf09fc0c-48ca-4487-ace1-26b198a7d69f', 'UZ001', 'UZMAN DAHİLİYE DOKTOR MUAYENESİ', 3500.000000);
INSERT INTO public.services VALUES ('390f4e47-78fa-476b-b629-b6842f934193', 'HA003', 'HASTA VİTAL TAKİP ', 0.000000);
INSERT INTO public.services VALUES ('41804985-e731-4083-9ced-3531a6faeae3', 'HCMT', 'HACAMAT', 1500.000000);
INSERT INTO public.services VALUES ('aa9f7d9f-3726-4355-b4d6-300d09c6754f', 'DLG', 'DOLGU', 6000.000000);
INSERT INTO public.services VALUES ('ddccddfc-ff7e-4501-8ec1-3377fc2a4297', 'BTX', 'BOTOKS', 4000.000000);
INSERT INTO public.services VALUES ('39f5ec3b-1fcc-492a-b02f-1d643c3ded9b', 'PRP', 'PRP İŞLEMİ', 3000.000000);
INSERT INTO public.services VALUES ('67e97e81-446d-43e3-9c36-d48b546f0f0f', 'MZTR', 'AĞRI MEZOTERAPİSİ', 3000.000000);
INSERT INTO public.services VALUES ('b2ba06de-f751-4451-9206-548033884b48', 'TRNK', 'TIRNAK ÇEKİMİ', 3000.000000);
INSERT INTO public.services VALUES ('db3c8078-dcd9-4bcf-a95b-7ff5d8be190a', 'ASPR', 'ASPİRASYON', 2000.000000);
INSERT INTO public.services VALUES ('8c1935fa-11a9-4352-896d-0894c4dd64e6', 'DO001', 'DOKTOR MUAYENESİ', 5000.000000);
INSERT INTO public.services VALUES ('bc1c96b5-7df9-46ce-a8f7-347f1770cade', 'EN001', 'ENJEKSİYON ', 1000.000000);
INSERT INTO public.services VALUES ('57ef70b0-3c5c-47bb-928b-9030efdff720', 'EK001', 'EKG ÇEKİMİ EVDE ', 0.000000);
INSERT INTO public.services VALUES ('36f1837c-8339-49fa-84f6-2840c3fe1a75', 'EK002', 'EKG ÇEKİMİ MERKEZDE ', 0.000000);
INSERT INTO public.services VALUES ('4e340d61-6762-47f0-815a-fe8090dee53f', 'TÜ001', 'TÜM ABDOMEN USG ÇEKİMİ ', 0.000000);
INSERT INTO public.services VALUES ('49ab38b0-1f80-4cfd-b4d9-bf9935ed3a06', 'BO001', 'BOYUN USG ', 0.000000);
INSERT INTO public.services VALUES ('2110e7e9-608c-4a8c-a0b3-f52b88aa7cdb', 'UL001', 'ULTRASON ÇEKİMİ ', 0.000000);
INSERT INTO public.services VALUES ('e7c26e0b-ca7c-477e-908b-e54aecfd75a1', 'BE001', 'BEYİN CERRAHİ DOKTOR MUANESİ ', 0.000000);
INSERT INTO public.services VALUES ('ad3a0be9-5e87-4cdc-8855-c8bfb88dc1e1', 'OR001', 'ORTAPEDİ DOKTOR MUANESİ ', 0.000000);
INSERT INTO public.services VALUES ('2000b3c2-dafd-457f-817f-935088d3d27e', 'NÖ001', 'NÖROLOJİ DOKTOR MUANESİ', 0.000000);
INSERT INTO public.services VALUES ('21439915-faba-4e92-83ec-e84a31fb6cb3', 'KA002', 'KADIN DOĞUM DOKTOR MUANESİ ', 0.000000);
INSERT INTO public.services VALUES ('9468780a-ae26-4f8b-8add-8320a4335099', 'ŞÜ001', 'ŞÜKRAN KOÇ GENOKS TAHLİL ', 250.000000);
INSERT INTO public.services VALUES ('85ff1eca-a6aa-4aa0-9e13-a5cc780ad889', 'RÖ001', 'RÖNTGEN ÇEKİMİ ', 4500.000000);
INSERT INTO public.services VALUES ('80bf4e96-158e-4641-a2aa-a6d47b6ab32a', '5 001', '5 Lİ PCR TESTİ ', 1500.000000);
INSERT INTO public.services VALUES ('ac1ba5f3-9239-470b-805b-ee11c485c1b9', 'HE001', 'HEMŞİRELİK HİZMETİ 24 saat ', 5500.000000);
INSERT INTO public.services VALUES ('b42361cf-4000-4990-8cda-13f28c968380', 'AY001', 'AYAK BAKIM HİZMETİ ', 1750.000000);
INSERT INTO public.services VALUES ('701420d5-ab37-46d2-9cd0-a7dc990063fc', 'ME001', 'MEDİKAL MALZEME ŞEKER ALETİ ', 0.000000);
INSERT INTO public.services VALUES ('1edf8aa9-d284-492a-9390-636f2edf554c', 'EC001', 'ECZANE İLAÇ ', 0.000000);
INSERT INTO public.services VALUES ('d46bbe52-469b-49ca-becf-ccf5296441f8', 'PO001', 'PORTATİF SERUM ASKISI ', 2000.000000);
INSERT INTO public.services VALUES ('638b20c0-4710-41d5-9256-f8a875501c60', 'OK001', 'OKSİJEN KONSANTRATÖRÜ   ', 4500.000000);
INSERT INTO public.services VALUES ('aa472074-c3cd-4a5a-b51f-ca7afa1694c1', 'GE001', 'GENOX FETAL DNA TESTİ ', 15500.000000);
INSERT INTO public.services VALUES ('2141c5b2-e129-486e-a3d8-84cc62f947a2', 'TO001', 'TOMOGRAFİ BT', 0.000000);
INSERT INTO public.services VALUES ('f146e5a3-6acf-4022-b872-ba9f3b1f0bfb', 'OK002', 'OKSİJEN TÜPÜ ', 2500.000000);
INSERT INTO public.services VALUES ('373e7343-790b-47d7-874e-40afdcab8171', 'HA002', 'HASTA YIKAMA', 2200.000000);
INSERT INTO public.services VALUES ('6ec01eaa-4cf3-4f03-b206-d1af7faf3eb9', ' T001', ' TRAKEOSTOMİ KANÜL DEĞİŞİMİ ', 4500.000000);
INSERT INTO public.services VALUES ('2993649d-d990-4f42-9178-2f86d923563a', 'MR001', 'MR ', 0.000000);
INSERT INTO public.services VALUES ('690971de-ad55-48b4-a086-afddc9e2750d', 'KA003', 'KADIN DOĞUM DOKTOR MUANESİ ', 0.000000);
INSERT INTO public.services VALUES ('19e331b0-f887-4475-8628-7fac030a2b37', 'ÜR001', 'ÜRÜN TEDARİK ', 0.000000);
INSERT INTO public.services VALUES ('80c50c99-3b2b-4be9-aab6-45630795c610', 'GI001', 'GIDA İN TOLERANS Lİ TEST ', 7500.000000);
INSERT INTO public.services VALUES ('dd27edb5-542c-455f-8ab4-9f557ae7fa3f', 'Sİ001', 'SİTEYE SAĞLIK HİZMETİ ', 63600.000000);
INSERT INTO public.services VALUES ('ee8c7798-9d82-4768-8f49-0550758fc030', 'SE002', 'SENTETİK ALÇI ', 0.000000);
INSERT INTO public.services VALUES ('7e865e79-25c2-4c3a-bbfa-25cd21002bbf', ' N001', '** NAKİT ÖDEME***', 0.000000);
INSERT INTO public.services VALUES ('6cc4a869-6989-44bd-8bd8-9246cf2e3928', 'OZ001', 'OZAN TERAPİ', 0.000000);
INSERT INTO public.services VALUES ('7a3818e2-bb3a-45bc-8908-50cb8f0d9a0e', 'GR001', 'GRİP AŞISI', 0.000000);
INSERT INTO public.services VALUES ('d1d18f18-cee9-4206-b3cc-c3fb205277d1', ' A001', '**** ALACAK****', 0.000000);
INSERT INTO public.services VALUES ('32442c1f-89f8-4d3d-8a1d-9e7b51a27e93', 'SA001', 'SAĞLIK HİZMETİ', 63600.000000);
INSERT INTO public.services VALUES ('f1f61617-38b9-49b0-be4d-6c15cb584a71', 'HE002', 'HEMŞİRELİK HİZMETİ GÜNLÜK 4 SAATLİK', 30000.000000);
INSERT INTO public.services VALUES ('8217c400-9124-46d0-860f-11631ff63c00', 'EL001', 'EL AYAK BAKIM ', 2000.000000);
INSERT INTO public.services VALUES ('551a50f9-2877-4602-b960-e592194c0dbf', 'ME002', 'MEDİKAL MASAJ ', 0.000000);
INSERT INTO public.services VALUES ('a29d4776-bf8e-40b6-8264-51a9050a21f1', 'NE001', 'Nebül hava', 0.000000);
INSERT INTO public.services VALUES ('105a46d5-b09b-4f8a-866b-4453ef32f5da', 'HE003', 'HEMOGLABİN ÖLÇÜMÜ ', 400.000000);
INSERT INTO public.services VALUES ('de760bf5-743e-42f0-b1f5-71a1204efbc9', 'EK003', 'eko çekimi', 3500.000000);
INSERT INTO public.services VALUES ('102bc7bf-258c-4238-befc-c52654221334', 'UZ003', 'Uzman kardiyoloji muanesi', 6500.000000);
INSERT INTO public.services VALUES ('5882abc0-74e3-4d37-8ca2-c328f69fe5df', 'AM001', 'Ambulans Hizmeti', 3000.000000);


--
-- Data for Name: supplier_operations; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO public.supplier_operations VALUES ('2871228e-4d24-489b-be76-7f1082d9bd31', '88776611-bbfe-48c8-b890-8d64fa608da6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '09d13911-989d-4378-82e1-79ee5424d7f3', '2025-09-19 13:10:38.256+03', 15800.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('efd4e912-dc89-4498-8091-de95e8a45b98', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '69859158-ff36-487c-8b4d-2e426d00241d', '2025-09-22 18:27:23.689+03', 2500.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('c480ed36-808d-4c98-a186-7e60ce45189f', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '69859158-ff36-487c-8b4d-2e426d00241d', '2025-09-22 18:29:08.972+03', 9312.500000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('09723c26-f22a-468f-9711-ca4ee3ef8200', '2fea03b0-7f91-4866-8aa8-75a4accca33d', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'c3675bbf-9c43-4de9-b3ee-05d3107202c2', '2025-09-22 18:40:54.515+03', 609.600000, 2, 'MASA BAYRAK ');
INSERT INTO public.supplier_operations VALUES ('6ad97ca5-8b91-4a29-81e0-c59bc1a4cdef', '5d22f6f0-8941-4e33-9761-fc6f19627141', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '09d13911-989d-4378-82e1-79ee5424d7f3', '2025-09-26 18:26:25.258+03', 8092.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('15d3ff82-ffcb-4a8d-8fa1-39b08338102c', '5d22f6f0-8941-4e33-9761-fc6f19627141', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-26 18:32:41.37+03', 1908.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('9a2788f2-c752-4f3d-83cc-13d22817a0ee', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-26 23:05:43.46+03', 3500.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('eba92da0-3e62-4d95-8abd-421c74f80f9b', '86b6f8f4-a889-43e9-8cdd-f2ac844cc5f6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-27 18:31:58.179+03', 1500.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('1576f8e9-7489-4ac5-8332-9848bf8cb870', '86b6f8f4-a889-43e9-8cdd-f2ac844cc5f6', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-28 14:41:25.11+03', 2500.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('eb547997-79b7-4fd5-aba2-c38295205fe9', 'b3645cd5-4e97-412e-a30f-3c199dcdd660', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-29 02:54:46.005+03', 5000.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('a258ae78-55f5-42d2-b4a1-92d94c1c8303', 'b3645cd5-4e97-412e-a30f-3c199dcdd660', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'e6baa3ee-ca68-44ce-a4f0-8ba62bf2ed9e', '2025-09-29 02:54:52.567+03', 5000.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('c04f7d21-700e-4713-af93-846587a71adb', '303463ee-512f-4cce-be8e-6e0e966c8261', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-09-30 16:23:19.105+03', 9000.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('2717ca1e-dad7-4e78-89d3-a1d5c0341b6f', '25327682-2166-4236-8a5b-cb339cdbcfcb', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '41b867bc-364e-4af6-ada5-08391afa2c54', '2025-10-03 19:59:52.889+03', 15000.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('30b37d56-e558-41e7-b6b5-2e2dad0544d5', '7529ba0e-7dfe-4ee2-9e99-3743adf6a6d7', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-10-04 18:16:26.012+03', 2500.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('dc932fa0-2334-4e83-b7ec-d133ef2156be', 'a252db66-e6ae-45ff-ac7f-06e489319e40', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '0864a6c8-025b-4c34-ba52-bc214bc1fd90', '2025-10-06 13:43:14.712+03', 6500.000000, 2, 'Emine konat');
INSERT INTO public.supplier_operations VALUES ('b3e4c2e1-682c-4fac-be16-9204bd7ba1d0', '135ad19f-7d6f-44e7-9ebf-4bfe5b8e12c5', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '09d13911-989d-4378-82e1-79ee5424d7f3', '2025-10-07 12:55:29.98+03', 8000.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('232612ed-f250-4695-a9d6-52a5e86b9d95', '135ad19f-7d6f-44e7-9ebf-4bfe5b8e12c5', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '6a117629-ca97-46d3-83b7-95a4ecf816d9', '2025-10-07 12:55:52.727+03', 8000.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('c9368a7a-f008-42be-a709-ec99af5b1512', '135ad19f-7d6f-44e7-9ebf-4bfe5b8e12c5', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '69859158-ff36-487c-8b4d-2e426d00241d', '2025-10-07 12:56:05.472+03', 8000.000000, 1, NULL);
INSERT INTO public.supplier_operations VALUES ('b966ab6e-0b0c-47d8-a261-544d5f511073', '3c321143-a928-40c2-8929-e3fe6faf56fb', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '0864a6c8-025b-4c34-ba52-bc214bc1fd90', '2025-10-08 18:28:12.297+03', 1500.000000, 2, NULL);
INSERT INTO public.supplier_operations VALUES ('ece6c35f-004c-4e36-8f90-69a53d6633a5', '8258f008-950d-443d-8811-d949a8e00018', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '468171c9-ffbb-44be-803c-4185b90c69e2', '2025-10-10 00:36:10+03', 4500.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('8787eacb-6dcc-43c1-a014-917bbdef4b24', '25327682-2166-4236-8a5b-cb339cdbcfcb', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '41b867bc-364e-4af6-ada5-08391afa2c54', '2025-10-15 15:06:05.026+03', 4000.000000, 2, NULL);
INSERT INTO public.supplier_operations VALUES ('c02deb03-35cc-4000-9288-e1ca281d98c0', '7385ea97-14f5-4f4c-aff9-db860072a206', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', 'f92557de-f4dd-4438-9cb0-eed9008e149d', '2025-10-30 16:17:20.512+03', 35000.000000, 0, NULL);
INSERT INTO public.supplier_operations VALUES ('957a9b26-57eb-4b75-ad52-a28b0fda63f0', 'a252db66-e6ae-45ff-ac7f-06e489319e40', '8de6ff31-e7f3-474a-a2e9-9602cddec1b6', '35e42921-d85d-4130-a31e-0b1155c2a01c', '2025-10-30 16:27:29.261+03', 7500.000000, 0, NULL);


--
-- Data for Name: wpmessages; Type: TABLE DATA; Schema: public; Owner: -
--



--
-- Name: account_operations account_operations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.account_operations
    ADD CONSTRAINT account_operations_pkey PRIMARY KEY (id);


--
-- Name: accounts accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT accounts_pkey PRIMARY KEY (id);


--
-- Name: application_service_items application_service_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_service_items
    ADD CONSTRAINT application_service_items_pkey PRIMARY KEY (id);


--
-- Name: application_services application_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_services
    ADD CONSTRAINT application_services_pkey PRIMARY KEY (id);


--
-- Name: applications applications_appointment_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_appointment_id_key UNIQUE (appointment_id);


--
-- Name: applications applications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_pkey PRIMARY KEY (id);


--
-- Name: appointment_users appointment_user_appointment_id_user_id; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointment_users
    ADD CONSTRAINT appointment_user_appointment_id_user_id UNIQUE (appointment_id, user_id);


--
-- Name: appointment_users appointment_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointment_users
    ADD CONSTRAINT appointment_users_pkey PRIMARY KEY (id);


--
-- Name: appointments appointments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointments
    ADD CONSTRAINT appointments_pkey PRIMARY KEY (id);


--
-- Name: blood_companies blood_companies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_companies
    ADD CONSTRAINT blood_companies_pkey PRIMARY KEY (id);


--
-- Name: blood_test_items blood_test_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_test_items
    ADD CONSTRAINT blood_test_items_pkey PRIMARY KEY (id);


--
-- Name: blood_tests blood_tests_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_tests
    ADD CONSTRAINT blood_tests_pkey PRIMARY KEY (application_id);


--
-- Name: blood_values blood_values_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_values
    ADD CONSTRAINT blood_values_pkey PRIMARY KEY (id);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: configurations configurations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.configurations
    ADD CONSTRAINT configurations_pkey PRIMARY KEY (key);


--
-- Name: departments departments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.departments
    ADD CONSTRAINT departments_pkey PRIMARY KEY (id);


--
-- Name: expense_records expense_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expense_records
    ADD CONSTRAINT expense_records_pkey PRIMARY KEY (id);


--
-- Name: expenses expenses_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expenses
    ADD CONSTRAINT expenses_pkey PRIMARY KEY (id);


--
-- Name: fixtures fixtures_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.fixtures
    ADD CONSTRAINT fixtures_pkey PRIMARY KEY (id);


--
-- Name: login_logs login_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.login_logs
    ADD CONSTRAINT login_logs_pkey PRIMARY KEY (id);


--
-- Name: medicines medicines_barcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.medicines
    ADD CONSTRAINT medicines_barcode_key UNIQUE (barcode);


--
-- Name: medicines medicines_code_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.medicines
    ADD CONSTRAINT medicines_code_key UNIQUE (code);


--
-- Name: medicines medicines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.medicines
    ADD CONSTRAINT medicines_pkey PRIMARY KEY (id);


--
-- Name: patient_invoice_details patient_invoice_details_patient_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_invoice_details
    ADD CONSTRAINT patient_invoice_details_patient_id_key UNIQUE (patient_id);


--
-- Name: patient_invoice_details patient_invoice_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_invoice_details
    ADD CONSTRAINT patient_invoice_details_pkey PRIMARY KEY (id);


--
-- Name: patient_operations patient_operations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_operations
    ADD CONSTRAINT patient_operations_pkey PRIMARY KEY (id);


--
-- Name: patients patients_code_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patients
    ADD CONSTRAINT patients_code_key UNIQUE (code);


--
-- Name: patients patients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patients
    ADD CONSTRAINT patients_pkey PRIMARY KEY (id);


--
-- Name: patients patients_tckn_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patients
    ADD CONSTRAINT patients_tckn_key UNIQUE (tckn);


--
-- Name: pre_registrations pre_registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pre_registrations
    ADD CONSTRAINT pre_registrations_pkey PRIMARY KEY (id);


--
-- Name: prescription_items prescription_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescription_items
    ADD CONSTRAINT prescription_items_pkey PRIMARY KEY (id);


--
-- Name: prescription_items prescription_items_prescription_id_medicine_id; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescription_items
    ADD CONSTRAINT prescription_items_prescription_id_medicine_id UNIQUE (prescription_id, medicine_id);


--
-- Name: prescriptions prescriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescriptions
    ADD CONSTRAINT prescriptions_pkey PRIMARY KEY (id);


--
-- Name: purchase_items purchase_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT purchase_items_pkey PRIMARY KEY (id);


--
-- Name: purchases purchases_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT purchases_pkey PRIMARY KEY (id);


--
-- Name: registration_channels registration_channels_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.registration_channels
    ADD CONSTRAINT registration_channels_pkey PRIMARY KEY (id);


--
-- Name: registration_subjects registration_subjects_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.registration_subjects
    ADD CONSTRAINT registration_subjects_pkey PRIMARY KEY (id);


--
-- Name: sale_items sale_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sale_items
    ADD CONSTRAINT sale_items_pkey PRIMARY KEY (id);


--
-- Name: sales sales_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sales
    ADD CONSTRAINT sales_pkey PRIMARY KEY (id);


--
-- Name: service_items service_items_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.service_items
    ADD CONSTRAINT service_items_pkey PRIMARY KEY (id);


--
-- Name: service_items service_items_service_id_medicine_id; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.service_items
    ADD CONSTRAINT service_items_service_id_medicine_id UNIQUE (service_id, medicine_id);


--
-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.services
    ADD CONSTRAINT services_pkey PRIMARY KEY (id);


--
-- Name: supplier_operations supplier_operations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.supplier_operations
    ADD CONSTRAINT supplier_operations_pkey PRIMARY KEY (id);


--
-- Name: wpmessages wpmessages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.wpmessages
    ADD CONSTRAINT wpmessages_pkey PRIMARY KEY (id);


--
-- Name: account_operations acc_operation_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER acc_operation_after_delete_trigger AFTER DELETE ON public.account_operations FOR EACH ROW EXECUTE FUNCTION public.acc_operation_after_delete_function();


--
-- Name: account_operations acc_operation_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER acc_operation_after_insert_trigger BEFORE INSERT ON public.account_operations FOR EACH ROW EXECUTE FUNCTION public.acc_operation_after_insert_function();


--
-- Name: account_operations acc_operation_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER acc_operation_after_update_trigger AFTER UPDATE ON public.account_operations FOR EACH ROW EXECUTE FUNCTION public.acc_operation_after_update_function();


--
-- Name: account_operations acc_operation_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER acc_operation_before_update_trigger BEFORE UPDATE ON public.account_operations FOR EACH ROW EXECUTE FUNCTION public.acc_operation_before_update_function();


--
-- Name: accounts account_before_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER account_before_insert_trigger BEFORE INSERT ON public.accounts FOR EACH ROW EXECUTE FUNCTION public.account_before_insert_function();


--
-- Name: accounts account_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER account_before_update_trigger BEFORE UPDATE ON public.accounts FOR EACH ROW EXECUTE FUNCTION public.account_before_update_function();


--
-- Name: applications application_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_after_delete_trigger AFTER DELETE ON public.applications FOR EACH ROW EXECUTE FUNCTION public.application_after_delete_function();


--
-- Name: applications application_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_after_insert_trigger AFTER INSERT ON public.applications FOR EACH ROW EXECUTE FUNCTION public.application_after_insert_function();


--
-- Name: applications application_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_after_update_trigger AFTER UPDATE ON public.applications FOR EACH ROW EXECUTE FUNCTION public.application_after_update_function();


--
-- Name: applications application_before_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_before_delete_trigger BEFORE DELETE ON public.applications FOR EACH ROW EXECUTE FUNCTION public.application_before_delete_function();


--
-- Name: applications application_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_before_update_trigger BEFORE UPDATE ON public.applications FOR EACH ROW EXECUTE FUNCTION public.application_before_update_function();


--
-- Name: application_services application_service_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_after_delete_trigger AFTER DELETE ON public.application_services FOR EACH ROW EXECUTE FUNCTION public.application_service_after_delete_function();


--
-- Name: application_services application_service_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_after_insert_trigger AFTER INSERT ON public.application_services FOR EACH ROW EXECUTE FUNCTION public.application_service_after_insert_function();


--
-- Name: application_services application_service_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_after_update_trigger AFTER UPDATE ON public.application_services FOR EACH ROW EXECUTE FUNCTION public.application_service_after_update_function();


--
-- Name: application_services application_service_before_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_before_delete_trigger BEFORE DELETE ON public.application_services FOR EACH ROW EXECUTE FUNCTION public.application_service_before_delete_function();


--
-- Name: application_services application_service_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_before_update_trigger BEFORE UPDATE ON public.application_services FOR EACH ROW EXECUTE FUNCTION public.application_service_before_update_function();


--
-- Name: application_service_items application_service_item_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_item_after_delete_trigger AFTER DELETE ON public.application_service_items FOR EACH ROW EXECUTE FUNCTION public.application_service_item_after_delete_function();


--
-- Name: application_service_items application_service_item_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_item_after_insert_trigger AFTER INSERT ON public.application_service_items FOR EACH ROW EXECUTE FUNCTION public.application_service_item_after_insert_function();


--
-- Name: application_service_items application_service_item_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_item_after_update_trigger AFTER UPDATE ON public.application_service_items FOR EACH ROW EXECUTE FUNCTION public.application_service_item_after_update_function();


--
-- Name: application_service_items application_service_item_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER application_service_item_before_update_trigger BEFORE UPDATE ON public.application_service_items FOR EACH ROW EXECUTE FUNCTION public.application_service_item_before_update_function();


--
-- Name: appointments appointment_before_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER appointment_before_insert_trigger BEFORE INSERT ON public.appointments FOR EACH ROW EXECUTE FUNCTION public.appointment_before_insert_function();


--
-- Name: appointments appointment_generate_no; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER appointment_generate_no BEFORE INSERT OR UPDATE ON public.appointments FOR EACH ROW WHEN ((new.appointment_no IS NULL)) EXECUTE FUNCTION public.generate_appointment_no();


--
-- Name: accounts check_account_category_id_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER check_account_category_id_trigger BEFORE INSERT OR UPDATE ON public.accounts FOR EACH ROW EXECUTE FUNCTION public.check_category_type_in_category_id();


--
-- Name: blood_values check_blood_value_category_id_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER check_blood_value_category_id_trigger BEFORE INSERT OR UPDATE ON public.blood_values FOR EACH ROW EXECUTE FUNCTION public.check_category_type_in_category_id();


--
-- Name: expenses check_expense_category_id_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER check_expense_category_id_trigger BEFORE INSERT OR UPDATE ON public.expenses FOR EACH ROW EXECUTE FUNCTION public.check_category_type_in_category_id();


--
-- Name: medicines check_medicine_category_id_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER check_medicine_category_id_trigger BEFORE INSERT OR UPDATE ON public.medicines FOR EACH ROW EXECUTE FUNCTION public.check_category_type_in_category_id();


--
-- Name: patients check_patient_category_id_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER check_patient_category_id_trigger BEFORE INSERT OR UPDATE ON public.patients FOR EACH ROW EXECUTE FUNCTION public.check_category_type_in_category_id();


--
-- Name: expense_records expense_record_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER expense_record_after_delete_trigger AFTER DELETE ON public.expense_records FOR EACH ROW EXECUTE FUNCTION public.expense_record_after_delete_function();


--
-- Name: expense_records expense_record_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER expense_record_after_insert_trigger AFTER INSERT ON public.expense_records FOR EACH ROW EXECUTE FUNCTION public.expense_record_after_insert_function();


--
-- Name: expense_records expense_record_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER expense_record_after_update_trigger AFTER UPDATE ON public.expense_records FOR EACH ROW EXECUTE FUNCTION public.expense_record_after_update_function();


--
-- Name: medicines medicine_barcode_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER medicine_barcode_trigger BEFORE INSERT OR UPDATE ON public.medicines FOR EACH ROW WHEN ((new.barcode IS NULL)) EXECUTE FUNCTION public.generate_barcode();


--
-- Name: medicines medicine_code_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER medicine_code_trigger BEFORE INSERT OR UPDATE ON public.medicines FOR EACH ROW WHEN ((new.code IS NULL)) EXECUTE FUNCTION public.generate_code();


--
-- Name: patient_operations pat_operation_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER pat_operation_after_delete_trigger AFTER DELETE ON public.patient_operations FOR EACH ROW EXECUTE FUNCTION public.pat_operation_after_delete_function();


--
-- Name: patient_operations pat_operation_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER pat_operation_after_insert_trigger AFTER INSERT ON public.patient_operations FOR EACH ROW EXECUTE FUNCTION public.pat_operation_after_insert_function();


--
-- Name: patient_operations pat_operation_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER pat_operation_after_update_trigger AFTER UPDATE ON public.patient_operations FOR EACH ROW EXECUTE FUNCTION public.pat_operation_after_update_function();


--
-- Name: patient_operations pat_operation_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER pat_operation_before_update_trigger BEFORE UPDATE ON public.patient_operations FOR EACH ROW EXECUTE FUNCTION public.pat_operation_before_update_function();


--
-- Name: patients patient_before_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER patient_before_insert_trigger BEFORE INSERT ON public.patients FOR EACH ROW EXECUTE FUNCTION public.patient_before_insert_function();


--
-- Name: patients patient_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER patient_before_update_trigger BEFORE UPDATE ON public.patients FOR EACH ROW EXECUTE FUNCTION public.patient_before_update_function();


--
-- Name: patients patient_code_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER patient_code_trigger BEFORE INSERT OR UPDATE ON public.patients FOR EACH ROW WHEN ((new.code IS NULL)) EXECUTE FUNCTION public.generate_code();


--
-- Name: prescriptions prescription_generate_no; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER prescription_generate_no BEFORE INSERT OR UPDATE ON public.prescriptions FOR EACH ROW WHEN ((new.prescription_no IS NULL)) EXECUTE FUNCTION public.generate_prescription_no();


--
-- Name: purchases purchase_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_after_delete_trigger AFTER DELETE ON public.purchases FOR EACH ROW EXECUTE FUNCTION public.purchase_after_delete_function();


--
-- Name: purchases purchase_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_after_update_trigger AFTER UPDATE ON public.purchases FOR EACH ROW EXECUTE FUNCTION public.purchase_after_update_function();


--
-- Name: purchases purchase_before_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_before_insert_trigger BEFORE INSERT ON public.purchases FOR EACH ROW EXECUTE FUNCTION public.purchase_before_insert_function();


--
-- Name: purchases purchase_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_before_update_trigger BEFORE UPDATE ON public.purchases FOR EACH ROW EXECUTE FUNCTION public.purchase_before_update_function();


--
-- Name: purchase_items purchase_item_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_item_after_delete_trigger AFTER DELETE ON public.purchase_items FOR EACH ROW EXECUTE FUNCTION public.purchase_item_after_delete_function();


--
-- Name: purchase_items purchase_item_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_item_after_insert_trigger AFTER INSERT ON public.purchase_items FOR EACH ROW EXECUTE FUNCTION public.purchase_item_after_insert_function();


--
-- Name: purchase_items purchase_item_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_item_after_update_trigger AFTER UPDATE ON public.purchase_items FOR EACH ROW EXECUTE FUNCTION public.purchase_item_after_update_function();


--
-- Name: purchase_items purchase_item_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_item_before_update_trigger BEFORE UPDATE ON public.purchase_items FOR EACH ROW EXECUTE FUNCTION public.purchase_item_before_update_function();


--
-- Name: purchase_items purchase_item_bprice_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER purchase_item_bprice_trigger AFTER INSERT OR DELETE OR UPDATE ON public.purchase_items FOR EACH ROW EXECUTE FUNCTION public.purchase_item_bprice_function();


--
-- Name: sales sale_before_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_before_insert_trigger BEFORE INSERT ON public.sales FOR EACH ROW EXECUTE FUNCTION public.sale_before_insert_function();


--
-- Name: sales sale_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_before_update_trigger BEFORE UPDATE ON public.sales FOR EACH ROW EXECUTE FUNCTION public.sale_before_update_function();


--
-- Name: sale_items sale_item_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_item_after_delete_trigger AFTER DELETE ON public.sale_items FOR EACH ROW EXECUTE FUNCTION public.sale_item_after_delete_function();


--
-- Name: sale_items sale_item_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_item_after_insert_trigger AFTER INSERT ON public.sale_items FOR EACH ROW EXECUTE FUNCTION public.sale_item_after_insert_function();


--
-- Name: sale_items sale_item_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_item_after_update_trigger AFTER UPDATE ON public.sale_items FOR EACH ROW EXECUTE FUNCTION public.sale_item_after_update_function();


--
-- Name: sale_items sale_item_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sale_item_before_update_trigger BEFORE UPDATE ON public.sale_items FOR EACH ROW EXECUTE FUNCTION public.sale_item_before_update_function();


--
-- Name: services service_code_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER service_code_trigger BEFORE INSERT OR UPDATE ON public.services FOR EACH ROW WHEN ((new.code IS NULL)) EXECUTE FUNCTION public.generate_code();


--
-- Name: supplier_operations sup_operation_after_delete_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sup_operation_after_delete_trigger AFTER DELETE ON public.supplier_operations FOR EACH ROW EXECUTE FUNCTION public.sup_operation_after_delete_function();


--
-- Name: supplier_operations sup_operation_after_insert_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sup_operation_after_insert_trigger AFTER INSERT ON public.supplier_operations FOR EACH ROW EXECUTE FUNCTION public.sup_operation_after_insert_function();


--
-- Name: supplier_operations sup_operation_after_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sup_operation_after_update_trigger AFTER UPDATE ON public.supplier_operations FOR EACH ROW EXECUTE FUNCTION public.sup_operation_after_update_function();


--
-- Name: supplier_operations sup_operation_before_update_trigger; Type: TRIGGER; Schema: public; Owner: -
--

CREATE TRIGGER sup_operation_before_update_trigger BEFORE UPDATE ON public.supplier_operations FOR EACH ROW EXECUTE FUNCTION public.sup_operation_before_update_function();


--
-- Name: accounts fk_account_category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT fk_account_category FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: accounts fk_account_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.accounts
    ADD CONSTRAINT fk_account_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: account_operations fk_account_operation_account; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.account_operations
    ADD CONSTRAINT fk_account_operation_account FOREIGN KEY (account_id) REFERENCES public.accounts(id);


--
-- Name: account_operations fk_account_operation_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.account_operations
    ADD CONSTRAINT fk_account_operation_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: account_operations fk_account_operation_transfer; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.account_operations
    ADD CONSTRAINT fk_account_operation_transfer FOREIGN KEY (transfer_account_id) REFERENCES public.accounts(id);


--
-- Name: applications fk_application_appointment; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT fk_application_appointment FOREIGN KEY (appointment_id) REFERENCES public.appointments(id) ON DELETE SET NULL;


--
-- Name: applications fk_application_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT fk_application_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: applications fk_application_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT fk_application_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id);


--
-- Name: applications fk_application_patient_operation; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT fk_application_patient_operation FOREIGN KEY (patient_operation_id) REFERENCES public.patient_operations(id) ON DELETE SET NULL;


--
-- Name: application_services fk_application_service_application; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_services
    ADD CONSTRAINT fk_application_service_application FOREIGN KEY (application_id) REFERENCES public.applications(id);


--
-- Name: application_service_items fk_application_service_item_medicine; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_service_items
    ADD CONSTRAINT fk_application_service_item_medicine FOREIGN KEY (medicine_id) REFERENCES public.medicines(id);


--
-- Name: application_service_items fk_application_service_item_service; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_service_items
    ADD CONSTRAINT fk_application_service_item_service FOREIGN KEY (application_service_id) REFERENCES public.application_services(id);


--
-- Name: application_services fk_application_service_service; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.application_services
    ADD CONSTRAINT fk_application_service_service FOREIGN KEY (service_id) REFERENCES public.services(id);


--
-- Name: appointments fk_appointment_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointments
    ADD CONSTRAINT fk_appointment_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: appointments fk_appointment_department; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointments
    ADD CONSTRAINT fk_appointment_department FOREIGN KEY (department_id) REFERENCES public.departments(id);


--
-- Name: appointments fk_appointment_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointments
    ADD CONSTRAINT fk_appointment_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id);


--
-- Name: appointment_users fk_appointment_user_appointment; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointment_users
    ADD CONSTRAINT fk_appointment_user_appointment FOREIGN KEY (appointment_id) REFERENCES public.appointments(id) ON DELETE CASCADE;


--
-- Name: appointment_users fk_appointment_user_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.appointment_users
    ADD CONSTRAINT fk_appointment_user_user FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: blood_tests fk_blood_test_application; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_tests
    ADD CONSTRAINT fk_blood_test_application FOREIGN KEY (application_id) REFERENCES public.applications(id) ON DELETE CASCADE;


--
-- Name: blood_tests fk_blood_test_company; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_tests
    ADD CONSTRAINT fk_blood_test_company FOREIGN KEY (blood_company_id) REFERENCES public.blood_companies(id) ON DELETE SET NULL;


--
-- Name: blood_tests fk_blood_test_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_tests
    ADD CONSTRAINT fk_blood_test_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: blood_test_items fk_blood_test_item_test; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_test_items
    ADD CONSTRAINT fk_blood_test_item_test FOREIGN KEY (blood_test_id) REFERENCES public.blood_tests(application_id) ON DELETE CASCADE;


--
-- Name: blood_test_items fk_blood_test_item_value; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_test_items
    ADD CONSTRAINT fk_blood_test_item_value FOREIGN KEY (blood_value_id) REFERENCES public.blood_values(id);


--
-- Name: blood_values fk_blood_value_category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.blood_values
    ADD CONSTRAINT fk_blood_value_category FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: expenses fk_expense_category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expenses
    ADD CONSTRAINT fk_expense_category FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: expense_records fk_expense_record_account; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expense_records
    ADD CONSTRAINT fk_expense_record_account FOREIGN KEY (account_id) REFERENCES public.accounts(id);


--
-- Name: expense_records fk_expense_record_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expense_records
    ADD CONSTRAINT fk_expense_record_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: expense_records fk_expense_record_expense; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.expense_records
    ADD CONSTRAINT fk_expense_record_expense FOREIGN KEY (expense_id) REFERENCES public.expenses(id);


--
-- Name: login_logs fk_login_log_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.login_logs
    ADD CONSTRAINT fk_login_log_user FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: medicines fk_medicine_category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.medicines
    ADD CONSTRAINT fk_medicine_category FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: patients fk_patient_category; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patients
    ADD CONSTRAINT fk_patient_category FOREIGN KEY (category_id) REFERENCES public.categories(id) ON DELETE SET NULL;


--
-- Name: patient_invoice_details fk_patient_invoice_details_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_invoice_details
    ADD CONSTRAINT fk_patient_invoice_details_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id) ON DELETE CASCADE;


--
-- Name: patient_operations fk_patient_operation_account; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_operations
    ADD CONSTRAINT fk_patient_operation_account FOREIGN KEY (account_id) REFERENCES public.accounts(id);


--
-- Name: patient_operations fk_patient_operation_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_operations
    ADD CONSTRAINT fk_patient_operation_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: patient_operations fk_patient_operation_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.patient_operations
    ADD CONSTRAINT fk_patient_operation_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id);


--
-- Name: pre_registrations fk_pre_reg_channel; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pre_registrations
    ADD CONSTRAINT fk_pre_reg_channel FOREIGN KEY (registration_channel_id) REFERENCES public.registration_channels(id);


--
-- Name: pre_registrations fk_pre_reg_subject; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pre_registrations
    ADD CONSTRAINT fk_pre_reg_subject FOREIGN KEY (registration_subject_id) REFERENCES public.registration_subjects(id);


--
-- Name: pre_registrations fk_pre_registration_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.pre_registrations
    ADD CONSTRAINT fk_pre_registration_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: prescriptions fk_prescription_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescriptions
    ADD CONSTRAINT fk_prescription_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: prescription_items fk_prescription_item_medicine; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescription_items
    ADD CONSTRAINT fk_prescription_item_medicine FOREIGN KEY (medicine_id) REFERENCES public.medicines(id);


--
-- Name: prescription_items fk_prescription_item_prescription; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescription_items
    ADD CONSTRAINT fk_prescription_item_prescription FOREIGN KEY (prescription_id) REFERENCES public.prescriptions(id) ON DELETE CASCADE;


--
-- Name: prescriptions fk_prescription_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.prescriptions
    ADD CONSTRAINT fk_prescription_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id);


--
-- Name: purchases fk_purchase_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT fk_purchase_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: purchase_items fk_purchase_item_medicine; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT fk_purchase_item_medicine FOREIGN KEY (medicine_id) REFERENCES public.medicines(id);


--
-- Name: purchase_items fk_purchase_item_purchase; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchase_items
    ADD CONSTRAINT fk_purchase_item_purchase FOREIGN KEY (purchase_id) REFERENCES public.purchases(id) ON DELETE CASCADE;


--
-- Name: purchases fk_purchase_supplier; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.purchases
    ADD CONSTRAINT fk_purchase_supplier FOREIGN KEY (supplier_id) REFERENCES public.suppliers(id);


--
-- Name: sales fk_sale_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sales
    ADD CONSTRAINT fk_sale_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: sale_items fk_sale_item_sale; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sale_items
    ADD CONSTRAINT fk_sale_item_sale FOREIGN KEY (sale_id) REFERENCES public.sales(id);


--
-- Name: sales fk_sale_patient; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sales
    ADD CONSTRAINT fk_sale_patient FOREIGN KEY (patient_id) REFERENCES public.patients(id);


--
-- Name: service_items fk_service_item_medicine; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.service_items
    ADD CONSTRAINT fk_service_item_medicine FOREIGN KEY (medicine_id) REFERENCES public.medicines(id) ON DELETE CASCADE;


--
-- Name: service_items fk_service_item_service; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.service_items
    ADD CONSTRAINT fk_service_item_service FOREIGN KEY (service_id) REFERENCES public.services(id) ON DELETE CASCADE;


--
-- Name: supplier_operations fk_supplier_operation_account; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.supplier_operations
    ADD CONSTRAINT fk_supplier_operation_account FOREIGN KEY (account_id) REFERENCES public.accounts(id);


--
-- Name: supplier_operations fk_supplier_operation_created_user; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.supplier_operations
    ADD CONSTRAINT fk_supplier_operation_created_user FOREIGN KEY (created_user) REFERENCES public.users(id);


--
-- Name: supplier_operations fk_supplier_operation_supplier; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.supplier_operations
    ADD CONSTRAINT fk_supplier_operation_supplier FOREIGN KEY (supplier_id) REFERENCES public.suppliers(id);