list bank vietnam

db.sql

-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Máy chủ: localhost:8889
-- Thời gian đã tạo: Th10 06, 2021 lúc 06:55 AM
-- Phiên bản máy phục vụ: 5.7.32
-- Phiên bản PHP: 7.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Cơ sở dữ liệu: `zz`
--

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `bank`
--

CREATE TABLE `bank` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `logo` text,
  `parent_id` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Đang đổ dữ liệu cho bảng `bank`
--

INSERT INTO `bank` (`id`, `name`, `logo`, `parent_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ABBank - NHTMCP An Binh', NULL, NULL, 1, '2021-10-06 13:53:43', '2021-10-06 13:53:43'),
(2, 'ACB - NH TMCP A Chau', NULL, NULL, 1, '2021-10-06 13:53:54', '2021-10-06 13:53:54'),
(3, 'ANZ Bank', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:53'),
(4, 'Agribank - NH NN & PTNT Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(5, 'BIDV - NH Dau tu & Phat trien Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(6, 'Bac A bank - NHTMCP Bac A', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(7, 'BaoViet Bank - NH TMCP Bao Viet', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(8, 'Citibank (HCM)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(9, 'Citibank (HN)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(10, 'Dong A Bank - NHTMCP Dong A', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(11, 'Eximbank - NHTMCP Xuat Nhap Khau', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(12, 'GPBank - NHTMCP Dau khi Toan cau', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(13, 'HD Bank - NHTMCP phat trien Tp HCM', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(14, 'Hong Kong and Shanghai Bank (HSBC)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(15, 'Hong Leong Bank Vietnam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(16, 'IVB - NH TNHH Indovina', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(17, 'Industrial Bank of Korea', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(18, 'Kien Long bank - NHTMCP Kien Long', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(19, 'Kookmin Bank (HCM)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(20, 'Lien Viet Post Bank - NH TMCP Buu Dien Lien Viet', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(21, 'MB - NHTMCP Quan Doi', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(22, 'Maritime Bank - NHTMCP Hang Hai', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(23, 'May Bank (HCM)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(24, 'May Bank (HN)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(25, 'Nam A Bank - NHTMCP Nam A', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(26, 'National Citizen Bank - NHTMCP Quoc Dan', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(27, 'OCB - NHTMCP Phuong Dong', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(28, 'Oceanbank - NHTMCP Dai Duong', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(29, 'PGBank - NHTMCP Xang dau Petrolimex', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(30, 'PVcomBank - NH TMCP Dai Chung Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(31, 'SCB - NHTMCP Sai Gon', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(32, 'SHB - NHTMCP Sai gon - Ha Noi', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(33, 'Sacombank - NHTMCP Sai gon Thuong Tin', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(34, 'SaigonBank - NHTMCP Sai Gon Cong Thuong', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(35, 'Seabank - NHTMCP Dong Nam A', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(36, 'Shinhan Bank Vietnam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(37, 'Siam Commercial Bank', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(38, 'Standard Chartered Bank', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(39, 'Sumitomo Mitsui Banking Corporation', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(40, 'Taipei Fubon Bank', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(41, 'Techcombank - NHTMCP Ky thuong VN', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(42, 'Tien Phong Bank - NH TMCP Tien Phong', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(43, 'VBSP - NH Chinh sach xa hoi', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(44, 'VCB - NH TMCP Ngoai Thuong Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(45, 'VDB - NH Phat trien Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(46, 'VIB - NHTMCP Quoc Te', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(47, 'VID Public Bank', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(48, 'VNCB - NHTMCP Xay dung VN', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(49, 'VP Bank - NHTMCP VN Thinh Vuong', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(50, 'VRB - NH Lien doanh Viet Nga', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(51, 'Viet Capital Bank - NHTMCP Ban Viet', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(52, 'VietABank - NHTMCP Viet A', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(53, 'VietBank - NHTMCP Viet Nam Thuong Tin', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(54, 'Vietinbank - NH Cong Thuong Viet Nam', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(55, 'Vinasiam Bank - NH Lien doanh Viet Thai', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54'),
(56, 'Woori Bank (HCM)', NULL, NULL, 1, '2021-10-06 13:54:53', '2021-10-06 13:54:54');

--
-- Chỉ mục cho các bảng đã đổ
--

--
-- Chỉ mục cho bảng `bank`
--
ALTER TABLE `bank`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT cho các bảng đã đổ
--

--
-- AUTO_INCREMENT cho bảng `bank`
--
ALTER TABLE `bank`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;