-- Create Table Statement for 'Onboarding Owner'
DROP TABLE IF EXISTS `ONBOARDING_OWNER`;
CREATE TABLE `ONBOARDING_OWNER` (
ID bigint(20) NOT NULL,
FIRST_NAME varchar,
COUNTRY_CODE varchar,
LAST_NAME varchar,
ZIP_CODE varchar,
CITY varchar,
PHONE varchar,
STATE varchar,
EMAIL varchar,
STREET1 varchar,
STREET2 varchar,
BIRTH_DATE datetime,
SOCIAL_SECURITY varchar,
STAKE_PERCENTAGE int(11),
ONBOARDING_APPLICATION_FK bigint(20),
MERCHANT_ACCOUNT_CODE int(11),
PROVISIONING_TRANSACTION_FK bigint(20),
RESULT_DATA varchar,
PROVIDER_REFERENCE_NUMBER varchar,
STATUS_CL varchar,
TITLE varchar,
DRIVER_LICENSE varchar,
DRIVER_LICENSE_COUNTRY_CODE varchar,
DRIVER_LICENSE_STATE varchar,
CREATE_DATE datetime,
DEACTIVATION_DATE datetime,
CODE varchar,
DEACTIVATOR_CODE varchar,
NUMBER int(11),
STATUS_CL varchar,
TITLE varchar,
DRIVER_LICENSE varchar,
DRIVER_LICENSE_COUNTRY_CODE varchar,
DRIVER_LICENSE_STATE varchar,
CREATE_DATE datetime,
DEACTIVATION_DATE datetime,
CODE varchar,
DEACTIVATOR_CODE varchar,
NUMBER int(11),
PROVISIONING_TRANSACTION_FK bigint(20),
CODE varchar,
PROVISIONING_TRANSACTION_FK bigint(20),
CODE varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;