 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) NOT NULL DEFAULT 'NULL',
-  `username` VARCHAR(40) NOT NULL DEFAULT 'NULL',
-  `password` VARCHAR(30) NOT NULL DEFAULT 'NULL',
+  `id` INTEGER NOT NULL AUTO_INCREMENT,
+  `company_name` VARCHAR(30) NULL,
+  `username` VARCHAR(40) NULL,
+  `password` VARCHAR(30) NULL,
   PRIMARY KEY (`id`)
 );
 


CREATE TABLE `institution` (
  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NOT NULL,
  `inst_name` VARCHAR(30) NOT NULL DEFAULT 'NULL',
  `type` VARCHAR(25) NOT NULL DEFAULT 'NULL',
  `description` VARCHAR(300) NOT NULL DEFAULT 'NULL',
  `rating` INTEGER(5) NOT NULL DEFAULT NULL,
  `phone_number` VARCHAR(20) NOT NULL DEFAULT 'NULL',
  PRIMARY KEY (`id`)
);


DROP TABLE IF EXISTS `physician`;

CREATE TABLE `physician` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `first` VARCHAR(30) NULL,
  `last` VARCHAR(30) NULL,
  `email` VARCHAR(30) NULL,
  `phone_number` VARCHAR(20) NULL,
  `password` VARCHAR(30) NULL,
  `photo_path` VARCHAR NULL,
  `specialty` VARCHAR(500) NULL,
  PRIMARY KEY (`id`),
KEY ()
);
