 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`)
 );
 

DROP TABLE IF EXISTS `insurance_company_client`;

CREATE TABLE `insurance_company_client` (
  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NOT NULL,
  `company_name` VARCHAR(30) NULL DEFAULT NULL,
  `username` INTEGER NULL DEFAULT NULL,
  `password` VARCHAR(30) NULL DEFAULT NULL,

DROP TABLE IF EXISTS `medication`;

CREATE TABLE `medication` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `drug_name` VARCHAR(40) DEFAULT NULL,
  `details` INTEGER NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);
