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 `transactionheader` ( `InterchangeSenderID` varchar(50) DEFAULT NULL, `InterchangeReceiverID` varchar(50) DEFAULT NULL, `InterchangeControlNumber` varchar(50) DEFAULT NULL, `TransactionSetPurposeCode` varchar(50) DEFAULT NULL, `FunctionalIdentifierCode` varchar(50) DEFAULT NULL, `TransactionDate` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$ delimiter $$ CREATE TABLE `subscriber` ( `InterchangeControlNumber` varchar(50) DEFAULT NULL, `SubscriberPolicyNumber` varchar(50) DEFAULT NULL, `InsuranceTypeCode` varchar(50) DEFAULT NULL, `EmploymentStatusCode` varchar(50) DEFAULT NULL, `LastName` varchar(50) DEFAULT NULL, `FirstName` varchar(50) DEFAULT NULL, `IdentificationCode` varchar(50) DEFAULT NULL, `SubscriberAddr1` varchar(50) DEFAULT NULL, `SubscriberAddr2` varchar(50) DEFAULT NULL, `SubscriberCity` varchar(50) DEFAULT NULL, `SubscriberState` varchar(50) DEFAULT NULL, `SubscriberPostalCode` varchar(50) DEFAULT NULL, `CountryCode` varchar(50) DEFAULT NULL, `MaritalStatus` varchar(50) DEFAULT NULL, `Quantity` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$ delimiter $$ CREATE TABLE `submitter` ( `InterchangeControlNumber` varchar(50) DEFAULT NULL, `EntityIDCode` varchar(20) DEFAULT NULL, `EntityTypeQualifier` varchar(10) DEFAULT NULL, `OrganizationName` varchar(50) DEFAULT NULL, `SubmitterFTIN` varchar(50) DEFAULT NULL, `FederalTaxID` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$ delimiter $$ CREATE TABLE `serviceline` ( `InterchangeControlNumber` varchar(50) DEFAULT NULL, `SubscriberPolicyNumber` varchar(50) DEFAULT NULL, `ProductServiceID` varchar(50) DEFAULT NULL, `LineItemCharge` float DEFAULT NULL, `ProcedureModifier` varchar(50) DEFAULT NULL, `Quantity` float DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$ delimiter $$ CREATE TABLE `physiciandetail` ( `AttendingPhysicianFirstName` varchar(100) DEFAULT NULL, `AttendingPhysicianLastName` varchar(100) DEFAULT NULL, `AttendingPhysicianMiddleName` varchar(100) DEFAULT NULL, `EmployersIDNumber` varchar(100) DEFAULT NULL, `EntityTypeQualifier` varchar(100) DEFAULT NULL, `EntityIdentifierCode` varchar(100) DEFAULT NULL, `InterchangeControlNumber` varchar(100) DEFAULT NULL, `SubscriberPolicyNumber` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$ delimiter $$ CREATE TABLE `payer` ( `PayerName` varchar(100) DEFAULT NULL, `EntityIdentifierCode` varchar(50) DEFAULT NULL, `OrgnizationName` varchar(100) DEFAULT NULL, `IdentificationCode` varchar(50) DEFAULT NULL, `PayerAddress` varchar(150) DEFAULT NULL, `PayerCity` varchar(50) DEFAULT NULL, `PayerState` varchar(50) DEFAULT NULL, `PayerPostalCode` varchar(15) DEFAULT NULL, `InterchangeControlNumber` varchar(50) DEFAULT NULL, `SubscriberPolicyNumber` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$