 DROP TABLE IF EXISTS `patient_physician`;
 
 CREATE TABLE `patient_physician` (
-  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NOT NULL,
+  `id` INTEGER NOT NULL AUTO_INCREMENT,
   `id_physician` INTEGER NOT NULL DEFAULT NOT NULL,
   `id_patient` INTEGER NOT NULL DEFAULT NOT NULL,
   PRIMARY KEY (`id`)

DROP TABLE IF EXISTS `physician`;

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

DROP TABLE IF EXISTS `patient`;

CREATE TABLE `patient` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `first` VARCHAR(30) NULL,
  `last` VARCHAR(30) NULL,
  `email` VARCHAR(30) NOT NULL DEFAULT 'NULL',
  `password` VARCHAR(30) NULL,
  `pin` INTEGER(4) NULL,
  `date_of_birth` DATE NULL,
  `address` VARCHAR(60) NULL,
  `city` VARCHAR(60) NULL,
  `state` VARCHAR(2) NULL,
  `zip` VARCHAR(10) NULL,
  `phone_number` VARCHAR(20) NULL,
  `weight` INTEGER NULL,
  `height` INTEGER NULL,
  `blood_type` VARCHAR(3) NULL,
  `photo_path` VARCHAR(200) NULL,
  PRIMARY KEY (`id`)
);

