-- Create Table Statement for 'Address'
DROP TABLE IF EXISTS `ADDRESS`;
CREATE TABLE `ADDRESS` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	NAME varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	REF_CREATOR_CODE varchar,
	IS_BAD tinyint(1),
	BAD_REASON varchar,
	ADDRESS_SOURCE_CL varchar,
	IS_SKIP_TRACE_ALLOWED tinyint(1),
	LAST_SKIP_TRACE_DATE datetime,
	IS_NOTIFICATION_LETTER_SENT1 tinyint(1),
	IS_NOTIFICATION_LETTER_SENT2 tinyint(1),
	IS_NOTIFICATION_LETTER_SENT3 tinyint(1),
	IS_COLLECTIONS_LETTER_SENT1 tinyint(1),
	IS_COLLECTIONS_LETTER_SENT2 tinyint(1),
	IS_COLLECTIONS_LETTER_SENT3 tinyint(1),
	IS_COLLECTIONS_LETTER_SENT4 tinyint(1),
	IS_COLLECTIONS_LETTER_SENT5 tinyint(1),
	CUSTOMER_FK bigint(20),
	ADDRESS_CL varchar,
	CUSTOMER_ACCOUNT_FK bigint(20),
	REF_CODE varchar,
	LAST_UPDATE_DATE datetime,
	COUNTRY_CODE varchar,
	LAST_INVOICE_NOTIFICATION_LETTER_SENT_DATE datetime,
	LAST_STATEMENT_LETTER_SENT_DATE datetime,
	BASE_OBJECT_CODE bigint(20),
	STREET1 varchar,
	STREET2 varchar,
	ADDRESS varchar,
	ADDRESS varchar,
	STREET1 varchar,
	STREET2 varchar,
	ADDRESS varchar,
	ADDRESS varchar,
	NAME varchar,
	COUNTRY_CODE varchar,
	CUSTOMER_FK bigint(20),
	STREET2 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;