DROP TABLE Doctor;

CREATE TABLE Doctor (
  did integer NOT NULL, 
  fname varchar(255) default NULL,
  lname varchar(255) default NULL,
  dept_id integer default NULL,
  age integer default NULL,
  salary integer default NULL,
  PRIMARY KEY (did)
);

DROP TABLE Patient;

CREATE TABLE Patient (
  pid integer unsigned NOT NULL, 
  fname varchar(255) default NULL,
  lname varchar(255) default NULL,
  primary_did integer default NULL,
  weight integer default NULL,
  height_in integer default NULL,
  age integer default NULL,
  PRIMARY KEY (pid)
);

DROP TABLE Department;

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