-- 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;