DROP TABLE `Doctor`;

CREATE TABLE `Doctor` (
  `did` mediumint(8) unsigned NOT NULL auto_increment,
  `fname` varchar(255) default NULL,
  `lname` varchar(255) default NULL,
  `dept_id` mediumint default NULL,
  `age` mediumint default NULL,
  `salary` mediumint default NULL,
  PRIMARY KEY (`did`)
) AUTO_INCREMENT=1;

DROP TABLE `Patient`;

CREATE TABLE `Patient` (
  `pid` mediumint(8) unsigned NOT NULL auto_increment,
  `fname` varchar(255) default NULL,
  `lname` varchar(255) default NULL,
  `primary_did` mediumint default NULL,
  `weight` mediumint default NULL,
  `height_in` mediumint default NULL,
  `age` mediumint default NULL,
  PRIMARY KEY (`pid`)
) AUTO_INCREMENT=1;

DROP TABLE `Department`;

CREATE TABLE `Department` (
  `dept_id` mediumint unsigned NOT NULL,
  `name` TEXT default NULL,
  `budget` mediumint default NULL,
  PRIMARY KEY (`dept_id`)
);