-- http://www.phpmyadmin.net
--




-- --------------------------------------------------------

--
-- Table structure for table `tbl_boq_details`
--

CREATE TABLE IF NOT EXISTS `tbl_boq_details` (
`ID` int(11) NOT NULL,
  `REF_CON_ID` int(11) NOT NULL,
  `ANAME` varchar(200) NOT NULL,
  `SANAME` varchar(200) NOT NULL,
  `PONO` varchar(200) NOT NULL,
  `DOC` varchar(20) NOT NULL,
  `SDATE` varchar(20) NOT NULL,
  `EDATE` varchar(20) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `STAT` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_boq_details`
--

INSERT INTO `tbl_boq_details` (`ID`, `REF_CON_ID`, `ANAME`, `SANAME`, `PONO`, `DOC`, `SDATE`, `EDATE`, `CDATE`, `STAT`) VALUES
(1, 1, 'Unitech Power Limited', 'P J Associates', 'LOL/LOA:-UPL/MOUDA/2020-21/TD-499', '24-07-2020', '24-07-2020', '23-07-2022', '2020-08-01 17:03:45', 1),
(2, 2, 'Unitech Power Limited', 'Anay Electricals', 'LOL/LOA:-UPL/MOUDA/2020-21/TD-499', '24-07-2020', '24-07-2020', '23-07-2022', '2020-07-24 16:13:19', 1),
(3, 3, 'UPL', 'P J Assciates', 'Mouda/123', '25-07-2020', '25-07-2020', '24-07-2022', '2020-07-25 05:15:18', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_boq_items`
--

CREATE TABLE IF NOT EXISTS `tbl_boq_items` (
`ID` int(11) NOT NULL,
  `REF_CON_ID` int(11) NOT NULL,
  `SINO` varchar(50) NOT NULL,
  `DESCRIPTION` varchar(400) NOT NULL,
  `QTY` double(16,2) NOT NULL,
  `UNIT` varchar(50) NOT NULL,
  `RATE` double(16,2) NOT NULL,
  `AMOUNT` double(16,2) NOT NULL,
  `TYPE` varchar(50) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_boq_items`
--

INSERT INTO `tbl_boq_items` (`ID`, `REF_CON_ID`, `SINO`, `DESCRIPTION`, `QTY`, `UNIT`, `RATE`, `AMOUNT`, `TYPE`, `CDATE`) VALUES
(1, 1, '60.10', 'Cleaning of Road and Pedestrian way', 22.00, 'PM', 168480.00, 4843520.00, 'Work', '2020-08-01 12:05:38'),
(2, 1, '60.20', 'Cleaning of all Drains', 22.00, 'PM', 45000.00, 10800000.00, 'Consume', '2020-08-01 12:05:45'),
(3, 1, '60.30', 'Cleaning on road side drain', 4000.00, 'M', 3.03, 12120.00, '', '2020-07-25 12:44:01'),
(4, 1, '60.40', 'Cleaning, Uplifting', 1200.00, 'EA', 525.00, 630000.00, '', '2020-07-25 12:44:11'),
(5, 1, '60.50', 'Clean and Uplifting', 400.00, 'EA', 1100.00, 440000.00, '', '2020-07-25 12:44:17'),
(6, 3, '60.10', 'Cleaning Road & Pedestrain', 22.00, 'Per month', 168480.00, 4043520.00, '', '2020-07-25 05:16:11');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_boq_sub_items`
--

CREATE TABLE IF NOT EXISTS `tbl_boq_sub_items` (
`ID` int(11) NOT NULL,
  `REF_CON_ID` int(11) NOT NULL,
  `REF_SRNO_ID` int(11) NOT NULL,
  `BOQ_DESC` varchar(400) NOT NULL,
  `FREQUENCY` varchar(100) NOT NULL,
  `AREA` double(16,2) NOT NULL,
  `TOTAL_AREA` double(16,2) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_boq_sub_items`
--

INSERT INTO `tbl_boq_sub_items` (`ID`, `REF_CON_ID`, `REF_SRNO_ID`, `BOQ_DESC`, `FREQUENCY`, `AREA`, `TOTAL_AREA`, `CDATE`) VALUES
(1, 1, 1, 'Gate No.2', '30', 14478.00, 434340.00, '2020-07-26 15:43:55'),
(2, 1, 1, 'Hospital', '30', 14478.00, 434340.00, '2020-07-26 14:38:21'),
(3, 1, 2, 'HOP Bunglow Drain', '30', 149.00, 2090.00, '2020-07-26 14:59:50'),
(4, 1, 2, 'School Play ground drain', '2', 149.30, 248.60, '2020-07-26 15:06:44'),
(5, 1, 2, 'METAL ROAD', '2', 361.40, 722.80, '2020-07-26 15:12:42'),
(6, 1, 0, '', '1', 1.00, 1.00, '2020-07-26 15:16:20'),
(7, 1, 5, 'TEST', '30', 14478.00, 434340.00, '2020-07-26 17:15:17'),
(8, 1, 3, 'TEST', '30', 14478.00, 434340.00, '2020-07-26 17:15:42'),
(9, 1, 5, 'Aniket Mahakalkar', '2', 14478.00, 28956.00, '2020-07-26 17:17:10'),
(10, 1, 4, 'test213', '15', 32.00, 480.00, '2020-07-26 17:16:14'),
(11, 1, 3, 'Swapnal', '30', 149.30, 4479.00, '2020-07-26 17:19:14'),
(12, 1, 2, 'SDJFKWEI', '15', 12.00, 180.00, '2020-07-26 17:16:48');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_contract`
--

CREATE TABLE IF NOT EXISTS `tbl_contract` (
`ID` int(11) NOT NULL,
  `CON_TYPE` varchar(200) NOT NULL,
  `CON_ABBR` varchar(20) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contract`
--

INSERT INTO `tbl_contract` (`ID`, `CON_TYPE`, `CON_ABBR`, `CDATE`) VALUES
(1, 'House Keeping', 'HSK', '2020-07-17 06:30:03'),
(2, 'Electrical Contract', 'EE', '2020-07-17 06:30:15'),
(3, 'Horticulture', 'HOR', '2020-07-17 06:34:47'),
(4, 'Carpetry', 'CAR', '2020-07-17 09:22:42'),
(5, 'Water Supply', 'WSU', '2020-07-25 05:14:05'),
(6, 'Pest Control', 'PEC', '2020-08-01 14:52:12');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_contractor`
--

CREATE TABLE IF NOT EXISTS `tbl_contractor` (
`ID` int(11) NOT NULL,
  `AG_NAME` varchar(250) NOT NULL,
  `CON_NAME` varchar(200) NOT NULL,
  `PAN_NO` varchar(50) NOT NULL,
  `VENDOR_CODE` varchar(50) NOT NULL,
  `EMAIL` varchar(150) NOT NULL,
  `MOBILE` varchar(20) NOT NULL,
  `NATURE` varchar(400) NOT NULL,
  `REMARKS` varchar(400) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contractor`
--

INSERT INTO `tbl_contractor` (`ID`, `AG_NAME`, `CON_NAME`, `PAN_NO`, `VENDOR_CODE`, `EMAIL`, `MOBILE`, `NATURE`, `REMARKS`, `CDATE`) VALUES
(1, 'P J Associates', 'Prashant Jane', 'BBQPM45398A', '83789ANTPC2020', 'pjmouda@rediffmail.com', '9890976455', 'Horticulture', 'NTPC township Mouda', '2020-08-01 16:42:50'),
(2, 'Anicom Solutions', 'Aniket Mahakalkar', 'BBQPM1903A', '', 'aniketmahakalkar@gmail.com', '9890976455', 'Web Application', 'NTPC Mouda Township ', '2020-08-01 16:54:15');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_frequency`
--

CREATE TABLE IF NOT EXISTS `tbl_frequency` (
`ID` int(11) NOT NULL,
  `FRQ` varchar(100) NOT NULL,
  `DAYS` int(11) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_frequency`
--

INSERT INTO `tbl_frequency` (`ID`, `FRQ`, `DAYS`, `CDATE`) VALUES
(1, 'Per Day', 30, '2020-07-25 18:14:27'),
(2, 'Alternate Day', 15, '2020-07-25 18:14:41'),
(3, 'Twice', 2, '2020-07-25 18:16:59'),
(4, 'Once', 1, '2020-07-25 18:14:55'),
(5, 'On Demand', 1, '2020-07-25 18:17:14');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_team`
--

CREATE TABLE IF NOT EXISTS `tbl_team` (
`ID` int(11) NOT NULL,
  `TNAME` varchar(200) NOT NULL,
  `REMARKS` varchar(200) NOT NULL,
  `CDATE` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_units`
--

CREATE TABLE IF NOT EXISTS `tbl_units` (
`ID` int(11) NOT NULL,
  `UNIT` varchar(100) NOT NULL,
  `UNIT_ABBR` varchar(50) NOT NULL,
  `CDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_units`
--

INSERT INTO `tbl_units` (`ID`, `UNIT`, `UNIT_ABBR`, `CDATE`) VALUES
(1, 'Per Month', 'PM', '2020-07-25 12:27:08'),
(2, 'Each', 'EA', '2020-07-25 12:12:10'),
(3, 'Meter', 'M', '2020-07-25 12:12:38'),
(4, 'Square Meter', 'M2', '2020-07-25 12:12:56'),
(5, 'Cubic Meter', 'M3', '2020-07-25 12:13:13'),
(6, 'Litre', 'L', '2020-07-25 12:13:22'),
(7, 'kilogram', 'KG', '2020-07-25 12:13:46'),
(8, 'Per Day', 'Day', '2020-07-25 12:14:01'),
(9, 'Lumsum', 'LPS', '2020-07-25 12:14:11');

--
-- Indexes for table `tbl_boq_details`
--
ALTER TABLE `tbl_boq_details`
 ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `REF_CON_ID` (`REF_CON_ID`);

--
-- Indexes for table `tbl_boq_items`
--
ALTER TABLE `tbl_boq_items`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_boq_sub_items`
--
ALTER TABLE `tbl_boq_sub_items`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_contract`
--
ALTER TABLE `tbl_contract`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_contractor`
--
ALTER TABLE `tbl_contractor`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_frequency`
--
ALTER TABLE `tbl_frequency`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_team`
--
ALTER TABLE `tbl_team`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tbl_units`
--
ALTER TABLE `tbl_units`
 ADD PRIMARY KEY (`ID`);
--
-- AUTO_INCREMENT for table `tbl_boq_details`
--
ALTER TABLE `tbl_boq_details`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tbl_boq_items`
--
ALTER TABLE `tbl_boq_items`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tbl_boq_sub_items`
--
ALTER TABLE `tbl_boq_sub_items`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `tbl_contract`
--
ALTER TABLE `tbl_contract`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tbl_contractor`
--
ALTER TABLE `tbl_contractor`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tbl_frequency`
--
ALTER TABLE `tbl_frequency`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tbl_team`
--
ALTER TABLE `tbl_team`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tbl_units`
--
ALTER TABLE `tbl_units`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
