-- Create Table Statement for 'Billing History Detail' DROP TABLE IF EXISTS `BILLING_HISTORY_DETAIL`; CREATE TABLE `BILLING_HISTORY_DETAIL` ( ID bigint(20) NOT NULL, AMOUNT int(11), CLAIM_CL varchar, MERCHANT_ACCOUNT_CODE int(11) NOT NULL, BILLING_HISTORY_CL varchar, BILLING_HISTORY_FK bigint(20), ACCOUNT_ACTIVITY_FK bigint(20), CUSTOMER_ACCOUNT_FK bigint(20), ACCOUNT_TRANSACTION_FK bigint(20), REJECTED_TRANSACTION_FK bigint(20), FEE_TRANSACTION_FK bigint(20), PRIMARY KEY (ID) ) ENGINE=InnoDB;