CREATE TABLE `patient_profile` (
  `FirstName` varchar(500) DEFAULT NULL,
  `LastName` varchar(500) DEFAULT NULL,
  `SSN` varchar(500) DEFAULT NULL,
  `DoB` varchar(500) DEFAULT NULL,
  `Gender` varchar(100) DEFAULT NULL,
  `PID` varchar(100) DEFAULT '',
  `Account` varchar(405) DEFAULT NULL,
  `Address` varchar(45) DEFAULT NULL,
  `City` varchar(45) DEFAULT NULL,
  `State` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$


CREATE TABLE `patient_test` (
  `PID` varchar(500) NOT NULL,
  `LabTest` varchar(500) NOT NULL,
  `PhysicianName` varchar(500) DEFAULT NULL,
  `OBID` varchar(500) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

CREATE TABLE `result_details` (
  `PID` varchar(500) NOT NULL,
  `ResultDesc` varchar(500) NOT NULL,
  `ResultSpec` varchar(500) DEFAULT NULL,
  `OBID` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$