· 2 years ago · Jun 11, 2023, 06:20 AM
1
2-- MySQL Administrator dump 1.4
3--
4-- ------------------------------------------------------
5-- Server version 5.0.15-nt
6
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16
17
18--
19-- Create schema loan
20--
21
22CREATE DATABASE IF NOT EXISTS loan;
23USE loan;
24
25--
26-- Definition of table `cust_master`
27--
28
29DROP TABLE IF EXISTS `cust_master`;
30CREATE TABLE `cust_master` (
31 `cust_id` int(11) NOT NULL default '0',
32 `cust_name` varchar(50) default NULL,
33 `cust_resi_add` varchar(200) default NULL,
34 `cust_off_add` varchar(255) default NULL,
35 `cust_mobile` varchar(50) default NULL,
36 `cust_email` varchar(50) default NULL,
37 `cust_dob` varchar(50) default NULL,
38 `cust_pan` varchar(10) default NULL,
39 `cust_aadhaar` varchar(12) default NULL,
40 `cust_entry_by` int(11) default NULL,
41 `cust_entry_date` datetime default NULL,
42 `cust_modify_by` int(11) default NULL,
43 `cust_modify_date` datetime default NULL,
44 `cust_password` varchar(50) default NULL,
45 `last_pass_chg_date` datetime default NULL,
46 `last_login1` datetime default NULL,
47 `last_login2` datetime default NULL,
48 PRIMARY KEY (`cust_id`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51--
52-- Dumping data for table `cust_master`
53--
54
55/*!40000 ALTER TABLE `cust_master` DISABLE KEYS */;
56INSERT INTO `cust_master` (`cust_id`,`cust_name`,`cust_resi_add`,`cust_off_add`,`cust_mobile`,`cust_email`,`cust_dob`,`cust_pan`,`cust_aadhaar`,`cust_entry_by`,`cust_entry_date`,`cust_modify_by`,`cust_modify_date`,`cust_password`,`last_pass_chg_date`,`last_login1`,`last_login2`) VALUES
57 (1,'Sachin Tendulkar','Mumbai','Mumbai','9999990000','sachin.t@rediffmail.com','2001-01-01 00:00:00','AJVM88888E','123456789120',10001,'2018-01-19 00:00:00',10001,'2018-01-20 11:06:39','123456',NULL,NULL,NULL),
58 (2,'Virat Kolhi','Delhi','Delhi','9999944444','virat.k@gmail.com','1980-11-09','VVVV99999P','123456781111',10001,'2018-01-15 00:13:05',NULL,NULL,'1',NULL,NULL,NULL),
59 (3,'Rohit Sharma','Mumbai','Pune','9000121222','rohit.sharma@gmail.com','rohit.sharma@gmail.com','RRRR00000R','124678995333',1,'2018-01-20 12:29:41',10001,'2018-01-20 12:32:40','123456',NULL,NULL,NULL),
60 (4,'Saurav Ganguly','Kolkata','Mumbai','9989995536','saurav.g@gmail.com','saurav.g@gmail.com','SAXN90900P','235602125888',1,'2018-01-20 15:27:06',NULL,NULL,'123456',NULL,NULL,NULL);
61/*!40000 ALTER TABLE `cust_master` ENABLE KEYS */;
62
63
64--
65-- Definition of table `loan_apply_master`
66--
67
68DROP TABLE IF EXISTS `loan_apply_master`;
69CREATE TABLE `loan_apply_master` (
70 `id` int(11) NOT NULL,
71 `cust_id` int(11) default NULL,
72 `apply_date` datetime default NULL,
73 `loan_amount` int(11) default NULL,
74 `loan_type_id` int(11) default NULL,
75 `loan_tenaure` int(11) default NULL,
76 `status` varchar(50) default NULL,
77 `approve_by` int(11) default NULL,
78 `approve_date` datetime default NULL,
79 `loan_master_id` int(10) unsigned default NULL,
80 `Loan_int_rate` double default NULL,
81 `monthly_income` double default NULL,
82 PRIMARY KEY (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=latin1;
84
85--
86-- Dumping data for table `loan_apply_master`
87--
88
89/*!40000 ALTER TABLE `loan_apply_master` DISABLE KEYS */;
90INSERT INTO `loan_apply_master` (`id`,`cust_id`,`apply_date`,`loan_amount`,`loan_type_id`,`loan_tenaure`,`status`,`approve_by`,`approve_date`,`loan_master_id`,`Loan_int_rate`,`monthly_income`) VALUES
91 (1,1,'2017-01-18 00:00:00',50000,1,60,'Approved',10001,'2018-01-01 00:00:00',1,8.6,NULL),
92 (2,2,'2017-01-19 00:00:00',60000,2,36,'Rejected',10001,'2018-01-20 10:43:42',NULL,9,NULL),
93 (3,1,'2018-01-20 01:36:22',600000,1,67,'Pending',NULL,NULL,NULL,9,NULL),
94 (4,1,'2018-01-20 01:37:10',45000,1,25,'Pending',NULL,NULL,NULL,9,NULL),
95 (5,1,'2018-01-20 01:37:38',600000,2,20,'Approved',10001,'2018-01-20 10:43:36',NULL,15,NULL),
96 (6,1,'2018-01-20 01:43:29',250000,2,24,'Pending',NULL,NULL,NULL,15,50000),
97 (7,3,'2018-01-20 12:31:20',1250000,2,60,'Approved',10001,'2018-01-20 12:31:57',NULL,15,75000);
98/*!40000 ALTER TABLE `loan_apply_master` ENABLE KEYS */;
99
100
101--
102-- Definition of table `loan_master`
103--
104
105DROP TABLE IF EXISTS `loan_master`;
106CREATE TABLE `loan_master` (
107 `loan_id` int(11) NOT NULL default '0',
108 `cust_id` int(11) default NULL,
109 `lt_id` int(11) default NULL,
110 `interest_type` varchar(50) default NULL,
111 `loan_interest` float default NULL,
112 `loan_amount` int(11) default NULL,
113 `loan_tenure` int(11) default NULL,
114 `loan_issue_date` datetime default NULL,
115 `loan_mortgage` varchar(255) default NULL,
116 `loan_guranter_name` varchar(50) default NULL,
117 `loan_guranter_address` varchar(255) default NULL,
118 `loan_guranter_contact_no` varchar(50) default NULL,
119 `loan_entry_date` datetime default NULL,
120 `loan_entry_by` int(11) default NULL,
121 `loan_modify_date` datetime default NULL,
122 `loan_modify_by` int(11) default NULL,
123 `loan_approve_type` varchar(50) default NULL,
124 PRIMARY KEY (`loan_id`)
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127--
128-- Dumping data for table `loan_master`
129--
130
131/*!40000 ALTER TABLE `loan_master` DISABLE KEYS */;
132INSERT INTO `loan_master` (`loan_id`,`cust_id`,`lt_id`,`interest_type`,`loan_interest`,`loan_amount`,`loan_tenure`,`loan_issue_date`,`loan_mortgage`,`loan_guranter_name`,`loan_guranter_address`,`loan_guranter_contact_no`,`loan_entry_date`,`loan_entry_by`,`loan_modify_date`,`loan_modify_by`,`loan_approve_type`) VALUES
133 (1,1,1,'Fixed',9,50000,50,'2017-01-01 00:00:00','Home','Atanu','Mumbai','9999999','2018-01-01 00:00:00',10001,NULL,NULL,'System'),
134 (2,1,2,'Fixed',15,600000,20,'2018-01-20 10:43:36',NULL,NULL,NULL,NULL,'2018-01-20 10:43:36',10001,NULL,NULL,'Staff'),
135 (3,3,2,'Fixed',15,1250000,60,'2018-01-20 12:31:57',NULL,NULL,NULL,NULL,'2018-01-20 12:31:57',10001,NULL,NULL,'Staff');
136/*!40000 ALTER TABLE `loan_master` ENABLE KEYS */;
137
138
139--
140-- Definition of table `loan_type_master`
141--
142
143DROP TABLE IF EXISTS `loan_type_master`;
144CREATE TABLE `loan_type_master` (
145 `lt_id` int(11) NOT NULL default '0',
146 `lt_name` varchar(50) default NULL,
147 `lt_fixed_rate` float default NULL,
148 `lt_floting_rate` float default NULL,
149 `lt_fail_emi_fine` float default NULL,
150 `lt_entry_date` datetime default NULL,
151 `lt_entry_by` int(11) default NULL,
152 `lt_modify_date` datetime default NULL,
153 `lt_modify_by` int(11) default NULL,
154 PRIMARY KEY (`lt_id`)
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156
157--
158-- Dumping data for table `loan_type_master`
159--
160
161/*!40000 ALTER TABLE `loan_type_master` DISABLE KEYS */;
162INSERT INTO `loan_type_master` (`lt_id`,`lt_name`,`lt_fixed_rate`,`lt_floting_rate`,`lt_fail_emi_fine`,`lt_entry_date`,`lt_entry_by`,`lt_modify_date`,`lt_modify_by`) VALUES
163 (1,'Home Loan',9,8.5,200,'2018-01-01 00:00:00',10001,NULL,NULL),
164 (2,'Personal Loan',15,17.5,500,'2018-01-19 22:27:01',10001,'2018-01-19 22:27:49',10001),
165 (3,'Car Loan',14,17.5,500,'2018-01-20 12:27:48',10001,'2018-01-20 12:27:56',10001);
166/*!40000 ALTER TABLE `loan_type_master` ENABLE KEYS */;
167
168
169--
170-- Definition of table `login_history`
171--
172
173DROP TABLE IF EXISTS `login_history`;
174CREATE TABLE `login_history` (
175 `id` int(11) NOT NULL auto_increment,
176 `login_user_id` varchar(100) default NULL,
177 `login_type` varchar(50) NOT NULL,
178 `login_date` datetime default NULL,
179 `login_user_name` varchar(50) default NULL,
180 PRIMARY KEY (`id`)
181) ENGINE=InnoDB DEFAULT CHARSET=latin1;
182
183--
184-- Dumping data for table `login_history`
185--
186
187/*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
188INSERT INTO `login_history` (`id`,`login_user_id`,`login_type`,`login_date`,`login_user_name`) VALUES
189 (1,'11001','USER','2018-01-19 22:34:27','ADMIN'),
190 (2,'10001','USER','2018-01-19 22:49:49','Aditya Maity'),
191 (3,'10001','USER','2018-01-19 22:49:59','Aditya Maity'),
192 (4,'1','CUSTOMER','2018-01-19 22:51:17','Atanu Maity'),
193 (5,'10001','USER','2018-01-19 22:58:13','Aditya Maity'),
194 (6,'10001','USER','2018-01-19 23:45:10','Aditya Maity'),
195 (7,'1','CUSTOMER','2018-01-20 00:22:57','Atanu Maity'),
196 (8,'1','CUSTOMER','2018-01-20 00:39:53','Atanu Maity'),
197 (9,'10001','USER','2018-01-20 00:40:05','Aditya Maity'),
198 (10,'1','CUSTOMER','2018-01-20 00:41:11','Atanu Maity'),
199 (11,'1','CUSTOMER','2018-01-20 00:59:43','Atanu Maity'),
200 (12,'1','CUSTOMER','2018-01-20 01:00:28','Atanu Maity'),
201 (13,'1','CUSTOMER','2018-01-20 01:32:11','Atanu Maity'),
202 (14,'10001','USER','2018-01-20 01:44:15','Aditya Maity'),
203 (15,'10001','USER','2018-01-20 09:39:41','Aditya Maity'),
204 (16,'10001','USER','2018-01-20 10:14:25','Aditya Maity'),
205 (17,'10001','USER','2018-01-20 10:54:29','Aditya Maity'),
206 (18,'10001','USER','2018-01-20 10:54:49','Aditya Maity'),
207 (19,'1','CUSTOMER','2018-01-20 11:11:22','Atanu Maity'),
208 (20,'1','CUSTOMER','2018-01-20 11:19:32','Atanu Maity'),
209 (21,'10001','USER','2018-01-20 11:21:27','Aditya Maity'),
210 (22,'10001','USER','2018-01-20 11:50:54','Aditya Maity'),
211 (23,'1','CUSTOMER','2018-01-20 11:59:51','Atanu Maity'),
212 (24,'1','CUSTOMER','2018-01-20 12:11:30','Atanu Maity'),
213 (25,'10001','USER','2018-01-20 12:18:42','Puja Thacker'),
214 (26,'10001','USER','2018-01-20 12:21:39','Puja Thacker'),
215 (27,'10001','USER','2018-01-20 12:24:51','Puja Thacker'),
216 (28,'3','CUSTOMER','2018-01-20 12:30:47','Rohit Sharma'),
217 (29,'10001','USER','2018-01-20 12:31:43','Puja Thacker'),
218 (30,'3','CUSTOMER','2018-01-20 12:33:21','Rohit Sharma'),
219 (31,'4','CUSTOMER','2018-01-20 15:28:13','Saurav Ganguly'),
220 (32,'3','CUSTOMER','2018-01-20 15:28:33','Rohit Sharma'),
221 (33,'1','CUSTOMER','2018-01-20 15:31:36','Sachin Tendulkar'),
222 (34,'10001','USER','2018-01-20 15:37:36','Puja Thacker');
223/*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
224
225
226--
227-- Definition of table `receipt_master`
228--
229
230DROP TABLE IF EXISTS `receipt_master`;
231CREATE TABLE `receipt_master` (
232 `r_id` int(11) default NULL,
233 `loan_id` int(11) default NULL,
234 `loan_emi_date` datetime default NULL,
235 `r_amount` int(11) default NULL,
236 `r_late_fine` int(11) default NULL,
237 `r_date` datetime default NULL,
238 `r_entry_by` int(11) default NULL,
239 `r_entry_date` datetime default NULL,
240 `r_modify_by` int(11) default NULL,
241 `r_modify_date` datetime default NULL,
242 KEY `Index_1` (`r_id`)
243) ENGINE=InnoDB DEFAULT CHARSET=latin1;
244
245--
246-- Dumping data for table `receipt_master`
247--
248
249/*!40000 ALTER TABLE `receipt_master` DISABLE KEYS */;
250INSERT INTO `receipt_master` (`r_id`,`loan_id`,`loan_emi_date`,`r_amount`,`r_late_fine`,`r_date`,`r_entry_by`,`r_entry_date`,`r_modify_by`,`r_modify_date`) VALUES
251 (1,1,'2018-01-20 11:50:38',NULL,0,'2018-01-20 11:50:38',10001,'2018-01-20 11:50:38',NULL,NULL),
252 (2,1,'2018-01-20 11:52:24',10000,0,'2018-01-20 11:52:24',10001,'2018-01-20 11:52:24',NULL,NULL),
253 (3,3,'2018-01-20 12:32:58',15000,0,'2018-01-20 12:32:58',10001,'2018-01-20 12:32:58',NULL,NULL);
254/*!40000 ALTER TABLE `receipt_master` ENABLE KEYS */;
255
256
257--
258-- Definition of table `user_master`
259--
260
261DROP TABLE IF EXISTS `user_master`;
262CREATE TABLE `user_master` (
263 `user_id` int(11) NOT NULL default '0',
264 `user_name` varchar(50) default NULL,
265 `user_password` varchar(50) default NULL,
266 `user_type` varchar(50) default NULL,
267 `user_active` int(11) default NULL,
268 `user_department` varchar(50) default NULL,
269 `user_desgination` varchar(50) default NULL,
270 `user_dob` datetime default NULL,
271 `user_address` varchar(255) default NULL,
272 `user_contact_no` varchar(50) default NULL,
273 `user_email_id` varchar(100) default NULL,
274 `create_date` datetime default NULL,
275 `create_by` int(11) default NULL,
276 `last_pass_chg_date` datetime default NULL,
277 `last_login1` datetime default NULL,
278 `last_login2` datetime default NULL,
279 PRIMARY KEY USING BTREE (`user_id`)
280) ENGINE=InnoDB DEFAULT CHARSET=latin1;
281
282--
283-- Dumping data for table `user_master`
284--
285
286/*!40000 ALTER TABLE `user_master` DISABLE KEYS */;
287INSERT INTO `user_master` (`user_id`,`user_name`,`user_password`,`user_type`,`user_active`,`user_department`,`user_desgination`,`user_dob`,`user_address`,`user_contact_no`,`user_email_id`,`create_date`,`create_by`,`last_pass_chg_date`,`last_login1`,`last_login2`) VALUES
288 (10001,'Puja Thacker','1','ADMIN',1,'IT','Manager','2001-01-01 00:00:00','Mumbai','9952525252','puja.t@gamil.com',NULL,NULL,NULL,'2018-01-15 09:10:00',NULL),
289 (10002,'Atanu Maity','123456','USER',1,'Finance','Manager',NULL,NULL,'1234567989','atanu.maity@rediffmail.com','2018-01-19 21:11:32',10001,NULL,'2018-01-15 09:10:00',NULL),
290 (10003,'Neha K','123456','USER',1,'IT','Manager',NULL,NULL,'9898989898','Neha.k@rediffmail.com','2018-01-20 12:27:22',10001,NULL,NULL,NULL),
291 (10004,'Mousumi Ghosh','123456','USER',1,'Sales','Asst Manager',NULL,NULL,'9920329254','mou.ghosh@gmail.com','2018-01-20 15:40:33',10001,NULL,NULL,NULL);
292/*!40000 ALTER TABLE `user_master` ENABLE KEYS */;
293
294
295
296
297/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
298/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
299/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
300/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
301/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
302/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
303/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
304