-- Create Table Statement for 'Metro To Batch'
DROP TABLE IF EXISTS `METRO2_BATCH`;
CREATE TABLE `METRO2_BATCH` (
	ID bigint(20) NOT NULL,
	INNOVIS_IDENTIFIER varchar,
	EQUIFAX_IDENTIFIER varchar,
	EXPERIAN_IDENTIFIER varchar,
	TRANS_UNION_IDENTIFIER varchar,
	ACTIVITY_DATE varchar,
	CREATE_DATE varchar,
	REPORTER_NAME varchar,
	REPORTER_ADDRESS varchar,
	REPORTER_TELEPHONE_NUMBER varchar,
	TOTAL_BASE_RECORDS varchar,
	TOTAL_STATUS_CODE_DF varchar,
	TOTAL_STATUS_CODE_DA varchar,
	TOTAL_STATUS_CODE62 varchar,
	TOTAL_STATUS_CODE93 varchar,
	TOTAL_ECOA_CODE_Z varchar,
	TOTAL_SOCIAL_SECURITY_NUMBERS varchar,
	TOTAL_BIRTH_DATES varchar,
	TOTAL_TELEPHONE_NUMBERS varchar,
	METRO_2_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;