-- 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;