· 9 years ago · Dec 18, 2016, 02:16 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 18, 2016 at 09:14 AM
7-- Server version: 5.6.28
8-- PHP Version: 5.6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `fb_angsuran`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `angsuran`
21--
22
23CREATE TABLE IF NOT EXISTS `angsuran` (
24 `id` int(11) NOT NULL,
25 `pinjaman_kode` varchar(15) NOT NULL,
26 `bulan` int(11) NOT NULL,
27 `angsuran` int(11) NOT NULL,
28 `dateline` date NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `log_actions`
35--
36
37CREATE TABLE IF NOT EXISTS `log_actions` (
38 `id` int(11) NOT NULL,
39 `username` int(11) NOT NULL,
40 `action` int(11) NOT NULL,
41 `sub_action` int(11) NOT NULL,
42 `detail` int(11) NOT NULL,
43 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `nasabah`
50--
51
52CREATE TABLE IF NOT EXISTS `nasabah` (
53 `id` int(11) NOT NULL,
54 `kode` varchar(30) NOT NULL,
55 `nama` int(11) NOT NULL,
56 `detail` text NOT NULL
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `pinjaman`
63--
64
65CREATE TABLE IF NOT EXISTS `pinjaman` (
66 `kode` varchar(15) NOT NULL,
67 `nasabah_kode` varchar(32) NOT NULL,
68 `tipe` enum('barang','uang','','') NOT NULL,
69 `detail` text NOT NULL,
70 `created` datetime NOT NULL,
71 `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
72 `username` varchar(30) NOT NULL
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `pinjaman_barang`
79--
80
81CREATE TABLE IF NOT EXISTS `pinjaman_barang` (
82 `pinjaman_kode` varchar(15) NOT NULL,
83 `pinjaman_nama` varchar(50) NOT NULL,
84 `pinjaman_hargadasar` int(11) NOT NULL,
85 `pinjaman_hargaangsur` int(11) NOT NULL,
86 `username` varchar(30) NOT NULL
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `pinjaman_uang`
93--
94
95CREATE TABLE IF NOT EXISTS `pinjaman_uang` (
96 `pinjaman_kode` varchar(15) NOT NULL,
97 `pinjaman_hargadasar` int(11) NOT NULL,
98 `pinjaman_hargaangsur` int(11) NOT NULL,
99 `username` varchar(30) NOT NULL
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101
102-- --------------------------------------------------------
103
104--
105-- Table structure for table `transaksi`
106--
107
108CREATE TABLE IF NOT EXISTS `transaksi` (
109 `id` int(11) NOT NULL,
110 `pinjaman_kode` varchar(15) NOT NULL,
111 `angsuran_id` int(11) NOT NULL,
112 `tanggal` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
113 `nominal` int(11) NOT NULL,
114 `detail` text NOT NULL,
115 `username` varchar(30) NOT NULL
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117
118-- --------------------------------------------------------
119
120--
121-- Table structure for table `user`
122--
123
124CREATE TABLE IF NOT EXISTS `user` (
125 `id` int(11) NOT NULL,
126 `username` varchar(30) NOT NULL,
127 `password` varchar(32) NOT NULL,
128 `role` enum('user','admin','cashier','') NOT NULL
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130
131--
132-- Indexes for dumped tables
133--
134
135--
136-- Indexes for table `angsuran`
137--
138ALTER TABLE `angsuran`
139 ADD PRIMARY KEY (`id`),
140 ADD KEY `pinjaman_kode` (`pinjaman_kode`);
141
142--
143-- Indexes for table `log_actions`
144--
145ALTER TABLE `log_actions`
146 ADD PRIMARY KEY (`id`),
147 ADD UNIQUE KEY `username` (`username`);
148
149--
150-- Indexes for table `nasabah`
151--
152ALTER TABLE `nasabah`
153 ADD PRIMARY KEY (`id`),
154 ADD UNIQUE KEY `kode` (`kode`);
155
156--
157-- Indexes for table `pinjaman`
158--
159ALTER TABLE `pinjaman`
160 ADD PRIMARY KEY (`kode`),
161 ADD KEY `nasabah_kode` (`nasabah_kode`),
162 ADD KEY `username` (`username`);
163
164--
165-- Indexes for table `pinjaman_barang`
166--
167ALTER TABLE `pinjaman_barang`
168 ADD PRIMARY KEY (`pinjaman_kode`),
169 ADD KEY `pinjaman_nama` (`pinjaman_nama`),
170 ADD KEY `username` (`username`);
171
172--
173-- Indexes for table `pinjaman_uang`
174--
175ALTER TABLE `pinjaman_uang`
176 ADD PRIMARY KEY (`pinjaman_kode`),
177 ADD KEY `username` (`username`);
178
179--
180-- Indexes for table `transaksi`
181--
182ALTER TABLE `transaksi`
183 ADD PRIMARY KEY (`id`),
184 ADD KEY `pinjaman_kode` (`pinjaman_kode`),
185 ADD KEY `angsuran_id` (`angsuran_id`),
186 ADD KEY `username` (`username`);
187
188--
189-- Indexes for table `user`
190--
191ALTER TABLE `user`
192 ADD PRIMARY KEY (`id`),
193 ADD UNIQUE KEY `username` (`username`),
194 ADD KEY `role` (`role`);
195
196--
197-- AUTO_INCREMENT for dumped tables
198--
199
200--
201-- AUTO_INCREMENT for table `angsuran`
202--
203ALTER TABLE `angsuran`
204 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
205--
206-- AUTO_INCREMENT for table `log_actions`
207--
208ALTER TABLE `log_actions`
209 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
210--
211-- AUTO_INCREMENT for table `nasabah`
212--
213ALTER TABLE `nasabah`
214 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
215--
216-- AUTO_INCREMENT for table `transaksi`
217--
218ALTER TABLE `transaksi`
219 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
220--
221-- AUTO_INCREMENT for table `user`
222--
223ALTER TABLE `user`
224 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
225--
226-- Constraints for dumped tables
227--
228
229--
230-- Constraints for table `angsuran`
231--
232ALTER TABLE `angsuran`
233 ADD CONSTRAINT `angsuran_ibfk_1` FOREIGN KEY (`pinjaman_kode`) REFERENCES `pinjaman` (`kode`);
234
235--
236-- Constraints for table `pinjaman`
237--
238ALTER TABLE `pinjaman`
239 ADD CONSTRAINT `pinjaman_ibfk_1` FOREIGN KEY (`nasabah_kode`) REFERENCES `nasabah` (`kode`);
240
241--
242-- Constraints for table `pinjaman_barang`
243--
244ALTER TABLE `pinjaman_barang`
245 ADD CONSTRAINT `pinjaman_barang_ibfk_1` FOREIGN KEY (`pinjaman_kode`) REFERENCES `pinjaman` (`kode`);
246
247--
248-- Constraints for table `pinjaman_uang`
249--
250ALTER TABLE `pinjaman_uang`
251 ADD CONSTRAINT `pinjaman_uang_ibfk_1` FOREIGN KEY (`pinjaman_kode`) REFERENCES `pinjaman` (`kode`);
252
253--
254-- Constraints for table `transaksi`
255--
256ALTER TABLE `transaksi`
257 ADD CONSTRAINT `transaksi_ibfk_1` FOREIGN KEY (`username`) REFERENCES `user` (`username`),
258 ADD CONSTRAINT `transaksi_ibfk_2` FOREIGN KEY (`pinjaman_kode`) REFERENCES `pinjaman` (`kode`);
259
260--
261-- Constraints for table `user`
262--
263ALTER TABLE `user`
264 ADD CONSTRAINT `user_ibfk_1` FOREIGN KEY (`username`) REFERENCES `pinjaman` (`username`);