-- Create Table Statement for 'Background Verification Result'
DROP TABLE IF EXISTS `IAPP_BACKGROUND_VERIFICATION_RESULT`;
CREATE TABLE `IAPP_BACKGROUND_VERIFICATION_RESULT` (
ID bigint(20) NOT NULL,
SCORE int(11),
SCORE_DESCRIPTION varchar,
NAME_ADDRESS_SSN_ASSOCIATION_CODE varchar,
NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE varchar,
NAME_ADDRESS_PHONE_ASSOCIATION_CODE varchar,
IS_NAME_VERIFIED tinyint(1),
IS_STREET_VERIFIED tinyint(1),
IS_CITY_VERIFIED tinyint(1),
IS_STATE_VERIFIED tinyint(1),
IS_ZIP_VERIFIED tinyint(1),
IS_PHONE_VERIFIED tinyint(1),
IS_SSN_VERIFIED tinyint(1),
IS_TAX_ID_VERIFIED tinyint(1),
ASSOCIATION_SCORE int(11),
ASSOCIATION_SCORE_DESCRIPTION varchar,
BUSINESS_VERIFICATION_RESULT_FK bigint(20),
NAME_ADDRESS_SSN_ASSOCIATION_DESCRIPTION varchar,
NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION varchar,
NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION varchar,
IS_DOB_VERIFIED tinyint(1),
BACKGROUND_CHECK_DECISION_NOTES varchar,
BANKRUPTCY_TYPE varchar,
BANKRUPTCY_COUNT int(11),
BANKRUPTCY_COMPANY_NAME varchar,
BANKRUPTCY_STREET1 varchar,
BANKRUPTCY_STREET2 varchar,
BANKRUPTCY_CITY varchar,
BANKRUPTCY_STATE varchar,
BANKRUPTCY_ZIP_CODE varchar,
BANKRUPTCY_FILING_DATE datetime,
LIEN_TYPE varchar,
LIEN_RELEASED_COUNT int(11),
LIEN_UNRELEASED_COUNT int(11),
LIEN_COMPANY_NAME varchar,
LIEN_STREET1 varchar,
LIEN_STREET2 varchar,
LIEN_CITY varchar,
LIEN_STATE varchar,
LIEN_ZIP_CODE varchar,
LIEN_FILING_DATE datetime,
RISK_INDICATOR1_CODE varchar,
RISK_INDICATOR1_DESCRIPTION varchar,
RISK_INDICATOR2_CODE varchar,
RISK_INDICATOR2_DESCRIPTION varchar,
RISK_INDICATOR3_CODE varchar,
RISK_INDICATOR3_DESCRIPTION varchar,
RISK_INDICATOR4_CODE varchar,
RISK_INDICATOR4_DESCRIPTION varchar,
RISK_INDICATOR5_CODE varchar,
RISK_INDICATOR5_DESCRIPTION varchar,
RISK_INDICATOR6_CODE varchar,
RISK_INDICATOR6_DESCRIPTION varchar,
LAST_UPDATE_DATE datetime,
STATUS_CODE varchar,
STATUS_DESCRIPTION varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;