-- Create Table Statement for 'Business Owner'
DROP TABLE IF EXISTS `IAPP_BUSINESS_OWNER`;
CREATE TABLE `IAPP_BUSINESS_OWNER` (
	ID bigint(20) NOT NULL,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	EMAIL varchar,
	SOCIAL_SECURITY varchar,
	SOCIAL_SECURITY_ENCODED varchar,
	PHONE varchar,
	BIRTH_DATE datetime,
	DRIVER_LICENSE varchar,
	DRIVER_LICENSE_ENCODED varchar,
	DRIVER_LICENSE_STATE varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	SOCIAL_SECURITY_MASKED varchar,
	DRIVER_LICENSE_MASKED varchar,
	VERIFICATION_RESULT_FK bigint(20),
	OWNERSHIP_PERCENTAGE int(11),
	CITIZENSHIP_COUNTRY_CODE varchar,
	CITIZENSHIP varchar,
	DRIVER_LICENSE_COUNTRY_CODE varchar,
	STAKE_PERCENTAGE int(11),
	DEACTIVATION_DATE datetime,
	RESULT_DATA varchar,
	ROLE_POLICY_CL varchar,
	BUSINESS_INFO_FK bigint(20),
	ONBOARDING_APPLICATION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVIDER_REFERENCE_NUMBER varchar,
	COUNTRY_CODE varchar,
	CITIZENSHIP_COUNTRY_CODE varchar,
	DRIVER_LICENSE_COUNTRY_CODE varchar,
	COUNTRY_CODE varchar,
	CITIZENSHIP_COUNTRY_CODE varchar,
	DRIVER_LICENSE_COUNTRY_CODE varchar,
	STAKE_PERCENTAGE int(11),
	DEACTIVATION_DATE datetime,
	RESULT_DATA varchar,
	ROLE_POLICY_CL varchar,
	BUSINESS_INFO_FK bigint(20),
	ONBOARDING_APPLICATION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVIDER_REFERENCE_NUMBER varchar,
	ONBOARDING_OWNER_FK bigint(20),
	ONBOARDING_OWNER_FK bigint(20),
	CREATE_DATE datetime,
	CODE varchar,
	DEACTIVATOR_CODE varchar,
	STAKE_PERCENTAGE int(11),
	DEACTIVATION_DATE datetime,
	RESULT_DATA varchar,
	ROLE_POLICY_CL varchar,
	BUSINESS_INFO_FK bigint(20),
	ONBOARDING_APPLICATION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVIDER_REFERENCE_NUMBER varchar,
	ONBOARDING_OWNER_FK bigint(20),
	CREATE_DATE datetime,
	CODE varchar,
	DEACTIVATOR_CODE varchar,
	CREATE_DATE datetime,
	CODE varchar,
	DEACTIVATOR_CODE varchar,
	ONBOARDING_APPLICATION_FK bigint(20),
	OWNERSHIP_PERCENTAGE int(11),
	PROVISIONING_TRANSACTION_FK bigint(20),
	CODE varchar,
	ONBOARDING_APPLICATION_FK bigint(20),
	OWNERSHIP_PERCENTAGE int(11),
	PROVISIONING_TRANSACTION_FK bigint(20),
	CODE varchar,
	OWNERSHIP_PERCENTAGE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;