-- Create Table Statement for 'Customer'
DROP TABLE IF EXISTS `CUSTOMER`;
CREATE TABLE `CUSTOMER` (
	ID bigint(20) NOT NULL,
	REF_CODE varchar,
	CREATE_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	TITLE varchar,
	SUFFIX varchar,
	ACCOUNT_CL varchar,
	SOCIAL_SECURITY varchar,
	SOCIAL_SECURITY_ENCODED varchar,
	DRIVER_LICENSE_NUMBER varchar,
	DRIVER_LICENSE_NUMBER_ENCODED varchar,
	DRIVER_LICENSE_STATE varchar,
	BIRTH_DATE datetime,
	IS_DECEASED tinyint(1),
	IS_MAIL_DISALLOWED tinyint(1),
	IS_EMAIL_DISALLOWED tinyint(1),
	IS_CALLING_DISALLOWED tinyint(1),
	SKIP_TRACE_SOURCE_CL varchar,
	IS_CHARGEBACK_REQUESTED tinyint(1),
	IS_BANKRUPTCY_FILED tinyint(1),
	IS_LEGAL_DISPUTE tinyint(1),
	IS_CANCELLATION_DISPUTE tinyint(1),
	ACTIVE_ACCOUNT_COUNT int(11),
	LAST_UPDATE_DATE datetime,
	IS_SKIP_TRACE_REQUIRED tinyint(1),
	IS_MARKETING_EMAIL_ALLOWED tinyint(1),
	IS_BILLING_EMAIL_ALLOWED tinyint(1),
	SKIP_TRACE_MODE_CL varchar,
	DEFAULT_ADDRESS_FK bigint(20),
	DEFAULT_HOME_PHONE_FK bigint(20),
	DEFAULT_WORK_PHONE_FK bigint(20),
	DEFAULT_EMAIL_FK bigint(20),
	DEFAULT_CELL_PHONE_FK bigint(20),
	IS_MARKETING_CALL_ALLOWED tinyint(1),
	ORGANIZATION_NAME varchar,
	COUNTRY_CODE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	HOLDER_NAME varchar,
	DEFAULT_ADDRESS bigint(20),
	ORGANIZATION_NAME varchar,
	COUNTRY_CODE varchar,
	HOLDER_NAME varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ORGANIZATION_NAME varchar,
	COUNTRY_CODE varchar,
	HOLDER_NAME varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;