-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `stock`
--

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

--
-- Table structure for table `outward_stock`
--

CREATE TABLE `outward_stock` (
  `id` int(11) NOT NULL,
  `outward_date` date DEFAULT NULL,
  `given_to` varchar(150) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `outward_stock`
--

INSERT INTO `outward_stock` (`id`, `outward_date`, `given_to`, `item_name`, `qty`, `remarks`) VALUES
(1, '2025-09-07', 'Rane', 'sensor', 3, 'For Rane Project');

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

--
-- Table structure for table `purchase_invoice`
--

CREATE TABLE `purchase_invoice` (
  `id` int(11) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `incoming_date` date DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `courier_charge` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_invoice`
--

INSERT INTO `purchase_invoice` (`id`, `invoice_number`, `incoming_date`, `courier_name`, `courier_charge`, `total_amount`) VALUES
(1, '2131', '2025-09-04', 'wewe', '123.00', '3437.00'),
(2, '4141', '2025-09-08', 'dtdc', '400.00', '15745.00');

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

--
-- Table structure for table `purchase_stock`
--

CREATE TABLE `purchase_stock` (
  `id` int(11) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `incoming_date` date DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `particular_name` varchar(100) DEFAULT NULL,
  `specification` varchar(100) DEFAULT NULL,
  `model_number` varchar(50) DEFAULT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `gst` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_stock`
--

INSERT INTO `purchase_stock` (`id`, `invoice_number`, `incoming_date`, `courier_name`, `item_name`, `particular_name`, `specification`, `model_number`, `qty`, `rate`, `gst`, `total`) VALUES
(1, '2131', '2025-09-04', 'wewe', 'Cabel', 'c', 'cc', 'ccc', '23.00', '15.00', '5.00', '350.00'),
(2, '2131', '2025-09-04', 'wewe', 'sensor', 's', 'ss', 'sss', '21.00', '141.00', '3.00', '2964.00'),
(3, '4141', '2025-09-08', 'dtdc', 'qoqo', 'qo', 'qow', 'oq', '2.00', '89.00', '12.00', '190.00'),
(4, '4141', '2025-09-08', 'dtdc', 'rt', 'rtt', 'rttt', 'rttttt', '8.00', '45.00', '15.00', '375.00'),
(5, '4141', '2025-09-08', 'dtdc', 'we', 'wee', 'weee', 'weeee', '15.00', '23.00', '5.00', '350.00'),
(6, '4141', '2025-09-08', 'dtdc', 'rf', 'rff', 'rfff', 'rffff', '45.00', '15.00', '4.00', '679.00'),
(7, '4141', '2025-09-08', 'dtdc', 'll', 'lll', 'llll', 'lllll', '48.00', '15.00', '7.00', '727.00'),
(8, '4141', '2025-09-08', 'dtdc', 'oo', 'ooo', 'oooo', 'ooooo', '78.00', '79.00', '6.00', '6168.00'),
(9, '4141', '2025-09-08', 'dtdc', 'pp', 'ppp', 'pppp', 'ppppp', '75.00', '4.00', '5.00', '305.00'),
(10, '4141', '2025-09-08', 'dtdc', 'yy', 'yyy', 'yyyy', 'yyyyyy', '65.00', '7.00', '2.00', '457.00'),
(11, '4141', '2025-09-08', 'dtdc', 'ii', 'iii', 'iiii', 'iiiii', '7.00', '7.00', '4.00', '53.00'),
(12, '4141', '2025-09-08', 'dtdc', 't', 'tt', 'ttt', 'ttttt', '5.00', '5.00', '5.00', '30.00'),
(13, '4141', '2025-09-08', 'dtdc', 'e', 'ee', 'eee', 'eeee', '8.00', '8.00', '5.00', '69.00'),
(14, '4141', '2025-09-08', 'dtdc', 'f', 'ff', 'fff', 'ffff', '6.00', '6.00', '5.00', '41.00'),
(15, '4141', '2025-09-08', 'dtdc', 'g', 'gg', 'ggg', 'gggg', '75.00', '75.00', '4.00', '5629.00'),
(16, '4141', '2025-09-08', 'dtdc', 'k', 'kk', 'kkk', 'kkkk', '52.00', '5.00', '12.00', '272.00');

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

--
-- Table structure for table `purchase_stock1`
--

CREATE TABLE `purchase_stock1` (
  `id` int(11) NOT NULL,
  `invoice_number` varchar(50) DEFAULT NULL,
  `incoming_date` date DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `particular_name` varchar(100) DEFAULT NULL,
  `specification` varchar(200) DEFAULT NULL,
  `model_number` varchar(100) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `gst` decimal(10,2) DEFAULT NULL,
  `courier_charge` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `purchase_stock1`
--

INSERT INTO `purchase_stock1` (`id`, `invoice_number`, `incoming_date`, `courier_name`, `item_name`, `particular_name`, `specification`, `model_number`, `qty`, `rate`, `gst`, `courier_charge`, `total`) VALUES
(1, '123', '2025-09-05', 'dddwe', 'sdsdfsd', 'sfdf', 'sdfs', 'sfd', 32, '321.00', '18.00', '300.00', '10590.00'),
(2, '22342', '2025-09-06', 'ere', 'Esp32', 'fdff', 'fdfr', 'fdrfer', 32, '350.00', '18.00', '200.00', '11418.00'),
(3, '225', '2025-09-05', 'dtdc', 'ic', '7805', 'p cha', 'strgh', 10, '75.00', '18.00', '500.00', '1268.00'),
(4, '255', '2025-09-05', 'dtdc', 'ic', '8974', 'fsdf', 'rwerg', 21, '75.00', '4.00', '400.00', '1979.00'),
(5, '2123', '2025-09-05', 'dtdc', 'ic', '324', 'wer', 'rwe', 23, '76.00', '18.00', '323.00', '2089.00'),
(6, '4545', '2025-09-05', 'dtdc', 'Esp32', 'esp', '32', '32-123', 5, '350.00', '15.00', '500.00', '2265.00'),
(7, '4545', '2025-09-05', 'dtdc', 'Board', 'es123', '3223', '32-9098', 3, '120.00', '6.00', '500.00', '866.00'),
(8, '4545', '2025-09-05', 'dtdc', 'Multimeter', 'mm', 'mmtt', 'mt-3241', 4, '150.00', '7.00', '500.00', '1107.00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `outward_stock`
--
ALTER TABLE `outward_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchase_invoice`
--
ALTER TABLE `purchase_invoice`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice_number` (`invoice_number`);

--
-- Indexes for table `purchase_stock`
--
ALTER TABLE `purchase_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchase_stock1`
--
ALTER TABLE `purchase_stock1`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `outward_stock`
--
ALTER TABLE `outward_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `purchase_invoice`
--
ALTER TABLE `purchase_invoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `purchase_stock`
--
ALTER TABLE `purchase_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `purchase_stock1`
--
ALTER TABLE `purchase_stock1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

