-- Create Table Statement for 'Bank Identification Number'
DROP TABLE IF EXISTS `IAPP_BANK_IDENTIFICATION_NUMBER`;
CREATE TABLE `IAPP_BANK_IDENTIFICATION_NUMBER` (
	CODE int(11) NOT NULL,
	PAYMENT_OPTION_CL varchar,
	BANK_NAME varchar,
	COUNTRY_CODE varchar,
	ADDRESS varchar,
	PHONE_NUMBER varchar,
	CARD_TYPE varchar,
	CARD_CATEGORY varchar,
	CARD_INDICATOR varchar,
	NETWORK_IDS varchar,
	BIN_UPDATE_DATE datetime,
	IS_COMMERCIAL tinyint(1),
	IS_FSA tinyint(1),
	IS_PREPAID tinyint(1),
	BIN_LOW int(11),
	BIN_HIGH int(11),
	PRODUCT_CODE varchar,
	REGULATOR_INDICATOR varchar,
	VISA_PRODUCT_SUB_TYPE varchar,
	IS_LARGE_TICKET tinyint(1),
	ACCOUNT_LEVEL_PROCESSING_INDICATOR varchar,
	ACCOUNT_FUND_SOURCE varchar,
	CARD_CLASS varchar,
	EBT_STATE varchar,
	PAN_LENGTH_MIN int(11),
	PAN_LENGTH_MAX int(11),
	CREATE_DATE datetime,
	LAST_UPDATE_DATE datetime,
	IS_OUT_DATED tinyint(1),
	PRIMARY KEY (CODE)
) ENGINE=InnoDB;