Created
October 6, 2021 07:09
-
-
Save ThienTranDuy/f5de3ed00ef8c2e615d57bbd924a7255 to your computer and use it in GitHub Desktop.
list bank vietnam
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment