/*
 Navicat Premium Data Transfer

 Source Server         : maria db
 Source Server Type    : MySQL
 Source Server Version : 101002
 Source Host           : localhost:3306
 Source Schema         : pmb_unsap

 Target Server Type    : MySQL
 Target Server Version : 101002
 File Encoding         : 65001

 Date: 19/02/2023 23:42:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for konfirmasi_pembayarans
-- ----------------------------
DROP TABLE IF EXISTS `konfirmasi_pembayarans`;
CREATE TABLE `konfirmasi_pembayarans` (
  `transaksi_id` char(36) NOT NULL,
  `id_channel` tinyint(4) DEFAULT NULL,
  `total_bayar` decimal(15,2) NOT NULL DEFAULT 0.00,
  `nomor_rekening_pengirim` varchar(255) DEFAULT NULL,
  `nama_rekening_pengirim` varchar(255) DEFAULT NULL,
  `nama_bank_pengirim` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `tanggal_bayar` date DEFAULT NULL,
  `bukti_bayar` varchar(255) NOT NULL DEFAULT 'storage/images/users/no_photo.png',
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`transaksi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;