-- Create Table Statement for 'Informed Consent'
DROP TABLE IF EXISTS `INFORMED_CONSENT`;
CREATE TABLE `INFORMED_CONSENT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CUSTOMER_ACCOUNT_CODE varchar,
	CREATE_DATE datetime,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	GENDER_CL varchar,
	BIRTH_DATE datetime,
	SOCIAL_SECURITY varchar,
	SOCIAL_SECURITY_ENCODED varchar,
	DRIVER_LICENSE_NUMBER varchar,
	DRIVER_LICENSE_NUMBER_ENCODED varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	HOME_PHONE varchar,
	WORK_PHONE varchar,
	CELL_PHONE varchar,
	EMAIL varchar,
	COMMENT varchar,
	POSTER_CODE varchar,
	SALES_PERSON_CODE varchar,
	SALES_PERSON_NUMBER1 varchar,
	STORE_NUMBER varchar,
	STATUS_CL varchar,
	IS_EXISTING_CUSTOMER tinyint(1),
	LEAD_SOURCE_CODE varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;