delimiter $$

CREATE TABLE `benefits` (
  `EmpSSN` int(11) DEFAULT NULL,
  `EmpFirstName` varchar(200) DEFAULT NULL,
  `EmpLastName` varchar(200) DEFAULT NULL,
  `EmpMiddleInitial` varchar(45) DEFAULT NULL,
   `EmpGender` varchar(45) DEFAULT NULL,
  `Addr1` varchar(200) DEFAULT NULL,
  `Addr2` varchar(200) DEFAULT NULL,
  `EmpCity` varchar(200) DEFAULT NULL,
  `EmpState` varchar(200) DEFAULT NULL,
  `EmpZipCode` varchar(45) DEFAULT NULL,
   `DOB` varchar(45) DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `ElectionCode` varchar(45) DEFAULT NULL,
  `OrgID` varchar(45) DEFAULT NULL,
  `PolicyNumber` varchar(45) DEFAULT NULL,
  `HomePhone` varchar(45) DEFAULT NULL,
   `MaritalStatus` varchar(45) DEFAULT NULL,
  `EffectiveDate` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

delimiter $$

CREATE TABLE `claim` (
  `ClaimSubmitterIdentifier` varchar(50) DEFAULT NULL,
  `MonetaryAmount` varchar(50) DEFAULT NULL,
  `HealthCareServiceLoc` varchar(50) DEFAULT NULL,
   `FacilityCode` varchar(10) DEFAULT NULL,
  `FacilityCodeQualifier` varchar(10) DEFAULT NULL,
  `ClaimFrequencyTypeCode` varchar(10) DEFAULT NULL,
  `SignatureOnFile` varchar(10) DEFAULT NULL,
  `InterchangeControlNumber` varchar(50) DEFAULT NULL,
   `SubscriberPolicyNumber` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

delimiter $$

CREATE TABLE `benefits` (
  `EmpSSN` int(11) DEFAULT NULL,
  `EmpFirstName` varchar(200) DEFAULT NULL,
   `EmpLastName` varchar(200) DEFAULT NULL,
  `EmpMiddleInitial` varchar(45) DEFAULT NULL,
  `EmpGender` varchar(45) DEFAULT NULL,
  `Addr1` varchar(200) DEFAULT NULL,
  `Addr2` varchar(200) DEFAULT NULL,
  `EmpCity` varchar(200) DEFAULT NULL,
   `EmpState` varchar(200) DEFAULT NULL,
  `EmpZipCode` varchar(45) DEFAULT NULL,
  `DOB` varchar(45) DEFAULT NULL,
  `Occupation` varchar(45) DEFAULT NULL,
  `ElectionCode` varchar(45) DEFAULT NULL,
  `OrgID` varchar(45) DEFAULT NULL,
   `PolicyNumber` varchar(45) DEFAULT NULL,
  `HomePhone` varchar(45) DEFAULT NULL,
  `MaritalStatus` varchar(45) DEFAULT NULL,
  `EffectiveDate` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$