 DROP TABLE IF EXISTS `patient_medication`;
 
 CREATE TABLE `patient_medication` (
-  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
-  `drug_name` VARCHAR NOT NULL DEFAULT 'NOT NULL',
-  `dosage` VARCHAR NULL DEFAULT 'NOT NULL',
-  `id_medication` INTEGER NOT NULL DEFAULT NOT NULL,
-  `id_physician` INTEGER NULL DEFAULT NULL,
-  `id_patient` INTEGER NOT NULL DEFAULT NOT NULL,
+  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+  `drug_name` VARCHAR(60) DEFAULT NULL,
+  `dosage` VARCHAR(60) DEFAULT NULL,
+  `id_medication` INTEGER UNSIGNED DEFAULT NULL,
+  `id_physician` INTEGER UNSIGNED DEFAULT NULL,
+  `id_patient` INTEGER UNSIGNED DEFAULT NULL,
   PRIMARY KEY (`id`)
 );
 

-- ---
-- Globals
-- ---

-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;


  `weight` INTEGER NULL DEFAULT NULL,
  `height` INTEGER NULL DEFAULT NULL,
  `blood_type` VARCHAR(2) NULL DEFAULT NULL,
  `photo_path` VARCHAR(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

