/*
 Navicat Premium Data Transfer

 Source Server         : mampp
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : db_fo

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

 Date: 19/11/2022 00:09:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for master_penerimaans
-- ----------------------------
DROP TABLE IF EXISTS `master_penerimaans`;
CREATE TABLE `master_penerimaans` (
  `id_penerimaan` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pemasukan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penjelasan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_penerimaan`),
  UNIQUE KEY `master_penerimaans_kode_unique` (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_penerimaans
-- ----------------------------
BEGIN;
INSERT INTO `master_penerimaans` VALUES ('18957c6a-52d9-4e73-a48c-1a6400353301', 'A', 'Transfer Yayasan/Rektorat', 'Semua penerimaan yang bersumber dari Yayasan/Rektorat', '2022-10-30 12:51:42', '2022-10-30 12:51:42');
INSERT INTO `master_penerimaans` VALUES ('cd9012d2-3a16-4055-b027-9082b583fd49', 'B', 'Bantuan/Subsidi/Donatur', 'Semua penerimaan yang bersumber dari bantuan pemerintah/pihak ke 3', '2022-10-30 12:52:30', '2022-10-30 12:52:30');
COMMIT;

-- ----------------------------
-- Table structure for master_pengeluarans
-- ----------------------------
DROP TABLE IF EXISTS `master_pengeluarans`;
CREATE TABLE `master_pengeluarans` (
  `id_pengeluaran` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_pengeluaran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penjelasan` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_pengeluaran`),
  UNIQUE KEY `master_pengeluarans_kode_unique` (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_pengeluarans
-- ----------------------------
BEGIN;
INSERT INTO `master_pengeluarans` VALUES ('70d1eae3-6e35-4dca-98a0-27ac97d95834', '04', 'Transport', 'Transport (DTY, Pimpinan Struktural, Staff, DPK, dan DLB) sesuai perhitungan riil atas beban yang harus dibayarkan YPSA sesuai dengan standar harga YPSA', '2022-10-31 15:33:16', '2022-10-31 15:33:16');
INSERT INTO `master_pengeluarans` VALUES ('a8485ab8-140d-4d0b-bc39-e7f251261687', '01', 'Honor Pimpinan dan Staf', 'Honor Pimpinan dan Staf sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:28:17', '2022-10-31 15:28:17');
INSERT INTO `master_pengeluarans` VALUES ('b82154eb-8dae-4d2b-8d57-bfe033bb8bc3', '03', 'Honor DLB', 'Honor DLB sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:30:11', '2022-10-31 15:30:11');
INSERT INTO `master_pengeluarans` VALUES ('c365a5a7-2cc8-43dd-891c-7a62bd7d8647', '02', 'Honor DTY', 'Honor DTY sesuai perhitungan riil atas beban yang harus dibayarkan yang sesuai dengan standar harga YPSA', '2022-10-31 15:29:18', '2022-10-31 15:29:18');
COMMIT;

-- ----------------------------
-- Table structure for master_units
-- ----------------------------
DROP TABLE IF EXISTS `master_units`;
CREATE TABLE `master_units` (
  `id_unit` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_unit` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat_unit` text COLLATE utf8mb4_unicode_ci,
  `jabatan_tanda_wadek` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_tanda_wadek` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan_tanda_kepala` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_tanda_kepala` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kop_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no_kop.png',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_unit`),
  UNIQUE KEY `master_units_kode_unit_unique` (`kode_unit`),
  UNIQUE KEY `master_units_nama_unit_unique` (`nama_unit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of master_units
-- ----------------------------
BEGIN;
INSERT INTO `master_units` VALUES ('0b706e2b-2348-4fad-8eef-c87061904ae3', '11', 'asasa', 'asasa', 'asasa', 'asas', 'asas', 'asas', '6374ef50edea8_sun_ight.jpg', '2022-11-16 15:31:20', '2022-11-16 21:10:28');
INSERT INTO `master_units` VALUES ('953631a7-9b7c-4de1-b2dc-ca42a92c315d', '01', 'Yayasan Pendidikan Sebelas April', 'Jl. Angkrek Situ No. 19', 'a', 'b', 'c', 'd', 'no_gambar.png', '2022-10-22 06:24:34', '2022-10-22 06:24:34');
INSERT INTO `master_units` VALUES ('9c192e30-c36f-4f08-bc7a-4f3b6633e2f8', '03', 'Fakultas Ekonomi dan Bisnis', 'Jl. Angkrek Situ No. 19 Sumedang', 'Wakil Dekan II', 'Asep Saeppani, M.Kom.', 'Kepala Bagian Umum', 'Sara Saraswati, S.Sos.', 'no_gambar.png', '2022-10-22 06:25:27', '2022-10-22 06:25:27');
INSERT INTO `master_units` VALUES ('df122919-1634-4814-a094-60180110908f', '02', 'Fakultas Keguruan dan Ilmu Pendidikan', 'Jl. Angkrek Situ No. 19', 'a', 'b', 'c', 'd', 'no_gambar.png', '2022-10-22 06:24:58', '2022-10-22 06:24:58');
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (71, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (72, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (73, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1);
INSERT INTO `migrations` VALUES (74, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (75, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (76, '2022_10_19_002625_create_master_penerimaans_table', 1);
INSERT INTO `migrations` VALUES (77, '2022_10_19_002659_create_master_pengeluarans_table', 1);
INSERT INTO `migrations` VALUES (78, '2022_10_19_040435_create_master_units_table', 1);
INSERT INTO `migrations` VALUES (79, '2022_10_19_041020_create_transaksi_penerimaans_table', 1);
INSERT INTO `migrations` VALUES (80, '2022_10_19_042300_create_transaksi_pengeluarans_table', 1);
COMMIT;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of password_resets
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for personal_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for transaksi_penerimaans
-- ----------------------------
DROP TABLE IF EXISTS `transaksi_penerimaans`;
CREATE TABLE `transaksi_penerimaans` (
  `id_transaksi_penerimaan` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_penerimaan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_transaksi_masuk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_penerimaan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_penerimaan` int(11) NOT NULL,
  `kode_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `validasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eviden` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_transaksi_penerimaan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of transaksi_penerimaans
-- ----------------------------
BEGIN;
INSERT INTO `transaksi_penerimaans` VALUES ('9387b2bc-a214-46ae-94bf-4e4e1a41512c', 'A', '111', 'lima juta', 5000000, '1', '0', 'no_image.png', '0', '2022-10-30 21:57:19', '2022-10-30 21:57:19');
INSERT INTO `transaksi_penerimaans` VALUES ('9b7417cd-0ed7-4446-a5f6-c08fdfac7bc7', 'A', '111', 'seratus lima puluh juta', 150000000, '1', '0', 'no_image.png', '0', '2022-10-30 22:06:47', '2022-10-30 22:06:47');
INSERT INTO `transaksi_penerimaans` VALUES ('c830cb30-1d3a-4b30-b8ea-9cf0846cc34b', 'B', '111', 'test', 5000000, '1', '0', 'no_image.png', '0', '2022-11-12 13:19:58', '2022-11-12 13:19:58');
INSERT INTO `transaksi_penerimaans` VALUES ('cc23f54e-147c-4d53-bc70-b1f738630f7a', 'A', '111', 'rettr', 2000000, '1', '0', 'no_image.png', '0', '2022-10-30 14:28:42', '2022-10-30 14:28:42');
COMMIT;

-- ----------------------------
-- Table structure for transaksi_pengeluarans
-- ----------------------------
DROP TABLE IF EXISTS `transaksi_pengeluarans`;
CREATE TABLE `transaksi_pengeluarans` (
  `id_transaksi_pengeluaran` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_pengeluaran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_transaksi_keluar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi_pengeluaran` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_pengeluaran` int(11) NOT NULL,
  `kode_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `validasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eviden` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_transaksi_pengeluaran`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of transaksi_pengeluarans
-- ----------------------------
BEGIN;
INSERT INTO `transaksi_pengeluarans` VALUES ('781f046a-80ef-4a77-9a65-facd5c0ec54b', '03', '111', 'Dua Puluh Juta Rupiah', 20000000, '1', '0', 'no_image.png', '0', '2022-10-31 15:39:25', '2022-10-31 15:39:25');
INSERT INTO `transaksi_pengeluarans` VALUES ('ef7a6168-718c-4924-b284-81e07fbdbdc2', '02', '111', 'Admin', 100000000, '1', '0', 'no_image.png', '0', '2022-10-31 16:05:13', '2022-10-31 16:05:13');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `two_factor_secret` text COLLATE utf8mb4_unicode_ci,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
  `two_factor_confirmed_at` timestamp NULL DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_unit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (3, 'Irfan Fadil', 'fadilirfan@unsap.ac.id', NULL, '$2y$10$fR85CRbIApSRNC9UvY6wxOJvO6rZoPfmYuHKLDpf4E5Qxx7PsyLMG', NULL, NULL, NULL, 'pengguna', 'df122919-1634-4814-a094-60180110908f', 'zhyt2uKa3TdPHON3YbP6eqoJ4zlqlq6GCNw9VQyfD44KLouGiDuKrKZpJ59P', '2022-11-12 20:29:28', '2022-11-15 11:44:38');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;