﻿CREATE TABLE `patients` (
  `pat_code` mediumint(8) NOT NULL auto_increment COMMENT 'Unique patient code',
  `pat_name` varchar(48) NOT NULL COMMENT 'Patient name (surename firstname)',
  `birth_year` smallint(5) default NULL COMMENT 'Birth year',
  `address` varchar(48) default NULL COMMENT 'Address',
  `telephone` char(10) default NULL COMMENT 'Telephone number',
  `mobile` char(10) default NULL COMMENT 'Mobile Phone number',
  `security` varchar(24) default NULL COMMENT 'Social Security information',
  `first_visit` date default NULL COMMENT 'First Visit',
  `Notes` text COMMENT 'Additional Notes',
  `Sex` enum('Ανδρας','Γυναικα') default NULL COMMENT 'Ανδρας ή Γυναίκα',
  PRIMARY KEY  (`pat_code`),
  KEY `X_NAME` (`pat_name`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=greek 