-- Create Table Statement for 'Skip Tracing History Detail'
DROP TABLE IF EXISTS `SKIP_TRACING_HISTORY_DETAIL`;
CREATE TABLE `SKIP_TRACING_HISTORY_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SKIP_TRACE_CL varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	SUFFIX varchar,
	BIRTH_DATE datetime,
	SOCIAL_SECURITY_NUMBER varchar,
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE01 varchar,
	PHONE02 varchar,
	PHONE03 varchar,
	PHONE04 varchar,
	PHONE05 varchar,
	PHONE06 varchar,
	PHONE07 varchar,
	PHONE08 varchar,
	PHONE09 varchar,
	PHONE10 varchar,
	RESPONSE_ADDRESS_FIRST_NAME varchar,
	RESPONSE_ADDRESS_LAST_NAME varchar,
	RESPONSE_ADDRESS_MIDDLE_NAME varchar,
	RESPONSE_ADDRESS_SUFFIX varchar,
	RESPONSE_ADDRESS_STREET varchar,
	RESPONSE_ADDRESS_CITY varchar,
	RESPONSE_ADDRESS_STATE varchar,
	RESPONSE_ADDRESS_ZIP_CODE varchar,
	RESPONSE_PHONE1 varchar,
	RESPONSE_PHONE1_FIRST_NAME varchar,
	RESPONSE_PHONE1_LAST_NAME varchar,
	RESPONSE_PHONE1_MIDDLE_NAME varchar,
	RESPONSE_PHONE1_SUFFIX varchar,
	RESPONSE_PHONE1_DUAL_NAME varchar,
	RESPONSE_PHONE2 varchar,
	RESPONSE_PHONE2_FIRST_NAME varchar,
	RESPONSE_PHONE2_LAST_NAME varchar,
	RESPONSE_PHONE2_MIDDLE_NAME varchar,
	RESPONSE_PHONE2_SUFFIX varchar,
	RESPONSE_PHONE2_DUAL_NAME varchar,
	CUSTOMER_ACCOUNT_FK bigint(20),
	SKIP_TRACING_HISTORY_FK bigint(20),
	ADDRESS_FK bigint(20),
	PHONE1_FK bigint(20),
	PHONE2_FK bigint(20),
	CUSTOMER_ACCOUNT_CODE varchar,
	REFERENCE_NUMBER bigint(20),
	SOURCE_ADDRESS_FK bigint(20),
	RESPONSE_DECEASED_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;