-- Create Table Statement for 'Employee'
DROP TABLE IF EXISTS `EMPLOYEE`;
CREATE TABLE `EMPLOYEE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	FIRST_NAME varchar NOT NULL,
	LAST_NAME varchar NOT NULL,
	MIDDLE_NAME varchar,
	MAIDEN_NAME varchar,
	TITLE varchar,
	SUFFIX varchar,
	GENDER_CL varchar,
	HOME_PHONE varchar,
	WORK_PHONE varchar,
	CELL_PHONE varchar,
	EMAIL varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	SOCIAL_SECURITY varchar,
	SOCIAL_SECURITY_MASKED varchar,
	DRIVER_LICENSE_NUMBER varchar,
	DRIVER_LICENSE_NUMBER_MASKED varchar,
	DRIVER_LICENSE_STATE varchar,
	BIRTH_DATE datetime,
	REF_CODE varchar,
	NOTES varchar,
	EMPLOYEE_RECORD_FK bigint(20),
	PASSWORD varchar,
	RACE_CL varchar,
	USERNAME varchar,
	MERCHANT_ACCOUNT_EXTERNAL_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;