-- Create Table Statement for 'Credit Agency Profile'
DROP TABLE IF EXISTS `CREDIT_AGENCY_PROFILE`;
CREATE TABLE `CREDIT_AGENCY_PROFILE` (
	ID bigint(20) NOT NULL,
	TRANS_UNION_IDENTIFIER varchar,
	EXPERIAN_IDENTIFIER varchar,
	EQUIFAX_IDENTIFIER varchar,
	INNOVIS_IDENTIFIER varchar,
	IDENTIFICATION_NUMBER varchar,
	REPORTER_NAME varchar,
	REPORTER_STREET varchar,
	REPORTER_CITY varchar,
	REPORTER_STATE varchar,
	REPORTER_ZIP_CODE varchar,
	REPORTER_TELEPHONE_NUMBER varchar,
	MERCHANT_ACCOUNT_PROFILE_FK bigint(20),
	REPORTER_PHONE_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;