
--
-- Table structure for table `tp_history_change_password`
--

CREATE TABLE `tp_history_change_password` (
  `id_history_password` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(21) NOT NULL DEFAULT '',
  `password` varchar(250) NOT NULL,
  `date_change_password` datetime NOT NULL,
  PRIMARY KEY (`id_history_password`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_history_change_password`
--

INSERT INTO `tp_history_change_password` VALUES (214,'USR-21012580','2d4946d0a2a6ade618c19f855dff351e','2021-02-19 04:36:55'),(215,'USR-21014397','64d011aac07b232c418d5e461bc8a59f','2021-05-19 09:47:29');

--
-- Table structure for table `tp_policy`
--

CREATE TABLE `tp_policy` (
  `policy_id` int(11) NOT NULL,
  `polis_number` varchar(100) NOT NULL,
  `company_id` varchar(21) DEFAULT NULL,
  `policy_inception_date` date NOT NULL,
  `policy_due_date` date NOT NULL,
  `policy_created_by` varchar(50) DEFAULT NULL,
  `policy_created date` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`policy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_policy`
--

INSERT INTO `tp_policy` VALUES (1,'01402202000024','COM003','2021-01-01','2021-12-31','fauzan',NULL,1),(2,'01402202000025','COM001','2021-01-01','2021-12-31','fauzan',NULL,1),(3,'01402202000026','COM004','2021-01-01','2021-12-31','fauzan',NULL,1),(4,'01402202000027','COM005','2021-01-01','2021-12-31','fauzan',NULL,1),(5,'01402202000028','COM002','2021-01-01','2021-12-31','fauzan',NULL,1);

--
-- Table structure for table `tp_quotation_slip`
--

CREATE TABLE `tp_quotation_slip` (
  `quotation_slip_id` varchar(21) NOT NULL,
  `quotation_slip_date` date NOT NULL,
  `quotation_slip_number` varchar(50) DEFAULT NULL,
  `eob_id` varchar(21) DEFAULT NULL,
  `up_name` varchar(50) DEFAULT NULL,
  `quotation_slip_period` varchar(200) DEFAULT 'NULL',
  `batch_number` varchar(20) DEFAULT NULL,
  `verified_by` varchar(21) DEFAULT NULL,
  `verified_dt` datetime DEFAULT NULL,
  `verified_status` tinyint(4) DEFAULT 0,
  `verified_reason` varchar(50) DEFAULT NULL,
  `approved_by` varchar(12) DEFAULT NULL,
  `approved_dt` datetime DEFAULT NULL,
  `approval_status` tinyint(4) DEFAULT 0,
  `approval_reason` varchar(20) DEFAULT NULL,
  `status` int(11) DEFAULT 0 COMMENT '0: ready entry;1:un-posted,100:posted,5: need verification,10: need approval, 3: done',
  `dt_etr` datetime DEFAULT NULL,
  `user_etr` varchar(21) DEFAULT NULL,
  PRIMARY KEY (`quotation_slip_id`,`quotation_slip_date`),
  UNIQUE KEY `quotation_slip_id` (`quotation_slip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_quotation_slip`
--

INSERT INTO `tp_quotation_slip` VALUES ('QL2021020001','2021-02-01','fauzan','AC2021020001','Bapak Karno','PERIODE DESEMBER (Tahap II)','Batch 05','USR-202001002','2021-03-18 12:51:16',1,'ok','USR-20200100','2021-03-18 12:55:14',1,'test',10,'2021-02-26 05:24:38','USR-202001002'),('QL2021030001','2021-03-24','Quotation Letter Number','AC2021030001','Bapak Karno','PERIODE Maret 2021','Batch 08','USR-202001002','2021-03-19 07:53:52',1,'ok','USR-20200100','2021-03-19 07:54:08',1,'sip',10,'2021-03-19 07:53:18','USR-202001002'),('QL2021110001','2021-11-15','001','AC2021110002','Bapak Karno','PERIODE 2021','Batch 001','USR-202001002','2021-11-15 12:18:52',1,'','USR-20200100','2021-11-15 12:19:01',1,'',10,'2021-11-15 12:18:33','USR-202001002');

--
-- Table structure for table `tp_upload_file_name`
--

CREATE TABLE `tp_upload_file_name` (
  `upload_id` varchar(21) NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `user_etr` varchar(21) NOT NULL,
  `dt_etr` datetime NOT NULL,
  PRIMARY KEY (`upload_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_upload_file_name`
--


--
-- Dumping routines for database 'db_fsa2021'
--


