text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: Jul 06, 2021 at 01:31 
  -- Server version: 10.1.21-MariaDB
  -- PHP Version: 5.6.30
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `ci-relasi-table`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `anggota`
  --
  
  CREATE TABLE `anggota` (
    `id_anggota` varchar(5) NOT NULL,
    `id_unit` int(5) NOT NULL,
    `nama` varchar(30) NOT NULL,
    `jenis_kelamin` varchar(30) NOT NULL,
    `alamat` text,
    `no_hp` varchar(50) DEFAULT NULL,
    `ket` text
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `anggota`
  --
  
  INSERT INTO `anggota` (`id_anggota`, `id_unit`, `nama`, `jenis_kelamin`, `alamat`, `no_hp`, `ket`) VALUES
  ('1', 1, 'Kuriyanto Adi', 'Laki-laki', 'Serang', '081111', 'aktif');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `simpanan`
  --
  
  CREATE TABLE `simpanan` (
    `id_simpanan` varchar(9) NOT NULL,
    `id_anggota` varchar(5) NOT NULL,
    `jumlah_simpanan` decimal(18,2) NOT NULL,
    `tgl_simp` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `simpanan`
  --
  
  INSERT INTO `simpanan` (`id_simpanan`, `id_anggota`, `jumlah_simpanan`, `tgl_simp`) VALUES
  ('', '1', '5000.00', '2021-07-15');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `anggota`
  --
  ALTER TABLE `anggota`
    ADD PRIMARY KEY (`id_anggota`);
  
  --
  -- Indexes for table `simpanan`
  --
  ALTER TABLE `simpanan`
    ADD PRIMARY KEY (`id_simpanan`);
  
  /*!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 */;
  