forked from iamshreyas/InsurancePolicyManagement
-
Notifications
You must be signed in to change notification settings - Fork 0
/
finalDB.sql
315 lines (279 loc) · 28.2 KB
/
finalDB.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
-- MySQL dump 10.13 Distrib 5.7.19, for Linux (x86_64)
--
-- Host: localhost Database: lic
-- ------------------------------------------------------
-- Server version 5.7.19-0ubuntu0.16.04.1
/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `agent`
--
DROP TABLE IF EXISTS `agent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent` (
`agent_id` int(11) NOT NULL AUTO_INCREMENT,
`a_uname` varchar(15) DEFAULT NULL,
`a_passwd` varchar(15) DEFAULT NULL,
`a_fname` varchar(15) DEFAULT NULL,
`a_lname` varchar(15) DEFAULT NULL,
`a_phone` varchar(10) DEFAULT NULL,
`a_email` varchar(30) DEFAULT NULL,
`a_addr` varchar(90) DEFAULT NULL,
`image` varchar(50) NOT NULL,
PRIMARY KEY (`agent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agent`
--
LOCK TABLES `agent` WRITE;
/*!40000 ALTER TABLE `agent` DISABLE KEYS */;
INSERT INTO `agent` VALUES (1,'Jay','jay123','Jay','Thanvi','8975871151','[email protected]','Shegaon','images/agent2.jpg'),(2,'Soham','soham123','Soham','Ray','8975871444','[email protected]','S-21, Kubera Colony,<br> NIBM road, Kondhwa, <br>Pune- 411048','images/agent1.jpg'),(3,'Sharan','sharan123','Sharan','Rajani','9875871251','[email protected]','Pune','images/agent3.jpg'),(4,'Shreyas','shreyas123','Shreyas','Waghmare','9545126354','[email protected]','Bhusawal','images/agent4.jpg');
/*!40000 ALTER TABLE `agent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `agent_policy`
--
DROP TABLE IF EXISTS `agent_policy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_policy` (
`agent_id` int(11) NOT NULL,
`pol_no` int(11) NOT NULL,
PRIMARY KEY (`agent_id`,`pol_no`),
KEY `pol_no` (`pol_no`),
CONSTRAINT `agent_policy_ibfk_1` FOREIGN KEY (`agent_id`) REFERENCES `agent` (`agent_id`),
CONSTRAINT `agent_policy_ibfk_2` FOREIGN KEY (`pol_no`) REFERENCES `policy` (`pol_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agent_policy`
--
LOCK TABLES `agent_policy` WRITE;
/*!40000 ALTER TABLE `agent_policy` DISABLE KEYS */;
INSERT INTO `agent_policy` VALUES (1,897456123),(2,897456124),(3,897456125),(4,897456126);
/*!40000 ALTER TABLE `agent_policy` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customer`
--
DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
`cust_id` int(11) NOT NULL AUTO_INCREMENT,
`c_uname` varchar(30) NOT NULL,
`c_passwd` varchar(30) NOT NULL,
`c_email` varchar(30) NOT NULL,
`c_phone` varchar(10) NOT NULL,
`c_dob` date DEFAULT NULL,
`c_addr` varchar(90) DEFAULT NULL,
`c_fname` varchar(15) NOT NULL,
`c_mname` varchar(15) DEFAULT NULL,
`c_lname` varchar(15) DEFAULT NULL,
`desig` varchar(10) DEFAULT NULL,
PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customer`
--
LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (1,'Akash','akash123','[email protected]','9422926454','1996-05-25','Katraj','Akash','Avinash','Kathole','Mr.'),(2,'Bhushan','bhushan123','[email protected]','7787945124','1997-04-14','Ambegaon','Bhushan','Amey','Gujrathi','Mr.'),(3,'Chaitraj','chaitraj123','[email protected]','7787777124','1998-12-21','Chinchwad','Chaitraj','Vishal','Mete','Mr.'),(4,'Dinesh','dines123','[email protected]','8484339026','1997-09-11','Shaniwarwada','Dinesh','Lalit','Bohra','Mr.'),(5,'Dilip','dilip123','[email protected]','8989897544','1998-12-05','Thane','Dilip','Vishwanath','Joshi','Mr.'),(6,'Jayesh','9881107600','[email protected]','9881107600','2017-02-02','PICT, PICT,Pune','Jayesh','Naresh','Oswal','Mr.'),(7,'motish','motish123','[email protected]','8974561254','1997-05-03','Pune','Motish','Ashokkumar','Mehta','Mr.'),(8,'shradha','shradha123','[email protected]','7894561255','1997-12-04','Mumbai','Shradha','Om','Jaiswal','Mrs.'),(9,'abhi','abhi123','[email protected]','985647123','1993-08-05','Solapur','Abhinay','Abhiraj','Dhamankar','Master'),(10,'sheela','sheela123','[email protected]','9874561230','1972-11-02','Akola','Sheela','Abhinay','Dhanokar','Miss'),(11,'ashu','ashu123','[email protected]','9513574260','1998-11-11','Ahmednagar','Ashutosh','Prakash','Shinde','Mr.'),(12,'sam','sam123','[email protected]','8974561230','1998-02-01','Akola','Sameer','Kiran','Kulkarni','Mr.'),(13,'shubham','shubham123','[email protected]','7788994455','1998-05-01','Yavatmal','Shubham','Vinod','Shahu','Mr.'),(14,'tanmay','tanu123','[email protected]','9966558877','1996-06-18','Bhusaval','Tanmay','Vishal','Jaiswal','Master'),(15,'suyog','suyog123','[email protected]','7744556627','1996-12-09','Delhi','Suyog','Sammer','Bhise','Mr.'),(16,'sagar','sagar123','[email protected]','7788441122','1995-05-04','Beed,Ahmednagar','Sagar','Babasaheb','Ware','Mr.'),(17,'vishal','vishal123','[email protected]','8452125630','1994-09-04','Amravati','Vishal','Raju','Thanvi','Mr.'),(18,'shreya','shreya123','[email protected]','7896541203','1989-08-09','Bhelapur','Shreya','Vijay','Chavan','Miss'),(19,'aaryan','aaryan123','[email protected]','7744112200','1990-12-11','Nashik','Aaryan','Sanjay','Pawar','Master'),(20,'sansa','sansa','[email protected]','9632587410','1970-05-04','Winterfell','Sansa','Ned','Stark','Mrs.');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customer_agent_policy`
--
DROP TABLE IF EXISTS `customer_agent_policy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_agent_policy` (
`cust_id` int(11) NOT NULL,
`agent_id` int(11) NOT NULL,
`pol_no` int(11) NOT NULL,
PRIMARY KEY (`cust_id`,`agent_id`,`pol_no`),
KEY `cust_id` (`cust_id`),
KEY `agent_id` (`agent_id`),
KEY `pol_no` (`pol_no`),
CONSTRAINT `agent_id` FOREIGN KEY (`agent_id`) REFERENCES `agent` (`agent_id`),
CONSTRAINT `cust_id` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`cust_id`),
CONSTRAINT `customer_agent_policy_ibfk_1` FOREIGN KEY (`pol_no`) REFERENCES `policy` (`pol_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customer_agent_policy`
--
LOCK TABLES `customer_agent_policy` WRITE;
/*!40000 ALTER TABLE `customer_agent_policy` DISABLE KEYS */;
INSERT INTO `customer_agent_policy` VALUES (1,1,897456123),(1,1,897456124),(1,1,897456126),(2,2,897456123),(2,2,897456124),(2,2,897456126),(3,3,897456125),(4,4,897456124),(4,4,897456125),(5,4,897456126),(6,4,897456125),(7,1,897456124),(7,1,897456126),(8,1,897456125),(9,1,897456125),(10,1,897456123),(10,1,897456126),(11,2,897456126),(12,2,897456123),(12,2,897456126),(13,2,897456124),(14,3,897456123),(14,3,897456125),(15,3,897456123),(16,3,897456124),(16,3,897456126),(17,3,897456123),(17,3,897456124),(17,3,897456125),(18,4,897456124),(18,4,897456125),(19,4,897456126),(20,4,897456123),(20,4,897456124);
/*!40000 ALTER TABLE `customer_agent_policy` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger deletefromcustomerpolicy BEFORE delete on customer_agent_policy
for each row
begin
delete from customer_policy where customer_policy.pol_no=old.pol_no and customer_policy.cust_id=old.cust_id;
end */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
--
-- Table structure for table `customer_policy`
--
DROP TABLE IF EXISTS `customer_policy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_policy` (
`cust_id` int(11) NOT NULL,
`pol_no` int(11) NOT NULL,
`prem_sdate` date DEFAULT NULL,
`prem_edate` date DEFAULT NULL,
`prem_pdate` date DEFAULT NULL,
PRIMARY KEY (`cust_id`,`pol_no`),
KEY `pol_no` (`pol_no`),
CONSTRAINT `customer_policy_ibfk_1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`cust_id`),
CONSTRAINT `customer_policy_ibfk_2` FOREIGN KEY (`pol_no`) REFERENCES `policy` (`pol_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customer_policy`
--
LOCK TABLES `customer_policy` WRITE;
/*!40000 ALTER TABLE `customer_policy` DISABLE KEYS */;
INSERT INTO `customer_policy` VALUES (1,897456123,'2017-09-12','2018-09-12','2018-01-05'),(1,897456124,'2017-08-05','2032-09-10','2017-09-10'),(1,897456126,'2017-08-05','2053-09-10','2017-09-10'),(2,897456123,'2017-02-25','2019-02-20','2018-06-26'),(2,897456124,'2017-04-10','2032-05-15','2017-05-15'),(2,897456126,'2017-04-10','2053-05-15','2017-07-15'),(3,897456125,'2017-02-19','2017-11-19','2018-05-05'),(4,897456124,'2017-02-26','2019-08-26','2017-09-26'),(4,897456125,'2017-03-30','2019-08-30','2017-09-30'),(5,897456126,'2017-02-24','2019-08-24','2017-09-24'),(6,897456125,'2017-10-03','2026-11-08','2017-11-08'),(7,897456124,'2017-10-07','2032-11-12','2017-11-12'),(7,897456126,'2017-10-07','2053-11-12','2017-11-12'),(8,897456125,'2017-10-10','2026-11-15','2017-12-15'),(9,897456125,'2017-08-05','2026-09-10','2017-09-10'),(10,897456123,'2017-08-05','2029-09-10','2017-09-10'),(10,897456126,'2017-08-05','2053-09-10','2017-09-10'),(11,897456126,'2017-04-20','2053-05-25','2017-05-25'),(12,897456123,'2017-04-21','2029-05-26','2017-09-26'),(12,897456126,'2017-05-21','2053-06-26','2017-06-26'),(13,897456124,'2017-04-21','2032-05-26','2017-05-26'),(14,897456123,'2017-05-21','2029-06-26','2017-10-26'),(14,897456125,'2017-05-21','2026-06-26','2017-06-26'),(15,897456123,'2017-05-21','2029-06-26','2017-06-26'),(16,897456124,'2017-05-21','2032-06-26','2017-07-26'),(16,897456126,'2017-07-17','2053-08-22','2017-08-22'),(17,897456123,'2017-07-17','2029-08-22','2017-10-22'),(17,897456124,'2017-07-17','2032-08-22','2017-08-22'),(17,897456125,'2017-07-17','2026-08-22','2017-10-22'),(18,897456124,'2017-07-30','2032-09-04','2017-09-04'),(18,897456125,'2017-07-30','2026-09-04','2017-09-04'),(19,897456126,'2017-07-30','2053-09-04','2017-09-04'),(20,897456123,'2017-07-30','2029-09-04','2017-09-04'),(20,897456124,'2017-07-30','2032-09-04','2017-09-04');
/*!40000 ALTER TABLE `customer_policy` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payment`
--
DROP TABLE IF EXISTS `payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment` (
`trans_no` int(11) NOT NULL AUTO_INCREMENT,
`cust_id` int(11) NOT NULL,
`agent_id` int(11) NOT NULL,
`date` date DEFAULT NULL,
`amt` decimal(11,2) DEFAULT NULL,
`pol_no` int(11) NOT NULL,
`commision` int(11) DEFAULT NULL,
`sdate` date DEFAULT NULL,
`edate` date DEFAULT NULL,
PRIMARY KEY (`trans_no`),
KEY `cust_id` (`cust_id`),
KEY `agent_id` (`agent_id`),
KEY `pol_no` (`pol_no`),
CONSTRAINT `payment_ibfk_1` FOREIGN KEY (`cust_id`) REFERENCES `customer` (`cust_id`),
CONSTRAINT `payment_ibfk_2` FOREIGN KEY (`agent_id`) REFERENCES `agent` (`agent_id`),
CONSTRAINT `payment_ibfk_3` FOREIGN KEY (`pol_no`) REFERENCES `policy` (`pol_no`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payment`
--
LOCK TABLES `payment` WRITE;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
INSERT INTO `payment` VALUES (18,1,1,'2017-10-07',5250.00,897456123,250,'2017-11-05','2017-12-05'),(19,8,1,'2017-10-10',1050.00,897456125,70,'2017-11-15','2017-12-15'),(20,1,1,'2017-08-05',5250.00,897456123,250,'2017-12-05','2018-01-05'),(21,2,2,'2017-04-21',52500.00,897456126,1500,'2017-05-15','2017-06-15'),(22,12,2,'2017-04-21',5250.00,897456123,250,'2017-05-26','2017-06-26'),(23,3,3,'2017-05-21',1050.00,897456125,70,'2017-10-05','2017-11-05'),(24,3,3,'2017-05-21',1050.00,897456125,70,'2017-11-05','2017-12-05'),(25,14,3,'2017-05-21',5250.00,897456123,250,'2017-06-26','2017-07-26'),(26,16,3,'2017-05-21',10500.00,897456124,500,'2017-06-26','2017-07-26'),(27,2,2,'2017-07-30',53550.00,897456126,1500,'2017-06-15','2017-07-15'),(28,2,2,'2017-07-30',5250.00,897456123,250,'2017-10-26','2017-11-26'),(29,2,2,'2017-07-30',5250.00,897456123,250,'2017-11-26','2017-12-26'),(30,2,2,'2017-07-30',5250.00,897456123,250,'2017-12-26','2018-01-26'),(31,2,2,'2017-07-30',5250.00,897456123,250,'2018-01-26','2018-02-26'),(32,2,2,'2017-07-30',5250.00,897456123,250,'2018-02-26','2018-03-26'),(33,2,2,'2017-07-30',5250.00,897456123,250,'2018-03-26','2018-04-26'),(34,2,2,'2017-07-30',5250.00,897456123,250,'2018-04-26','2018-05-26'),(35,2,2,'2017-07-30',5250.00,897456123,250,'2018-05-26','2018-06-26'),(36,12,2,'2017-07-30',5512.50,897456123,250,'2017-06-26','2017-07-26'),(37,12,2,'2017-07-30',5512.50,897456123,250,'2017-07-26','2017-08-26'),(38,12,2,'2017-07-30',5250.00,897456123,250,'2017-08-26','2017-09-26'),(39,14,3,'2017-10-10',5512.50,897456123,250,'2017-07-26','2017-08-26'),(40,14,3,'2017-10-10',5512.50,897456123,250,'2017-08-26','2017-09-26'),(41,14,3,'2017-10-10',5512.50,897456123,250,'2017-09-26','2017-10-26'),(42,3,3,'2017-10-10',1050.00,897456125,70,'2017-12-05','2018-01-05'),(43,3,3,'2017-10-10',1050.00,897456125,70,'2018-01-05','2018-02-05'),(44,3,3,'2017-10-10',1050.00,897456125,70,'2018-02-05','2018-03-05'),(45,3,3,'2017-10-10',1050.00,897456125,70,'2018-03-05','2018-04-05'),(46,3,3,'2017-10-10',1050.00,897456125,70,'2018-04-05','2018-05-05'),(47,17,3,'2017-10-10',1207.50,897456125,70,'2017-08-22','2017-09-22'),(48,17,3,'2017-10-10',1207.50,897456125,70,'2017-09-22','2017-10-22'),(49,17,3,'2017-10-10',5512.50,897456123,250,'2017-08-22','2017-09-22'),(50,17,3,'2017-10-10',5512.50,897456123,250,'2017-09-22','2017-10-22');
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger p_date
after insert on payment
for each row
begin
update customer_policy set prem_pdate =(select DATE_ADD(prem_pdate, INTERVAL 1 MONTH)) where customer_policy.cust_id=NEW.cust_id AND customer_policy.pol_no=NEW.pol_no;
end */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
--
-- Table structure for table `policy`
--
DROP TABLE IF EXISTS `policy`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `policy` (
`pol_no` int(11) NOT NULL AUTO_INCREMENT,
`p_name` varchar(30) NOT NULL,
`duration` int(11) DEFAULT NULL,
`late_fee` int(11) DEFAULT NULL,
`premium` int(11) DEFAULT NULL,
`commision` int(11) DEFAULT NULL,
`image` varchar(500) DEFAULT NULL,
PRIMARY KEY (`pol_no`)
) ENGINE=InnoDB AUTO_INCREMENT=897456127 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `policy`
--
LOCK TABLES `policy` WRITE;
/*!40000 ALTER TABLE `policy` DISABLE KEYS */;
INSERT INTO `policy` VALUES (897456123,'Jeevan Utkarsh',12,250,5000,5,'images/plan1.png'),(897456124,'Jeevan Anand',15,500,10000,5,'images/plan2.jpg'),(897456125,'Jeevan Pragati',9,150,1000,7,'images/plan3.jpg'),(897456126,'Jeevan Lakshaya',36,1000,50000,3,'images/plan4.jpg');
/*!40000 ALTER TABLE `policy` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `policy_description`
--
DROP TABLE IF EXISTS `policy_description`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `policy_description` (
`p_name` varchar(30) NOT NULL,
`plan_type` varchar(40) DEFAULT NULL,
`entry_age` varchar(20) DEFAULT NULL,
`premium` int(11) DEFAULT NULL,
`policy_duration` int(5) DEFAULT NULL,
`medical_exam` varchar(30) DEFAULT NULL,
`status` varchar(30) DEFAULT NULL,
`descp` varchar(10000) DEFAULT NULL,
PRIMARY KEY (`p_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `policy_description`
--
LOCK TABLES `policy_description` WRITE;
/*!40000 ALTER TABLE `policy_description` DISABLE KEYS */;
INSERT INTO `policy_description` VALUES ('Jeevan Anand','Participation Endowment Plan','18-50 years',10000,75,'Required','Discontinued','<p style=\"text-align: justify;\"><strong>Salient Features</strong>\r\n </p>\r\n <ul style=\"text-align: justify;\">\r\n <li><strong>Immediate Annuity Plan</strong> – Annuity starts as early as the next month</li>\r\n <li><strong>Single Premium Plan</strong> – “Pay Once, Enjoy Forever”</li>\r\n <li><strong>Minimum purchase price</strong> is Rs.1, 00,000 for offline and Rs.1, 50,000 for online purchase. There is no maximum limit on purchase or annuity.</li>\r\n <li><strong>More Annuity Options</strong> – 7 Options of Annuities to choose from</li>\r\n <li><strong>Annuity payable for life</strong> at a uniform rate till the life assured is alive.</li>\r\n <li><strong>Annuity payable for 5, 10, 15 or 20 years</strong> no matter if the insured person is alive or not, and thereafter as long as the annuitant is alive.</li>\r\n <li><strong>Annuity for life with return of purchase price on death</strong> of the annuitant.</li>\r\n <li><strong>Increasing Annuity </strong>in which the pension is paid till the life assured is alive at an increasing rate of 3% p.a.</li>\r\n <li><strong>Annuity for life with a provision of 50% of the annuity</strong> payable to spouse during his/her lifetime on death of the annuitant.</li>\r\n <li><strong>Annuity for life with a provision of 100% of the annuity</strong> payable to spouse during his/her life time on death of annuitant. The purchase price will be returned on the death of last survivor.</li>\r\n <li><strong>Annuity for life with a provision for 100% of the annuity</strong> payable to the spouse of the annuitant for life on death of the annuitant, with return of purchase price on the death of last survivor</li>\r\n <li><strong>Covers broad range of age</strong> <strong>group</strong> – From 30 years to 85 years</li>\r\n <li><strong>Maturity Benefit</strong> – No maturity benefits are available in this policy.</li>\r\n <li><strong>No medical examination</strong> is required.</li>\r\n <li><strong>Income Tax Benefit</strong> – Although, premiums paid under this policy are exempted from tax under section 80C, but the pension received will be taxable.</li>\r\n <li><strong>No surrender value </strong>shall be payable under this policy.</li>\r\n <li><strong>No loan available </strong>under this plan.</li>\r\n <li><strong>Incentive for online</strong> – Rebate of 1% by way of increase in the basic annuity rate will be available.\r\n <br>\r\n <br>\r\n </li>\r\n </ul>'),('Jeevan Lakshaya','With-Profit Endowment Assurance Plan','18-50',50000,65,'Not Required','Continued','<h2>Key Features and Highlights of LIC Jeevan Lakshya</h2>\r\n\r\n<p>The Jeevan Lakshya plan’s salient features can be mentioned as follows -</p>\r\n<ul>\r\n <li>Sum assured</li>\r\n <ul>\r\n <li>Minimum - Rs. 1,00,000</li>\r\n <li>Maximum - No limit</li>\r\n <li>Multiples - The basic sum assured can be in multiples of Rs. 10,000 only</li>\r\n </ul>\r\n <li>Policy term - 13 to 25 years</li>\r\n <li>Premium payment modes - Premiums for the policy can be paid in yearly, half-yearly, quarterly and monthly periods and an option of Electronic Clearing Service (ECS) is also available, wherein it facilitates an easier option to pay the premiums</li>\r\n <li>Premium payment term - The premium paying term is 3 years less than the policy term, irrespective of whatever term the policy is for</li>\r\n <li>Age of entry</li>\r\n <ul>\r\n <li>Minimum - 18 years (completed)</li>\r\n <li>Maximum - 50 years (nearest birthday)</li>\r\n </ul>\r\n <li>Maximum maturity age - 65 years (nearest birthday)</li>\r\n <li>Bonuses - Being a With-Profits Endowment Assurance plan, this policy garners profits made by the Life Insurance Corporation of India through the Simple Reversionary Bonus and Final Additional Bonus (if applicable) and these are paid out at the end of the maturity period</li>\r\n <li>Optional riders - The policy can have two optional riders</li>\r\n <ul>\r\n <li>LIC Accidental Death and Disability Benefit Rider</li>\r\n <li>LIC New Term Assurance Rider</li>\r\n </ul>\r\n</ul>\r\n'),('Jeevan Pragati','Endowment Plan','18-65 years',1000,12,'Required','DisContinued','<h2 style=\"text-align: justify;\"><strong>Key Features of Jeevan Pragati Policy:</strong></h2>\r\n<p style=\"text-align: justify;\">Let’s now take a look at the key features of the plan:</p>\r\n<ul style=\"text-align: justify;\">\r\n<li>Basic minimum sum assured amount: Rs. 1,50,000</li>\r\n<li>Maximum age at maturity: 65 years</li>\r\n<li>Basic maximum sum assured: No limit (The assured sum on maturity is in multiples of Rs. 10,000)</li>\r\n<li>Minimum entry age for the rider: 18 years</li>\r\n<li>Policy holders qualify for premium paid under section 80C.</li>\r\n<li>The maturity amount is tax free under 10(10D).</li>\r\n<li>The loan facility can be availed when the premium is paid for three years.</li>\r\n<li>Policy can be surrendered after premium is paid for three years.</li>\r\n<li>Insurer accepts the risk from the date of commencement of the policy</li>\r\n<li>Minimum Accident benefit sum assured: Rs 10,000</li>\r\n<li>Maximum Accident Benefit sum assured: Basic sum assured which is subject to the maximum of Rs. 1 crore.</li>\r\n<li>From the date of receipt of the policy bond you will be eligible for a free look period of 15 days. </li>\r\n</ul>\r\n'),('Jeevan Utkarsh','-','6-47 years',7500,12,'NotRequired','Continued','<h2>Key Features</h2>\r\n<ul>\r\n <li>High Risk Cover (10 times of Single Premium)</li>\r\n <li>5,10 or 15 years settlement option</li>\r\n <li>Premium paid is eligible for rebate under 80(C)</li>\r\n <li>Maturity amount will be tax free under 10(10D)</li>\r\n</ul>\r\n\r\n<h2>Plan Parameters</h2>\r\n <table>\r\n <tr>\r\n <th>Age at Entry</th><td>6 Years (Completed)</td>\r\n </tr>\r\n <tr>\r\n <th>Maximum Age at Entry</th>\r\n <td>47 (Nearest Birthday)<br /> <a target=\"_blank\" href=\"http://www.insurance21.in/lic-age-calculator.php\">Calculate your Age</a></td>\r\n </tr>\r\n \r\n <tr>\r\n <th>Premium Paying Mode</th>\r\n <td>One Time (Single Premium)<br /><a href=\"http://www.insurance21.in/premium-calculator/lic-jeevan-utkarsh-plan-846.html\">Calculate Premium</a></td>\r\n </tr>\r\n <tr>\r\n <th>Policy Term</th>\r\n <td>12 Years</td>\r\n </tr><tr><th>Sum Assured</th>\r\n <td>75,000 and above</td>\r\n </tr>\r\n <tr>\r\n <th>Surrender</th>\r\n <td>70% of Single Premium in 1st Policy Year <br />\r\n 90% of Single Premium from 2nd Policy Year</td>\r\n </tr>\r\n <tr>\r\n <th>Loan</th>\r\n <td>Can be Availed after 3 Months </td>\r\n </tr>\r\n</table>\r\n<br />\r\n<h2>Maturity Benefits</h2>\r\n<ul>\r\n<li>On survival of policy holder i.e. completion of 12 year term, maturity will be <b>Sum Assured</b> + <b>Loyalty Addition</b>.</li>\r\n</ul>\r\n\r\n<h2>Death benefits</h2>\r\n<ul>\r\n<li>On death during <b>First Five Years</b> of the policy:</li>\r\n <ul>\r\n <li>\r\n If Death happens <b>before 8 years of Age</b>, then death claim amount will be single premium (excluding Rider premium and GST) without any interest. \r\n </li>\r\n <li>\r\n If Death happens <b>after 8 years of age</b>, then death claim amount will be 10 times of single premium paid (excluding Rider premium and GST). \r\n </li>\r\n </ul>\r\n</ul>\r\n<ul>\r\n<li>On death after 5 years of the policy and before maturity:</li>\r\n <ul>\r\n <li>Death Claim amount will be 10 times of single premium paid (excluding Rider premium and GST) + Loyalty Addition.</li>\r\n </ul>\r\n</ul>\r\n<p><strong>Note: </strong>8 Years is minimum age of risk commencement under this policy and Loyalty Addition is applicable only after 5 years of successful policy term.</p> \r\n<div>\r\n<h2>Jeevan Utkarsh Policy (846) with an Example</h2>\r\n<div>\r\n <div>\r\n <p>Let\'s take and example of Jeevan Utkarsh policy with following details.</p>\r\n <table>\r\n <tr><td><strong>Purchase Year</strong></td><td>2017</td></tr>\r\n <tr><td><strong>Age</strong></td><td>25 Years</td></tr>\r\n <tr><td><strong>Basic Sum Assured</strong></td><td>5,00,000</td></tr>\r\n <tr><td><strong>Premium Paying Term</strong></td><td>1</td></tr>\r\n <tr><td><strong>Policy Term</strong></td><td>12</td></tr>\r\n <tr><td><strong>Premium of Basic Plan (without GST)</strong></td><td>2,62,450</td></tr>\r\n <tr><td><strong>Premium of Basic Plan with AD & DB Rider (without GST)</strong></td><td>2,67,000</td></tr>\r\n </table><br />\r\n </div></div></div>');
/*!40000 ALTER TABLE `policy_description` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-10-10 23:50:26