-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 09, 2024 at 08:21 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.1.17

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mnjnadminsklh`
--

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

--
-- Table structure for table `anggotarombel`
--

CREATE TABLE `anggotarombel` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `anggotarombel`
--

INSERT INTO `anggotarombel` (`id`, `pesdik_id`, `rombel_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2022-09-13 02:10:22', '2022-09-13 02:10:22'),
(2, 2, 1, '2022-09-14 14:42:02', '2022-09-14 14:42:02'),
(3, 4, 1, '2023-02-03 11:50:52', '2023-02-03 11:50:52'),
(4, 3, 2, '2024-02-09 03:19:04', '2024-02-09 03:19:04');

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

--
-- Table structure for table `disposisis`
--

CREATE TABLE `disposisis` (
  `id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `suratmasuk_id` int(10) UNSIGNED NOT NULL,
  `tujuan` varchar(30) NOT NULL,
  `isi` varchar(30) NOT NULL,
  `sifat` varchar(25) NOT NULL,
  `batas_waktu` date NOT NULL,
  `catatan` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `guru`
--

CREATE TABLE `guru` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `no_hp` varchar(13) NOT NULL,
  `email` varchar(35) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `guru`
--

INSERT INTO `guru` (`id`, `nama`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `alamat`, `no_hp`, `email`, `created_at`, `updated_at`) VALUES
(1, 'SARINEM', 'Perempuan', 'Kab. Jago', '1988-09-13', 'Gang 7 asdsda', '0811111111111', 'sarinem@localhost', '2022-09-13 02:07:38', '2022-09-13 02:07:38');

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

--
-- Table structure for table `instansis`
--

CREATE TABLE `instansis` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `pimpinan` varchar(20) NOT NULL,
  `email` varchar(35) NOT NULL,
  `file` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `instansis`
--

INSERT INTO `instansis` (`id`, `nama`, `alamat`, `pimpinan`, `email`, `file`, `created_at`, `updated_at`) VALUES
(1, 'SMA 1 JAGO SOFTWARE', 'JAGO SOFTWARE JL. SHOPEE CO ID', 'dr. Jago Software, M', 'jagosoftware@shopee.co.id', 'uploads/logo/1654616430Photo_1653768845071.png', '2022-06-07 15:29:24', '2022-06-07 15:40:30');

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

--
-- Table structure for table `kategori`
--

CREATE TABLE `kategori` (
  `id` int(10) UNSIGNED NOT NULL,
  `jenis_kategori` int(11) NOT NULL,
  `nama_kategori` varchar(25) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kategori`
--

INSERT INTO `kategori` (`id`, `jenis_kategori`, `nama_kategori`, `created_at`, `updated_at`) VALUES
(1, 1, 'Pembayaran Siswa', '2022-06-07 15:29:24', '2022-06-07 15:29:24'),
(2, 1, 'PEMBAYARAN SPP', '2022-09-14 14:37:51', '2022-09-14 14:37:51');

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

--
-- Table structure for table `klasifikasi`
--

CREATE TABLE `klasifikasi` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(20) NOT NULL,
  `kode` varchar(2) NOT NULL,
  `uraian` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `klasifikasi`
--

INSERT INTO `klasifikasi` (`id`, `nama`, `kode`, `uraian`, `created_at`, `updated_at`) VALUES
(1, 'JAGOSOFTWARE', '01', 'JAGO SOFTWARE', '2022-06-07 15:35:11', '2022-06-07 15:35:11');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(35) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `name`, `email`, `created_at`, `updated_at`) VALUES
(0, 'Administrator', 'jagosoftware@shopee.co.id', '2023-02-03 11:48:13', '2023-02-03 11:48:13'),
(1, 'Administrator', 'admin123@gmail.com', '2022-06-07 15:33:40', '2022-06-07 15:33:40'),
(2, 'Administrator', 'jagosoftware@shopee.co.id', '2022-06-07 16:10:01', '2022-06-07 16:10:01'),
(3, 'Administrator', 'jagosoftware@shopee.co.id', '2022-06-07 16:11:17', '2022-06-07 16:11:17'),
(4, 'Administrator', 'jagosoftware@shopee.co.id', '2022-06-07 16:16:03', '2022-06-07 16:16:03'),
(5, 'Administrator', 'jagosoftware@shopee.co.id', '2022-06-07 16:19:49', '2022-06-07 16:19:49'),
(6, 'Administrator', 'jagosoftware@shopee.co.id', '2022-09-13 02:01:03', '2022-09-13 02:01:03'),
(7, 'Administrator', 'jagosoftware@shopee.co.id', '2022-09-13 05:31:44', '2022-09-13 05:31:44'),
(8, 'Administrator', 'jagosoftware@shopee.co.id', '2022-09-14 14:34:17', '2022-09-14 14:34:17'),
(9, 'Panjul A.B', '1111111111@siswa.com', '2022-09-14 15:19:19', '2022-09-14 15:19:19'),
(10, 'Administrator', 'jagosoftware@shopee.co.id', '2022-09-14 15:24:29', '2022-09-14 15:24:29'),
(11, 'Panjul A.B', '1111111111@siswa.com', '2023-02-03 11:55:08', '2023-02-03 11:55:08'),
(12, 'Administrator', 'jagosoftware@shopee.co.id', '2023-02-03 11:55:51', '2023-02-03 11:55:51'),
(13, 'Surat', 'surat@shopee.co.id', '2023-02-03 12:02:21', '2023-02-03 12:02:21'),
(14, 'Keuangan', 'keuangan@shopee.co.id', '2023-02-05 15:00:46', '2023-02-05 15:00:46'),
(15, 'Administrator', 'jagosoftware@shopee.co.id', '2023-02-05 15:01:45', '2023-02-05 15:01:45'),
(16, 'Administrator', 'jagosoftware@shopee.co.id', '2024-02-08 00:03:38', '2024-02-08 00:03:38'),
(17, 'Administrator', 'jagosoftware@shopee.co.id', '2024-02-08 05:10:39', '2024-02-08 05:10:39'),
(18, 'Administrator', 'jagosoftware@shopee.co.id', '2024-02-08 15:22:08', '2024-02-08 15:22:08'),
(19, 'Administrator', 'jagosoftware@shopee.co.id', '2024-02-09 01:25:53', '2024-02-09 01:25:53');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2020_01_12_102424_create_suratmasuk_table', 1),
(9, '2020_01_12_102608_create_suratkeluar_table', 1),
(10, '2020_01_12_102751_create_klasifikasi_table', 1),
(11, '2020_02_01_150517_create_instansis_table', 1),
(12, '2020_02_03_030401_create_disposisi_table', 1),
(13, '2020_03_11_105629_create_guru_table', 1),
(14, '2020_03_11_151552_create_tendik_table', 1),
(15, '2020_03_11_165200_create_rombel_table', 1),
(16, '2020_03_12_002830_create_pesdik_table', 1),
(17, '2020_03_14_035908_create_pengumuman_table', 1),
(18, '2020_03_15_132829_create_pesdikkeluar_table', 1),
(19, '2020_03_16_145519_create_pesdikalumni_table', 1),
(20, '2020_03_18_045010_create_tapel_table', 1),
(21, '2020_03_18_145532_create_kategori_table', 1),
(22, '2020_03_18_152452_create_pemasukan_table', 1),
(23, '2020_03_21_101644_create_pengeluaran_table', 1),
(24, '2020_03_21_142613_create_setor_table', 1),
(25, '2020_03_22_034043_create_tarik_table', 1),
(26, '2020_03_24_044951_create_anggotarombel_table', 1),
(27, '2020_03_24_133753_create_tagihan_table', 1),
(28, '2020_04_08_142650_create_transaksipembayaran_table', 1),
(29, '2020_06_18_222709_create_login_table', 1),
(30, '2020_06_19_014420_tambah_foreign_key_constraint', 1);

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

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pemasukan`
--

CREATE TABLE `pemasukan` (
  `id` int(10) UNSIGNED NOT NULL,
  `kategori_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pemasukan`
--

INSERT INTO `pemasukan` (`id`, `kategori_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(54, 1, '0000-00-00', 50000, 'Panjul A.B', '2024-02-09 06:00:40', '2024-02-09 06:00:40'),
(55, 1, '0000-00-00', 54000, 'Panjul A.B', '2024-02-09 06:13:35', '2024-02-09 06:13:35'),
(56, 1, '0000-00-00', 240000, 'Panjul A.B', '2024-02-09 06:14:10', '2024-02-09 06:14:10'),
(57, 1, '0000-00-00', 830000, 'Panjul A.B', '2024-02-09 06:17:04', '2024-02-09 06:17:04'),
(58, 1, '0000-00-00', 500000, 'udik kuswanto', '2024-02-09 06:41:02', '2024-02-09 06:41:02'),
(59, 1, '0000-00-00', 350000, 'udik kuswanto', '2024-02-09 06:41:22', '2024-02-09 06:41:22'),
(60, 1, '0000-00-00', 350000, 'ASAD', '2024-02-09 07:08:09', '2024-02-09 07:08:09'),
(61, 1, '0000-00-00', 925000, 'ASAD', '2024-02-09 07:09:14', '2024-02-09 07:09:14');

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

--
-- Table structure for table `pengeluaran`
--

CREATE TABLE `pengeluaran` (
  `id` int(10) UNSIGNED NOT NULL,
  `kategori_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pengumuman`
--

CREATE TABLE `pengumuman` (
  `id` int(10) UNSIGNED NOT NULL,
  `judul` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pengumuman`
--

INSERT INTO `pengumuman` (`id`, `judul`, `isi`, `users_id`, `created_at`, `updated_at`) VALUES
(1, 'Setting Data Master', 'Pastikan administrator sudah melakukan setting data master pada menu KELOLA DATA, mulai dari data Sekolah, GTK, Tahun Pelajaran, Rombongan Belajar dan Peserta Didik.', 1, '2022-06-07 15:29:24', '2022-06-07 15:29:24');

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

--
-- Table structure for table `pesdik`
--

CREATE TABLE `pesdik` (
  `id` int(10) UNSIGNED NOT NULL,
  `status` varchar(7) NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `nisn` varchar(10) NOT NULL,
  `induk` varchar(6) NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `jenis_pendaftaran` varchar(10) NOT NULL,
  `tanggal_masuk` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pesdik`
--

INSERT INTO `pesdik` (`id`, `status`, `nama`, `jenis_kelamin`, `nisn`, `induk`, `rombel_id`, `tempat_lahir`, `tanggal_lahir`, `jenis_pendaftaran`, `tanggal_masuk`, `created_at`, `updated_at`) VALUES
(1, 'Aktif', 'Panjul A.B', 'Laki-Laki', '1111111111', '3314', 1, 'Kota Pakal', '2013-07-22', 'Siswa Baru', '2016-07-22', '2022-09-13 02:10:22', '2022-09-13 02:10:22'),
(2, 'Aktif', 'Parni', 'Laki-Laki', '2222222222', '3315', 1, 'Kota Pakal', '1999-08-22', 'Siswa Baru', '2016-08-22', '2022-09-14 14:42:02', '2022-09-14 14:42:02'),
(3, 'Aktif', 'ASAD', 'Laki-Laki', '1111111111', '3316', 2, 'Kota Pakal', '2013-07-22', 'Siswa Baru', '2016-07-22', '2022-09-13 02:10:22', '2024-02-09 03:19:04'),
(4, 'Aktif', 'udik kuswanto', 'Laki-Laki', '1212133333', '122334', 1, 'sragen', '2023-02-03', 'Siswa Baru', '2023-02-03', '2023-02-03 11:50:51', '2023-02-03 11:50:51');

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

--
-- Table structure for table `pesdikalumni`
--

CREATE TABLE `pesdikalumni` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `tanggal_lulus` date NOT NULL,
  `melanjutkan_ke` varchar(20) NOT NULL,
  `keterangan` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pesdikkeluar`
--

CREATE TABLE `pesdikkeluar` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `keluar_karena` varchar(20) NOT NULL,
  `tanggal_keluar` date NOT NULL,
  `alasan_keluar` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `rombel`
--

CREATE TABLE `rombel` (
  `id` int(10) UNSIGNED NOT NULL,
  `tapel_id` int(10) UNSIGNED NOT NULL,
  `guru_id` int(10) UNSIGNED NOT NULL,
  `kelas` int(11) NOT NULL,
  `nama_rombel` varchar(15) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rombel`
--

INSERT INTO `rombel` (`id`, `tapel_id`, `guru_id`, `kelas`, `nama_rombel`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 7, 'VIIA', '2022-09-13 02:08:15', '2022-09-13 02:08:15'),
(2, 2, 1, 8, 'VIIIA', '2024-02-09 03:18:49', '2024-02-09 03:18:49');

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

--
-- Table structure for table `setor`
--

CREATE TABLE `setor` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setor`
--

INSERT INTO `setor` (`id`, `pesdik_id`, `users_id`, `rombel_id`, `tanggal`, `jumlah`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2024-02-09', 9000, '-', '2024-02-08 17:11:04', '2024-02-08 17:11:04'),
(2, 1, 1, 1, '2024-02-08', 5000, '-', '2024-02-08 17:11:33', '2024-02-08 17:11:33');

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

--
-- Table structure for table `suratkeluar`
--

CREATE TABLE `suratkeluar` (
  `id` int(10) UNSIGNED NOT NULL,
  `klasifikasi_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `no_surat` varchar(30) NOT NULL,
  `tujuan_surat` varchar(50) NOT NULL,
  `isi` varchar(191) NOT NULL,
  `tgl_surat` date NOT NULL,
  `tgl_catat` date NOT NULL,
  `filekeluar` varchar(100) NOT NULL,
  `keterangan` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `suratmasuk`
--

CREATE TABLE `suratmasuk` (
  `id` int(10) UNSIGNED NOT NULL,
  `klasifikasi_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `no_surat` varchar(30) NOT NULL,
  `asal_surat` varchar(50) NOT NULL,
  `isi` text NOT NULL,
  `tgl_surat` date NOT NULL,
  `tgl_terima` date NOT NULL,
  `filemasuk` varchar(100) NOT NULL,
  `keterangan` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suratmasuk`
--

INSERT INTO `suratmasuk` (`id`, `klasifikasi_id`, `users_id`, `no_surat`, `asal_surat`, `isi`, `tgl_surat`, `tgl_terima`, `filemasuk`, `keterangan`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '001/KS/2022', 'JAGOSOFTWARE', 'JAGO SOFTWARE', '2022-06-07', '2022-06-02', 'S_Masuk-logo.png', 'OK SURAT SIAP DISPOSISI', '2022-06-07 15:36:28', '2022-06-07 15:36:28');

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

--
-- Table structure for table `tagihan`
--

CREATE TABLE `tagihan` (
  `id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `rincian` varchar(50) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `nominal` int(11) NOT NULL,
  `batas_bayar` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tagihan`
--

INSERT INTO `tagihan` (`id`, `rombel_id`, `rincian`, `jenis_kelamin`, `nominal`, `batas_bayar`, `created_at`, `updated_at`) VALUES
(2, 1, 'UangPangkal', 'Semua', 100000, '2022-09-30', '2022-09-13 02:12:28', '2022-09-14 15:24:44'),
(3, 1, 'DafarUlang', 'Semua', 250000, '2022-09-30', '2022-09-13 02:12:28', '2022-09-14 15:24:54'),
(4, 1, 'SPP', 'Semua', 500000, '2022-09-28', '2022-09-14 14:51:42', '2022-09-14 14:51:42'),
(6, 2, 'SPP', 'Semua', 525000, '2024-02-29', '2024-02-09 06:20:57', '2024-02-09 06:20:57'),
(7, 2, 'Uang Pangkal', 'Semua', 125000, '2024-02-29', '2024-02-09 06:20:57', '2024-02-09 06:20:57'),
(8, 2, 'Daftar Ulang', 'Semua', 275000, '2024-02-29', '2024-02-09 06:20:57', '2024-02-09 06:20:57');

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

--
-- Table structure for table `tapel`
--

CREATE TABLE `tapel` (
  `id` int(10) UNSIGNED NOT NULL,
  `tahun` varchar(9) NOT NULL,
  `semester` varchar(15) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tapel`
--

INSERT INTO `tapel` (`id`, `tahun`, `semester`, `created_at`, `updated_at`) VALUES
(1, '2022/2023', 'Semester Ganjil', '2022-06-07 16:23:57', '2022-06-07 16:23:57'),
(2, '2023/2024', 'Semester Genap', '2024-02-09 03:18:01', '2024-02-09 03:18:01');

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

--
-- Table structure for table `tarik`
--

CREATE TABLE `tarik` (
  `id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(11) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tendik`
--

CREATE TABLE `tendik` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(30) NOT NULL,
  `jenis_kelamin` varchar(9) NOT NULL,
  `tempat_lahir` varchar(25) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `alamat` varchar(100) NOT NULL,
  `no_hp` varchar(13) NOT NULL,
  `email` varchar(35) NOT NULL,
  `tugas` varchar(35) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transaksipembayaran`
--

CREATE TABLE `transaksipembayaran` (
  `id` int(10) UNSIGNED NOT NULL,
  `tagihan_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `pesdik_id` int(10) UNSIGNED NOT NULL,
  `rombel_id` int(10) UNSIGNED NOT NULL,
  `jumlah_bayar` int(11) NOT NULL,
  `tagihannya` int(11) NOT NULL,
  `sisatagihan` int(11) NOT NULL,
  `tahun` year(4) NOT NULL,
  `last_number` int(11) NOT NULL DEFAULT 0,
  `noinvoice` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaksipembayaran`
--

INSERT INTO `transaksipembayaran` (`id`, `tagihan_id`, `users_id`, `pesdik_id`, `rombel_id`, `jumlah_bayar`, `tagihannya`, `sisatagihan`, `tahun`, `last_number`, `noinvoice`, `created_at`, `updated_at`) VALUES
(88, 2, 1, 1, 1, 50000, 100000, 50000, '2024', 1, 'INV-2024-0001', '2024-02-09 06:00:40', '2024-02-09 06:00:40'),
(89, 2, 1, 1, 1, 4000, 50000, 46000, '2024', 2, 'INV-2024-0002', '2024-02-09 06:13:35', '2024-02-09 06:13:35'),
(90, 2, 1, 1, 1, 36000, 46000, 10000, '2024', 3, 'INV-2024-0003', '2024-02-09 06:14:10', '2024-02-09 06:14:10'),
(91, 3, 1, 1, 1, 150000, 250000, 100000, '2024', 3, 'INV-2024-0003', '2024-02-09 06:14:10', '2024-02-09 06:14:10'),
(92, 2, 1, 1, 1, 10000, 10000, 0, '2024', 4, 'INV-2024-0004', '2024-02-09 06:17:04', '2024-02-09 06:17:04'),
(93, 3, 1, 1, 1, 80000, 100000, 20000, '2024', 4, 'INV-2024-0004', '2024-02-09 06:17:04', '2024-02-09 06:17:04'),
(94, 4, 1, 1, 1, 500000, 500000, 0, '2024', 4, 'INV-2024-0004', '2024-02-09 06:17:04', '2024-02-09 06:17:04'),
(95, 4, 1, 4, 1, 500000, 500000, 0, '2024', 5, 'INV-2024-0005', '2024-02-09 06:41:02', '2024-02-09 06:41:02'),
(96, 2, 1, 4, 1, 100000, 100000, 0, '2024', 6, 'INV-2024-0006', '2024-02-09 06:41:22', '2024-02-09 06:41:22'),
(97, 3, 1, 4, 1, 250000, 250000, 0, '2024', 6, 'INV-2024-0006', '2024-02-09 06:41:22', '2024-02-09 06:41:22'),
(98, 6, 1, 3, 2, 325000, 525000, 200000, '2024', 7, 'INV-2024-0007', '2024-02-09 07:08:09', '2024-02-09 07:08:09'),
(99, 7, 1, 3, 2, 25000, 125000, 100000, '2024', 7, 'INV-2024-0007', '2024-02-09 07:08:09', '2024-02-09 07:08:09'),
(100, 6, 1, 3, 2, 200000, 200000, 0, '2024', 8, 'INV-2024-0008', '2024-02-09 07:09:14', '2024-02-09 07:09:14'),
(101, 7, 1, 3, 2, 100000, 100000, 0, '2024', 8, 'INV-2024-0008', '2024-02-09 07:09:14', '2024-02-09 07:09:14'),
(102, 8, 1, 3, 2, 275000, 275000, 0, '2024', 8, 'INV-2024-0008', '2024-02-09 07:09:14', '2024-02-09 07:09:14');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(30) NOT NULL,
  `email` varchar(191) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) NOT NULL,
  `role` varchar(35) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'jagosoftware@shopee.co.id', NULL, '$2y$10$uuxhO8kn3r6I4iKg4FsEzeIYw/ZJFhBBYEm4GG0u2EPWG1MeR3STS', 'admin', NULL, '2022-06-07 15:29:24', '2022-06-07 15:29:24'),
(2, 'Panjul A.B', '1111111111@siswa.com', NULL, '$2y$10$dCevVPMGThRftvVt6fTIGuowwrH640jQG9moXZ5JpVD5ybjLhZrGW', 'Siswa', NULL, '2022-09-13 02:10:22', '2023-02-03 11:54:59'),
(3, 'Parni', '2222222222@siswa.com', NULL, '$2y$10$D2aePy.xTxFCg.zHFMnF0unbBo3gq8AUHxUl/KTTcmnKcjJBQ7RNq', 'Siswa', NULL, '2022-09-14 14:42:02', '2022-09-14 14:42:02'),
(4, 'udik kuswanto', '1212133333@siswa.com', NULL, '$2y$10$tJAzO93XvCN3q37qZ5el/.gMvRZUDkzNiQT.kFx8rbfhR1l5N5ulq', 'Siswa', NULL, '2023-02-03 11:50:53', '2023-02-03 11:50:53'),
(5, 'Surat', 'surat@shopee.co.id', NULL, '$2y$10$opEbV70zpKTY7a1dVWMYUOOGuadkINv2u5JaJmZEMA35xMvCLJCYK', 'PetugasAdministrasiSurat', NULL, '2023-02-03 12:01:50', '2023-02-03 12:01:50'),
(6, 'Keuangan', 'keuangan@shopee.co.id', NULL, '$2y$10$f/q6OzculC1mCn3bissLP.gKE.16gcfxA8K8fqDE0RMx6h4exeM3G', 'PetugasAdministrasiKeuangan', NULL, '2023-02-03 12:03:34', '2023-02-03 12:03:34');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `anggotarombel`
--
ALTER TABLE `anggotarombel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `anggotarombel_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `anggotarombel_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `disposisis`
--
ALTER TABLE `disposisis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `disposisis_users_id_foreign` (`users_id`),
  ADD KEY `disposisis_suratmasuk_id_foreign` (`suratmasuk_id`);

--
-- Indexes for table `guru`
--
ALTER TABLE `guru`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `instansis`
--
ALTER TABLE `instansis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `klasifikasi`
--
ALTER TABLE `klasifikasi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `pemasukan`
--
ALTER TABLE `pemasukan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pemasukan_kategori_id_foreign` (`kategori_id`);

--
-- Indexes for table `pengeluaran`
--
ALTER TABLE `pengeluaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pengeluaran_kategori_id_foreign` (`kategori_id`);

--
-- Indexes for table `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pengumuman_users_id_foreign` (`users_id`);

--
-- Indexes for table `pesdik`
--
ALTER TABLE `pesdik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdik_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `pesdikalumni`
--
ALTER TABLE `pesdikalumni`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdikalumni_pesdik_id_foreign` (`pesdik_id`);

--
-- Indexes for table `pesdikkeluar`
--
ALTER TABLE `pesdikkeluar`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pesdikkeluar_pesdik_id_foreign` (`pesdik_id`);

--
-- Indexes for table `rombel`
--
ALTER TABLE `rombel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rombel_tapel_id_foreign` (`tapel_id`),
  ADD KEY `rombel_guru_id_foreign` (`guru_id`);

--
-- Indexes for table `setor`
--
ALTER TABLE `setor`
  ADD PRIMARY KEY (`id`),
  ADD KEY `setor_users_id_foreign` (`users_id`),
  ADD KEY `setor_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `setor_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `suratkeluar`
--
ALTER TABLE `suratkeluar`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `suratkeluar_no_surat_unique` (`no_surat`),
  ADD KEY `suratkeluar_users_id_foreign` (`users_id`),
  ADD KEY `suratkeluar_klasifikasi_id_foreign` (`klasifikasi_id`);

--
-- Indexes for table `suratmasuk`
--
ALTER TABLE `suratmasuk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `suratmasuk_no_surat_unique` (`no_surat`),
  ADD KEY `suratmasuk_users_id_foreign` (`users_id`),
  ADD KEY `suratmasuk_klasifikasi_id_foreign` (`klasifikasi_id`);

--
-- Indexes for table `tagihan`
--
ALTER TABLE `tagihan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tagihan_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `tapel`
--
ALTER TABLE `tapel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tarik`
--
ALTER TABLE `tarik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tarik_users_id_foreign` (`users_id`),
  ADD KEY `tarik_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `tarik_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `tendik`
--
ALTER TABLE `tendik`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transaksipembayaran`
--
ALTER TABLE `transaksipembayaran`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaksipembayaran_tagihan_id_foreign` (`tagihan_id`),
  ADD KEY `transaksipembayaran_users_id_foreign` (`users_id`),
  ADD KEY `transaksipembayaran_pesdik_id_foreign` (`pesdik_id`),
  ADD KEY `transaksipembayaran_rombel_id_foreign` (`rombel_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `anggotarombel`
--
ALTER TABLE `anggotarombel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `disposisis`
--
ALTER TABLE `disposisis`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `guru`
--
ALTER TABLE `guru`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `instansis`
--
ALTER TABLE `instansis`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `klasifikasi`
--
ALTER TABLE `klasifikasi`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pemasukan`
--
ALTER TABLE `pemasukan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `pengeluaran`
--
ALTER TABLE `pengeluaran`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pengumuman`
--
ALTER TABLE `pengumuman`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pesdik`
--
ALTER TABLE `pesdik`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `pesdikalumni`
--
ALTER TABLE `pesdikalumni`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pesdikkeluar`
--
ALTER TABLE `pesdikkeluar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rombel`
--
ALTER TABLE `rombel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `setor`
--
ALTER TABLE `setor`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `suratkeluar`
--
ALTER TABLE `suratkeluar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `suratmasuk`
--
ALTER TABLE `suratmasuk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tagihan`
--
ALTER TABLE `tagihan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tapel`
--
ALTER TABLE `tapel`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tarik`
--
ALTER TABLE `tarik`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tendik`
--
ALTER TABLE `tendik`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaksipembayaran`
--
ALTER TABLE `transaksipembayaran`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `anggotarombel`
--
ALTER TABLE `anggotarombel`
  ADD CONSTRAINT `anggotarombel_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `anggotarombel_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Constraints for table `disposisis`
--
ALTER TABLE `disposisis`
  ADD CONSTRAINT `disposisis_suratmasuk_id_foreign` FOREIGN KEY (`suratmasuk_id`) REFERENCES `suratmasuk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `disposisis_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `pemasukan`
--
ALTER TABLE `pemasukan`
  ADD CONSTRAINT `pemasukan_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`);

--
-- Constraints for table `pengeluaran`
--
ALTER TABLE `pengeluaran`
  ADD CONSTRAINT `pengeluaran_kategori_id_foreign` FOREIGN KEY (`kategori_id`) REFERENCES `kategori` (`id`);

--
-- Constraints for table `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD CONSTRAINT `pengumuman_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `pesdik`
--
ALTER TABLE `pesdik`
  ADD CONSTRAINT `pesdik_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Constraints for table `pesdikalumni`
--
ALTER TABLE `pesdikalumni`
  ADD CONSTRAINT `pesdikalumni_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`);

--
-- Constraints for table `pesdikkeluar`
--
ALTER TABLE `pesdikkeluar`
  ADD CONSTRAINT `pesdikkeluar_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`);

--
-- Constraints for table `rombel`
--
ALTER TABLE `rombel`
  ADD CONSTRAINT `rombel_guru_id_foreign` FOREIGN KEY (`guru_id`) REFERENCES `guru` (`id`),
  ADD CONSTRAINT `rombel_tapel_id_foreign` FOREIGN KEY (`tapel_id`) REFERENCES `tapel` (`id`);

--
-- Constraints for table `setor`
--
ALTER TABLE `setor`
  ADD CONSTRAINT `setor_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `setor_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `setor_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `suratkeluar`
--
ALTER TABLE `suratkeluar`
  ADD CONSTRAINT `suratkeluar_klasifikasi_id_foreign` FOREIGN KEY (`klasifikasi_id`) REFERENCES `klasifikasi` (`id`),
  ADD CONSTRAINT `suratkeluar_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `suratmasuk`
--
ALTER TABLE `suratmasuk`
  ADD CONSTRAINT `suratmasuk_klasifikasi_id_foreign` FOREIGN KEY (`klasifikasi_id`) REFERENCES `klasifikasi` (`id`),
  ADD CONSTRAINT `suratmasuk_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `tagihan`
--
ALTER TABLE `tagihan`
  ADD CONSTRAINT `tagihan_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`);

--
-- Constraints for table `tarik`
--
ALTER TABLE `tarik`
  ADD CONSTRAINT `tarik_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `tarik_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `tarik_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `transaksipembayaran`
--
ALTER TABLE `transaksipembayaran`
  ADD CONSTRAINT `transaksipembayaran_pesdik_id_foreign` FOREIGN KEY (`pesdik_id`) REFERENCES `pesdik` (`id`),
  ADD CONSTRAINT `transaksipembayaran_rombel_id_foreign` FOREIGN KEY (`rombel_id`) REFERENCES `rombel` (`id`),
  ADD CONSTRAINT `transaksipembayaran_tagihan_id_foreign` FOREIGN KEY (`tagihan_id`) REFERENCES `tagihan` (`id`),
  ADD CONSTRAINT `transaksipembayaran_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;