/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50612
Source Host           : localhost:3306
Source Database       : heart00001

Target Server Type    : MYSQL
Target Server Version : 50612
File Encoding         : 65001

Date: 2020-06-14 22:54:12
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cbo_epaggelmatikikatastasi`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_epaggelmatikikatastasi`;
CREATE TABLE `cbo_epaggelmatikikatastasi` (
  `IDKatastasis` bigint(20) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(80) DEFAULT '',
  PRIMARY KEY (`IDKatastasis`),
  KEY `IDNationality` (`IDKatastasis`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cbo_epaggelmatikikatastasi
-- ----------------------------
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('1', 'ΕΡΓΑΖΟΜΕΝΟΣ ΠΛΗΡΟΥΣ ΑΠΑΣΧΟΛΗΣΗΣ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('2', 'ΕΡΓΑΖΟΜΕΝΟΣ ΜΕΡΙΚΗΣ ΑΠΑΣΧΟΛΗΣΗΣ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('3', 'ΦΟΙΤΗΤΗΣ/ΦΑΝΤΑΡΟΣ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('4', 'ΑΝΕΡΓΟΣ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('5', 'ΣΥΝΤΑΞΙΟΥΧΟΣ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('6', 'ΟΙΚΙΑΚΑ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('7', 'ΑΝΙΚΑΝΟΣ ΓΙΑ ΕΡΓΑΣΙΑ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('8', 'ΑΛΛΟ');
INSERT INTO `cbo_epaggelmatikikatastasi` VALUES ('10', '');

-- ----------------------------
-- Table structure for `cbo_epipedoekpaideysis`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_epipedoekpaideysis`;
CREATE TABLE `cbo_epipedoekpaideysis` (
  `IDc` bigint(20) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(80) DEFAULT '',
  PRIMARY KEY (`IDc`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cbo_epipedoekpaideysis
-- ----------------------------
INSERT INTO `cbo_epipedoekpaideysis` VALUES ('1', 'ΑΝΑΛΦΑΒΗΤΟΣ');
INSERT INTO `cbo_epipedoekpaideysis` VALUES ('2', 'ΒΑΣΙΚΗ ΕΚΠΑΙΔΕΥΣΗ');
INSERT INTO `cbo_epipedoekpaideysis` VALUES ('3', 'ΛΥΚΕΙΟ');
INSERT INTO `cbo_epipedoekpaideysis` VALUES ('4', 'ΑΝΩΤΕΡΗ/ΑΝΩΤΑΤΗ');

-- ----------------------------
-- Table structure for `cbo_farmaka_kardiologou`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_farmaka_kardiologou`;
CREATE TABLE `cbo_farmaka_kardiologou` (
  `IDc` bigint(20) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(80) DEFAULT '',
  PRIMARY KEY (`IDc`),
  KEY `IDNationality` (`IDc`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cbo_farmaka_kardiologou
-- ----------------------------
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('1', 'COX-2-Αναστολείς');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('2', 'SSRis');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('3', 'Βενλαφαξίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('4', 'Γκαμπαπεντίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('5', 'Καψαϊκίνη (PATCH)');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('6', 'Κλονιδίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('7', 'Κωδείνη + Παρακεταμόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('8', 'Λιδοκαϊνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('9', 'Μεξιλετίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('10', 'Μορφίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('12', 'Μπουπρενοφρίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('13', 'Ντουλοξετίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('14', 'Οξυκοδόνη + Παρακεταμόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('15', 'Οπιοειδή');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('16', 'Παρακεταμόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('17', 'Πρεγκαμπαλίνη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('18', 'Ταπενταδόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('19', 'Τραμαδόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('20', 'Τραμαδόλη + Παρακεταμόλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('21', 'Τρικυκλικά Αντικαταθλιπτικά');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('22', 'Φεντανύλη');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('23', 'Αλλο');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('24', 'ΜΣΑΦ');
INSERT INTO `cbo_farmaka_kardiologou` VALUES ('25', 'EMLA');

-- ----------------------------
-- Table structure for `cbo_monadametrisis`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_monadametrisis`;
CREATE TABLE `cbo_monadametrisis` (
  `IDc` bigint(20) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(80) DEFAULT '',
  PRIMARY KEY (`IDc`),
  KEY `IDc` (`IDc`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cbo_monadametrisis
-- ----------------------------
INSERT INTO `cbo_monadametrisis` VALUES ('1', 'mg');
INSERT INTO `cbo_monadametrisis` VALUES ('2', 'mg/kg');
INSERT INTO `cbo_monadametrisis` VALUES ('3', 'ml');
INSERT INTO `cbo_monadametrisis` VALUES ('4', 'μg');
INSERT INTO `cbo_monadametrisis` VALUES ('5', 'Επιθέματα');
INSERT INTO `cbo_monadametrisis` VALUES ('6', 'Άλλη');

-- ----------------------------
-- Table structure for `cbo_nationality`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_nationality`;
CREATE TABLE `cbo_nationality` (
  `IDNationality` bigint(20) NOT NULL AUTO_INCREMENT,
  `Nationality` varchar(80) DEFAULT '',
  `NationalityCode` varchar(30) DEFAULT '',
  PRIMARY KEY (`IDNationality`),
  KEY `IDNationality` (`IDNationality`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cbo_nationality
-- ----------------------------
INSERT INTO `cbo_nationality` VALUES ('1', 'ΕΛΛΗΝΙΚΗ', '');
INSERT INTO `cbo_nationality` VALUES ('2', 'ΑΛΒΑΝΙΚΗ', '');
INSERT INTO `cbo_nationality` VALUES ('3', 'ΑΝΑΤΟΛΙΚΗ ΕΥΡΩΠΗ', '');
INSERT INTO `cbo_nationality` VALUES ('4', 'ΔΥΤΙΚΗ ΕΥΡΩΠΗ', '');
INSERT INTO `cbo_nationality` VALUES ('5', 'ΑΣΙΑ', '');
INSERT INTO `cbo_nationality` VALUES ('6', 'ΑΦΡΙΚΗ', '');
INSERT INTO `cbo_nationality` VALUES ('7', 'ΑΜΕΡΙΚΗ', '');
INSERT INTO `cbo_nationality` VALUES ('8', 'ΑΛΛΗ', '');
INSERT INTO `cbo_nationality` VALUES ('11', '', '');

-- ----------------------------
-- Table structure for `cbo_oikogkatastasi`
-- ----------------------------
DROP TABLE IF EXISTS `cbo_oikogkatastasi`;
CREATE TABLE `cbo_oikogkatastasi` (
  `IDc` bigint(20) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(80) DEFAULT '',
  PRIMARY KEY (`IDc`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cbo_oikogkatastasi
-- ----------------------------
INSERT INTO `cbo_oikogkatastasi` VALUES ('1', 'ΑΓΓΑΜΟΣ/Η');
INSERT INTO `cbo_oikogkatastasi` VALUES ('2', 'ΕΓΓΑΜΟΣ/Η');
INSERT INTO `cbo_oikogkatastasi` VALUES ('3', 'ΔΙΑΖΕΥΓΜΕΝΟΣ/Η');
INSERT INTO `cbo_oikogkatastasi` VALUES ('4', 'ΧΗΡΟΣ/Α');

-- ----------------------------
-- Table structure for `foreisasfalisis`
-- ----------------------------
DROP TABLE IF EXISTS `foreisasfalisis`;
CREATE TABLE `foreisasfalisis` (
  `IDc` int(11) NOT NULL AUTO_INCREMENT,
  `Perigrafi` varchar(255) DEFAULT '',
  `Dnsi` varchar(100) DEFAULT '',
  `Poli` varchar(50) DEFAULT '',
  `TK` varchar(50) DEFAULT '',
  `Tilefono` varchar(50) DEFAULT '',
  `Sxolia` longtext,
  PRIMARY KEY (`IDc`),
  KEY `IDc` (`IDc`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of foreisasfalisis
-- ----------------------------
INSERT INTO `foreisasfalisis` VALUES ('1', 'ΙΚΑ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('2', 'Ο.Γ.Α.', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('3', 'Ε.ΥΔ.Α.Π', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('4', 'ΟΑ.Ε.Ε.', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('5', 'Ο.Ν', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('6', 'ΟΠΑΔ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('7', 'ΤΑΠ-ΑΣΦΑΛΙΣΤΙΚΗ ΕΘΝΙΚΗ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('8', 'Τ.Α.Υ.Τ.ΕΚ.Ω- ΤΑΠ-ΔΕΗ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('9', 'Τ.Α.Υ.Τ.Ε.Κ.Ω- ΤΑΠ-ΕΤΒΑ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('10', 'Τ.Α.Υ.Τ.Ε.Κ.Ω- ΤΑΠ-ΕΤΕ', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('11', 'ΕΟΠYY', '', '', '', '', '');
INSERT INTO `foreisasfalisis` VALUES ('12', 'Τ.Α.Υ.Τ.Ε.Κ.Ω ΤΑΠ-ΗΛΠΑΠ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('13', 'Τ.Α.Υ.Τ.Ε.Κ.Ω- ΤΑΠ-ΗΣΑΠ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('14', 'Τ.Α.Υ.Τ.Ε.Κ.Ω- ΤΑΠ-ΟΤΕ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('15', 'Τ.Α.Υ.Τ.Ε.Κ.Ω- ΤΑΠΤΠΓΑΕ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('16', 'Ε.Τ.Α.Α - Τ.Υ.Μ.Ε.Δ.Ε', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('17', 'Ε.Τ.Α.Α - Τ.Υ.Y', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('18', 'Ε.Τ.Α.Α - Τ.Υ.Σ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('19', 'Ε.Τ.Α.Α - Τ.Υ.Δ.Α', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('20', 'Ε.Τ.Α.Α - Τ.Υ.Δ.Θ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('21', 'Ε.Τ.Α.Α - Τ.Υ.Δ.Π', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('22', 'Ε.Τ.Α.Α - Τ.Υ.Δ.Ε-Τ.Π.Δ.Ε.', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('23', 'Ε.Τ.Α.Α - Τ.Α.Ν', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('24', 'Υ.ΕΘ.Α', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('25', 'ΕΤΑΠ-ΜΜΕ', '', '', '', '', null);
INSERT INTO `foreisasfalisis` VALUES ('26', ' ', '', '', '', '', null);

-- ----------------------------
-- Table structure for `patients`
-- ----------------------------
DROP TABLE IF EXISTS `patients`;
CREATE TABLE `patients` (
  `IDPatient` int(11) NOT NULL AUTO_INCREMENT,
  `IDOrgMonadas` int(11) DEFAULT '0',
  `Eponymo` varbinary(200) DEFAULT '',
  `Onoma` varbinary(100) DEFAULT '',
  `OnPatera` varchar(50) DEFAULT '',
  `OnMiteras` varchar(50) DEFAULT '',
  `HmEggrafis` datetime DEFAULT NULL,
  `HmGennisis` datetime DEFAULT NULL,
  `ToposGennisis` varchar(150) DEFAULT '',
  `DnsiKatoikias` varchar(80) DEFAULT '',
  `PoliKatoikias` varchar(50) DEFAULT NULL,
  `TK` varchar(10) DEFAULT '',
  `Til` varchar(50) DEFAULT '',
  `Fax` varchar(30) DEFAULT '',
  `Kinito` varchar(50) DEFAULT '',
  `email` varchar(100) DEFAULT '',
  `SyggenikoProsopoOnoma` varchar(80) DEFAULT '',
  `SyggenikoProsopoTil` varchar(30) DEFAULT '',
  `AMKA` varbinary(30) DEFAULT '',
  `IDForeaAsfalisis` int(11) DEFAULT '0',
  `Anasfalistos` tinyint(4) DEFAULT '0',
  `Baros` double DEFAULT '0',
  `Ycos` double DEFAULT '0',
  `DiktisMazasSomatos` double DEFAULT '0',
  `Filo` varchar(10) DEFAULT '',
  `Ethnikotita` varchar(50) DEFAULT '',
  `EpaggelmatikiKatastasi` varchar(50) DEFAULT '',
  `EpipedoEkpaideysis` varchar(50) DEFAULT '',
  `OikogKatastasi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `Kapnistis` tinyint(1) DEFAULT '0',
  `KapnistisTsigaraAnaHmera` double DEFAULT '0',
  `KapnistisEti` double DEFAULT '0',
  `ProinKapnistis` tinyint(1) DEFAULT '0',
  `ProinKapnistisTsigaraAnaHmera` double DEFAULT '0',
  `ProinKapnistisEti` double DEFAULT '0',
  `ProinKapnistisHmDiakopis` datetime DEFAULT NULL,
  `KapnistisPaketa` double DEFAULT '0',
  `KatanalosiAlkool` tinyint(1) DEFAULT '0',
  `KatanalosiAlkoolPotiriaAnaHmera` double DEFAULT '0',
  `XristisOusion` tinyint(1) DEFAULT '0',
  `PhotoFileName` varchar(250) DEFAULT '',
  `Sxolia` longtext,
  `isActive` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`IDPatient`),
  KEY `Eponymo` (`IDOrgMonadas`),
  KEY `pelEponymo` (`Eponymo`),
  KEY `pelOnoma` (`Onoma`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patients
-- ----------------------------
INSERT INTO `patients` VALUES ('1', '1', 0xAB6407F74CABACBA9FD26667146DE0778F119C2BAC6C59F2170EFAE1268F39B1, 0x4366C3596C1894C62AD02655E8B5D5AC, null, '', '2005-03-19 00:00:00', '1955-02-12 00:00:00', 'ΑΘΗΝΑ', '', null, '67100', null, null, null, null, 'ΞΑΝΘΗ', 'ΜΠΡΩΚΟΥΜΗ 2', 0x53DCBBED7C6303CE9BA5B22EAC2BE6F0, '1', '0', '0', '0', null, 'ΑΝΔΡΑΣ', '', 'ΑΣΤ.ΔΝΣΗ ΞΑΝΘΗΣ', '', null, '1', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, null, '1');
INSERT INTO `patients` VALUES ('2', null, 0xA12D63D41DBF8C949809BB8BD11B7EC92C81300EBB2031A42B5995ADEC652B5C, 0x14FF20BE86130099113F92CDB4E6822F38B0CAA53801644877B3B55D11736CB8, 'ΔΗΜΗΤΡΙΟΣ', 'ΜΑΡΙΑ', '2005-04-08 00:00:00', '1947-03-07 00:00:00', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'Λ.ΔΗΜΟΚΡΑΤΙΑΣ 322', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', '68100', '25510 12345', '25510 00000', '6977 123456', 'info@terazakis.gr', 'ΚΩΣΤΑΝΤΙΝΙΔΗΣ ΑΠΟΣΤΟΛΟΣ', '210 1234567', 0x4A2F93B81A713E5897407EB9CBB33DA2, '2', '0', '79', '171', '79', 'ΑΝΔΡΑΣ', 'ΕΛΛΗΝΙΚΗ', 'ΕΡΓΑΖΟΜΕΝΟΣ ΠΛΗΡΟΥΣ ΑΠΑΣΧΟΛΗΣΗΣ', 'ΑΝΩΤΕΡΗ/ΑΝΩΤΑΤΗ', 'ΕΓΓΑΜΟΣ/Η', '1', '30', '3', '0', '50', '4', null, '4.5', '0', '5', '0', 'm1.jpg', 'sdfsdfslfjkghsdjkfh ksjhdfjhsd fjkhsdk f skdfjksdhfkjhsdkjf  aaaaaaaaaaa bbbbbbbbbbbb\r\n', '1');
INSERT INTO `patients` VALUES ('3', '1', 0x655510132B8D9A565AB044BF6CE86A20, 0x17871086EF2333F1D92FFE5B6671D541AFB7485717AB190E911FDF5078DB8861, null, '', '2002-04-09 00:00:00', '1968-07-02 00:00:00', 'ΞΑΝΘΗ', '', null, '68100', '25510 33883', null, null, null, 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'ΒΙΖΒΥΖΗ 5', 0x53DCBBED7C6303CE9BA5B22EAC2BE6F0, '1', '0', '0', '0', null, 'ΑΝΔΡΑΣ', '', 'ΑΤ ΑΛΕΞΑΝΔΡΟΥΠΟΛΗΣ', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'ΚΙΧΝΕ : 26159', '1');
INSERT INTO `patients` VALUES ('4', '1', 0x5B599F2BAF002FBA0155089DF5ABEF4456790AC9E788594FB62399784833541D, 0xCB64220F47B1CC6728030BC9A37DB33CAFB7485717AB190E911FDF5078DB8861, null, '', '2002-09-12 00:00:00', '1972-04-13 00:00:00', 'ΑΘΗΝΑ', '', null, '68100', '25510 31965', '20110', null, null, 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'Λ.ΔΗΜΟΚΡΑΤΙΑΣ 123', 0xE0E3123FB94060FBFF73C9FE5FC3E5C0, '2', '0', '0', '0', null, 'ΑΝΔΡΑΣ', '', 'ΑΤ ΑΛΕΞΑΝΔΡΟΥΠΟΛΗΣ', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'ΛΕΝΑ, \r\nΚΙΝ :  0944 346006\r\nΑνδρεας : 33.572\r\n      σπιτι : 33.667\r\nΤΗΛ.ΑΘΗΝΑΣ : 01 3332668, 3332636\r\nΥΠΕΘΟ : 01 3332492-6\r\nΑρια σπιτι : 35725', '1');
INSERT INTO `patients` VALUES ('5', '3', 0x97139EEE5924700F22D61CB9FA43F7B2AFB7485717AB190E911FDF5078DB8861, 0xE2D85F242D52401E9F5966FFBB1EA3DA, 'ΙΩΑΝΝΗΣ', 'ΕΥΑΓΓΕΛΙΑ', '2001-02-01 00:00:00', '1945-06-07 00:00:00', 'ΘΕΣΣΑΛΟΝΙΚΗ', '', null, '68100', '25510 39414', '2551012345', '6977123456', 'info@mamasidis.gr', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'Λ. ΔΗΜΟΚΡΑΤΙΑΣ', 0x2AB602E1F0A34C25CB6C53C0D1A2CEC2, '2', '0', '0', '0', null, 'ΑΝΔΡΑΣ', 'AA12345', 'ΑΤ ΑΛΕΞΑΝΔΡΟΥΠΟΛΗΣ', '', null, '1', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'ΛΙΝΑΡΔΟΣ ΔΙΟΝΥΣΗΣ ΤΗΛ. 25510 32222\r\n', '1');
INSERT INTO `patients` VALUES ('9', '3', 0xD7A9B41AF44225DA2407F0159A4CB2B6, 0x0475814CE3C27BBAACD7011CCA97F3EAAFB7485717AB190E911FDF5078DB8861, 'ΓΕΩΡΓΙΟΣ', '', '2005-04-08 00:00:00', '1947-03-07 00:00:00', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', '', null, '68100', '25510 12345', '25510 00000', '6977 123456', 'info@terazakis.gr', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'ΑΝ.ΘΡΑΚΗΣ 145', 0x4A2F93B81A713E5897407EB9CBB33DA2, '4', '0', '0', '0', null, 'ΑΝΔΡΑΣ', '', 'ΑΤ ΑΛΕΞΑΝΔΡΟΥΠΟΛΗΣ', '', null, '1', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'τεστ test sdfsfsdfsd swfwerwer wer werwe werfsdbhkfgsdh fm,njsdlfjklsdjf ljsdfkl ulsdkfj kldsjflksdj flkjsdjf sdkljfkls djfsdh jkfhgsdjkfgsdhjk gfhjg sdhjfghsd fkjsbhjkfhjkwhefrjhjk κξη ξκφηδκοκσδξηφξκσδηφξκσδη φξκδηφκξ ησδξκφησδξκφη κσξδφησηδφ ξκσηδκφνσδξκφηκσξδη aaaaaaa ξσηφξκη φησδξκηφσδηφκξη κληκξη φφφφφφφ abcde a1 φσδφξσδκλφξλκ σδ΄φλξκ σλ΄δφκλ΄σδφ', '1');
INSERT INTO `patients` VALUES ('10', '1', 0x4B43B169D8DA83E5443E20F89FF4305A65A3596C4D50EC129EFA2966E783F018, 0xAD4079BC9B3CFBEC729ABDF29BE6458655973CA79DEAECFAD2179CF01D26722A, 'Κωνσταντίνος', '', '2014-07-08 00:00:00', '1970-04-13 00:00:00', null, null, null, '10443', '2105151404', '2105125566', '639123456789', 'email@email.com', null, null, 0xD008698DB8C06057EFB6A95C2A6EE9C8, '11', '0', '0', '0', null, 'ΑΝΔΡΑΣ', null, null, null, null, '1', '0', '0', '0', '0', '0', null, null, '0', '0', '0', null, 'Αιμοκαθαιρόμενος νεφροπαθής λόγω τελικού σταδίου νεφρικής ανεπάρκειας οφειλόμενης πιθανώς σε υπερτασική νεφροσκλήρυνση', '1');
INSERT INTO `patients` VALUES ('11', '2', 0xFDFCE64EFC4232166FBDC19805C0B14C6929E48350B9922E6B94F4882D46D8DE, 0x14FF20BE86130099113F92CDB4E6822F38B0CAA53801644877B3B55D11736CB8, 'ΧΡΗΣΤΟΣ', '', '2003-04-08 00:00:00', '1947-03-07 00:00:00', 'ΑΘΗΝΑ', '', null, '68100', '25510 12345', '25510 00000', '6977 123456', 'info@abcd.gr', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', 'ΑΝ.ΘΡΑΚΗΣ 145', 0x4A2F93B81A713E5897407EB9CBB33DA2, '4', '0', '0', '0', null, 'ΓΥΝΑΙΚΑ', '', 'ΑΤ ΑΛΕΞΑΝΔΡΟΥΠΟΛΗΣ', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'τεστ test sdfsfsdfsd swfwerwer wer werwe werfsdbhkfgsdh fm,njsdlfjklsdjf ljsdfkl ulsdkfj kldsjflksdj flkjsdjf sdkljfkls djfsdh jkfhgsdjkfgsdhjk gfhjg sdhjfghsd fkjsbhjkfhjkwhefrjhjk κξη ξκφηδκοκσδξηφξκσδηφξκσδη φξκδηφκξ ησδξκφησδξκφη κσξδφησηδφ ξκσηδκφνσδξκφηκσξδη aaaaaaa ξσηφξκη φησδξκηφσδηφκξη κληκξη φφφφφφφ abcde a1 φσδφξσδκλφξλκ σδ΄φλξκ σλ΄δφκλ΄σδφ', '0');
INSERT INTO `patients` VALUES ('12', '1', 0xCB64220F47B1CC6728030BC9A37DB33C9B85662A9CABFD217783242563194B5F, 0xDDDDD1BCD77E94A513F94869B888A21B, null, '', '2007-07-12 00:00:00', '1962-04-01 00:00:00', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', '', null, '68200', null, null, null, null, 'ΟΡΕΣΤΙΑΔΑ', 'ΚΩΝΣΤΑΝΤΙΝΟΥΠΟΛΕΩΣ 34', 0x1835AE751CCAAE56CE2FFB4BC2D8FD38, '1', '0', '0', '0', null, 'ΓΥΝΑΙΚΑ', '', 'ΑΣΤ.ΤΜΗΜΑ ΟΡΕΣΤΙΑΔΟΣ', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, null, '1');
INSERT INTO `patients` VALUES ('13', '1', 0x8259E8D06BFED7CA1CB4601D6625457248C23095FC0D5A9218D1ED4768B0AE90, 0x278D8A0F5D0665D28C6682D494328D78FCAEFEA8E1AB8EF472D76D2923D8D30B, 'ΑΠΟΣΤΟΛΟΣ', '', '2007-01-22 00:00:00', '1947-03-11 00:00:00', 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', '', null, '68200', null, null, null, null, 'ΟΡΕΣΤΙΑΔΑ', 'ΜΟΥΡΟΥΖΗ 27', 0xD99AA0A0B30F168578DE80E7EC0F1E14, '1', '0', '0', '0', null, 'ΓΥΝΑΙΚΑ', '', 'ΑΣΤ.ΤΜΗΜΑ ΟΡΕΣΤΙΑΔΟΣ', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, 'Τασος Κιν. 093 295106  Προσ.Δημος : 22219, 28154\r\nΣΠΙΤΙ ΤΑΣΟΣ : 0552 29744\r\nΣΠΙΤΙ ΚΩΣΤΑΣ : 0552 24973\r\nΚΟΙΝΟΤΗΤΑ ΣΠΗΛΑΙΟΥ : ΤΗΛ. 0556 51241\r\nΠΡΟΕΔΡΟΣ (ΣΠΙΤΙ)  : 0556 51171\r\nΚΑΦΕΤΕΡΙΑ : 0556 51504', '1');
INSERT INTO `patients` VALUES ('17', '18', 0xA12D63D41DBF8C949809BB8BD11B7EC92C81300EBB2031A42B5995ADEC652B5C, 0x14FF20BE86130099113F92CDB4E6822F38B0CAA53801644877B3B55D11736CB8, null, '', '2014-01-06 00:00:00', '1970-01-06 00:00:00', '', '', null, null, null, null, null, null, 'ΑΛΕΞΑΝΔΡΟΥΠΟΛΗ', null, 0xE21D9A4AE1A7F921090A5984F16F353F, '1', '0', '0', '0', null, 'ΑΝΔΡΑΣ', '', '', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, null, '0');
INSERT INTO `patients` VALUES ('20', '1', 0x4B43B169D8DA83E5443E20F89FF4305A65A3596C4D50EC129EFA2966E783F018, 0xAD4079BC9B3CFBEC729ABDF29BE6458655973CA79DEAECFAD2179CF01D26722A, 'Κωνσταντίνος', '', '2014-07-08 00:00:00', '1970-04-13 00:00:00', null, null, null, '10443', '2105151404', '2105125566', '639123456789', 'email@email.com', null, null, 0xD008698DB8C06057EFB6A95C2A6EE9C8, '11', '0', '0', '0', null, 'ΑΝΔΡΑΣ', null, null, null, null, '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', null, 'Αιμοκαθαιρόμενος νεφροπαθής λόγω τελικού σταδίου νεφρικής ανεπάρκειας οφειλόμενης πιθανώς σε υπερτασική νεφροσκλήρυνση', '0');
INSERT INTO `patients` VALUES ('22', '21', 0xA1BC4CFE99A7B017440D839DACEF136B, 0x3B151F151E754882EA20DCC2182BD087, 'ΙΩΑΝΝΗΣ', '', '2014-07-16 00:00:00', '1933-01-01 00:00:00', '', '', null, null, null, null, null, null, null, null, 0x987E06072B68E2DC6D5B6DACD03C1163, '5', '0', '0', '0', null, 'ΓΥΝΑΙΚΑ', '', '', '', null, '0', '0', '0', null, '0', '0', null, '0', '0', '0', '0', null, null, '0');
INSERT INTO `patients` VALUES ('23', null, 0x6AB34C70A350B86E7C04D2959EC9B0FA, 0x3BC26C9E83E995E7FD9F5F333BF22E39, 'ΓΕΩΡΓΙΟΣ', '', '2015-03-12 00:00:00', '1986-03-12 00:00:00', 'ΑΘΗΝΑ', 'ΕΥΕΛΠΙΔΩΝ 1', 'ΑΘΗΝΑ', '11363', '210-1234567', '210-1234567', '6911234567', 'MAIL@EMAIL.GR', 'TEST1 UNCLE', '210-1234567', 0xB9F66491871D8D2370AAC0AA5BEB0BBC, '11', '0', '70', '150', '31.11', 'ΑΝΔΡΑΣ', 'ΕΛΛΗΝΙΚΗ', 'ΑΝΕΡΓΟΣ', 'ΒΑΣΙΚΗ ΕΚΠΑΙΔΕΥΣΗ', 'ΑΓΓΑΜΟΣ/Η', '1', '15', null, '0', null, null, null, '0', '1', '3', '1', null, 'COMMENTS', '1');
INSERT INTO `patients` VALUES ('27', '1', 0x6AB34C70A350B86E7C04D2959EC9B0FA, 0xCFD0A6A642E064779315DD93A7E8D09A, null, '', '2015-04-28 00:00:00', '1986-04-28 00:00:00', null, null, null, null, null, null, null, null, null, null, 0xFCAEFEA8E1AB8EF472D76D2923D8D30B, null, '0', null, null, null, null, null, null, null, null, '0', null, null, '0', null, null, null, null, '0', null, '0', null, null, '0');
INSERT INTO `patients` VALUES ('29', '1', 0x6AB34C70A350B86E7C04D2959EC9B0FA, 0xB0AD6825BAE91EF542300730C9D77EA8, null, '', '2015-05-01 00:00:00', '1986-05-01 00:00:00', null, null, null, null, null, null, null, null, null, null, 0xFCAEFEA8E1AB8EF472D76D2923D8D30B, '10', '1', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', null, null, '0');
INSERT INTO `patients` VALUES ('31', '19', 0xFDFCE64EFC4232166FBDC19805C0B14C6929E48350B9922E6B94F4882D46D8DE, 0x0475814CE3C27BBAACD7011CCA97F3EAAFB7485717AB190E911FDF5078DB8861, null, '', '2015-05-04 00:00:00', '1986-01-01 00:00:00', null, null, null, null, null, null, null, null, null, null, 0xFCAEFEA8E1AB8EF472D76D2923D8D30B, null, '0', null, null, null, null, null, null, null, null, '0', null, null, '0', null, null, null, null, '0', null, '0', null, null, '0');
INSERT INTO `patients` VALUES ('32', '26', 0x2FA17DCC8E3052B554CB941DDF97D6CF, 0x59F8697ECE41E244A178A75B6F5357E0, 'basileios', '', '2015-06-09 00:00:00', '1952-01-01 00:00:00', 'αθηνα', 'λεωφόρος αμαλίας 18', null, null, '2105123654', null, null, null, null, null, 0xA192544D067A2BF21C8AAA2188FF7185, '23', '0', '75', '170', '25.95', 'ΓΥΝΑΙΚΑ', null, null, null, null, '1', '0', '0', '1', '0', '0', null, null, '1', '0', '1', null, null, '1');
INSERT INTO `patients` VALUES ('33', '26', 0x17D378CD3C4A3BBBFED7A165CF411D44, 0x0C30F19A9F2D33F1DFE7A764781AD34E, 'βασιλειος', '', '2015-07-22 00:00:00', '1953-01-01 00:00:00', 'αθηνα', null, null, null, '2107286173', null, null, null, null, null, 0xEF16CE8A209404532F837DEEE65BF535, '11', '0', '0', '0', null, 'ΓΥΝΑΙΚΑ', 'ΕΛΛΗΝΙΚΗ', 'ΑΝΕΡΓΟΣ', null, null, '1', '10', '10', '0', '0', '0', null, '5', '1', '1', '0', null, null, '0');
INSERT INTO `patients` VALUES ('35', '14', 0x7BD6ADB558DDDC8781E1832410E5D29D6929E48350B9922E6B94F4882D46D8DE, 0x4366C3596C1894C62AD02655E8B5D5AC, 'ΝΙΚΟΣ', '', '2015-09-02 00:00:00', '1990-08-01 00:00:00', null, null, null, null, '666666666666', null, null, null, null, null, 0x8B41437599BA251422C5ED11F833BFDE, '0', '0', '0', '0', null, null, null, null, null, null, '0', '0', '0', '0', '0', '0', null, null, '0', '0', '0', null, null, '0');
INSERT INTO `patients` VALUES ('38', '26', 0x4B43B169D8DA83E5443E20F89FF4305A65A3596C4D50EC129EFA2966E783F018, 0xD71C4CF6B7D7F4F920F9BEFF2AD16053FCAEFEA8E1AB8EF472D76D2923D8D30B, 'Θεόδωρος', '', '2015-08-22 00:00:00', '1986-05-23 00:00:00', null, null, null, null, '6972233857', null, null, null, null, null, 0x67326D177A6A8C15B66B45B6051DCA57, null, '0', null, null, null, null, null, null, null, null, '0', null, null, '0', null, null, null, null, '0', null, '0', null, null, '0');
INSERT INTO `patients` VALUES ('39', '28', 0x6F18FFB226A32EA61D096D5DE058E1DE, 0x9E51E9ED5E2BCE4490988297F637594A, 'ΑΘΑΝΑΣΙΟΣ', '', '1980-01-01 00:00:00', '1960-01-01 00:00:00', null, null, null, null, '2101234567', null, null, null, null, null, 0x818DA50A53662D6AA3C9EA3E31B0E27B, null, '0', null, null, null, null, null, null, null, null, '0', null, null, '0', null, null, null, null, '0', null, '0', null, null, '0');

-- ----------------------------
-- Table structure for `patients_aitia_episkepsis`
-- ----------------------------
DROP TABLE IF EXISTS `patients_aitia_episkepsis`;
CREATE TABLE `patients_aitia_episkepsis` (
  `IDEpiskepsis` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) DEFAULT '0',
  `HmEggrafis` datetime DEFAULT NULL,
  `TaktikosKardiologikosElegxos` tinyint(1) DEFAULT '0',
  `ProliptikosElegxos` tinyint(1) DEFAULT '0',
  `ProatlitikosElegxos` tinyint(1) DEFAULT '0',
  `DyspnoiaMoxthou` tinyint(1) DEFAULT '0',
  `ThorakikoAlgos` tinyint(1) DEFAULT '0',
  `AisthimaPalmon` tinyint(1) DEFAULT '0',
  `Fysima` tinyint(1) DEFAULT '0',
  `SygkopikoEpisodio` tinyint(1) DEFAULT '0',
  `ProSygkopikoEpisodio` tinyint(1) DEFAULT '0',
  `Zali` tinyint(1) DEFAULT NULL,
  `AporytmisiArtiriakisPiesis` tinyint(1) DEFAULT NULL,
  `Dyslipidaimia` tinyint(1) DEFAULT '0',
  `Allo` tinyint(1) DEFAULT '0',
  `AlloText` text,
  PRIMARY KEY (`IDEpiskepsis`),
  KEY `IDPatient` (`IDPatient`),
  KEY `IDEidosPonou` (`IDEpiskepsis`) USING BTREE,
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patients_aitia_episkepsis
-- ----------------------------
INSERT INTO `patients_aitia_episkepsis` VALUES ('11', '2', '2013-04-19 00:00:00', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('18', '2', '2013-04-03 00:00:00', null, null, null, null, null, null, null, null, null, null, null, null, '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('22', '2', '2015-01-21 00:00:00', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('24', '17', '2014-09-07 00:00:00', null, null, null, null, null, null, null, null, null, null, null, null, '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('26', '20', '2014-07-15 00:00:00', null, '0', null, null, '0', null, '0', null, null, null, null, null, '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('43', '2', '2015-04-22 00:00:00', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'asdasdd');
INSERT INTO `patients_aitia_episkepsis` VALUES ('46', '23', '2015-04-26 00:00:00', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('48', '2', '2015-04-28 00:00:00', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('50', '23', '2015-04-28 00:00:00', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('51', '28', '2015-04-28 00:00:00', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('52', '28', '2015-04-28 00:00:00', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('53', '23', '2015-04-28 00:00:00', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('58', '2', '2015-05-04 00:00:00', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', 'ααα');
INSERT INTO `patients_aitia_episkepsis` VALUES ('59', '2', '2017-04-14 00:00:00', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('60', '2', '2017-04-14 00:00:00', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('65', '2', '2017-04-15 00:00:00', '0', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', null);
INSERT INTO `patients_aitia_episkepsis` VALUES ('67', '2', '2017-04-22 00:00:00', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', 'aaaaaaa');

-- ----------------------------
-- Table structure for `patients_anamnistiko`
-- ----------------------------
DROP TABLE IF EXISTS `patients_anamnistiko`;
CREATE TABLE `patients_anamnistiko` (
  `IDAnamnistikou` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) DEFAULT '0',
  `HmEggrafis` datetime DEFAULT NULL,
  `StefaniaiaNosos` tinyint(1) DEFAULT '0',
  `ProliptikosElegxos` tinyint(1) DEFAULT '0',
  `KardiakiAneparkeia` tinyint(1) DEFAULT '0',
  `Arithmies` tinyint(1) DEFAULT '0',
  `MonimosVimatodotis` tinyint(1) DEFAULT '0',
  `ArtiriakiYpertasi` tinyint(1) DEFAULT '0',
  `Dislipidaimia` tinyint(1) DEFAULT NULL,
  `Kapnisma` tinyint(1) DEFAULT '0',
  `SakxarodisDiabitis` tinyint(1) DEFAULT '0',
  `AlloText` text,
  PRIMARY KEY (`IDAnamnistikou`),
  KEY `IDPatient` (`IDPatient`) USING BTREE,
  KEY `IDEidosPonou` (`IDAnamnistikou`) USING BTREE,
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of patients_anamnistiko
-- ----------------------------

-- ----------------------------
-- Table structure for `patients_ergelegxoi`
-- ----------------------------
DROP TABLE IF EXISTS `patients_ergelegxoi`;
CREATE TABLE `patients_ergelegxoi` (
  `IDErgElegxou` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) DEFAULT '0',
  `HmEggrafis` datetime DEFAULT NULL,
  `Hb` double DEFAULT NULL,
  `K` double DEFAULT NULL,
  `P` double DEFAULT NULL,
  `Na` double DEFAULT NULL,
  `Ca` double DEFAULT NULL,
  `PTH` double DEFAULT NULL,
  `Ouria` double DEFAULT NULL,
  `OuriaMeta` double DEFAULT NULL,
  `OurikoOxy` double DEFAULT NULL,
  `Kreatinini` double DEFAULT NULL,
  `KtV` double DEFAULT NULL,
  `RRF` double DEFAULT NULL,
  `OlLeykomata` double DEFAULT NULL,
  `Alvoulini` double DEFAULT NULL,
  `MDRD` double DEFAULT NULL,
  `CockcroftGault` double DEFAULT NULL,
  `CKDEP` double DEFAULT NULL,
  `SchwartzPediatric` double DEFAULT NULL,
  `Ht` double DEFAULT NULL,
  `MCV` double DEFAULT NULL,
  `MCH` double DEFAULT NULL,
  `MCHC` double DEFAULT NULL,
  `DEC` double DEFAULT NULL,
  `TKE` double DEFAULT NULL,
  `Leyka` double DEFAULT NULL,
  `Oudeterofila` double DEFAULT NULL,
  `Lemfokitara` double DEFAULT NULL,
  `Iosinofila` double DEFAULT NULL,
  `Monopirina` double DEFAULT NULL,
  `Baseofila` double DEFAULT NULL,
  `Feritini` double DEFAULT NULL,
  `Aimopetalia` double DEFAULT NULL,
  `FylikoOxy` double DEFAULT NULL,
  `B12` double DEFAULT NULL,
  `Triglikeridia` double DEFAULT NULL,
  `Glikozi` double DEFAULT NULL,
  `Amilasi` double DEFAULT NULL,
  `LDH` double DEFAULT NULL,
  `Mg` double DEFAULT NULL,
  `Fe` double DEFAULT NULL,
  `TIBC` double DEFAULT NULL,
  `SGOT` double DEFAULT NULL,
  `SGPT` double DEFAULT NULL,
  `Xolisteroli` double DEFAULT NULL,
  `HDL` double DEFAULT NULL,
  `LDL` double DEFAULT NULL,
  `ALP` double DEFAULT NULL,
  `gGT` double DEFAULT NULL,
  `XolerithriniOl` double DEFAULT NULL,
  `XolerithriniAm` double DEFAULT NULL,
  `HbA1c` double DEFAULT NULL,
  `HIU` double DEFAULT NULL,
  `HBsAG` varchar(15) DEFAULT '',
  `AntiHCU` double DEFAULT NULL,
  `AntiHBs` varchar(15) DEFAULT '',
  `AntiHBc` varchar(15) DEFAULT '',
  `CRP` double DEFAULT NULL,
  `EidikoBaros` double DEFAULT NULL,
  `Opsi` varchar(50) DEFAULT '',
  `Xroma` varchar(50) DEFAULT '',
  `pH` double DEFAULT NULL,
  `Leykoma` double DEFAULT NULL,
  `LeykomaText` varchar(15) DEFAULT NULL,
  `Sakxaro` double DEFAULT NULL,
  `Oxoni` tinyint(1) DEFAULT NULL,
  `Aimosfairini` varchar(50) DEFAULT NULL,
  `Xolerithrini` tinyint(1) DEFAULT NULL,
  `Ouroxoligono` tinyint(1) DEFAULT NULL,
  `Piosfairia` varchar(15) DEFAULT '',
  `Erithra` double DEFAULT NULL,
  `Epithilia` tinyint(1) DEFAULT NULL,
  `Vleni` tinyint(1) DEFAULT NULL,
  `Krystalloi` tinyint(1) DEFAULT NULL,
  `Mikroorganismoi` varchar(50) DEFAULT '',
  `Kylindroi` varchar(50) DEFAULT NULL,
  `Mykites` varchar(50) DEFAULT NULL,
  `LeykomaOuron` double DEFAULT NULL,
  `YperixosNefron` longtext,
  `Polimorfopirina` double DEFAULT NULL,
  `AlloErgastiriaka` longtext,
  PRIMARY KEY (`IDErgElegxou`),
  KEY `HmErgElegxou` (`HmEggrafis`),
  KEY `IDErgElegxou` (`IDErgElegxou`),
  KEY `IDPatient` (`IDPatient`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patients_ergelegxoi
-- ----------------------------
INSERT INTO `patients_ergelegxoi` VALUES ('1', '2', '2009-12-01 00:00:00', '15.1', '5.4', '4', '140', '9.8', '325.4', '156', '53', '8.1', '11.6', '0', '0', '6.9', null, null, null, null, null, '48.8', '86.2', '26.7', '30.9', '0', '2', '5970', null, '18.1', '3.5', '7.9', '0', '42.26', '92000', null, null, '180', '96', '0', '203', null, '45', null, '5', '11', '145', '34', '75', null, '28', '0.6', '0.1', null, null, '-', null, '+', '+', '1', null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, '70.2', '');
INSERT INTO `patients_ergelegxoi` VALUES ('2', '2', '2012-06-01 00:00:00', '12', '5.4', '4', '140', '9.8', '325.4', '156', '53', '8.1', '11.6', null, null, '6.9', null, null, null, null, null, '50', '92', '26.7', '30.9', '0', '2', '5970', null, '18.1', '3.5', '7.9', '0', '42.26', '92000', null, null, '180', '96', '0', '203', null, '45', null, '5', '11', '145', '34', '75', null, '28', '0.6', '0.1', null, null, '0', null, '0', '0', '1', null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, '70.2', '');
INSERT INTO `patients_ergelegxoi` VALUES ('4', '2', '2013-04-19 00:00:00', '11', '8', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '85', '11', null, '131.2', '2', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2011', null, null, null, null, null, null, null, null, null, null, '12', '2', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '1', null, '1', '0', null, null, '1', '1', '1', null, null, null, null, null, '0', '');
INSERT INTO `patients_ergelegxoi` VALUES ('5', '16', '2014-06-28 00:00:00', '1111', '12', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, null, '1201', '0', '0', '0', '0', '0', '0', null, '0', '0', '1', '0', '0', '0', null, null, '0', '0', '0', '0', null, '0', null, '0', '0', '0', '0', '0', null, null, '0', '0', null, null, null, null, null, null, '0', null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, '0', null);
INSERT INTO `patients_ergelegxoi` VALUES ('7', '20', '2014-05-05 00:00:00', '10', '52', '58', '137', '98', '220', '135', '30', '65', '82', '12', '5', '60', '0', '0', '0', '0', '0', '33', '0', '0', '0', '0', '0', null, '0', '0', '0', '0', '0', '320', null, '0', '0', '195', '90', '40', '195', '0', '65', '0', '11', '9', '142', '50', '45', '0', '0', '8', '3', '0', '0', '0,00', '0', '0,00', '0,00', '8', '0', null, null, '0', '0', null, '0', '1', null, '1', '0', '0', '0', '1', '1', '1', null, null, null, '0', null, '0', null);
INSERT INTO `patients_ergelegxoi` VALUES ('8', '20', '2014-06-06 00:00:00', '10.5', '51', '55', '136', '89', '270', '140', '40', '55', '78', '13', '0', '61', null, null, null, null, null, '32', '0', '0', '0', '0', '0', null, null, '0', '0', '0', '0', '350', null, null, null, '125', '75', '0', '200', null, '0', null, '20', '15', '170', '50', '95', null, null, '1', '4', null, null, '(-)', null, '>1.000', '(-)', '7', null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, '0', null);
INSERT INTO `patients_ergelegxoi` VALUES ('9', '20', '2014-07-07 00:00:00', '11.3', '4.7', '5.6', '138', '93', '240', '150', '45', '60', '68', '0.4', '0', '64', null, null, null, null, null, '35.1', '0', '0', '0', '0', '0', '0', null, '0', '0', '0', '0', '250', '0', null, null, '170', '88', '0', '150', null, '0', null, '17', '22', '160', '40', '70', null, null, '12', '5', null, null, '(-)', null, '>1.000', '(-)', '6', null, '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, '132', null);
INSERT INTO `patients_ergelegxoi` VALUES ('18', '2', '2014-11-21 00:00:00', '20', '9', '20', '199', '20', '2200.1', '999', '999', '20', '30', '9', '4444', '10', '10', '150', '150', '150', '150', '99', '120', '50', '50', '10', '200', '200', '100', '100', '100', '100', '100', '20', '2100', '30', '15', '1111', null, null, '1111', null, null, null, '1111', '1111', null, null, null, '111', null, null, null, null, null, null, null, null, null, null, null, null, null, '1', null, null, null, '0', null, '1', '1', 'aaaa', null, '1', '0', '1', null, null, null, null, 'bbbbbbbbbbbbbbbbb', null, 'xscsdcfdsfcsdfsdf');
INSERT INTO `patients_ergelegxoi` VALUES ('19', '2', '2017-04-22 00:00:00', '11', '11', '2', null, '20', '657', '777', '666', '777', null, null, null, null, null, null, null, null, null, '11', null, null, null, '22', null, null, null, '11', null, null, null, '33', null, null, null, null, null, null, null, null, null, null, null, '33', '33', '33', null, '33', '33', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '1', null, '0', '0', null, null, '0', '0', '0', null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `patients_farm_agogi`
-- ----------------------------
DROP TABLE IF EXISTS `patients_farm_agogi`;
CREATE TABLE `patients_farm_agogi` (
  `IDFarmAgogis` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) DEFAULT '0',
  `HmEggrafis` datetime DEFAULT NULL,
  `Sxolia` longtext,
  PRIMARY KEY (`IDFarmAgogis`),
  KEY `IDPatient` (`IDPatient`),
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE,
  KEY `IDFarmAgogis` (`IDFarmAgogis`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patients_farm_agogi
-- ----------------------------
INSERT INTO `patients_farm_agogi` VALUES ('12', '2', '2012-10-14 00:00:00', 'Δοκιμαστική asdasd asfcdf 111111111');
INSERT INTO `patients_farm_agogi` VALUES ('14', '1', '2012-12-30 00:00:00', 'ΤΕΣΤ1');
INSERT INTO `patients_farm_agogi` VALUES ('32', '20', '2014-07-09 00:00:00', 'Συνεδρίες HDF 3 / εβδομάδα');
INSERT INTO `patients_farm_agogi` VALUES ('37', '2', '2015-04-22 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('39', '23', '2015-04-26 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('41', '2', '2015-05-04 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('45', '23', '2015-05-04 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('46', '31', '2015-05-10 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('47', '31', '2015-05-11 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('48', '33', '2015-07-20 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('49', '33', '2015-07-22 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('50', '32', '2015-07-25 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('52', '33', '2015-09-03 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('55', '33', '2015-09-04 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('56', '38', '2015-09-03 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('57', '38', '2015-09-04 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('58', '38', '2015-09-03 00:00:00', null);
INSERT INTO `patients_farm_agogi` VALUES ('59', '39', '2015-09-04 00:00:00', null);

-- ----------------------------
-- Table structure for `patients_farm_agogi_details`
-- ----------------------------
DROP TABLE IF EXISTS `patients_farm_agogi_details`;
CREATE TABLE `patients_farm_agogi_details` (
  `IDc` int(11) NOT NULL AUTO_INCREMENT,
  `IDFarmAgogis` int(11) DEFAULT '0',
  `IDPatient` int(11) DEFAULT '0',
  `AA` int(11) DEFAULT NULL,
  `OnomaFarmakou` varchar(100) DEFAULT '',
  `OdosXorigisis` varchar(100) DEFAULT '',
  `DosiXorigisis` double DEFAULT '0',
  `MonadaMetrisis` varchar(30) DEFAULT '',
  `SyxnotitaXorigisis` double DEFAULT '0',
  `PeriodikotitaXorigisis` varchar(100) DEFAULT '',
  `HmEnarxis` date DEFAULT NULL,
  `KatastasiUerapeias` varchar(30) DEFAULT '',
  `HmDiakopis` date DEFAULT NULL,
  `LogosAllagisUerapeias` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDc`),
  KEY `IDPatient` (`IDPatient`) USING BTREE,
  KEY `IDc` (`IDc`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of patients_farm_agogi_details
-- ----------------------------
INSERT INTO `patients_farm_agogi_details` VALUES ('1', '12', '2', '0', 'COX-2-Αναστολείς', 'Από το στόμα', '0', '', '0', '', '2015-03-01', '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('3', '12', '2', '0', 'SSRis', 'Επίθεμα', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('19', '12', '2', '0', 'Λιδοκαϊνη', 'Ενδοφλέβια', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('20', '37', '2', '0', 'COX-2-Αναστολείς', 'Από το στόμα', '2', 'mg/kg', '3', 'ανά ημέρα', '2015-03-01', 'Εναρξη', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('21', '37', '2', '0', 'Γκαμπαπεντίνη', 'Επίθεμα', '3', '', '0', '', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('22', '12', '2', '0', 'Οξυκοδόνη + Παρακεταμόλη', '', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('24', '37', '2', '0', 'Αλλο', 'Επίθεμα', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('25', '39', '23', '0', 'Καψαϊκίνη (PATCH)', 'Από το στόμα', '1', 'mg', '1', 'ανά ημέρα', null, 'Εναρξη', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('26', '39', '23', '0', 'Γκαμπαπεντίνη', 'Επίθεμα', '12', 'mg/kg', '12', 'ανά μήνα', null, 'Συνεχίζει (Αύξηση δοσολογίας)', null, 'Μειωμένη αποτελεσματικότητα');
INSERT INTO `patients_farm_agogi_details` VALUES ('27', '39', '23', '0', 'Κλονιδίνη', 'Ενδοφλέβια', '123', 'ml', '453', 'ανά 3 μήνες', null, 'Συνεχίζει (ίδια δοσολογία)', null, 'Προτιμήσεις ασθενούς');
INSERT INTO `patients_farm_agogi_details` VALUES ('28', '39', '23', '0', 'Καψαϊκίνη (PATCH)', 'Δια-ρινικά', '1234', 'μg', '0', 'Αλλη', null, 'Συνεχίζει (Μείωση δοσολογίας)', null, 'Κόστος');
INSERT INTO `patients_farm_agogi_details` VALUES ('29', '39', '23', '0', 'Βενλαφαξίνη', 'Ενδομυικά', '12', 'Επιθέματα', '0', 'ανά ημέρα', null, 'Διακοπή', null, 'Μη συμμόρφωση');
INSERT INTO `patients_farm_agogi_details` VALUES ('30', '37', '2', '0', 'Βενλαφαξίνη', 'Δια-ρινικά', '1', 'mg', '0', 'ανά ημέρα', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('35', '41', '2', '0', 'COX-2-Αναστολείς', 'Από το στόμα', '2', 'mg/kg', '3', 'ανά ημέρα', '2015-03-01', 'Εναρξη', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('37', '41', '2', '0', 'Αλλο', 'Επίθεμα', '0', '', '0', 'ανά ημέρα', null, 'Συνεχίζει (ίδια δοσολογία)', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('38', '41', '2', '0', 'Βενλαφαξίνη', 'Δια-ρινικά', '1', 'mg', '0', 'ανά ημέρα', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('46', '45', '23', '0', 'Καψαϊκίνη (PATCH)', 'Από το στόμα', '1', 'mg', '1', 'ανά ημέρα', null, 'Εναρξη', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('47', '45', '23', '0', 'Γκαμπαπεντίνη', 'Επίθεμα', '12', 'mg/kg', '12', 'ανά μήνα', null, 'Συνεχίζει (Αύξηση δοσολογίας)', null, 'Μειωμένη αποτελεσματικότητα');
INSERT INTO `patients_farm_agogi_details` VALUES ('48', '45', '23', '0', 'Κλονιδίνη', 'Ενδοφλέβια', '123', 'ml', '453', 'ανά 3 μήνες', null, 'Συνεχίζει (ίδια δοσολογία)', null, 'Προτιμήσεις ασθενούς');
INSERT INTO `patients_farm_agogi_details` VALUES ('49', '45', '23', '0', 'Καψαϊκίνη (PATCH)', 'Δια-ρινικά', '1234', 'μg', '0', 'Αλλη', null, 'Διακοπή', null, 'Κόστος');
INSERT INTO `patients_farm_agogi_details` VALUES ('50', '45', '23', '0', 'Βενλαφαξίνη', 'Ενδομυικά', '12', 'Επιθέματα', '0', 'ανά ημέρα', null, 'Συνεχίζει (ίδια δοσολογία)', null, 'Μη συμμόρφωση');
INSERT INTO `patients_farm_agogi_details` VALUES ('51', '46', '31', '0', 'Καψαϊκίνη (PATCH)', 'Επίθεμα', '1', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('52', '47', '31', '0', 'Καψαϊκίνη (PATCH)', 'Επίθεμα', '0', '', '0', '', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('53', '46', '31', '0', 'SSRis', 'Από το στόμα', '10', 'mg', '2', 'ανά ημέρα', '2015-05-11', 'Συνεχίζει (Αύξηση δοσολογίας)', null, 'Μειωμένη αποτελεσματικότητα');
INSERT INTO `patients_farm_agogi_details` VALUES ('54', '45', '23', '0', 'Μορφίνη', '', '0', '', '0', '', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('57', '41', '2', '0', 'ΜΣΑΦ', 'Από το στόμα', '0', '', '0', '', null, 'Συνεχίζει (ίδια δοσολογία)', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('58', '41', '2', '0', 'EMLA', 'Επίθεμα', '5', 'Επιθέματα', '3', 'ανά 3 μήνες', '2022-05-25', 'Εναρξη', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('59', '48', '33', '0', 'Πρεγκαμπαλίνη', 'Από το στόμα', '150', 'mg', '3', 'ανά ημέρα', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('60', '49', '33', '0', 'Πρεγκαμπαλίνη', 'Από το στόμα', '150', 'mg', '3', 'ανά ημέρα', null, 'Διακοπή', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('62', '50', '32', '0', 'Παρακεταμόλη', 'Επίθεμα', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('64', '49', '33', '0', 'Γκαμπαπεντίνη', 'Επίθεμα', '100', 'mg', '3', 'ανά μήνα', null, 'Εναρξη', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('65', '49', '33', '0', 'Πρεγκαμπαλίνη', 'Από το στόμα', '150', 'mg', '3', 'ανά ημέρα', null, 'Εναρξη', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('66', '52', '33', '0', 'COX-2-Αναστολείς', 'Επίθεμα', '150', 'mg', '3', 'ανά ημέρα', null, 'Συνεχίζει (ίδια δοσολογία)', null, 'Ανεπιθύμητες ενέργειες');
INSERT INTO `patients_farm_agogi_details` VALUES ('69', '55', '33', '0', 'EMLA', 'Επίθεμα', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('70', '56', '38', '0', 'SSRis', '', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('71', '57', '38', '0', 'Αλλο', '', '0', '', '0', '', null, '', null, '');
INSERT INTO `patients_farm_agogi_details` VALUES ('72', '58', '38', '0', 'SSRis', 'Επίθεμα', '150', 'mg', '3', 'ανά ημέρα', null, 'Εναρξη', null, 'Προτιμήσεις ασθενούς');
INSERT INTO `patients_farm_agogi_details` VALUES ('73', '59', '39', '0', 'Οξυκοδόνη + Παρακεταμόλη', 'Ενδομυικά', '0', 'Επιθέματα', '0', 'ανά 3 μήνες', null, 'Συνεχίζει (Αύξηση δοσολογίας)', null, 'Μειωμένη αποτελεσματικότητα');
INSERT INTO `patients_farm_agogi_details` VALUES ('74', '59', '39', '0', 'Μεξιλετίνη', '', '0', '', '0', '', null, '', null, '');

-- ----------------------------
-- Table structure for `patients_hkg`
-- ----------------------------
DROP TABLE IF EXISTS `patients_hkg`;
CREATE TABLE `patients_hkg` (
  `IDHKG` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) NOT NULL DEFAULT '0',
  `HmEggrafis` datetime NOT NULL,
  `Flevokomvikos` tinyint(1) DEFAULT '0',
  `KolpikiMarmarigi` tinyint(1) DEFAULT '0',
  `KolpikosPterigismos` tinyint(1) DEFAULT NULL,
  `Vimatodotkos` tinyint(1) DEFAULT '0',
  `VimatodotkosAAI` tinyint(1) DEFAULT NULL,
  `VimatodotkosVDD` tinyint(1) DEFAULT NULL,
  `VimatodotkosDDD` tinyint(1) DEFAULT '0',
  `RithmosMemo` text,
  `Syxnotita` text,
  `HKGMemo` text,
  PRIMARY KEY (`IDHKG`),
  KEY `IDPatient` (`IDPatient`) USING BTREE,
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE,
  KEY `IDParagKindinou` (`IDHKG`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of patients_hkg
-- ----------------------------

-- ----------------------------
-- Table structure for `patients_klinikiexetasi`
-- ----------------------------
DROP TABLE IF EXISTS `patients_klinikiexetasi`;
CREATE TABLE `patients_klinikiexetasi` (
  `IDKlinikisExetasis` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) NOT NULL DEFAULT '0',
  `HmEggrafis` datetime NOT NULL,
  `AkroasiKardiasS1S2` tinyint(1) DEFAULT '0',
  `ProsthetoiHxoi` tinyint(1) DEFAULT '0',
  `AkroasiKardiasMemo` text,
  `AkroasiPnevmononTypos` tinyint(1) DEFAULT '0',
  `AkroasiPnevmononMemo` text,
  `KatoAkraOidimata` tinyint(1) DEFAULT NULL,
  `KatoAkraOidimataThesi` tinyint(1) DEFAULT '0',
  `Sfagitides` tinyint(1) DEFAULT '0',
  `Karotides` tinyint(1) DEFAULT NULL,
  `KarotidesFisimaThesi` tinyint(1) DEFAULT NULL,
  `ArtiriakiPiesiDexiaMikri` double DEFAULT NULL,
  `ArtiriakiPiesiDexiaMegali` double DEFAULT NULL,
  `ArtiriakiPiesiAristeraMikri` double DEFAULT NULL,
  `ArtiriakiPiesiAristeraMegali` double DEFAULT '0',
  `ArtiriakiPiesiMemo` text,
  `Sxolia` text,
  PRIMARY KEY (`IDKlinikisExetasis`),
  KEY `IDPatient` (`IDPatient`) USING BTREE,
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE,
  KEY `IDParagKindinou` (`IDKlinikisExetasis`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of patients_klinikiexetasi
-- ----------------------------

-- ----------------------------
-- Table structure for `patients_paragondes_kindinou`
-- ----------------------------
DROP TABLE IF EXISTS `patients_paragondes_kindinou`;
CREATE TABLE `patients_paragondes_kindinou` (
  `IDParagKindinou` int(11) NOT NULL AUTO_INCREMENT,
  `IDPatient` int(11) DEFAULT '0',
  `HmEggrafis` datetime DEFAULT NULL,
  `Kapnisma` tinyint(1) DEFAULT '0',
  `KapnismaDiakopi` tinyint(1) DEFAULT '0',
  `KapnismaDiakopiHmerominia` datetime DEFAULT NULL,
  `SakxarodisDiavitis` tinyint(1) DEFAULT '0',
  `Sakxaro` double DEFAULT '0',
  `HbA1C` double DEFAULT NULL,
  `ArtiriakiPiesi` tinyint(1) DEFAULT '0',
  `ArtiriakiPiesiMegali` double DEFAULT NULL,
  `ArtiriakiPiesiMikri` double DEFAULT NULL,
  `Dyslipidaimia` tinyint(1) DEFAULT '0',
  `Xolisterini` double DEFAULT NULL,
  `Triglikeridia` double DEFAULT NULL,
  `HDL` double DEFAULT NULL,
  `LDL` double DEFAULT NULL,
  `SGOT` double DEFAULT NULL,
  `SGPT` double DEFAULT NULL,
  `CPK` double DEFAULT NULL,
  `ThetikoOikogIstoriko` tinyint(1) DEFAULT '0',
  `BMI` double DEFAULT '0',
  `Varos` double DEFAULT '0',
  `Ycos` double DEFAULT '0',
  `HeartScore` text,
  `Sxolia` text,
  PRIMARY KEY (`IDParagKindinou`),
  KEY `IDPatient` (`IDPatient`),
  KEY `HmEggrafis` (`HmEggrafis`) USING BTREE,
  KEY `IDParagKindinou` (`IDParagKindinou`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of patients_paragondes_kindinou
-- ----------------------------
INSERT INTO `patients_paragondes_kindinou` VALUES ('22', '2', '2015-01-21 00:00:00', '1', '1', null, '1', '1', '1', '1', '1', null, '1', null, null, null, null, null, null, null, '1', '1', '0', '0', '1', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('24', '17', '2014-09-07 00:00:00', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '0', '0', null, null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('26', '20', '2014-07-15 00:00:00', null, null, null, '0', null, null, null, null, null, null, null, null, null, null, null, null, null, '0', null, '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('46', '23', '2015-04-26 00:00:00', '0', '1', null, '0', '1', '1', '1', '1', null, '1', null, null, null, null, null, null, null, '1', '1', '0', '0', '1', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('48', '2', '2015-04-28 00:00:00', '0', '1', null, '1', '1', '1', '1', '1', null, '1', null, null, null, null, null, null, null, '1', '1', '0', '0', '1', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('50', '23', '2015-04-28 00:00:00', '0', '1', null, '1', '1', '1', '1', '1', null, '1', null, null, null, null, null, null, null, '1', '1', '0', '0', '1', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('51', '28', '2015-04-28 00:00:00', '0', '0', null, '1', '0', '0', '1', '0', null, '0', null, null, null, null, null, null, null, '0', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('52', '28', '2015-04-28 00:00:00', '0', '0', null, '1', '0', '0', '1', '0', null, '0', null, null, null, null, null, null, null, '0', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('53', '23', '2015-04-28 00:00:00', '0', '0', null, '1', '0', '0', '1', '0', null, '0', null, null, null, null, null, null, null, '0', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('58', '2', '2015-05-04 00:00:00', '1', '1', null, '1', '1', '1', '1', '1', null, '1', null, null, null, null, null, null, null, '1', '1', '0', '0', '1', 'ααα');
INSERT INTO `patients_paragondes_kindinou` VALUES ('59', '2', '2017-04-14 00:00:00', '1', '0', null, '1', '0', '0', '1', '0', null, '1', null, null, null, null, null, null, null, '0', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('60', '2', '2017-04-14 00:00:00', '1', '0', null, '1', '0', '0', '1', '0', null, '0', null, null, null, null, null, null, null, '0', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('65', '2', '2017-04-15 00:00:00', '0', '0', null, '1', '0', '0', '1', '0', null, '1', null, null, null, null, null, null, null, '1', '0', '0', '0', '0', null);
INSERT INTO `patients_paragondes_kindinou` VALUES ('67', '2', '2017-04-22 00:00:00', '1', '0', null, '0', '0', '0', '0', '0', null, '0', null, null, null, null, null, null, null, '0', '0', '0', '0', '1', 'aaaaaaa');
INSERT INTO `patients_paragondes_kindinou` VALUES ('68', '2', '2017-04-24 00:00:00', '1', '1', '2006-05-01 00:00:00', '1', '1', '2', '0', '12', '9', '1', '3', '4', null, null, null, null, null, '1', '5', '6', '1.7', '8', null);
