· 8 years ago · Jan 15, 2018, 12:34 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Jan 15, 2018 at 01:29 PM
7-- Server version: 5.6.20
8-- PHP Version: 5.5.15
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `koperasi_simpan_pinjam`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `anggota`
27--
28
29CREATE TABLE IF NOT EXISTS `anggota` (
30`id_anggota` int(11) NOT NULL,
31 `id_petugas` int(11) NOT NULL,
32 `nama_anggota` varchar(50) NOT NULL,
33 `alamat_anggota` text NOT NULL,
34 `tgl_lahir_anggota` date NOT NULL,
35 `tempat_lahir_anggota` varchar(20) NOT NULL,
36 `jk_anggota` varchar(20) NOT NULL,
37 `status_anggota` varchar(100) NOT NULL,
38 `no_telp_anggota` int(20) NOT NULL,
39 `ket_anggota` varchar(200) NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `angsuran`
46--
47
48CREATE TABLE IF NOT EXISTS `angsuran` (
49`id_angsuran` int(11) NOT NULL,
50 `id_kategori` int(11) NOT NULL,
51 `id_anggota` int(11) NOT NULL,
52 `tgl_pembayaran` date NOT NULL,
53 `angsuran_ke` varchar(20) NOT NULL,
54 `besar_angsuran` int(20) NOT NULL,
55 `ket_angsuran` varchar(200) NOT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `detail_angsuran`
62--
63
64CREATE TABLE IF NOT EXISTS `detail_angsuran` (
65`id_detail` int(10) NOT NULL,
66 `id_angsuran` int(11) NOT NULL,
67 `tgl_jatuh_tempo` date NOT NULL,
68 `besar_angsuran` int(20) NOT NULL,
69 `ket_detail` varchar(200) NOT NULL
70) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
71
72-- --------------------------------------------------------
73
74--
75-- Table structure for table `kategori_pinjaman`
76--
77
78CREATE TABLE IF NOT EXISTS `kategori_pinjaman` (
79`id_kategori` int(11) NOT NULL,
80 `nama_pinjaman` varchar(50) NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `level`
87--
88
89CREATE TABLE IF NOT EXISTS `level` (
90`id_level` int(11) NOT NULL,
91 `nama_level` varchar(60) NOT NULL
92) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
93
94--
95-- Dumping data for table `level`
96--
97
98INSERT INTO `level` (`id_level`, `nama_level`) VALUES
99(1, 'Admin'),
100(2, 'Petugas'),
101(3, 'Anggota');
102
103-- --------------------------------------------------------
104
105--
106-- Table structure for table `petugas`
107--
108
109CREATE TABLE IF NOT EXISTS `petugas` (
110`id_petugas` int(11) NOT NULL,
111 `nama_petugas` varchar(50) NOT NULL,
112 `alamat_petugas` text NOT NULL,
113 `no_telp_petugas` varchar(20) NOT NULL,
114 `tempat_lahir_petugas` varchar(20) NOT NULL,
115 `tgl_lahir_petugas` date NOT NULL,
116 `ket_petugas` varchar(200) NOT NULL,
117 `status` varchar(50) NOT NULL
118) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
119
120--
121-- Dumping data for table `petugas`
122--
123
124INSERT INTO `petugas` (`id_petugas`, `nama_petugas`, `alamat_petugas`, `no_telp_petugas`, `tempat_lahir_petugas`, `tgl_lahir_petugas`, `ket_petugas`, `status`) VALUES
125(1, 'Desi Mutiarsa', 'Jln. Babakan', '081567850002', 'Jawa Tengah', '2017-11-20', 'Bekerja', ''),
126(3, 'Tika Nur', 'Kamarung', '081467862351', 'Bandung', '2017-11-06', 'Bekerja', ''),
127(4, 'Jojo', 'Rancabentang', '087578841294', 'Bandung', '2017-11-21', 'Bekerja', '');
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `pinjaman`
133--
134
135CREATE TABLE IF NOT EXISTS `pinjaman` (
136`id_pinjaman` int(11) NOT NULL,
137 `id_kategori` int(11) NOT NULL,
138 `id_anggota` int(11) NOT NULL,
139 `besar_pinjaman` int(20) NOT NULL,
140 `tgl_pengajuan_pinjam` date NOT NULL,
141 `tgl_acc_pinjam` date NOT NULL,
142 `tgl_pinjaman` date NOT NULL,
143 `tgl_pelunasan` date NOT NULL,
144 `id_angsuran` int(11) NOT NULL,
145 `ket_pinjaman` varchar(200) NOT NULL
146) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `simpanan`
152--
153
154CREATE TABLE IF NOT EXISTS `simpanan` (
155 `id_simpanan` int(11) NOT NULL,
156 `nama_simpanan` varchar(50) NOT NULL,
157 `id_anggota` int(11) NOT NULL,
158 `tgl_simpanan` date NOT NULL,
159 `besar_simpanan` int(20) NOT NULL,
160 `ket_simpanan` varchar(200) NOT NULL
161) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `user`
167--
168
169CREATE TABLE IF NOT EXISTS `user` (
170`id_user` int(11) NOT NULL,
171 `username` varchar(20) NOT NULL,
172 `password` varchar(50) NOT NULL,
173 `nama` varchar(100) NOT NULL,
174 `foto` varchar(80) NOT NULL,
175 `id_level` int(11) NOT NULL
176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
177
178--
179-- Dumping data for table `user`
180--
181
182INSERT INTO `user` (`id_user`, `username`, `password`, `nama`, `foto`, `id_level`) VALUES
183(1, 'admin', 'admin', 'Adjie Roshandy', '.jpg', 1),
184(2, 'petugas', '123456', 'Desi Mutiarsa', '.jpg', 2);
185
186--
187-- Indexes for dumped tables
188--
189
190--
191-- Indexes for table `anggota`
192--
193ALTER TABLE `anggota`
194 ADD PRIMARY KEY (`id_anggota`), ADD KEY `id_petugas` (`id_petugas`);
195
196--
197-- Indexes for table `angsuran`
198--
199ALTER TABLE `angsuran`
200 ADD PRIMARY KEY (`id_angsuran`), ADD KEY `id_anggota` (`id_anggota`), ADD KEY `id_kategori` (`id_kategori`);
201
202--
203-- Indexes for table `detail_angsuran`
204--
205ALTER TABLE `detail_angsuran`
206 ADD PRIMARY KEY (`id_detail`);
207
208--
209-- Indexes for table `kategori_pinjaman`
210--
211ALTER TABLE `kategori_pinjaman`
212 ADD PRIMARY KEY (`id_kategori`);
213
214--
215-- Indexes for table `level`
216--
217ALTER TABLE `level`
218 ADD PRIMARY KEY (`id_level`);
219
220--
221-- Indexes for table `petugas`
222--
223ALTER TABLE `petugas`
224 ADD PRIMARY KEY (`id_petugas`);
225
226--
227-- Indexes for table `pinjaman`
228--
229ALTER TABLE `pinjaman`
230 ADD PRIMARY KEY (`id_pinjaman`), ADD KEY `pinjaman_ibfk_1` (`id_kategori`), ADD KEY `id_anggota` (`id_anggota`);
231
232--
233-- Indexes for table `simpanan`
234--
235ALTER TABLE `simpanan`
236 ADD PRIMARY KEY (`id_simpanan`), ADD KEY `id_anggota` (`id_anggota`);
237
238--
239-- Indexes for table `user`
240--
241ALTER TABLE `user`
242 ADD PRIMARY KEY (`id_user`);
243
244--
245-- AUTO_INCREMENT for dumped tables
246--
247
248--
249-- AUTO_INCREMENT for table `anggota`
250--
251ALTER TABLE `anggota`
252MODIFY `id_anggota` int(11) NOT NULL AUTO_INCREMENT;
253--
254-- AUTO_INCREMENT for table `angsuran`
255--
256ALTER TABLE `angsuran`
257MODIFY `id_angsuran` int(11) NOT NULL AUTO_INCREMENT;
258--
259-- AUTO_INCREMENT for table `detail_angsuran`
260--
261ALTER TABLE `detail_angsuran`
262MODIFY `id_detail` int(10) NOT NULL AUTO_INCREMENT;
263--
264-- AUTO_INCREMENT for table `kategori_pinjaman`
265--
266ALTER TABLE `kategori_pinjaman`
267MODIFY `id_kategori` int(11) NOT NULL AUTO_INCREMENT;
268--
269-- AUTO_INCREMENT for table `level`
270--
271ALTER TABLE `level`
272MODIFY `id_level` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
273--
274-- AUTO_INCREMENT for table `petugas`
275--
276ALTER TABLE `petugas`
277MODIFY `id_petugas` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
278--
279-- AUTO_INCREMENT for table `pinjaman`
280--
281ALTER TABLE `pinjaman`
282MODIFY `id_pinjaman` int(11) NOT NULL AUTO_INCREMENT;
283--
284-- AUTO_INCREMENT for table `user`
285--
286ALTER TABLE `user`
287MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
288/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
289/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
290/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;