/*
 Navicat Premium Data Transfer

 Source Server         : Server67
 Source Server Type    : PostgreSQL
 Source Server Version : 90615
 Source Host           : localhost:5432
 Source Catalog        : IKICashTA
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 90615
 File Encoding         : 65001

 Date: 19/10/2019 14:37:25
*/


-- ----------------------------
-- Sequence structure for refbank_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."refbank_id_seq";
CREATE SEQUENCE "public"."refbank_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for systeminfo_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."systeminfo_id_seq";
CREATE SEQUENCE "public"."systeminfo_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for transaction_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."transaction_id_seq";
CREATE SEQUENCE "public"."transaction_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Table structure for bankbalance
-- ----------------------------
CREATE TABLE "public"."bankbalance" (
  "mitraid" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "balancedate" date,
  "BODBalance" numeric(64),
  "status" varchar(255) COLLATE "pg_catalog"."default",
  "debit" numeric(255),
  "credit" numeric(255),
  "createdate" date,
  "createtime" time(0),
  "createby" varchar(255) COLLATE "pg_catalog"."default",
  "currentBalance" numeric(255)
)
;
COMMENT ON COLUMN "public"."bankbalance"."balancedate" IS 'tanggal balance';
COMMENT ON COLUMN "public"."bankbalance"."BODBalance" IS 'begin of day balance';
COMMENT ON COLUMN "public"."bankbalance"."status" IS 'debit/credit';
COMMENT ON COLUMN "public"."bankbalance"."debit" IS 'summary debit';
COMMENT ON COLUMN "public"."bankbalance"."credit" IS 'summary credit';

-- ----------------------------
-- Records of bankbalance
-- ----------------------------
INSERT INTO "public"."bankbalance" VALUES ('451', '2019-10-16', 1000000, 'D', 1000000, NULL, '2019-10-16', '17:18:16', 'sys', 1000000);
INSERT INTO "public"."bankbalance" VALUES ('451', '2019-10-17', 1000000, 'D', 1000000, NULL, '2019-10-17', '10:01:32', 'sys', 1000000);

-- ----------------------------
-- Table structure for clientbalance
-- ----------------------------
CREATE TABLE "public"."clientbalance" (
  "clientid" varchar(64) COLLATE "pg_catalog"."default",
  "balancedate" date,
  "BODBalance" numeric(64),
  "status" varchar(255) COLLATE "pg_catalog"."default",
  "debit" numeric(255),
  "credit" numeric(255),
  "createdate" date,
  "createtime" time(0),
  "createby" varchar(255) COLLATE "pg_catalog"."default",
  "transid" varchar(20) COLLATE "pg_catalog"."default",
  "currentBalance" numeric(255)
)
;
COMMENT ON COLUMN "public"."clientbalance"."balancedate" IS 'tanggal balance';
COMMENT ON COLUMN "public"."clientbalance"."BODBalance" IS 'begin of day balance';
COMMENT ON COLUMN "public"."clientbalance"."status" IS 'D. debit C. credit';
COMMENT ON COLUMN "public"."clientbalance"."debit" IS 'summary debit';
COMMENT ON COLUMN "public"."clientbalance"."credit" IS 'summary credit';
COMMENT ON COLUMN "public"."clientbalance"."createtime" IS 'time trx';
COMMENT ON COLUMN "public"."clientbalance"."transid" IS 'client transaction id';

-- ----------------------------
-- Records of clientbalance
-- ----------------------------
INSERT INTO "public"."clientbalance" VALUES ('51', '2019-10-16', 1000000, 'D', 1000000, NULL, '2019-10-16', '16:15:00', 'sys', '', 1000000);
INSERT INTO "public"."clientbalance" VALUES ('51', '2019-10-17', 1000000, 'D', 1000000, NULL, '2019-10-17', '10:00:39', 'sys', '', 1000000);

-- ----------------------------
-- Table structure for group
-- ----------------------------
CREATE TABLE "public"."group" (
  "groupid" varchar(2) COLLATE "pg_catalog"."default" NOT NULL,
  "groupname" varchar(255) COLLATE "pg_catalog"."default",
  "createdby" varchar(255) COLLATE "pg_catalog"."default",
  "createdtime" time(6),
  "updatetime" time(6)
)
;

-- ----------------------------
-- Records of group
-- ----------------------------
INSERT INTO "public"."group" VALUES ('02', 'C2A', NULL, NULL, NULL);
INSERT INTO "public"."group" VALUES ('03', 'COURIER', NULL, NULL, NULL);
INSERT INTO "public"."group" VALUES ('01', 'PPOB', NULL, NULL, '03:14:46');

-- ----------------------------
-- Table structure for log
-- ----------------------------
CREATE TABLE "public"."log" (
  "transId" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "message" text COLLATE "pg_catalog"."default",
  "clientId" varchar(100) COLLATE "pg_catalog"."default",
  "bankId" int8,
  "created_by" varchar(255) COLLATE "pg_catalog"."default",
  "created_date" date,
  "created_time" time(1),
  "messagetype" varchar(255) COLLATE "pg_catalog"."default",
  "mitraId" varchar(10) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."log"."transId" IS 'Client Trans Id';
COMMENT ON COLUMN "public"."log"."message" IS 'Original request dan response';
COMMENT ON COLUMN "public"."log"."clientId" IS 'Client ID';
COMMENT ON COLUMN "public"."log"."bankId" IS 'Destination Bank';
COMMENT ON COLUMN "public"."log"."created_by" IS 'system';
COMMENT ON COLUMN "public"."log"."created_date" IS 'system';
COMMENT ON COLUMN "public"."log"."created_time" IS 'system';
COMMENT ON COLUMN "public"."log"."messagetype" IS 'RFC = Request From Client, RTB = Request to Bank, RFB = Respons From Bank, FTC = Respons to Client';

-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '12:05:26', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('156', '{"CompanyId":"MITRALINK","Trans_id":"156","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"10000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '12:05:26', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('156', '{"Username":"dabdb3ec329329514a95394e99ff453e42b347f245db80391ff54b89dca474ed","Password":"d4bf8691f8a1b8759e0674519db0a1834a0656346c11f568b07aadd222a4fde2","Tanggal":"20191017","Jam":"120526","SenderName":"PT HARSYA REMITINDO 2","SenderAccount":"7112192257","BeneficiaryAccount":"989000981112","BeneficiaryName":"Amri Amru","Description":"coba inquiry","Amount":"10000000","ReceiverBankCode":"009","Refference":"15651","CurrencyID":"IDR","MSG":"eb84775b063dd390e245fe3ae40a86947b7f0e48d41aed8fcd46c5eff7188650"}', '51', 9, 'sys', '2019-10-17', '12:05:26', 'RTB', '451');
INSERT INTO "public"."log" VALUES ('156', '{"Respon":"000000","Tanggal":"20191017","Jam":"120612","SourceName":"NANDA FERNANDO","DestinationAcc":"989000981112","DestinationName":"MUHAMMAD AZRAQI AL KHAWARIZMI","DestinationIdBank":"009","DestinationBankName":"BNI","TerminalId":"1R3130332E3179","MsgKey":"a3ff7be0","transtype":"01"}', '51', 9, 'sys', '2019-10-17', '12:06:12', 'FTC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '12:06:02', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('156', '{"CompanyId":"MITRALINK","Trans_id":"156","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"1000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '12:06:12', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('156', '{"Username":"74dda3fef8abb90c727bf406f26bf2298650d79e02274ab534fc4764cf9d8cb6","Password":"6fdaf8f39d46685cb3d8e1a9503b7a589cba5c201c08d024d8e9749a4d475c02","Tanggal":"20191017","Jam":"120612","SenderName":"PT HARSYA REMITINDO 2","SenderAccount":"7112192257","BeneficiaryAccount":"989000981112","BeneficiaryName":"Amri Amru","Description":"coba inquiry","Amount":"1000000","ReceiverBankCode":"009","Refference":"15651","CurrencyID":"IDR","MSG":"3111002593b8865e6b5196cbf792f04e112d8f1d2d0e7cc6ea14a00a758a229c","transtype":"02"}', '51', 9, 'sys', '2019-10-17', '12:06:12', 'RTB', '451');
INSERT INTO "public"."log" VALUES ('156', '{"Respon":"000000","Tanggal":"20191017","Jam":"120650","SourceName":"PT HARSYA REMITINDO 2","DestinationAcc":"989000981112","DestinationName":"MUHAMMAD AZRAQI AL KHAWARIZMI","DestinationIdBank":"009","DestinationBankName":"BNI","TerminalId":"1R3130332E3179","MsgKey":"a3ff7be0","transtype":"01"}', '51', 9, 'sys', '2019-10-17', '12:06:50', 'FTC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '13:45:43', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"10000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:45:44', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Username":"6cd306fa3b878f03bfb161e0005e391d314a3edacb8a5206c7046aeef51f755e","Password":"3dcf4f5b2063d18e12919afcd0e2b04b853253576de77b72d19594f782efc5b9","Tanggal":"20191017","Jam":"134544","SenderName":"PT HARSYA REMITINDO 2","SenderAccount":"7112192257","BeneficiaryAccount":"989000981112","BeneficiaryName":"Amri Amru","Description":"coba inquiry","Amount":"10000000","ReceiverBankCode":"009","Refference":"21151","CurrencyID":"IDR","MSG":"22ad386c9bc906944e3e2aa78a13bc3fbe784c2ee2ecf4b974a67a111618cbde"}', '51', 9, 'sys', '2019-10-17', '13:45:44', 'RTB', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Respon":"000000","Tanggal":"20191017","Jam":"134632","SourceName":"NANDA FERNANDO","DestinationAcc":"989000981112","DestinationName":"MUHAMMAD AZRAQI AL KHAWARIZMI","DestinationIdBank":"009","DestinationBankName":"BNI","TerminalId":"1R3130332E3179","MsgKey":"9f0be26f","transtype":"01"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'FTC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '13:46:19', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"1000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '13:49:22', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"1000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '13:59:17', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"1000000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '14:03:03', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"500000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '14:03:24', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"500000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '14:10:29', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"500000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Username":"255e47335bcd1e3d18e31486c635ce5b5f80cac9029cd6fef3081f472458a37e","Password":"80040ef576dab2867a7f00da52b0b041c18fe72c3a7a120d144af4ed7d327f35","Tanggal":"20191017","Jam":"134632","SenderName":"PT HARSYA REMITINDO 2","SenderAccount":"7112192257","BeneficiaryAccount":"989000981112","BeneficiaryName":"Amri Amru","Description":"coba inquiry","Amount":"500000","ReceiverBankCode":"009","Refference":"21151","CurrencyID":"IDR","MSG":"6e2929dd86fce01754b703469698ea7476d4e5e7b9e75fbbbd2ff19db9d98e63","transtype":"02","Balance_Last_Client":"990000","Balance_Last_Company":"1000000","WithdrawBalance_Client":"985000","WithdrawBalance_Company":"995000"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RTB', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Respon":"000013","Tanggal":"20191017","Jam":"141116","SourceName":"OVER LIMIT","DestinationAcc":[],"DestinationName":[],"DestinationIdBank":[],"DestinationBankName":[],"TerminalId":"Invalid amount","MsgKey":[],"transtype":"01"}', '51', 9, 'sys', '2019-10-17', '14:11:16', 'FTC', '451');
INSERT INTO "public"."log" VALUES ('0', '{"request":"MITRALINK"}', 'MITRALINK', 0, 'sys', '2019-10-17', '14:18:55', 'RFC', '0');
INSERT INTO "public"."log" VALUES ('211', '{"CompanyId":"MITRALINK","Trans_id":"211","Credit_account":"989000981112","Credit_name":"Amri Amru","Kode_Bank":"009","Amount":"500000","Deskripsi":"coba inquiry"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RFC', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Username":"255e47335bcd1e3d18e31486c635ce5b5f80cac9029cd6fef3081f472458a37e","Password":"80040ef576dab2867a7f00da52b0b041c18fe72c3a7a120d144af4ed7d327f35","Tanggal":"20191017","Jam":"134632","SenderName":"PT HARSYA REMITINDO 2","SenderAccount":"7112192257","BeneficiaryAccount":"989000981112","BeneficiaryName":"Amri Amru","Description":"coba inquiry","Amount":"500000","ReceiverBankCode":"009","Refference":"21151","CurrencyID":"IDR","MSG":"6e2929dd86fce01754b703469698ea7476d4e5e7b9e75fbbbd2ff19db9d98e63","transtype":"02","Balance_Last_Client":"1000000","Balance_Last_Company":"1000000","WithdrawBalance_Client":"995000","WithdrawBalance_Company":"995000"}', '51', 9, 'sys', '2019-10-17', '13:46:32', 'RTB', '451');
INSERT INTO "public"."log" VALUES ('211', '{"Respon":"000013","Tanggal":"20191017","Jam":"141942","SourceName":"OVER LIMIT","DestinationAcc":[],"DestinationName":[],"DestinationIdBank":[],"DestinationBankName":[],"TerminalId":"Invalid amount","MsgKey":[],"transtype":"01"}', '51', 9, 'sys', '2019-10-17', '14:19:42', 'FTC', '451');

-- ----------------------------
-- Table structure for master_mitra
-- ----------------------------
CREATE TABLE "public"."master_mitra" (
  "mitraId" varchar(3) COLLATE "pg_catalog"."default" NOT NULL DEFAULT nextval('systeminfo_id_seq'::regclass),
  "group" varchar(50) COLLATE "pg_catalog"."default",
  "companyName" varchar(50) COLLATE "pg_catalog"."default",
  "urlDev" varchar(200) COLLATE "pg_catalog"."default",
  "urlLive" varchar(200) COLLATE "pg_catalog"."default",
  "createDate" date,
  "createTime" time(0),
  "activestatus" varchar(1) COLLATE "pg_catalog"."default",
  "username" varchar(30) COLLATE "pg_catalog"."default",
  "password" varchar(255) COLLATE "pg_catalog"."default",
  "salt" varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."master_mitra"."group" IS '01 PPOB, 02 C2A, 03. COURIER';
COMMENT ON COLUMN "public"."master_mitra"."activestatus" IS '1 active, 0 in active';

-- ----------------------------
-- Records of master_mitra
-- ----------------------------
INSERT INTO "public"."master_mitra" VALUES ('451', '02', 'PT Bank Syariah Mandiri', NULL, NULL, NULL, NULL, '1', 'HARSYA123', 'PASSWORD', 'KEY123');

-- ----------------------------
-- Table structure for product
-- ----------------------------
CREATE TABLE "public"."product" (
  "productid" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "productname" varchar(255) COLLATE "pg_catalog"."default",
  "group" varchar(255) COLLATE "pg_catalog"."default",
  "mitraid" varchar(32) COLLATE "pg_catalog"."default",
  "mitrafee" int8,
  "clientfee" int8,
  "createtime" date,
  "updatetime" date,
  "createby" varchar(255) COLLATE "pg_catalog"."default",
  "updateby" date
)
;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO "public"."product" VALUES ('BSM001', 'BSM Cash to Account', '02', '52', 4500, 10000, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for rc
-- ----------------------------
CREATE TABLE "public"."rc" (
  "rc" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "rcname" varchar(255) COLLATE "pg_catalog"."default",
  "createdby" varchar(255) COLLATE "pg_catalog"."default",
  "createtime" date,
  "updatetime" date
)
;

-- ----------------------------
-- Records of rc
-- ----------------------------
INSERT INTO "public"."rc" VALUES ('L1000', 'Success', NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1001', 'Authorization Company is empty', NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1002', 'Authorization Company is not valid or not active', NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1003', NULL, NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1004', NULL, NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1006', NULL, NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1007', NULL, NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1008', NULL, NULL, NULL, NULL);
INSERT INTO "public"."rc" VALUES ('L1005', 'Invalid Access Token', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for ref_bank
-- ----------------------------
CREATE TABLE "public"."ref_bank" (
  "bankid" varchar(32) COLLATE "pg_catalog"."default" NOT NULL DEFAULT nextval('refbank_id_seq'::regclass),
  "bankname" varchar(50) COLLATE "pg_catalog"."default",
  "createby" varchar(255) COLLATE "pg_catalog"."default",
  "createdate" date,
  "createtime" time(0),
  "tarif" float4,
  "bankcode" varchar(100) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ref_bank
-- ----------------------------
INSERT INTO "public"."ref_bank" VALUES ('1', 'BRI', NULL, NULL, NULL, NULL, '002');
INSERT INTO "public"."ref_bank" VALUES ('2', 'Ekspor Indonesia - SKN', NULL, NULL, NULL, NULL, '003');
INSERT INTO "public"."ref_bank" VALUES ('3', 'Mandiri', NULL, NULL, NULL, NULL, '008');
INSERT INTO "public"."ref_bank" VALUES ('4', 'BNI', NULL, NULL, NULL, NULL, '009');
INSERT INTO "public"."ref_bank" VALUES ('5', 'Danamon', NULL, NULL, NULL, NULL, '011');
INSERT INTO "public"."ref_bank" VALUES ('6', 'Danamon Syariah', NULL, NULL, NULL, NULL, '011');
INSERT INTO "public"."ref_bank" VALUES ('7', 'Permata', NULL, NULL, NULL, NULL, '013');
INSERT INTO "public"."ref_bank" VALUES ('8', 'Permata Syariah', NULL, NULL, NULL, NULL, '013');
INSERT INTO "public"."ref_bank" VALUES ('9', 'BCA', NULL, NULL, NULL, NULL, '014');
INSERT INTO "public"."ref_bank" VALUES ('10', 'Maybank Indonesia', NULL, NULL, NULL, NULL, '016');
INSERT INTO "public"."ref_bank" VALUES ('11', 'Maybank Syariah', NULL, NULL, NULL, NULL, '016');
INSERT INTO "public"."ref_bank" VALUES ('12', 'Panin', NULL, NULL, NULL, NULL, '019');
INSERT INTO "public"."ref_bank" VALUES ('14', 'CIMB Niaga Syariah', NULL, NULL, NULL, NULL, '022');
INSERT INTO "public"."ref_bank" VALUES ('13', 'CIMB Niaga', NULL, NULL, NULL, NULL, '022');
INSERT INTO "public"."ref_bank" VALUES ('15', 'Bank UOB Indonesia', NULL, NULL, NULL, NULL, '023');
INSERT INTO "public"."ref_bank" VALUES ('16', 'OCBC NISP', NULL, NULL, NULL, NULL, '028');
INSERT INTO "public"."ref_bank" VALUES ('17', 'American Express - SKN', NULL, NULL, NULL, NULL, '030');
INSERT INTO "public"."ref_bank" VALUES ('18', 'Citibank', NULL, NULL, NULL, NULL, '031');
INSERT INTO "public"."ref_bank" VALUES ('19', 'JP Morgan Chase - SKN', NULL, NULL, NULL, NULL, '032');
INSERT INTO "public"."ref_bank" VALUES ('20', 'Bank Of America - SKN', NULL, NULL, NULL, NULL, '033');
INSERT INTO "public"."ref_bank" VALUES ('21', 'Windu Kentjana - SKN', NULL, NULL, NULL, NULL, '036');
INSERT INTO "public"."ref_bank" VALUES ('22', 'Artha Graha - SKN', NULL, NULL, NULL, NULL, '037');
INSERT INTO "public"."ref_bank" VALUES ('23', 'Bangkok Bank PCL - SKN', NULL, NULL, NULL, NULL, '040');
INSERT INTO "public"."ref_bank" VALUES ('24', 'Hongkong & Shanghai (HSBC)', NULL, NULL, NULL, NULL, '041');
INSERT INTO "public"."ref_bank" VALUES ('25', 'Bank Of Tokyo Mitsubishi', NULL, NULL, NULL, NULL, '042');
INSERT INTO "public"."ref_bank" VALUES ('26', 'Sumitomo Mitsui Indonesia - SKN', NULL, NULL, NULL, NULL, '045');
INSERT INTO "public"."ref_bank" VALUES ('27', 'DBS Indonesia', NULL, NULL, NULL, NULL, '046');
INSERT INTO "public"."ref_bank" VALUES ('28', 'Resona Perdania - SKN', NULL, NULL, NULL, NULL, '047');
INSERT INTO "public"."ref_bank" VALUES ('29', 'Mizuho Indonesia - SKN', NULL, NULL, NULL, NULL, '048');
INSERT INTO "public"."ref_bank" VALUES ('30', 'UFJ Indonesia - SKN', NULL, NULL, NULL, NULL, '049');
INSERT INTO "public"."ref_bank" VALUES ('31', 'Standard Chartered', NULL, NULL, NULL, NULL, '050');
INSERT INTO "public"."ref_bank" VALUES ('32', 'Royal Bank Of Scotland', NULL, NULL, NULL, NULL, '052');
INSERT INTO "public"."ref_bank" VALUES ('33', 'Capital Indonesia', NULL, NULL, NULL, NULL, '054');
INSERT INTO "public"."ref_bank" VALUES ('34', 'BNP Paribas Indonesia - SKN', NULL, NULL, NULL, NULL, '057');
INSERT INTO "public"."ref_bank" VALUES ('35', 'UOB Indonesia - SKN', NULL, NULL, NULL, NULL, '058');
INSERT INTO "public"."ref_bank" VALUES ('36', 'Korea Exchange - SKN', NULL, NULL, NULL, NULL, '059');
INSERT INTO "public"."ref_bank" VALUES ('37', 'Rabobank Indonesia - SKN', NULL, NULL, NULL, NULL, '060');
INSERT INTO "public"."ref_bank" VALUES ('38', 'ANZ Panin', NULL, NULL, NULL, NULL, '061');
INSERT INTO "public"."ref_bank" VALUES ('39', 'Deutsche Bank - SKN', NULL, NULL, NULL, NULL, '067');
INSERT INTO "public"."ref_bank" VALUES ('40', 'Woori Indonesia - SKN', NULL, NULL, NULL, NULL, '068');
INSERT INTO "public"."ref_bank" VALUES ('41', 'Bank Of China', NULL, NULL, NULL, NULL, '069');
INSERT INTO "public"."ref_bank" VALUES ('42', 'Bumi Arta', NULL, NULL, NULL, NULL, '076');
INSERT INTO "public"."ref_bank" VALUES ('43', 'Ekonomi Raharja', NULL, NULL, NULL, NULL, '087');
INSERT INTO "public"."ref_bank" VALUES ('44', 'Bank Antar Daerah - SKN', NULL, NULL, NULL, NULL, '088');
INSERT INTO "public"."ref_bank" VALUES ('45', 'Rabobank', NULL, NULL, NULL, NULL, '089');
INSERT INTO "public"."ref_bank" VALUES ('47', 'IFI Syariah', NULL, NULL, NULL, NULL, '093');
INSERT INTO "public"."ref_bank" VALUES ('46', 'IFI', NULL, NULL, NULL, NULL, '093');
INSERT INTO "public"."ref_bank" VALUES ('48', 'Bank Mutiara', NULL, NULL, NULL, NULL, '095');
INSERT INTO "public"."ref_bank" VALUES ('49', 'Mayapada', NULL, NULL, NULL, NULL, '097');
INSERT INTO "public"."ref_bank" VALUES ('50', 'BPD Jabar', NULL, NULL, NULL, NULL, '110');
INSERT INTO "public"."ref_bank" VALUES ('51', 'Bank DKI', NULL, NULL, NULL, NULL, '111');
INSERT INTO "public"."ref_bank" VALUES ('52', 'Bank DKI Syariah', NULL, NULL, NULL, NULL, '111');
INSERT INTO "public"."ref_bank" VALUES ('53', 'BPD DIY', NULL, NULL, NULL, NULL, '112');
INSERT INTO "public"."ref_bank" VALUES ('54', 'BPD Jateng', NULL, NULL, NULL, NULL, '113');
INSERT INTO "public"."ref_bank" VALUES ('55', 'BPD Jatim', NULL, NULL, NULL, NULL, '114');
INSERT INTO "public"."ref_bank" VALUES ('56', 'BPD Jambi', NULL, NULL, NULL, NULL, '115');
INSERT INTO "public"."ref_bank" VALUES ('57', 'BPD Aceh', NULL, NULL, NULL, NULL, '116');
INSERT INTO "public"."ref_bank" VALUES ('58', 'BPD Sumut', NULL, NULL, NULL, NULL, '117');
INSERT INTO "public"."ref_bank" VALUES ('59', 'BPD Sumut Syariah', NULL, NULL, NULL, NULL, '117');
INSERT INTO "public"."ref_bank" VALUES ('60', 'BPD Sumatera Barat', NULL, NULL, NULL, NULL, '118');
INSERT INTO "public"."ref_bank" VALUES ('61', 'BPD Riau', NULL, NULL, NULL, NULL, '119');
INSERT INTO "public"."ref_bank" VALUES ('62', 'BPD Sumsel', NULL, NULL, NULL, NULL, '120');
INSERT INTO "public"."ref_bank" VALUES ('63', 'BPD Lampung', NULL, NULL, NULL, NULL, '121');
INSERT INTO "public"."ref_bank" VALUES ('65', 'BPD Kalsel Syariah', NULL, NULL, NULL, NULL, '122');
INSERT INTO "public"."ref_bank" VALUES ('64', 'BPD Kalsel', NULL, NULL, NULL, NULL, '122');
INSERT INTO "public"."ref_bank" VALUES ('66', 'BPD Kalbar', NULL, NULL, NULL, NULL, '123');
INSERT INTO "public"."ref_bank" VALUES ('67', 'BPD Kalbar Syariah', NULL, NULL, NULL, NULL, '123');
INSERT INTO "public"."ref_bank" VALUES ('68', 'BPD Kaltim', NULL, NULL, NULL, NULL, '124');
INSERT INTO "public"."ref_bank" VALUES ('69', 'BPD Kalteng', NULL, NULL, NULL, NULL, '125');
INSERT INTO "public"."ref_bank" VALUES ('70', 'BPD Sulsel', NULL, NULL, NULL, NULL, '126');
INSERT INTO "public"."ref_bank" VALUES ('71', 'BPD Sulut', NULL, NULL, NULL, NULL, '127');
INSERT INTO "public"."ref_bank" VALUES ('72', 'BPD NTB', NULL, NULL, NULL, NULL, '128');
INSERT INTO "public"."ref_bank" VALUES ('73', 'BPD Bali', NULL, NULL, NULL, NULL, '129');
INSERT INTO "public"."ref_bank" VALUES ('74', 'BPD NTT', NULL, NULL, NULL, NULL, '130');
INSERT INTO "public"."ref_bank" VALUES ('75', 'BPD Maluku', NULL, NULL, NULL, NULL, '131');
INSERT INTO "public"."ref_bank" VALUES ('76', 'BPD Papua', NULL, NULL, NULL, NULL, '132');
INSERT INTO "public"."ref_bank" VALUES ('77', 'BPD Bengkulu', NULL, NULL, NULL, NULL, '133');
INSERT INTO "public"."ref_bank" VALUES ('78', 'BPD Sulteng', NULL, NULL, NULL, NULL, '134');
INSERT INTO "public"."ref_bank" VALUES ('79', 'BPD Sultra', NULL, NULL, NULL, NULL, '135');
INSERT INTO "public"."ref_bank" VALUES ('80', 'Nusantara Parahyangan', NULL, NULL, NULL, NULL, '145');
INSERT INTO "public"."ref_bank" VALUES ('81', 'Swadesi', NULL, NULL, NULL, NULL, '146');
INSERT INTO "public"."ref_bank" VALUES ('82', 'Muamalat', NULL, NULL, NULL, NULL, '147');
INSERT INTO "public"."ref_bank" VALUES ('83', 'Mestika Dharma', NULL, NULL, NULL, NULL, '151');
INSERT INTO "public"."ref_bank" VALUES ('84', 'Metro Ekspress - SKN', NULL, NULL, NULL, NULL, '152');
INSERT INTO "public"."ref_bank" VALUES ('85', 'Sinarmas', NULL, NULL, NULL, NULL, '153');
INSERT INTO "public"."ref_bank" VALUES ('86', 'Maspion', NULL, NULL, NULL, NULL, '157');
INSERT INTO "public"."ref_bank" VALUES ('87', 'Hagakita', NULL, NULL, NULL, NULL, '159');
INSERT INTO "public"."ref_bank" VALUES ('88', 'Ganesha', NULL, NULL, NULL, NULL, '161');
INSERT INTO "public"."ref_bank" VALUES ('89', 'Windu Kentjana - SKN', NULL, NULL, NULL, NULL, '162');
INSERT INTO "public"."ref_bank" VALUES ('90', 'ICBC Indonesia - SKN', NULL, NULL, NULL, NULL, '164');
INSERT INTO "public"."ref_bank" VALUES ('91', 'Harmoni - SKN', NULL, NULL, NULL, NULL, '166');
INSERT INTO "public"."ref_bank" VALUES ('92', 'Kesawan', NULL, NULL, NULL, NULL, '167');
INSERT INTO "public"."ref_bank" VALUES ('94', 'BTN Syariah', NULL, NULL, NULL, NULL, '200');
INSERT INTO "public"."ref_bank" VALUES ('93', 'BTN', NULL, NULL, NULL, NULL, '200');
INSERT INTO "public"."ref_bank" VALUES ('95', 'HS 1906', NULL, NULL, NULL, NULL, '212');
INSERT INTO "public"."ref_bank" VALUES ('96', 'BTPN', NULL, NULL, NULL, NULL, '213');
INSERT INTO "public"."ref_bank" VALUES ('97', 'Victoria Syariah - SKN', NULL, NULL, NULL, NULL, '405');
INSERT INTO "public"."ref_bank" VALUES ('98', 'BRI Syariah', NULL, NULL, NULL, NULL, '422');
INSERT INTO "public"."ref_bank" VALUES ('99', 'BPD Jabar Syariah', NULL, NULL, NULL, NULL, '425');
INSERT INTO "public"."ref_bank" VALUES ('100', 'Mega', NULL, NULL, NULL, NULL, '426');
INSERT INTO "public"."ref_bank" VALUES ('101', 'BNI Syariah', NULL, NULL, NULL, NULL, '427');
INSERT INTO "public"."ref_bank" VALUES ('102', 'Bukopin', NULL, NULL, NULL, NULL, '441');
INSERT INTO "public"."ref_bank" VALUES ('103', 'BSM - Bank Syariah Mandiri', NULL, NULL, NULL, NULL, '451');
INSERT INTO "public"."ref_bank" VALUES ('104', 'Bank Bisnis International - SKN', NULL, NULL, NULL, NULL, '459');
INSERT INTO "public"."ref_bank" VALUES ('105', 'Andara - SKN', NULL, NULL, NULL, NULL, '466');
INSERT INTO "public"."ref_bank" VALUES ('106', 'Jasa Jakarta', NULL, NULL, NULL, NULL, '472');
INSERT INTO "public"."ref_bank" VALUES ('107', 'Bank Hana - SKN', NULL, NULL, NULL, NULL, '484');
INSERT INTO "public"."ref_bank" VALUES ('108', 'Bumiputera', NULL, NULL, NULL, NULL, '485');
INSERT INTO "public"."ref_bank" VALUES ('109', 'Yudha Bhakti - SKN', NULL, NULL, NULL, NULL, '490');
INSERT INTO "public"."ref_bank" VALUES ('110', 'Mitraniaga - SKN', NULL, NULL, NULL, NULL, '491');
INSERT INTO "public"."ref_bank" VALUES ('111', 'Agroniaga', NULL, NULL, NULL, NULL, '494');
INSERT INTO "public"."ref_bank" VALUES ('112', 'Bank SBI Indonesia', NULL, NULL, NULL, NULL, '498');
INSERT INTO "public"."ref_bank" VALUES ('113', 'Royal Indonesia', NULL, NULL, NULL, NULL, '501');
INSERT INTO "public"."ref_bank" VALUES ('114', 'Bank Nationalnobu', NULL, NULL, NULL, NULL, '503');
INSERT INTO "public"."ref_bank" VALUES ('115', 'Syariah Mega', NULL, NULL, NULL, NULL, '506');
INSERT INTO "public"."ref_bank" VALUES ('116', 'Ina Perdana', NULL, NULL, NULL, NULL, '513');
INSERT INTO "public"."ref_bank" VALUES ('117', 'Panin Syariah - SKN', NULL, NULL, NULL, NULL, '517');
INSERT INTO "public"."ref_bank" VALUES ('118', 'Prima Master - SKN', NULL, NULL, NULL, NULL, '520');
INSERT INTO "public"."ref_bank" VALUES ('119', 'Bukopin Syariah', NULL, NULL, NULL, NULL, '521');
INSERT INTO "public"."ref_bank" VALUES ('120', 'Dipo International - SKN', NULL, NULL, NULL, NULL, '523');
INSERT INTO "public"."ref_bank" VALUES ('121', 'Barclays', NULL, NULL, NULL, NULL, '525');
INSERT INTO "public"."ref_bank" VALUES ('122', 'Liman - SKN', NULL, NULL, NULL, NULL, '526');
INSERT INTO "public"."ref_bank" VALUES ('123', 'Anglomas - SKN', NULL, NULL, NULL, NULL, '531');
INSERT INTO "public"."ref_bank" VALUES ('124', 'Kesejahteraan Ekonomi', NULL, NULL, NULL, NULL, '535');
INSERT INTO "public"."ref_bank" VALUES ('125', 'BCA Syariah', NULL, NULL, NULL, NULL, '536');
INSERT INTO "public"."ref_bank" VALUES ('126', 'Artos', NULL, NULL, NULL, NULL, '542');
INSERT INTO "public"."ref_bank" VALUES ('127', 'Purba Danarta - SKN', NULL, NULL, NULL, NULL, '547');
INSERT INTO "public"."ref_bank" VALUES ('128', 'Multiarta Sentosa - SKN', NULL, NULL, NULL, NULL, '548');
INSERT INTO "public"."ref_bank" VALUES ('129', 'Mayora', NULL, NULL, NULL, NULL, '553');
INSERT INTO "public"."ref_bank" VALUES ('130', 'Index Selindo', NULL, NULL, NULL, NULL, '555');
INSERT INTO "public"."ref_bank" VALUES ('131', 'Bank Pundi', NULL, NULL, NULL, NULL, '558');
INSERT INTO "public"."ref_bank" VALUES ('132', 'Centratama Nasional - SKN', NULL, NULL, NULL, NULL, '559');
INSERT INTO "public"."ref_bank" VALUES ('133', 'Fama International - SKN', NULL, NULL, NULL, NULL, '562');
INSERT INTO "public"."ref_bank" VALUES ('134', 'Sinar Harapan Bali - SKN', NULL, NULL, NULL, NULL, '564');
INSERT INTO "public"."ref_bank" VALUES ('135', 'Victoria', NULL, NULL, NULL, NULL, '566');
INSERT INTO "public"."ref_bank" VALUES ('136', 'Harda Internasional - SKN', NULL, NULL, NULL, NULL, '567');
INSERT INTO "public"."ref_bank" VALUES ('137', 'Agris Bank - SKN', NULL, NULL, NULL, NULL, '945');
INSERT INTO "public"."ref_bank" VALUES ('138', 'Maybank Syariah Indonesia - SKN', NULL, NULL, NULL, NULL, '947');
INSERT INTO "public"."ref_bank" VALUES ('139', 'OCBC Indonesia - SKN', NULL, NULL, NULL, NULL, '948');
INSERT INTO "public"."ref_bank" VALUES ('140', 'Chinatrust Indonesia - SKN', NULL, NULL, NULL, NULL, '949');
INSERT INTO "public"."ref_bank" VALUES ('141', 'Commonwealth', NULL, NULL, NULL, NULL, '950');
INSERT INTO "public"."ref_bank" VALUES ('142', 'PT. POS INDONESIA', NULL, NULL, NULL, NULL, 'POS');

-- ----------------------------
-- Table structure for systemId
-- ----------------------------
CREATE TABLE "public"."systemId" (
  "clientId" varchar(2) COLLATE "pg_catalog"."default" NOT NULL,
  "systemName" varchar(50) COLLATE "pg_catalog"."default",
  "companyName" varchar(50) COLLATE "pg_catalog"."default",
  "IPDev" varchar(200) COLLATE "pg_catalog"."default",
  "IPProduction" varchar(200) COLLATE "pg_catalog"."default",
  "createDate" date,
  "createTime" time(0),
  "activestatus" varchar(1) COLLATE "pg_catalog"."default",
  "username" varchar(30) COLLATE "pg_catalog"."default",
  "password" varchar(255) COLLATE "pg_catalog"."default",
  "salt" varchar(255) COLLATE "pg_catalog"."default",
  "cekbalance" varchar(1) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."systemId"."activestatus" IS '1 active, 0 in active';
COMMENT ON COLUMN "public"."systemId"."cekbalance" IS '1 cek balance, 0 uncek balance';

-- ----------------------------
-- Records of systemId
-- ----------------------------
INSERT INTO "public"."systemId" VALUES ('01', 'IKIPAY', 'PT. Emporia Digital Raya', NULL, NULL, NULL, NULL, NULL, 'edr2019', NULL, NULL, NULL);
INSERT INTO "public"."systemId" VALUES ('02', 'IKIPPOB', 'PT. MAI', NULL, NULL, NULL, NULL, NULL, 'mai2019', NULL, NULL, NULL);
INSERT INTO "public"."systemId" VALUES ('03', 'IKIREMITT', 'PT. Harsya Remittindo', NULL, NULL, NULL, NULL, NULL, 'remmit2019', NULL, NULL, NULL);
INSERT INTO "public"."systemId" VALUES ('51', 'MITRALINK', 'MITRALINK', NULL, NULL, '2019-10-15', '15:25:13', '1', 'mitralink2019', '71050a2d7ac2b757184c244fc9664526', '5da582690a3b1r3dY', NULL);

-- ----------------------------
-- Table structure for transaction
-- ----------------------------
CREATE TABLE "public"."transaction" (
  "id" int8 NOT NULL DEFAULT nextval('transaction_id_seq'::regclass),
  "transid" int8,
  "clientid" varchar(32) COLLATE "pg_catalog"."default",
  "bankid" varchar(3) COLLATE "pg_catalog"."default",
  "fromsaving" varchar(20) COLLATE "pg_catalog"."default",
  "destsaving" varchar(50) COLLATE "pg_catalog"."default",
  "amount" numeric(100),
  "fee" numeric(100),
  "total_amount" numeric(100),
  "created_by" varchar(255) COLLATE "pg_catalog"."default",
  "created_date" varchar(200) COLLATE "pg_catalog"."default",
  "currentbalance" numeric(100),
  "mitraid" varchar(100) COLLATE "pg_catalog"."default",
  "transtype" varchar(5) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."transaction"."transtype" IS '01 = Inquiry, 02 = Process, 03 = success, 99= failed';

-- ----------------------------
-- Records of transaction
-- ----------------------------
INSERT INTO "public"."transaction" VALUES (5, 156, '51', '009', '7112192257', '989000981112', 100000, 0, 100000, 'sys', '2019-10-1712:06:12', 1000000, '451', '03');
INSERT INTO "public"."transaction" VALUES (6, 211, '51', '009', '7112192257', '989000981112', 100000, 0, 100000, 'sys', '2019-10-1713:46:32', 1000000, '451', '03');

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
SELECT setval('"public"."refbank_id_seq"', 143, true);
SELECT setval('"public"."systeminfo_id_seq"', 5, true);
SELECT setval('"public"."transaction_id_seq"', 7, true);

-- ----------------------------
-- Primary Key structure for table group
-- ----------------------------
ALTER TABLE "public"."group" ADD CONSTRAINT "group_pkey" PRIMARY KEY ("groupid");

-- ----------------------------
-- Primary Key structure for table master_mitra
-- ----------------------------
ALTER TABLE "public"."master_mitra" ADD CONSTRAINT "systemId_copy1_pkey" PRIMARY KEY ("mitraId");

-- ----------------------------
-- Primary Key structure for table product
-- ----------------------------
ALTER TABLE "public"."product" ADD CONSTRAINT "product_pkey" PRIMARY KEY ("productid");

-- ----------------------------
-- Primary Key structure for table ref_bank
-- ----------------------------
ALTER TABLE "public"."ref_bank" ADD CONSTRAINT "ref_bank_pkey" PRIMARY KEY ("bankid");

-- ----------------------------
-- Primary Key structure for table systemId
-- ----------------------------
ALTER TABLE "public"."systemId" ADD CONSTRAINT "systemId\_pkey" PRIMARY KEY ("clientId");

-- ----------------------------
-- Primary Key structure for table transaction
-- ----------------------------
ALTER TABLE "public"."transaction" ADD CONSTRAINT "va_map_pkey" PRIMARY KEY ("id");
