Слили БД банка в стадии слияния, одного другим. (USA)
2й Банк Работает посей день.
Как оценить стоимость БД в ней 800к+ Юзеров с данными
2й Банк Работает посей день.
Как оценить стоимость БД в ней 800к+ Юзеров с данными
idint NOT NULL,
customer_numberint DEFAULT NULL,
household_numbervarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_fnamevarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_lnamevarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_namevarchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_ssnint DEFAULT NULL,
customer_sincedate DEFAULT NULL,
customer_dobdate DEFAULT NULL,
customer_deceased_datedate DEFAULT NULL,
customer_streetvarchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_cityvarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_statevarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_zipint DEFAULT NULL,
customer_countryvarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_primary_phonebigint DEFAULT NULL,
customer_secondary_phonebigint DEFAULT NULL,
customer_emailvarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_primary_bankervarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
primary_banker_initialsvarchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_secondary_bankervarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_branch_nameint DEFAULT NULL,
customer_typevarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_lobvarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
customer_valuationvarchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
ob_enroll_datedate DEFAULT NULL,
ob_statustinyint(1) DEFAULT '0' COMMENT '1 for A, 0 for D',
ob_last_logindate DEFAULT NULL,
ob_unenroll_statusvarchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
ob_unenroll_datedate DEFAULT NULL,
ob_closed_datedate DEFAULT NULL,
bp_enroll_statusvarchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
bp_enroll_datevarchar(20) DEFAULT NULL,
bp_unenroll_datedate DEFAULT NULL,
bp_service_levelvarchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
distance_from_branchint DEFAULT NULL,
uv_employeevarchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
agent_idint DEFAULT NULL,
zip_testvarchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
fulldatedate DEFAULT NULL,
is_exist_customerint NOT NULL DEFAULT '1' COMMENT '1 for exist, 0 for not exist customer in rule data master',
egps_bankervarchar(255) DEFAULT NULL,
cust_type_descvarchar(30) DEFAULT NULL,
address_idvarchar(55) DEFAULT NULL,
data_update_datetimestamp NULL DEFAULT CURRENT_TIMESTAMP