-- MySQL dump 10.13  Distrib 8.0.36, for Win64 (x86_64)
--
-- Host: localhost    Database: erp
-- ------------------------------------------------------
-- Server version	5.5.25a

/*!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 */;
/*!50503 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 `acc_status_master`
--

DROP TABLE IF EXISTS `acc_status_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `acc_status_master` (
  `status` varchar(95) NOT NULL,
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `account_type_master_table`
--

DROP TABLE IF EXISTS `account_type_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_type_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `account_type` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `accounting_year_table`
--

DROP TABLE IF EXISTS `accounting_year_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounting_year_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `account_year` varchar(45) DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `additional_feilds_settings_template_table`
--

DROP TABLE IF EXISTS `additional_feilds_settings_template_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `additional_feilds_settings_template_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `settings_name` varchar(95) DEFAULT NULL,
  `id` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `visible` varchar(45) DEFAULT 'No',
  `default_value` varchar(95) DEFAULT NULL,
  `combo_items` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `admin_settings_table`
--

DROP TABLE IF EXISTS `admin_settings_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_settings_table` (
  `tid` int(11) NOT NULL,
  `settings_name` varchar(75) DEFAULT NULL,
  `visible_status` varchar(45) DEFAULT 'false',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `agent_master_table`
--

DROP TABLE IF EXISTS `agent_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agent_master_table` (
  `agent_name` varchar(200) NOT NULL,
  `commession_percentage` decimal(10,2) DEFAULT NULL,
  `contact_no` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`agent_name`),
  UNIQUE KEY `tid_UNIQUE` (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `amc_last_update`
--

DROP TABLE IF EXISTS `amc_last_update`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `amc_last_update` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `enquiry_id` int(11) DEFAULT NULL,
  `last_update_date` date DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `enq_fk_main_call_idx` (`tid`),
  KEY `enq_fk_main_call` (`enquiry_id`),
  CONSTRAINT `amc_fk_main_call` FOREIGN KEY (`enquiry_id`) REFERENCES `amc_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `amc_table`
--

DROP TABLE IF EXISTS `amc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `amc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `data_date` date DEFAULT NULL,
  `source` varchar(90) DEFAULT NULL,
  `tele_caller` varchar(90) DEFAULT NULL,
  `customer_name` varchar(90) DEFAULT NULL,
  `company_name` varchar(90) DEFAULT NULL,
  `street_address` text,
  `city` varchar(90) DEFAULT NULL,
  `state` varchar(90) DEFAULT NULL,
  `contact_no` text,
  `email` text,
  `requirment` varchar(120) DEFAULT NULL,
  `feedback` text,
  `appoinment_date` date DEFAULT NULL,
  `process_status` varchar(90) DEFAULT NULL,
  `other_details` text,
  `priority` varchar(90) DEFAULT NULL,
  `last_update_date` date DEFAULT NULL,
  `gstin` varchar(45) DEFAULT NULL,
  `dealer_name` varchar(90) DEFAULT NULL,
  `deal_value` decimal(10,2) DEFAULT NULL,
  `lead_stage` varchar(90) DEFAULT NULL,
  `deal_close_date` date DEFAULT NULL,
  `order_qty` decimal(10,3) DEFAULT NULL,
  `date_of_delivery` date DEFAULT NULL,
  `attachment_url` text,
  `lead_category` date DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_attachment_table`
--

DROP TABLE IF EXISTS `asset_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `notes` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `asset_attach_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `asset_attach_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `asset_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_category_master`
--

DROP TABLE IF EXISTS `asset_category_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_category_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(250) DEFAULT NULL,
  `sub_category` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_main_table`
--

DROP TABLE IF EXISTS `asset_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `asset_name` varchar(250) DEFAULT NULL,
  `serial_no` varchar(250) DEFAULT NULL,
  `model_no` varchar(250) DEFAULT NULL,
  `supplier` varchar(45) DEFAULT NULL,
  `incharge` varchar(45) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `warrenty_till` date DEFAULT NULL,
  `asset_type` varchar(45) DEFAULT NULL,
  `asset_value` int(11) DEFAULT NULL,
  `depreciation_per` int(11) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  UNIQUE KEY `asset_name_UNIQUE` (`asset_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_process_description`
--

DROP TABLE IF EXISTS `asset_process_description`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_process_description` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `description` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `latitude` varchar(250) DEFAULT NULL,
  `longitude` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_asset_desc_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_asset_desc` FOREIGN KEY (`main_id_fk`) REFERENCES `asset_process_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_process_master`
--

DROP TABLE IF EXISTS `asset_process_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_process_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `process_name` varchar(45) DEFAULT NULL,
  `department` varchar(45) DEFAULT NULL,
  `days` varchar(45) DEFAULT NULL,
  `recurring_days` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `other_details` varchar(250) DEFAULT NULL,
  `process_supplier` varchar(45) DEFAULT NULL,
  `assign_to` varchar(45) DEFAULT NULL,
  `ordered` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_process_status_master`
--

DROP TABLE IF EXISTS `asset_process_status_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_process_status_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `process_status` varchar(45) DEFAULT NULL,
  `created_on` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_process_table`
--

DROP TABLE IF EXISTS `asset_process_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_process_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `process_name` varchar(45) DEFAULT NULL,
  `planned_start_date` date DEFAULT NULL,
  `planned_end_date` date DEFAULT NULL,
  `actual_start_date` date DEFAULT NULL,
  `actual_end_date` date DEFAULT NULL,
  `process_supplier` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `days` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  `recurring_days` varchar(45) DEFAULT NULL,
  `assign_to` varchar(45) DEFAULT NULL,
  `ordered` int(11) DEFAULT NULL,
  `department` varchar(45) DEFAULT NULL,
  `process_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_process_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_asset1` FOREIGN KEY (`main_id_fk`) REFERENCES `asset_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_template_master`
--

DROP TABLE IF EXISTS `asset_template_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_template_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(45) DEFAULT NULL,
  `description` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_template_process_master`
--

DROP TABLE IF EXISTS `asset_template_process_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_template_process_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `process_name` varchar(45) DEFAULT NULL,
  `department` varchar(45) DEFAULT NULL,
  `days` varchar(45) DEFAULT NULL,
  `recurring_days` varchar(45) DEFAULT NULL,
  `ordered` int(11) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `subject` text,
  `type` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_asset_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_asset` FOREIGN KEY (`main_id_fk`) REFERENCES `asset_template_master` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `asset_type_master_table`
--

DROP TABLE IF EXISTS `asset_type_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asset_type_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `asset_type` varchar(45) DEFAULT NULL,
  `description` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `att_manual_entry_table`
--

DROP TABLE IF EXISTS `att_manual_entry_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `att_manual_entry_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `device_no` varchar(45) DEFAULT NULL,
  `employee_name` varchar(45) DEFAULT NULL,
  `working_days` int(11) DEFAULT NULL,
  `absent_days` int(11) DEFAULT NULL,
  `worked_days` int(11) DEFAULT NULL,
  `month` varchar(100) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `att_work_hrs_table`
--

DROP TABLE IF EXISTS `att_work_hrs_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `att_work_hrs_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `device_code` varchar(45) DEFAULT NULL,
  `work_date` date DEFAULT NULL,
  `actual_work_hrs` varchar(45) DEFAULT NULL,
  `alloted_work_hrs` varchar(45) DEFAULT NULL,
  `ot_hours` varchar(45) DEFAULT NULL,
  `duration` varchar(45) DEFAULT NULL,
  `ot_duration` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `in_time` varchar(45) DEFAULT NULL,
  `out_time` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `atten_month_master`
--

DROP TABLE IF EXISTS `atten_month_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atten_month_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `month` varchar(45) DEFAULT NULL,
  `working_days` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `attendance_entry_table`
--

DROP TABLE IF EXISTS `attendance_entry_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendance_entry_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `device_code` varchar(45) DEFAULT NULL,
  `work_date` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `actual_work_hrs` varchar(45) DEFAULT NULL,
  `longitude` varchar(45) DEFAULT NULL,
  `sync_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bank_account_table`
--

DROP TABLE IF EXISTS `bank_account_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bank_account_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(95) DEFAULT NULL,
  `mode_of_payment` varchar(95) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `credit` decimal(10,2) DEFAULT NULL,
  `debit` decimal(10,2) DEFAULT NULL,
  `contact_person` varchar(95) DEFAULT NULL,
  `details` text,
  `contact_person_contact_no` varchar(95) DEFAULT NULL,
  `bank_name_cus_vendor` varchar(95) DEFAULT NULL,
  `reference_no` varchar(95) DEFAULT NULL,
  `payment_for` varchar(45) DEFAULT NULL COMMENT 'vendor,customer,employee',
  `employee_name` varchar(200) DEFAULT NULL,
  `user_name` varchar(90) DEFAULT NULL,
  `currency_type` varchar(45) DEFAULT NULL,
  `exchange_rate` decimal(10,2) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `payment_against` varchar(200) DEFAULT NULL,
  `transaction_status` varchar(90) DEFAULT NULL,
  `clearance_date` date DEFAULT NULL,
  `printname` varchar(250) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  `contractor` varchar(100) DEFAULT NULL,
  `branch` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bank_master_table`
--

DROP TABLE IF EXISTS `bank_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bank_master_table` (
  `account_number` varchar(95) NOT NULL,
  `bank_name` text,
  `branch_name` varchar(95) DEFAULT NULL,
  `ifc` varchar(95) DEFAULT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `account_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`account_number`),
  UNIQUE KEY `tid_UNIQUE` (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `barcode_master_table`
--

DROP TABLE IF EXISTS `barcode_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `barcode_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(45) DEFAULT NULL,
  `style_name` varchar(45) DEFAULT NULL,
  `coulour` varchar(45) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `barcode_types` varchar(45) DEFAULT NULL,
  `created_on` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` varchar(45) DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `barcode_scan_table`
--

DROP TABLE IF EXISTS `barcode_scan_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `barcode_scan_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `baecode_id` varchar(45) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `sacn_time` time DEFAULT NULL,
  `line_qc` varchar(45) DEFAULT NULL,
  `line_number` varchar(45) DEFAULT NULL,
  `floor_name` varchar(45) DEFAULT NULL,
  `process_name` varchar(45) DEFAULT NULL,
  `bscan_types` varchar(45) DEFAULT NULL,
  `created_on` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `floor_incharge` varchar(45) DEFAULT NULL,
  `line_supervisor` varchar(45) DEFAULT NULL,
  `in_out` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `batch_table`
--

DROP TABLE IF EXISTS `batch_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `batch_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `batch_id` varchar(90) DEFAULT NULL,
  `sku` varchar(120) DEFAULT NULL,
  `expiry_date` varchar(45) DEFAULT NULL,
  `batch_describition` text,
  `maf_dt` varchar(45) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `billwise_opening_balance_table`
--

DROP TABLE IF EXISTS `billwise_opening_balance_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `billwise_opening_balance_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `invoice_no` int(11) DEFAULT NULL,
  `invoice_amount` decimal(10,2) DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT NULL,
  `current_bal` decimal(10,2) DEFAULT NULL,
  `entrytype` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `bill_wise_opening_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `bill_wise_opening_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `company_table` (`company_name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bom_acc`
--

DROP TABLE IF EXISTS `bom_acc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bom_acc` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bom_fk` int(11) DEFAULT NULL,
  `items` varchar(90) DEFAULT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,3) DEFAULT NULL,
  `ava_qty` decimal(10,3) DEFAULT NULL,
  `qty_planned` decimal(10,3) DEFAULT NULL,
  `final_qty` decimal(10,3) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `fk_main_idx` (`bom_fk`),
  CONSTRAINT `fk_main_acc` FOREIGN KEY (`bom_fk`) REFERENCES `bom_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bom_fabric`
--

DROP TABLE IF EXISTS `bom_fabric`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bom_fabric` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bom_fk` int(11) DEFAULT NULL,
  `items` varchar(90) DEFAULT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,3) DEFAULT NULL,
  `ava_qty` decimal(10,3) DEFAULT NULL,
  `qty_planned` decimal(10,3) DEFAULT NULL,
  `final_qty` decimal(10,3) DEFAULT NULL,
  `item_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `fk_main_idx` (`bom_fk`),
  CONSTRAINT `fk_main` FOREIGN KEY (`bom_fk`) REFERENCES `bom_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bom_main`
--

DROP TABLE IF EXISTS `bom_main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bom_main` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `style_name` varchar(90) DEFAULT NULL,
  `production_no` int(11) DEFAULT NULL,
  `remarks` text,
  `create_date` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `branch_multi_attachment_table`
--

DROP TABLE IF EXISTS `branch_multi_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `branch_multi_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `notes` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `ticket_attach_fk_idx` (`main_id_fk`),
  KEY `main_id_fk_ticket_attach_idx` (`main_id_fk`),
  KEY `main_id_fk_branch_multi_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_branch_multi` FOREIGN KEY (`main_id_fk`) REFERENCES `store_invoice_no_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `brand_master`
--

DROP TABLE IF EXISTS `brand_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `brand_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `brand` varchar(100) DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `budget_table`
--

DROP TABLE IF EXISTS `budget_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `process_name` varchar(200) DEFAULT NULL,
  `item_name` varchar(200) DEFAULT NULL,
  `colour` varchar(200) DEFAULT NULL,
  `qty` varchar(45) DEFAULT NULL,
  `rate` varchar(200) DEFAULT NULL,
  `need_po` varchar(100) DEFAULT NULL,
  `po_status` varchar(100) DEFAULT NULL,
  `main_id_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `budget_table_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `budget_table_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `order_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bundel_card`
--

DROP TABLE IF EXISTS `bundel_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bundel_card` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `po_no` varchar(200) DEFAULT NULL,
  `art_no_buyer` varchar(220) DEFAULT NULL,
  `style` varchar(220) DEFAULT NULL,
  `size` varchar(200) DEFAULT NULL,
  `colour` varchar(200) DEFAULT NULL,
  `no_of_bundels` int(11) DEFAULT NULL,
  `total_qty` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `operation_no` varchar(200) DEFAULT NULL,
  `operation` varchar(220) DEFAULT NULL,
  `machine` varchar(220) DEFAULT NULL,
  `sam_per_100_pcs` decimal(10,2) DEFAULT NULL,
  `sam_per_bundel` decimal(10,2) DEFAULT NULL,
  `bundel_number` int(11) DEFAULT NULL,
  `bundel_qty` int(11) DEFAULT NULL,
  `process_status` varchar(220) DEFAULT NULL,
  `assigned_staff` varchar(220) DEFAULT NULL,
  `completed_date` date DEFAULT NULL,
  `line_no` varchar(45) DEFAULT NULL,
  `internal_order_no` varchar(45) DEFAULT NULL,
  `lot_no` varchar(45) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `local_bundel_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bundle_cut_table`
--

DROP TABLE IF EXISTS `bundle_cut_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bundle_cut_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` int(11) DEFAULT NULL,
  `order_name` varchar(200) DEFAULT NULL,
  `style_name` varchar(200) DEFAULT NULL,
  `colour` varchar(45) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `size_chart` varchar(45) DEFAULT NULL,
  `order_qty` varchar(46) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `process_name` varchar(45) DEFAULT NULL,
  `bundle_no` varchar(45) DEFAULT NULL,
  `pcs` int(11) DEFAULT NULL,
  `rejected` int(11) DEFAULT NULL,
  `oil` int(11) DEFAULT NULL,
  `addas` int(11) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bundle_entry_table`
--

DROP TABLE IF EXISTS `bundle_entry_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bundle_entry_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_name` varchar(250) DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  `style_name` varchar(250) DEFAULT NULL,
  `color` varchar(250) DEFAULT NULL,
  `order_qty` varchar(45) DEFAULT NULL,
  `style_qty` varchar(45) DEFAULT NULL,
  `order_incharge` varchar(45) DEFAULT NULL,
  `process` varchar(45) DEFAULT NULL,
  `staff` varchar(45) DEFAULT NULL,
  `bundle_no` int(11) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `qty` varchar(45) DEFAULT NULL,
  `rejected` varchar(45) DEFAULT NULL,
  `oil` varchar(45) DEFAULT NULL,
  `rework` varchar(45) DEFAULT NULL,
  `remark` text,
  `supplier` varchar(45) DEFAULT NULL,
  `bundle_status` varchar(45) DEFAULT NULL,
  `received_qty` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bundle_remarks_master`
--

DROP TABLE IF EXISTS `bundle_remarks_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bundle_remarks_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `remarks` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `buyer_costing_table`
--

DROP TABLE IF EXISTS `buyer_costing_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `buyer_costing_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(150) DEFAULT NULL,
  `detail` varchar(150) DEFAULT NULL,
  `base_price` decimal(10,2) DEFAULT NULL,
  `buffer_price` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ca_accounts_table`
--

DROP TABLE IF EXISTS `ca_accounts_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ca_accounts_table` (
  `ca_accounts` varchar(120) NOT NULL,
  `account_type` varchar(200) DEFAULT NULL,
  `description` text,
  `create_date` date DEFAULT NULL,
  `opening_balance` decimal(10,2) DEFAULT NULL,
  `sub_account_of` varchar(120) DEFAULT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ca_accounts`),
  UNIQUE KEY `tid_UNIQUE` (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `category_wise_hsn_table`
--

DROP TABLE IF EXISTS `category_wise_hsn_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_wise_hsn_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(50) DEFAULT NULL,
  `hsn` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cbom_acc`
--

DROP TABLE IF EXISTS `cbom_acc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cbom_acc` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bom_fk` int(11) DEFAULT NULL,
  `items` varchar(90) DEFAULT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,3) DEFAULT NULL,
  `ava_qty` decimal(10,3) DEFAULT NULL,
  `qty_planned` decimal(10,3) DEFAULT NULL,
  `final_qty` decimal(10,3) DEFAULT NULL,
  `po_status` varchar(45) DEFAULT NULL,
  `style_name` varchar(100) DEFAULT NULL,
  `d1` varchar(100) DEFAULT NULL,
  `d2` varchar(100) DEFAULT NULL,
  `d3` varchar(100) DEFAULT NULL,
  `d4` varchar(100) DEFAULT NULL,
  `d5` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `fk_main_idx` (`bom_fk`),
  CONSTRAINT `fk_cmain_acc` FOREIGN KEY (`bom_fk`) REFERENCES `cbom_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cbom_fabric`
--

DROP TABLE IF EXISTS `cbom_fabric`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cbom_fabric` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bom_fk` int(11) DEFAULT NULL,
  `items` varchar(90) DEFAULT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,3) DEFAULT NULL,
  `ava_qty` decimal(10,3) DEFAULT NULL,
  `qty_planned` decimal(10,3) DEFAULT NULL,
  `final_qty` decimal(10,3) DEFAULT NULL,
  `po_status` varchar(100) DEFAULT NULL,
  `item_type` varchar(45) DEFAULT NULL,
  `style_name` varchar(100) DEFAULT NULL,
  `d1` varchar(100) DEFAULT NULL,
  `d2` varchar(100) DEFAULT NULL,
  `d3` varchar(100) DEFAULT NULL,
  `d4` varchar(100) DEFAULT NULL,
  `d5` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `fk_main_idx` (`bom_fk`),
  CONSTRAINT `cfk_main` FOREIGN KEY (`bom_fk`) REFERENCES `cbom_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cbom_main`
--

DROP TABLE IF EXISTS `cbom_main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cbom_main` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `style_name` varchar(150) DEFAULT NULL,
  `production_no` varchar(150) DEFAULT NULL,
  `remarks` text,
  `create_date` date DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cbom_onhold_stock_table`
--

DROP TABLE IF EXISTS `cbom_onhold_stock_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cbom_onhold_stock_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `order_no` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,2) DEFAULT NULL,
  `utilized_qty` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `cbom_stock_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `cbom_stock_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `order_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cbom_yarn`
--

DROP TABLE IF EXISTS `cbom_yarn`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cbom_yarn` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bom_fk` int(11) DEFAULT NULL,
  `items` varchar(100) DEFAULT NULL,
  `uom` varchar(45) DEFAULT NULL,
  `req_qty` decimal(10,3) DEFAULT NULL,
  `ava_qty` decimal(10,3) DEFAULT NULL,
  `qty_planned` decimal(10,3) DEFAULT NULL,
  `final_qty` decimal(10,3) DEFAULT NULL,
  `po_status` varchar(100) DEFAULT NULL,
  `item_type` varchar(45) DEFAULT NULL,
  `style_name` varchar(100) DEFAULT NULL,
  `d1` varchar(100) DEFAULT NULL,
  `d2` varchar(100) DEFAULT NULL,
  `d3` varchar(100) DEFAULT NULL,
  `d4` varchar(100) DEFAULT NULL,
  `d5` varchar(100) DEFAULT NULL,
  `yarn_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `cyk_main_idx` (`bom_fk`),
  CONSTRAINT `cyk_main` FOREIGN KEY (`bom_fk`) REFERENCES `cbom_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `city_master_table`
--

DROP TABLE IF EXISTS `city_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `city_master_table` (
  `city_name` varchar(90) NOT NULL,
  PRIMARY KEY (`city_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `color_master`
--

DROP TABLE IF EXISTS `color_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `color_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `color` varchar(100) DEFAULT NULL,
  `notes` text,
  `brand` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `colour_chart_table`
--

DROP TABLE IF EXISTS `colour_chart_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `colour_chart_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `colour_chart_name` varchar(200) DEFAULT NULL,
  `colour` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `combo_product_table`
--

DROP TABLE IF EXISTS `combo_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `combo_product_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `combo_product` varchar(90) DEFAULT NULL,
  `single_product` varchar(90) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `combo_valid_qty` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `combo_product_call_idx` (`combo_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `company_brand_process_price_list_table`
--

DROP TABLE IF EXISTS `company_brand_process_price_list_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_brand_process_price_list_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(250) DEFAULT NULL,
  `brand_name` varchar(250) DEFAULT NULL,
  `process_name` varchar(250) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `company_prise_list`
--

DROP TABLE IF EXISTS `company_prise_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_prise_list` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(95) DEFAULT NULL,
  `sku` varchar(95) DEFAULT NULL,
  `selling_price` decimal(10,2) DEFAULT NULL,
  `purchase_price` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `company_profile_table`
--

DROP TABLE IF EXISTS `company_profile_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_profile_table` (
  `company_name` varchar(95) DEFAULT NULL,
  `display_name` varchar(95) DEFAULT NULL,
  `b_street_l1` text,
  `b_street_l2` text,
  `b_city` varchar(95) DEFAULT NULL,
  `b_state` varchar(95) DEFAULT NULL,
  `b_zip` varchar(95) DEFAULT NULL,
  `b_country` varchar(95) DEFAULT NULL,
  `s_street_l1` text,
  `s_street_l2` text,
  `s_city` varchar(95) DEFAULT NULL,
  `s_state` varchar(95) DEFAULT NULL,
  `s_zip` varchar(95) DEFAULT NULL,
  `s_country` varchar(95) DEFAULT NULL,
  `email` text,
  `landline` text,
  `mobile` text,
  `fax` varchar(95) DEFAULT NULL,
  `website` varchar(95) DEFAULT NULL,
  `other_details` longtext,
  `tin` varchar(45) DEFAULT NULL,
  `tan` varchar(45) DEFAULT NULL,
  `cst` varchar(45) DEFAULT NULL,
  `pan` varchar(45) DEFAULT NULL,
  `service_tax` varchar(95) DEFAULT NULL,
  `department` varchar(95) DEFAULT NULL,
  `date_of_add` date DEFAULT NULL,
  `payable_opening_balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `receivable_opening_balance` decimal(10,2) DEFAULT NULL,
  `bonus_point` decimal(10,2) NOT NULL DEFAULT '0.00',
  `contact_person_name` varchar(95) DEFAULT NULL,
  `conatct_person_mobile` varchar(95) DEFAULT NULL,
  `approved_status` varchar(45) DEFAULT NULL,
  `image_logo_url` text,
  `contact_type` varchar(45) DEFAULT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `credit_amount` int(11) NOT NULL DEFAULT '0',
  `credit_days` int(11) NOT NULL DEFAULT '0',
  `bank_name` varchar(120) DEFAULT NULL,
  `ifs_code` varchar(120) DEFAULT NULL,
  `branch_name` varchar(120) DEFAULT NULL,
  `acc_number` varchar(120) DEFAULT NULL,
  `account_name` varchar(120) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  UNIQUE KEY `tid_UNIQUE` (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `company_table`
--

DROP TABLE IF EXISTS `company_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(95) NOT NULL,
  `display_name` varchar(95) DEFAULT NULL,
  `b_street_l1` text,
  `b_street_l2` text,
  `b_city` varchar(95) DEFAULT NULL,
  `b_state` varchar(95) DEFAULT NULL,
  `b_zip` varchar(95) DEFAULT NULL,
  `b_country` varchar(95) DEFAULT NULL,
  `s_street_l1` text,
  `s_street_l2` text,
  `s_city` varchar(95) DEFAULT NULL,
  `s_state` varchar(95) DEFAULT NULL,
  `s_zip` varchar(95) DEFAULT NULL,
  `s_country` varchar(95) DEFAULT NULL,
  `email` text,
  `landline` text,
  `mobile` text,
  `fax` varchar(95) DEFAULT NULL,
  `website` varchar(95) DEFAULT NULL,
  `other_details` text,
  `tin` varchar(45) DEFAULT NULL,
  `tan` varchar(45) DEFAULT NULL,
  `cst` varchar(45) DEFAULT NULL,
  `pan` varchar(45) DEFAULT NULL,
  `service_tax` varchar(95) DEFAULT NULL,
  `department` varchar(95) DEFAULT NULL,
  `date_of_add` date DEFAULT NULL,
  `payable_opening_balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `receivable_opening_balance` decimal(10,2) DEFAULT NULL,
  `bonus_point` decimal(10,2) NOT NULL DEFAULT '0.00',
  `contact_person_name` varchar(95) DEFAULT NULL,
  `conatct_person_mobile` varchar(95) DEFAULT NULL,
  `approved_status` varchar(45) DEFAULT NULL,
  `image_logo_url` text,
  `contact_type` varchar(45) DEFAULT 'Both',
  `credit_amount` int(11) NOT NULL DEFAULT '0',
  `credit_days` int(11) NOT NULL DEFAULT '0',
  `price_list` varchar(90) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `ad6` varchar(250) DEFAULT NULL,
  `ad7` varchar(250) DEFAULT NULL,
  `ad8` varchar(250) DEFAULT NULL,
  `ad9` varchar(250) DEFAULT NULL,
  `ad10` varchar(250) DEFAULT NULL,
  `ad11` varchar(250) DEFAULT NULL,
  `ad12` varchar(250) DEFAULT NULL,
  `ad13` varchar(250) DEFAULT NULL,
  `ad14` varchar(250) DEFAULT NULL,
  `ad15` varchar(250) DEFAULT NULL,
  `date_of_birth` varchar(200) DEFAULT NULL,
  `accounts_manager` varchar(200) DEFAULT NULL,
  `date_of_anniversary` varchar(200) DEFAULT NULL,
  `bank_details` text,
  `agent_name` varchar(45) DEFAULT NULL,
  `dealer_name` varchar(45) DEFAULT NULL,
  `last_updated_date` varchar(45) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `royality_points` decimal(10,2) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(150) DEFAULT NULL,
  `short_name` varchar(250) DEFAULT NULL,
  `code` varchar(250) DEFAULT NULL,
  `referance_name` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `customer_portal` varchar(45) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  UNIQUE KEY `Company_UNIQUE` (`company_name`),
  UNIQUE KEY `tid_UNIQUE` (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=646 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contact_attachment_table`
--

DROP TABLE IF EXISTS `contact_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `notes` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `contact_attach_fk_idx` (`main_id_fk`),
  CONSTRAINT `contact_attach_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `company_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contact_person_privilage_table`
--

DROP TABLE IF EXISTS `contact_person_privilage_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_person_privilage_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `contact_person_tid_fk` int(11) DEFAULT NULL,
  `process_name` varchar(200) DEFAULT NULL,
  `sms` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `contact_person_tid_fk_idx` (`contact_person_tid_fk`),
  CONSTRAINT `contact_person_tid_fk` FOREIGN KEY (`contact_person_tid_fk`) REFERENCES `contact_persons_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contact_persons_table`
--

DROP TABLE IF EXISTS `contact_persons_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_persons_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `contact_person_name` varchar(250) DEFAULT NULL,
  `designation` varchar(250) DEFAULT NULL,
  `email` text,
  `mobile` text,
  PRIMARY KEY (`tid`),
  KEY `company_name_fk_idx` (`main_id_fk`),
  CONSTRAINT `company_name_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `company_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `control_panel_table`
--

DROP TABLE IF EXISTS `control_panel_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `control_panel_table` (
  `control_name` varchar(200) NOT NULL,
  `settings_value` text,
  `settings_type` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`control_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_fab_details_table`
--

DROP TABLE IF EXISTS `costing_fab_details_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_fab_details_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `fabric` varchar(250) DEFAULT NULL,
  `avg_wt` decimal(10,3) DEFAULT NULL,
  `main_id_fk` int(11) NOT NULL,
  PRIMARY KEY (`tid`),
  KEY `costing_fab_details_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `costing_fab_details_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `costing_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_fab_per_table`
--

DROP TABLE IF EXISTS `costing_fab_per_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_fab_per_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `fabric_process` varchar(250) DEFAULT NULL,
  `fab_percentage` decimal(10,2) DEFAULT NULL,
  `fab_rate` decimal(10,2) DEFAULT NULL,
  `main_id_fk` int(11) NOT NULL,
  PRIMARY KEY (`tid`),
  KEY `costing_fab_per_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `costing_fab_per_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `costing_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_main_table`
--

DROP TABLE IF EXISTS `costing_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(150) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_product_table`
--

DROP TABLE IF EXISTS `costing_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_costing_main_idx` (`main_id_fk`),
  CONSTRAINT `key_costing_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `costing_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_style_per_table`
--

DROP TABLE IF EXISTS `costing_style_per_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_style_per_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) NOT NULL,
  `style_process` varchar(250) DEFAULT NULL,
  `style_percentage` decimal(10,2) DEFAULT NULL,
  `style_rate` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `costing_style_per_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `costing_style_per_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `costing_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_table`
--

DROP TABLE IF EXISTS `costing_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(150) DEFAULT NULL,
  `order_name` varchar(250) DEFAULT NULL,
  `costing_type` varchar(150) DEFAULT NULL,
  `cossting_item` varchar(150) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `costing_tax_dis_table`
--

DROP TABLE IF EXISTS `costing_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `costing_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_costing_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_costing_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `costing_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `country_master_table`
--

DROP TABLE IF EXISTS `country_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country_master_table` (
  `country_name` varchar(90) NOT NULL,
  PRIMARY KEY (`country_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_department_master`
--

DROP TABLE IF EXISTS `crm_department_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_department_master` (
  `department_name` varchar(120) NOT NULL,
  PRIMARY KEY (`department_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_lead_desc_table`
--

DROP TABLE IF EXISTS `crm_lead_desc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_lead_desc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) NOT NULL,
  `describition` text,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `appoinment_on` date DEFAULT NULL,
  `lead_value` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `lead_fk_call_idx` (`main_id_fk`),
  CONSTRAINT `lead_fk_call` FOREIGN KEY (`main_id_fk`) REFERENCES `crm_lead_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_lead_main_table`
--

DROP TABLE IF EXISTS `crm_lead_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_lead_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `lead_source` varchar(250) DEFAULT NULL,
  `company_name` varchar(250) DEFAULT NULL,
  `contact_person` varchar(250) DEFAULT NULL,
  `contact_person_designation` varchar(250) DEFAULT NULL,
  `contact_number` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `product_name` varchar(250) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `agent` varchar(250) DEFAULT NULL,
  `priority` varchar(250) DEFAULT NULL,
  `lead_stage` varchar(250) DEFAULT NULL,
  `assigned_to` varchar(250) DEFAULT NULL,
  `quote_no` varchar(250) DEFAULT NULL,
  `reference_no` varchar(250) DEFAULT NULL,
  `other_details` text,
  `appoinment_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `lead_status` varchar(250) DEFAULT NULL,
  `lead_type` varchar(45) DEFAULT NULL,
  `country` varchar(45) DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `stage_process` varchar(250) DEFAULT NULL,
  `read_status` varchar(45) DEFAULT NULL,
  `new_lead` varchar(45) DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `a1` varchar(250) DEFAULT NULL,
  `a2` varchar(250) DEFAULT NULL,
  `a3` varchar(250) DEFAULT NULL,
  `a4` varchar(250) DEFAULT NULL,
  `a5` varchar(250) DEFAULT NULL,
  `a6` varchar(250) DEFAULT NULL,
  `a7` varchar(250) DEFAULT NULL,
  `a8` varchar(250) DEFAULT NULL,
  `a9` varchar(250) DEFAULT NULL,
  `a10` varchar(250) DEFAULT NULL,
  `location` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_status_master`
--

DROP TABLE IF EXISTS `crm_status_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_status_master` (
  `status` varchar(95) NOT NULL,
  PRIMARY KEY (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_category_master_table`
--

DROP TABLE IF EXISTS `crm_task_category_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_category_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_department_master`
--

DROP TABLE IF EXISTS `crm_task_department_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_department_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `department` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_desc_table`
--

DROP TABLE IF EXISTS `crm_task_desc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_desc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `describition` text,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `time` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `task_main_id_fk_idx` (`main_id_fk`),
  CONSTRAINT `task_main_id_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `crm_task_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_main_table`
--

DROP TABLE IF EXISTS `crm_task_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(250) DEFAULT NULL,
  `contact_person` varchar(250) DEFAULT NULL,
  `contact_person_designation` varchar(250) DEFAULT NULL,
  `contact_number` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `ticket_subject` varchar(250) DEFAULT NULL,
  `ticket_source` varchar(250) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `priority` varchar(250) DEFAULT NULL,
  `ticket_stage` varchar(250) DEFAULT NULL,
  `assigned_to` varchar(250) DEFAULT NULL,
  `reference_no` varchar(250) DEFAULT NULL,
  `other_details` text,
  `due_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ticket_status` varchar(250) DEFAULT NULL,
  `stage_process` varchar(250) DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `read_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_priority_master_table`
--

DROP TABLE IF EXISTS `crm_task_priority_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_priority_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `priority` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_source_master`
--

DROP TABLE IF EXISTS `crm_task_source_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_source_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_source` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_stage_master_table`
--

DROP TABLE IF EXISTS `crm_task_stage_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_stage_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_stage` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_status_master_table`
--

DROP TABLE IF EXISTS `crm_task_status_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_status_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_status` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_subject_master_table`
--

DROP TABLE IF EXISTS `crm_task_subject_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_subject_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_subject` varchar(250) DEFAULT NULL,
  `describition` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_task_template_master`
--

DROP TABLE IF EXISTS `crm_task_template_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_task_template_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(250) DEFAULT NULL,
  `description` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_ticket_desc_table`
--

DROP TABLE IF EXISTS `crm_ticket_desc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_ticket_desc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `describition` text,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `time` time DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_call_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_call` FOREIGN KEY (`main_id_fk`) REFERENCES `crm_ticket_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `crm_ticket_main_table`
--

DROP TABLE IF EXISTS `crm_ticket_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crm_ticket_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(250) DEFAULT NULL,
  `contact_person` varchar(250) DEFAULT NULL,
  `contact_person_designation` varchar(250) DEFAULT NULL,
  `contact_number` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `ticket_subject` varchar(250) DEFAULT NULL,
  `ticket_source` varchar(250) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `priority` varchar(250) DEFAULT NULL,
  `ticket_stage` varchar(250) DEFAULT NULL,
  `assigned_to` varchar(250) DEFAULT NULL,
  `reference_no` varchar(250) DEFAULT NULL,
  `other_details` text,
  `due_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `ticket_status` varchar(250) DEFAULT NULL,
  `stage_process` varchar(250) DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `read_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `currency_table`
--

DROP TABLE IF EXISTS `currency_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `currency_table` (
  `name` varchar(45) NOT NULL,
  `symbol` varchar(45) DEFAULT NULL,
  `details` text,
  `created_on` date DEFAULT NULL,
  `name_amount_in_words` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cus_city_master_table`
--

DROP TABLE IF EXISTS `cus_city_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cus_city_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(45) DEFAULT NULL,
  `state` varchar(45) DEFAULT NULL,
  `city` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=1219 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cus_state_master_table`
--

DROP TABLE IF EXISTS `cus_state_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cus_state_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(45) DEFAULT NULL,
  `state` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `custom_agent_com_tbl`
--

DROP TABLE IF EXISTS `custom_agent_com_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `custom_agent_com_tbl` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(45) DEFAULT NULL,
  `commission` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_wise_agent_commission_table`
--

DROP TABLE IF EXISTS `customer_wise_agent_commission_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_wise_agent_commission_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `agent_name` varchar(60) DEFAULT NULL,
  `customer_name` varchar(60) DEFAULT NULL,
  `commission_percentage` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cut_sheet_table`
--

DROP TABLE IF EXISTS `cut_sheet_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cut_sheet_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(200) DEFAULT NULL,
  `style_name` varchar(250) DEFAULT NULL,
  `colour_print_name` varchar(250) DEFAULT NULL,
  `size` varchar(200) DEFAULT NULL,
  `process_name` varchar(250) DEFAULT NULL,
  `process_date` date DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `checked_by` varchar(200) DEFAULT NULL,
  `accounts` varchar(200) DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `daily_production`
--

DROP TABLE IF EXISTS `daily_production`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_production` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `process_name` varchar(150) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `job_no` varchar(150) DEFAULT NULL,
  `machine` varchar(150) DEFAULT NULL,
  `shift` varchar(100) DEFAULT NULL,
  `party_name` varchar(250) DEFAULT NULL,
  `dia` varchar(45) DEFAULT NULL,
  `weight` decimal(10,3) DEFAULT NULL,
  `combo` varchar(150) DEFAULT NULL,
  `design_des` varchar(150) DEFAULT NULL,
  `print_type` varchar(100) DEFAULT NULL,
  `badges` varchar(100) DEFAULT NULL,
  `rolls` decimal(10,3) DEFAULT NULL,
  `fabric_gsm` varchar(150) DEFAULT NULL,
  `start_time` varchar(45) DEFAULT NULL,
  `ca_time` varchar(45) DEFAULT NULL,
  `end_time` varchar(45) DEFAULT NULL,
  `operator` varchar(150) DEFAULT NULL,
  `platiter` varchar(150) DEFAULT NULL,
  `stop_from` varchar(45) DEFAULT NULL,
  `stop_to` varchar(45) DEFAULT NULL,
  `remarks` text,
  `process_status` varchar(150) DEFAULT NULL,
  `reason` varchar(250) DEFAULT NULL,
  `design_no` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `daily_work_table`
--

DROP TABLE IF EXISTS `daily_work_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_work_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(250) DEFAULT NULL,
  `design_style_no` varchar(200) DEFAULT NULL,
  `staff_name` varchar(200) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `ref_no` varchar(150) DEFAULT NULL,
  `order_no` varchar(150) DEFAULT NULL,
  `internal_job_no` varchar(150) DEFAULT NULL,
  `work_type` varchar(150) DEFAULT NULL,
  `process_status` varchar(45) DEFAULT NULL,
  `describition` text,
  `remarks` text,
  `category` varchar(190) DEFAULT NULL,
  `colour` varchar(190) DEFAULT NULL,
  `percentage` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dc_main_table`
--

DROP TABLE IF EXISTS `dc_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dc_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `dc_type` varchar(45) DEFAULT NULL,
  `company_profile` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dc_product_table`
--

DROP TABLE IF EXISTS `dc_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dc_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_dc_main_idx` (`main_id_fk`),
  CONSTRAINT `key_dc_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `dc_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dc_tax_dis_table`
--

DROP TABLE IF EXISTS `dc_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dc_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_dc_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_dc_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `dc_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `declared_holiday_table`
--

DROP TABLE IF EXISTS `declared_holiday_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `declared_holiday_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `holiday` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `defect_category_master`
--

DROP TABLE IF EXISTS `defect_category_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `defect_category_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(100) DEFAULT NULL,
  `color` varchar(100) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `defect_master`
--

DROP TABLE IF EXISTS `defect_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `defect_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(100) DEFAULT NULL,
  `defect_type` varchar(100) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `defect_reject_details_coordinates_table`
--

DROP TABLE IF EXISTS `defect_reject_details_coordinates_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `defect_reject_details_coordinates_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  `defect_type` varchar(45) DEFAULT NULL,
  `xaxis` int(11) DEFAULT NULL,
  `yaxis` int(11) DEFAULT NULL,
  `spot_color` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `axis_fk_idx` (`main_id_fk`),
  CONSTRAINT `axis_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `defect_reject_details_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `defect_reject_details_table`
--

DROP TABLE IF EXISTS `defect_reject_details_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `defect_reject_details_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `style` varchar(45) DEFAULT NULL,
  `colour` varchar(45) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `old_status` varchar(45) DEFAULT NULL,
  `entry_type` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `deleted_einvoice_table`
--

DROP TABLE IF EXISTS `deleted_einvoice_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deleted_einvoice_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `einvoice_id` int(11) DEFAULT NULL,
  `log` text,
  `deleted_by` varchar(250) DEFAULT NULL,
  `deleted_on` datetime DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `deleted_sales_return_einvoice_table`
--

DROP TABLE IF EXISTS `deleted_sales_return_einvoice_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deleted_sales_return_einvoice_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `einvoice_id` int(11) DEFAULT NULL,
  `log` text,
  `deleted_by` varchar(250) DEFAULT NULL,
  `deleted_on` datetime DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `despatch_attachment_table`
--

DROP TABLE IF EXISTS `despatch_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `despatch_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_despatch_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_despatch_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `despatch_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `despatch_main_table`
--

DROP TABLE IF EXISTS `despatch_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `despatch_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` varchar(45) DEFAULT NULL,
  `jobwork_id` varchar(95) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` varchar(95) DEFAULT NULL,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(150) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `despatch_product_table`
--

DROP TABLE IF EXISTS `despatch_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `despatch_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` varchar(95) DEFAULT NULL,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_despatch_main_idx` (`main_id_fk`),
  CONSTRAINT `key_despatch_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `despatch_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `despatch_tax_dis_table`
--

DROP TABLE IF EXISTS `despatch_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `despatch_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_despatch_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_despatch_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `despatch_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `direct_booking_attachment_table`
--

DROP TABLE IF EXISTS `direct_booking_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `direct_booking_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `notes` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `direct_booking_attach_fk_idx` (`main_id_fk`),
  CONSTRAINT `direct_booking_attach_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `direct_booking_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `direct_booking_fit_master`
--

DROP TABLE IF EXISTS `direct_booking_fit_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `direct_booking_fit_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `fit` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `direct_booking_main_table`
--

DROP TABLE IF EXISTS `direct_booking_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `direct_booking_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` varchar(95) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `ratio` varchar(200) DEFAULT NULL,
  `fit` varchar(200) DEFAULT NULL,
  `fabric` varchar(200) DEFAULT NULL,
  `fabric_source` varchar(200) DEFAULT NULL,
  `print` varchar(200) DEFAULT NULL,
  `total_colours` varchar(200) DEFAULT NULL,
  `brand` varchar(200) DEFAULT NULL,
  `gsm` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `printer` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `direct_booking_product_table`
--

DROP TABLE IF EXISTS `direct_booking_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `direct_booking_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `color_ext_file` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_direct_booking_main_idx` (`main_id_fk`),
  CONSTRAINT `key_direct_booking_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `direct_booking_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `discount_master_table`
--

DROP TABLE IF EXISTS `discount_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `discount_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(250) DEFAULT NULL,
  `discount_name` varchar(250) DEFAULT NULL,
  `discount_percentage` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `docket_table`
--

DROP TABLE IF EXISTS `docket_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `docket_table` (
  `docket_name` varchar(250) NOT NULL,
  `create_date` date DEFAULT NULL,
  `details` text,
  PRIMARY KEY (`docket_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_inward_main_table`
--

DROP TABLE IF EXISTS `domestic_inward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_inward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_inward_product_table`
--

DROP TABLE IF EXISTS `domestic_inward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_inward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `c25` varchar(95) DEFAULT NULL,
  `c26` varchar(95) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_inward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_inward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_inward_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_inward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_inward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_inward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_inward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_inward_main_table`
--

DROP TABLE IF EXISTS `domestic_lot_inward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_inward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_inward_product_table`
--

DROP TABLE IF EXISTS `domestic_lot_inward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_inward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_inward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_inward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_inward_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_lot_inward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_inward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_inward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_inward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_outward_main_table`
--

DROP TABLE IF EXISTS `domestic_lot_outward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_outward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_outward_product_table`
--

DROP TABLE IF EXISTS `domestic_lot_outward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_outward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_outward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_outward_program_product_table`
--

DROP TABLE IF EXISTS `domestic_lot_outward_program_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_outward_program_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_outward_ptogram_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_outward_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_lot_outward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_outward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_outward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_outward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_return_main_table`
--

DROP TABLE IF EXISTS `domestic_lot_return_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_return_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_return_product_table`
--

DROP TABLE IF EXISTS `domestic_lot_return_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_return_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_return_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_return_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_lot_return_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_lot_return_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_lot_return_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_lot_return_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_lot_return_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_lot_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_outward_main_table`
--

DROP TABLE IF EXISTS `domestic_outward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_outward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_outward_product_table`
--

DROP TABLE IF EXISTS `domestic_outward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_outward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_outward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_outward_program_product_table`
--

DROP TABLE IF EXISTS `domestic_outward_program_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_outward_program_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_outward_ptogram_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_outward_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_outward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_outward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_outward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_outward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_return_main_table`
--

DROP TABLE IF EXISTS `domestic_return_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_return_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_return_product_table`
--

DROP TABLE IF EXISTS `domestic_return_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_return_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_return_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_return_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `domestic_return_tax_dis_table`
--

DROP TABLE IF EXISTS `domestic_return_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `domestic_return_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_domestic_return_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_domestic_return_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `domestic_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `e_invoice_table`
--

DROP TABLE IF EXISTS `e_invoice_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `e_invoice_table` (
  `inv_id` int(11) NOT NULL,
  `invoice_data` longtext,
  `e_invoice_result` longtext,
  PRIMARY KEY (`inv_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecom_order_table`
--

DROP TABLE IF EXISTS `ecom_order_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecom_order_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(100) DEFAULT NULL,
  `awb` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `order_date` varchar(125) DEFAULT NULL,
  `sub_order_id` varchar(125) DEFAULT NULL,
  `sku` varchar(250) DEFAULT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `order_status` varchar(125) DEFAULT NULL,
  `deliver_date` date DEFAULT NULL,
  `remarks` text,
  `channel_name` varchar(200) DEFAULT NULL,
  `zone` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `address` text,
  `city` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `mrp` decimal(10,2) DEFAULT '0.00',
  `gst_percentage` decimal(10,2) DEFAULT '0.00',
  `taxable_amount` decimal(10,2) DEFAULT '0.00',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecom_payment_reconcile_table`
--

DROP TABLE IF EXISTS `ecom_payment_reconcile_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecom_payment_reconcile_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(200) DEFAULT NULL,
  `sale_amount` decimal(10,2) DEFAULT '0.00',
  `settlement_amount` decimal(10,2) DEFAULT '0.00',
  `status` varchar(45) DEFAULT 'open',
  `remarks` text,
  `channel` varchar(120) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ecom_return_table`
--

DROP TABLE IF EXISTS `ecom_return_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ecom_return_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(200) DEFAULT NULL,
  `sku` varchar(200) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `return_reason` text,
  `return_type` varchar(150) DEFAULT NULL,
  `channel` varchar(150) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `email_list_table`
--

DROP TABLE IF EXISTS `email_list_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_list_table` (
  `email_id` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_category_master`
--

DROP TABLE IF EXISTS `employee_category_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_category_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_company_name_master`
--

DROP TABLE IF EXISTS `employee_company_name_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_company_name_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_department_master`
--

DROP TABLE IF EXISTS `employee_department_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_department_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `department` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_designation_master`
--

DROP TABLE IF EXISTS `employee_designation_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_designation_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_gender_master`
--

DROP TABLE IF EXISTS `employee_gender_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_gender_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `gender` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_name_master`
--

DROP TABLE IF EXISTS `employee_name_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_name_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_type` varchar(100) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_nominees_table`
--

DROP TABLE IF EXISTS `employee_nominees_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_nominees_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `age` varchar(45) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `relationship` varchar(100) DEFAULT NULL,
  `dob` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `emp_nominee_fk_idx` (`main_id_fk`),
  CONSTRAINT `emp_nominee_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `employee_table` (`employee_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_position_table`
--

DROP TABLE IF EXISTS `employee_position_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_position_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `increment` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `emp_position_fk_idx` (`main_id_fk`),
  CONSTRAINT `emp_position_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `employee_table` (`employee_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_salary_type`
--

DROP TABLE IF EXISTS `employee_salary_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_salary_type` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `salary_type` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `employee_table`
--

DROP TABLE IF EXISTS `employee_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee_table` (
  `employee_id` int(11) NOT NULL AUTO_INCREMENT,
  `display_name` varchar(95) NOT NULL,
  `gender` varchar(95) DEFAULT NULL,
  `print_on_check_as` varchar(95) DEFAULT NULL,
  `email` text,
  `marriage_status` varchar(95) DEFAULT NULL,
  `other_details` text,
  `designation` varchar(95) DEFAULT NULL,
  `department` varchar(95) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `date_of_join` date NOT NULL,
  `opening_balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_points` decimal(10,2) NOT NULL DEFAULT '0.00',
  `device_no` varchar(90) DEFAULT NULL,
  `company_name` varchar(200) DEFAULT NULL,
  `salary_type` varchar(150) DEFAULT NULL,
  `date_of_resignation` date DEFAULT NULL,
  `enable_esi` varchar(45) DEFAULT NULL,
  `enable_pf` varchar(45) DEFAULT NULL,
  `per_day_salary` decimal(10,2) DEFAULT NULL,
  `ot_hr_allow` varchar(45) DEFAULT NULL,
  `hra` varchar(45) DEFAULT NULL,
  `da` varchar(45) DEFAULT NULL,
  `ca` varchar(45) DEFAULT NULL,
  `ma` varchar(45) DEFAULT NULL,
  `sa` varchar(45) DEFAULT NULL,
  `tds_percent` varchar(45) DEFAULT NULL,
  `per_month_salary` decimal(10,2) DEFAULT NULL,
  `loan_amount` decimal(10,2) DEFAULT NULL,
  `monthly_loan_repay` decimal(10,2) DEFAULT NULL,
  `pf_no` varchar(90) DEFAULT NULL,
  `esi_insurance_no` varchar(90) DEFAULT NULL,
  `current_status` varchar(45) DEFAULT NULL,
  `father_mother_name` varchar(200) DEFAULT NULL,
  `spouse_name` varchar(200) DEFAULT NULL,
  `aadhar_no` varchar(45) DEFAULT NULL,
  `pan_no` varchar(45) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `address` text,
  `current_address` text,
  `mobile_no` varchar(200) DEFAULT NULL,
  `alternate_no` varchar(200) DEFAULT NULL,
  `home_contact_no` varchar(200) DEFAULT NULL,
  `blood_group` varchar(45) DEFAULT NULL,
  `medical_health_record` text,
  `bank_name` varchar(250) DEFAULT NULL,
  `ifs_code` varchar(200) DEFAULT NULL,
  `bank_account_no` varchar(200) DEFAULT NULL,
  `bank_account_name` varchar(200) DEFAULT NULL,
  `branch` varchar(200) DEFAULT NULL,
  `print_name_on_cheque_as` varchar(200) DEFAULT NULL,
  `allowed_month_leave_with_salary` decimal(10,2) DEFAULT NULL,
  `bonus_percentage` int(11) DEFAULT NULL,
  `work_time_from` time DEFAULT NULL,
  `work_time_to` time DEFAULT NULL,
  `ot_applicable` varchar(45) DEFAULT NULL,
  `date_of_rejoin` varchar(45) DEFAULT NULL,
  `no_of_childrens` varchar(45) DEFAULT NULL,
  `height` varchar(45) DEFAULT NULL,
  `weight` varchar(45) DEFAULT NULL,
  `driving_lic_no` varchar(45) DEFAULT NULL,
  `quota` varchar(45) DEFAULT NULL,
  `nature_of_emp` varchar(45) DEFAULT NULL,
  `ration_card_no` varchar(45) DEFAULT NULL,
  `passport_no` varchar(45) DEFAULT NULL,
  `nominees` varchar(45) DEFAULT NULL,
  `weekly_off` varchar(45) DEFAULT NULL,
  `birth_certi_ext` varchar(45) DEFAULT NULL,
  `employee_img` varchar(45) DEFAULT NULL,
  `passport_ext` varchar(45) DEFAULT NULL,
  `driving_lic_ext` varchar(45) DEFAULT NULL,
  `medical_certi_ext` varchar(45) DEFAULT NULL,
  `aadhar_ext` varchar(45) DEFAULT NULL,
  `voter_id_ext` varchar(45) DEFAULT NULL,
  `pan_card_ext` varchar(45) DEFAULT NULL,
  `ration_card_ext` varchar(45) DEFAULT NULL,
  `property_of_tax_ext` varchar(45) DEFAULT NULL,
  `eb_card_ext` varchar(45) DEFAULT NULL,
  `qualification_certi_ext` varchar(45) DEFAULT NULL,
  `school_leaving_ext` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  `esi_percentage` varchar(45) DEFAULT NULL,
  `pf_percentage` varchar(45) DEFAULT NULL,
  `pre_punch` varchar(45) DEFAULT NULL,
  `per_day_salary_tax` decimal(10,2) DEFAULT NULL,
  `per_month_salary_tax` decimal(10,2) DEFAULT NULL,
  `uan_no` varchar(45) DEFAULT NULL,
  `rating` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `end_line_qc_table`
--

DROP TABLE IF EXISTS `end_line_qc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `end_line_qc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `style` varchar(45) DEFAULT NULL,
  `colour` varchar(45) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `good` varchar(45) DEFAULT NULL,
  `defect` varchar(45) DEFAULT NULL,
  `reject` varchar(45) DEFAULT NULL,
  `rectified` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `enquiry_last_update`
--

DROP TABLE IF EXISTS `enquiry_last_update`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enquiry_last_update` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `enquiry_id` int(11) DEFAULT NULL,
  `last_update_date` date DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `enq_fk_main_call_idx` (`tid`),
  KEY `enq_fk_main_call` (`enquiry_id`),
  CONSTRAINT `enq_fk_main_call` FOREIGN KEY (`enquiry_id`) REFERENCES `enquiry_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `enquiry_table`
--

DROP TABLE IF EXISTS `enquiry_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enquiry_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `data_date` date DEFAULT NULL,
  `source` varchar(90) DEFAULT NULL,
  `tele_caller` varchar(90) DEFAULT NULL,
  `customer_name` varchar(90) DEFAULT NULL,
  `company_name` varchar(90) DEFAULT NULL,
  `street_address` text,
  `city` varchar(90) DEFAULT NULL,
  `state` varchar(90) DEFAULT NULL,
  `contact_no` text,
  `email` text,
  `requirment` varchar(120) DEFAULT NULL,
  `feedback` text,
  `appoinment_date` date DEFAULT NULL,
  `process_status` varchar(90) DEFAULT NULL,
  `other_details` text,
  `priority` varchar(90) DEFAULT NULL,
  `last_update_date` date DEFAULT NULL,
  `gstin` varchar(45) DEFAULT NULL,
  `dealer_name` varchar(90) DEFAULT NULL,
  `deal_value` decimal(10,2) DEFAULT NULL,
  `lead_stage` varchar(90) DEFAULT NULL,
  `deal_close_date` date DEFAULT NULL,
  `order_qty` decimal(10,3) DEFAULT NULL,
  `date_of_delivery` varchar(90) DEFAULT NULL,
  `attachment_url` text,
  `lead_category` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `estimate_attachment_table`
--

DROP TABLE IF EXISTS `estimate_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_estimate_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_estimate_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `estimate_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `estimate_main_table`
--

DROP TABLE IF EXISTS `estimate_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `estimate_product_table`
--

DROP TABLE IF EXISTS `estimate_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_estimate_main_idx` (`main_id_fk`),
  CONSTRAINT `key_estimate_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `estimate_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `estimate_tax_dis_table`
--

DROP TABLE IF EXISTS `estimate_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `estimate_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_estimate_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_estimate_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `estimate_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `expense_attachment_table`
--

DROP TABLE IF EXISTS `expense_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_exp_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_exp_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `expense_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `expense_main_table`
--

DROP TABLE IF EXISTS `expense_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  `outstanding_amt` varchar(100) DEFAULT NULL,
  `s_company_name` varchar(100) DEFAULT NULL,
  `mode_of_payment` varchar(100) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `expense_product_table`
--

DROP TABLE IF EXISTS `expense_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_expense_main_idx` (`main_id_fk`),
  CONSTRAINT `key_expense_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `expense_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `expense_tax_dis_table`
--

DROP TABLE IF EXISTS `expense_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_expense_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_expense_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `expense_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fabric_per_master_table`
--

DROP TABLE IF EXISTS `fabric_per_master_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fabric_per_master_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `fabric` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fabric_planning_table`
--

DROP TABLE IF EXISTS `fabric_planning_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fabric_planning_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `style_name` varchar(225) DEFAULT NULL,
  `colour` varchar(225) DEFAULT NULL,
  `fabric_name` varchar(225) DEFAULT NULL,
  `yarn_name` varchar(225) DEFAULT NULL,
  `consuption_percentage` decimal(10,2) DEFAULT NULL,
  `knit_dia` varchar(150) DEFAULT NULL,
  `finish_dia` varchar(150) DEFAULT NULL,
  `gg` varchar(150) DEFAULT NULL,
  `gsm` varchar(45) DEFAULT NULL,
  `loop_length` varchar(150) DEFAULT NULL,
  `count` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `yarn_programming_fk_id_idx` (`main_id_fk`),
  CONSTRAINT `yarn_programming_fk_id` FOREIGN KEY (`main_id_fk`) REFERENCES `style_planning_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fabric_trims_life_cycle_table`
--

DROP TABLE IF EXISTS `fabric_trims_life_cycle_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fabric_trims_life_cycle_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `style_name` varchar(150) DEFAULT NULL,
  `colour` varchar(150) DEFAULT NULL,
  `fabric_trims_name` varchar(150) DEFAULT NULL,
  `life_cycle_name` varchar(150) DEFAULT NULL,
  `wastage_percentage` decimal(10,2) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `fk_main_style_planning_idx` (`main_id_fk`),
  KEY `life_cycle_fk_id_idx` (`main_id_fk`),
  CONSTRAINT `life_cycle_fk_id` FOREIGN KEY (`main_id_fk`) REFERENCES `style_planning_main` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `favourites_table`
--

DROP TABLE IF EXISTS `favourites_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `favourites_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` text,
  `created_by` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_inward_main_table`
--

DROP TABLE IF EXISTS `final_checking_inward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_inward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` varchar(45) DEFAULT NULL,
  `jobwork_id` varchar(95) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` varchar(95) DEFAULT NULL,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(150) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_inward_product_table`
--

DROP TABLE IF EXISTS `final_checking_inward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_inward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` varchar(95) DEFAULT NULL,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_inward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_inward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_inward_tax_dis_table`
--

DROP TABLE IF EXISTS `final_checking_inward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_inward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_inward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_inward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_outward_main_table`
--

DROP TABLE IF EXISTS `final_checking_outward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_outward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` varchar(45) DEFAULT NULL,
  `jobwork_id` varchar(95) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` varchar(95) DEFAULT NULL,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(150) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_outward_product_table`
--

DROP TABLE IF EXISTS `final_checking_outward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_outward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` varchar(95) DEFAULT NULL,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_outward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_outward_tax_dis_table`
--

DROP TABLE IF EXISTS `final_checking_outward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_outward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_outward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_outward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_return_main_table`
--

DROP TABLE IF EXISTS `final_checking_return_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_return_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` varchar(45) DEFAULT NULL,
  `jobwork_id` varchar(95) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` varchar(95) DEFAULT NULL,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(150) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_return_product_table`
--

DROP TABLE IF EXISTS `final_checking_return_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_return_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` varchar(95) DEFAULT NULL,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_return_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_return_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `final_checking_return_tax_dis_table`
--

DROP TABLE IF EXISTS `final_checking_return_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `final_checking_return_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_final_checking_return_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_final_checking_return_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `final_checking_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `finance_master`
--

DROP TABLE IF EXISTS `finance_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `finance_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `finance_name` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `notes` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fit_table`
--

DROP TABLE IF EXISTS `fit_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fit_table` (
  `fit_name` varchar(250) NOT NULL,
  `create_date` date DEFAULT NULL,
  `details` text,
  PRIMARY KEY (`fit_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gc_main_table`
--

DROP TABLE IF EXISTS `gc_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gc_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `bill_to_bill` decimal(10,2) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gc_product_table`
--

DROP TABLE IF EXISTS `gc_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gc_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,3) NOT NULL DEFAULT '0.000',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_gc_main_idx` (`main_id_fk`),
  CONSTRAINT `key_gc_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `gc_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `gc_tax_dis_table`
--

DROP TABLE IF EXISTS `gc_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gc_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_gc_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_gc_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `gc_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `grey_opening_stock_table`
--

DROP TABLE IF EXISTS `grey_opening_stock_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grey_opening_stock_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(250) DEFAULT NULL,
  `product_name` varchar(250) DEFAULT NULL,
  `stock` decimal(10,3) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `grn_attachment_table`
--

DROP TABLE IF EXISTS `grn_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grn_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_grn_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_grn_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `grn_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `grn_main_table`
--

DROP TABLE IF EXISTS `grn_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grn_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(100) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `grn_product_table`
--

DROP TABLE IF EXISTS `grn_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grn_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_grn_main_idx` (`main_id_fk`),
  CONSTRAINT `key_grn_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `grn_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `grn_tax_dis_table`
--

DROP TABLE IF EXISTS `grn_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `grn_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(150) DEFAULT NULL,
  `tax_dis_amount` varchar(150) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_grn_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_grn_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `grn_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ie_planning_table`
--

DROP TABLE IF EXISTS `ie_planning_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ie_planning_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `io_no` varchar(45) DEFAULT NULL,
  `style_name` varchar(45) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  `sam_value` varchar(45) DEFAULT NULL,
  `efficiency_per` varchar(45) DEFAULT NULL,
  `planned_sam` varchar(45) DEFAULT NULL,
  `total_req_min` varchar(45) DEFAULT NULL,
  `no_of_operators` varchar(45) DEFAULT NULL,
  `no_of_hrs_per_day` varchar(45) DEFAULT NULL,
  `target_days` varchar(45) DEFAULT NULL,
  `total_required_days` varchar(45) DEFAULT NULL,
  `notes` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ie_planning_table_qlty`
--

DROP TABLE IF EXISTS `ie_planning_table_qlty`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ie_planning_table_qlty` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `io_no` varchar(45) DEFAULT NULL,
  `style_name` varchar(45) DEFAULT NULL,
  `color` varchar(45) DEFAULT NULL,
  `sam_value` varchar(45) DEFAULT NULL,
  `efficiency_per` varchar(45) DEFAULT NULL,
  `planned_sam` varchar(45) DEFAULT NULL,
  `total_req_min` varchar(45) DEFAULT NULL,
  `no_of_operators` varchar(45) DEFAULT NULL,
  `no_of_hrs_per_day` varchar(45) DEFAULT NULL,
  `target_days` varchar(45) DEFAULT NULL,
  `total_required_days` varchar(45) DEFAULT NULL,
  `notes` text,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inventory_tracker_table`
--

DROP TABLE IF EXISTS `inventory_tracker_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inventory_tracker_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `sku` varchar(150) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `process_name` varchar(150) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `create_time` varchar(90) DEFAULT NULL,
  `reverse_notes` text,
  `user_name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invoice_attachment_table`
--

DROP TABLE IF EXISTS `invoice_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_inv_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_inv_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `invoice_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invoice_emp_commission`
--

DROP TABLE IF EXISTS `invoice_emp_commission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_emp_commission` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `commession_amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `inv_fk_call_idx` (`main_id_fk`),
  CONSTRAINT `inv_fk_call` FOREIGN KEY (`main_id_fk`) REFERENCES `invoice_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invoice_main_table`
--

DROP TABLE IF EXISTS `invoice_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `bill_to_bill` decimal(10,2) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `bank_name` varchar(200) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  `irn_no` varchar(500) DEFAULT NULL,
  `act_no` varchar(100) DEFAULT NULL,
  `act_date` varchar(100) DEFAULT NULL,
  `s_company_name` varchar(100) DEFAULT NULL,
  `outstanding_amt` varchar(100) DEFAULT NULL,
  `mode_of_payment` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invoice_product_table`
--

DROP TABLE IF EXISTS `invoice_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,3) NOT NULL DEFAULT '0.000',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_invoice_main_idx` (`main_id_fk`),
  CONSTRAINT `key_invoice_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `invoice_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=780 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `invoice_tax_dis_table`
--

DROP TABLE IF EXISTS `invoice_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_invoice_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_invoice_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `invoice_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inward_attachment_table`
--

DROP TABLE IF EXISTS `inward_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inward_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_inward_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_inward_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inward_main_table`
--

DROP TABLE IF EXISTS `inward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(220) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inward_product_table`
--

DROP TABLE IF EXISTS `inward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_inward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_inward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `inward_tax_dis_table`
--

DROP TABLE IF EXISTS `inward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `inward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_inward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_inward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_id_main_table`
--

DROP TABLE IF EXISTS `jobwork_id_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_id_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `jw_name` varchar(100) DEFAULT NULL,
  `jw_number` int(11) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(100) DEFAULT NULL,
  `jw_status` varchar(40) DEFAULT NULL,
  `jw_against` varchar(45) DEFAULT NULL,
  `other_details` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_life_cycle_table`
--

DROP TABLE IF EXISTS `jobwork_life_cycle_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_life_cycle_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` int(11) DEFAULT NULL,
  `process_name` varchar(200) DEFAULT NULL,
  `wastage_percent` decimal(10,2) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `main_id_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main-if_fk_jw_main_table_idx` (`main_id_fk`),
  CONSTRAINT `main-if_fk_jw_main_table` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_id_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_main_table`
--

DROP TABLE IF EXISTS `jobwork_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(200) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_inward_main_table`
--

DROP TABLE IF EXISTS `jobwork_process_inward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_inward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_inward_product_table`
--

DROP TABLE IF EXISTS `jobwork_process_inward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_inward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_inward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_inward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_inward_tax_dis_table`
--

DROP TABLE IF EXISTS `jobwork_process_inward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_inward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(150) DEFAULT NULL,
  `tax_dis_amount` varchar(150) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_inward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_inward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_inward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_outward_main_table`
--

DROP TABLE IF EXISTS `jobwork_process_outward_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_outward_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_outward_product_table`
--

DROP TABLE IF EXISTS `jobwork_process_outward_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_outward_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_outward_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_outward_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_outward_tax_dis_table`
--

DROP TABLE IF EXISTS `jobwork_process_outward_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_outward_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(150) DEFAULT NULL,
  `tax_dis_amount` varchar(150) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_outward_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_outward_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_outward_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_return_main_table`
--

DROP TABLE IF EXISTS `jobwork_process_return_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_return_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(10) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(250) DEFAULT NULL,
  `a1` varchar(95) DEFAULT NULL,
  `a2` varchar(95) DEFAULT NULL,
  `a3` varchar(95) DEFAULT NULL,
  `a4` varchar(95) DEFAULT NULL,
  `a5` varchar(95) DEFAULT NULL,
  `a6` varchar(95) DEFAULT NULL,
  `a7` varchar(95) DEFAULT NULL,
  `a8` varchar(95) DEFAULT NULL,
  `a9` varchar(95) DEFAULT NULL,
  `a10` varchar(95) DEFAULT NULL,
  `a11` varchar(95) DEFAULT NULL,
  `a12` varchar(95) DEFAULT NULL,
  `a13` varchar(95) DEFAULT NULL,
  `a14` varchar(95) DEFAULT NULL,
  `a15` varchar(95) DEFAULT NULL,
  `a16` varchar(95) DEFAULT NULL,
  `a17` varchar(95) DEFAULT NULL,
  `a18` varchar(95) DEFAULT NULL,
  `a19` varchar(95) DEFAULT NULL,
  `a20` varchar(95) DEFAULT NULL,
  `a21` varchar(95) DEFAULT NULL,
  `a22` text,
  `a23` varchar(95) DEFAULT NULL,
  `a24` varchar(95) DEFAULT NULL,
  `a25` varchar(95) DEFAULT NULL,
  `a26` varchar(95) DEFAULT NULL,
  `a27` varchar(95) DEFAULT NULL,
  `a28` varchar(95) DEFAULT NULL,
  `a29` varchar(95) DEFAULT NULL,
  `a30` varchar(95) DEFAULT NULL,
  `status` varchar(95) DEFAULT NULL,
  `approved_status` varchar(95) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_return_product_table`
--

DROP TABLE IF EXISTS `jobwork_process_return_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_return_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` varchar(95) DEFAULT NULL,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_return_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_return_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_process_return_tax_dis_table`
--

DROP TABLE IF EXISTS `jobwork_process_return_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_process_return_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(150) DEFAULT NULL,
  `tax_dis_amount` varchar(150) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_process_return_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_process_return_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_process_return_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_product_table`
--

DROP TABLE IF EXISTS `jobwork_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_product_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product_name` text,
  `description` text,
  `c1` varchar(95) DEFAULT NULL,
  `c2` varchar(95) DEFAULT NULL,
  `c3` varchar(95) DEFAULT NULL,
  `c4` varchar(95) DEFAULT NULL,
  `c5` varchar(95) DEFAULT NULL,
  `c6` varchar(95) DEFAULT NULL,
  `c7` varchar(95) DEFAULT NULL,
  `c8` varchar(95) DEFAULT NULL,
  `qty` decimal(10,3) NOT NULL DEFAULT '0.000',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_inc_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pack_stcok` decimal(10,3) NOT NULL DEFAULT '0.000',
  `unit` varchar(45) DEFAULT NULL,
  `c9` varchar(95) DEFAULT NULL,
  `c10` varchar(95) DEFAULT NULL,
  `c11` text,
  `c12` varchar(95) DEFAULT NULL,
  `c13` varchar(95) DEFAULT NULL,
  `c14` varchar(95) DEFAULT NULL,
  `c15` varchar(95) DEFAULT NULL,
  `c16` varchar(95) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `discount_amt` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_product_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobwork_tax_dis_table`
--

DROP TABLE IF EXISTS `jobwork_tax_dis_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobwork_tax_dis_table` (
  `tid` bigint(20) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `tax_dis_name` varchar(45) DEFAULT NULL,
  `tax_dis_amount` decimal(10,2) DEFAULT NULL,
  `cgst_percentage` decimal(10,2) DEFAULT NULL,
  `cgst_amt` decimal(10,2) DEFAULT NULL,
  `sgst_percentage` decimal(10,2) DEFAULT NULL,
  `sgst_amt` decimal(10,2) DEFAULT NULL,
  `igst_percentage` decimal(10,2) DEFAULT NULL,
  `igst_amt` decimal(10,2) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `key_jobwork_tax_dis_call_main_idx` (`main_id_fk`),
  CONSTRAINT `key_jobwork_tax_dis_call_main` FOREIGN KEY (`main_id_fk`) REFERENCES `jobwork_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `journal_table`
--

DROP TABLE IF EXISTS `journal_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `journal_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `bank_name` varchar(95) DEFAULT NULL,
  `mode_of_payment` varchar(95) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `credit` decimal(10,2) DEFAULT NULL,
  `debit` decimal(10,2) DEFAULT NULL,
  `contact_person` varchar(95) DEFAULT NULL,
  `details` text,
  `contact_person_contact_no` varchar(95) DEFAULT NULL,
  `bank_name_cus_vendor` varchar(95) DEFAULT NULL,
  `reference_no` varchar(95) DEFAULT NULL,
  `payment_for` varchar(45) DEFAULT NULL COMMENT 'vendor,customer,employee',
  `employee_name` varchar(200) DEFAULT NULL,
  `user_name` varchar(90) DEFAULT NULL,
  `currency_type` varchar(45) DEFAULT NULL,
  `exchange_rate` decimal(10,2) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `payment_against` varchar(200) DEFAULT NULL,
  `transaction_status` varchar(90) DEFAULT NULL,
  `clearance_date` date DEFAULT NULL,
  `printname` varchar(250) DEFAULT NULL,
  `branch` varchar(200) DEFAULT NULL,
  `inv_no` int(11) DEFAULT NULL,
  `ref_branch` varchar(45) DEFAULT NULL,
  `company_profile` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_category_master`
--

DROP TABLE IF EXISTS `lead_category_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_category_master` (
  `category` varchar(250) DEFAULT NULL,
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_city_master`
--

DROP TABLE IF EXISTS `lead_city_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_city_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_country_master`
--

DROP TABLE IF EXISTS `lead_country_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_country_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_mail_cc_table`
--

DROP TABLE IF EXISTS `lead_mail_cc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_mail_cc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `cc` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `cc_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_priority_master`
--

DROP TABLE IF EXISTS `lead_priority_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_priority_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `priority` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_product_source_table`
--

DROP TABLE IF EXISTS `lead_product_source_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_product_source_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(250) DEFAULT NULL,
  `describition` text,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `category` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_product_table`
--

DROP TABLE IF EXISTS `lead_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_product_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `product` varchar(250) DEFAULT NULL,
  `qty` decimal(10,3) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_lead_product_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_lead_product` FOREIGN KEY (`main_id_fk`) REFERENCES `crm_lead_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_source_master`
--

DROP TABLE IF EXISTS `lead_source_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_source_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `lead_source` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_stage_master`
--

DROP TABLE IF EXISTS `lead_stage_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_stage_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `lead_stage` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_stage_template_master_main_table`
--

DROP TABLE IF EXISTS `lead_stage_template_master_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_stage_template_master_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `lead_stage` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_stage_template_master_sub_table`
--

DROP TABLE IF EXISTS `lead_stage_template_master_sub_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_stage_template_master_sub_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `descriptions` varchar(45) DEFAULT NULL,
  `sort_order` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_lead_stage_template_master_main_table` (`main_id_fk`),
  CONSTRAINT `main_id_fk_lead_stage_template_master_main_table` FOREIGN KEY (`main_id_fk`) REFERENCES `lead_stage_template_master_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_state_master`
--

DROP TABLE IF EXISTS `lead_state_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_state_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `state` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `lead_status_master`
--

DROP TABLE IF EXISTS `lead_status_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_status_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `lead_status` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `created_by` varchar(250) DEFAULT NULL,
  `describition` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `life_cycle_master`
--

DROP TABLE IF EXISTS `life_cycle_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `life_cycle_master` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(90) DEFAULT NULL,
  `process_name` varchar(90) DEFAULT NULL,
  `wastage_percent` decimal(10,2) DEFAULT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `default_process_type` varchar(120) DEFAULT NULL,
  `visible_process` varchar(45) DEFAULT NULL,
  `main_id_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `life_cycle_order_fk_idx` (`main_id_fk`),
  CONSTRAINT `life_cycle_order_fk` FOREIGN KEY (`main_id_fk`) REFERENCES `order_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `life_cycle_master_main_table`
--

DROP TABLE IF EXISTS `life_cycle_master_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `life_cycle_master_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` varchar(45) DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` varchar(45) DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `life_cycle_process_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `life_cycle_master_sub_table`
--

DROP TABLE IF EXISTS `life_cycle_master_sub_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `life_cycle_master_sub_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(90) DEFAULT NULL,
  `process_name` varchar(90) DEFAULT NULL,
  `wastage_percent` decimal(10,2) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `default_process_type` varchar(120) DEFAULT NULL,
  `visible_process` varchar(45) DEFAULT NULL,
  `main_id_fk` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_life_cycle_master_main_table_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_life_cycle_master_main_table` FOREIGN KEY (`main_id_fk`) REFERENCES `life_cycle_master_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `life_cycle_process_table`
--

DROP TABLE IF EXISTS `life_cycle_process_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `life_cycle_process_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(95) DEFAULT NULL,
  `process_name` varchar(95) DEFAULT NULL,
  `wastage_percentage` decimal(10,2) DEFAULT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(100) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `log_table`
--

DROP TABLE IF EXISTS `log_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `recent_head` text,
  `recent_body` text,
  `recent_search_id` int(11) DEFAULT NULL,
  `recent_type` varchar(90) DEFAULT NULL,
  `user_name` varchar(250) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `create_time` varchar(95) DEFAULT NULL,
  `tech_details` text,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `machine_master_tbl`
--

DROP TABLE IF EXISTS `machine_master_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `machine_master_tbl` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `machine_name` varchar(200) DEFAULT NULL,
  `group_name` varchar(200) DEFAULT NULL,
  `sub_group` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `machine_product_table`
--

DROP TABLE IF EXISTS `machine_product_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `machine_product_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id` int(11) DEFAULT NULL,
  `product` varchar(200) DEFAULT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `warranty` int(11) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `machine_reading_tbl`
--

DROP TABLE IF EXISTS `machine_reading_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `machine_reading_tbl` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `machine_name` varchar(200) DEFAULT NULL,
  `opening_reading` decimal(10,3) DEFAULT NULL,
  `closing_reading` decimal(10,3) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `group_name` varchar(200) DEFAULT NULL,
  `sub_group` varchar(200) DEFAULT NULL,
  `total_closing_reading` decimal(10,3) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `machine_ticket_table`
--

DROP TABLE IF EXISTS `machine_ticket_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `machine_ticket_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(200) DEFAULT NULL,
  `contact_person_name` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone_no` varchar(200) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `issuse_type` varchar(200) DEFAULT NULL,
  `guarantee_status` varchar(200) DEFAULT NULL,
  `model` varchar(200) DEFAULT NULL,
  `material_name` varchar(200) DEFAULT NULL,
  `part_missing` text,
  `other_details` text,
  `ticket_status` varchar(45) DEFAULT NULL,
  `product_code` varchar(125) DEFAULT NULL,
  `serial_no` varchar(125) DEFAULT NULL,
  `advance_amount` decimal(10,2) DEFAULT NULL,
  `bill_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `magic_search_table`
--

DROP TABLE IF EXISTS `magic_search_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `magic_search_table` (
  `search_id` varchar(75) NOT NULL,
  `keywords` text,
  `display_name` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`search_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mail_cc_table`
--

DROP TABLE IF EXISTS `mail_cc_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_cc_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `cc` varchar(250) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  `cc_name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mail_template_table`
--

DROP TABLE IF EXISTS `mail_template_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_template_table` (
  `mail_template_name` varchar(95) NOT NULL,
  `mail_template` text,
  `subject` text,
  PRIMARY KEY (`mail_template_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `maill_account_table`
--

DROP TABLE IF EXISTS `maill_account_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `maill_account_table` (
  `email` varchar(95) NOT NULL,
  `password` varchar(95) DEFAULT NULL,
  `smtp` varchar(95) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `ssl` varchar(45) DEFAULT NULL,
  `cc_mail` text,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `material_indent_attachment_table`
--

DROP TABLE IF EXISTS `material_indent_attachment_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `material_indent_attachment_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `main_id_fk` int(11) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ext_file` varchar(45) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(45) DEFAULT NULL,
  `last_updated_on` date DEFAULT NULL,
  `last_updated_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`),
  KEY `main_id_fk_material_indent_multi_attach_idx` (`main_id_fk`),
  CONSTRAINT `main_id_fk_material_indent_multi_attach` FOREIGN KEY (`main_id_fk`) REFERENCES `material_indent_main_table` (`tid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `material_indent_main_table`
--

DROP TABLE IF EXISTS `material_indent_main_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `material_indent_main_table` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `generate_no` int(11) DEFAULT NULL,
  `company_name` varchar(95) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `renewal_date` date DEFAULT NULL,
  `terms` text,
  `other_details` text,
  `tags` varchar(95) DEFAULT NULL,
  `transport_details` text,
  `dc_inward_details` text,
  `staffname` varchar(95) DEFAULT NULL,
  `order_number` varchar(45) DEFAULT NULL,
  `reference_number` varchar(45) DEFAULT NULL,
  `reduce_to_stock` tinyint(1) DEFAULT NULL,
  `add_to_stock` tinyint(1) DEFAULT NULL,
  `print_form_type` varchar(95) DEFAULT NULL,
  `accounting_year` varchar(220) DEFAULT NULL,
  `narration` text,
  `jobwork_id` varchar(150) DEFAULT NULL,
  `a1` varchar(200) DEFAULT NULL,
  `a2` varchar(200) DEFAULT NULL,
  `a3` varchar(200) DEFAULT NULL,
  `a4` varchar(200) DEFAULT NULL,
  `a5` varchar(200) DEFAULT NULL,
  `a6` varchar(200) DEFAULT NULL,
  `a7` varchar(200) DEFAULT NULL,
  `a8` varchar(200) DEFAULT NULL,
  `a9` varchar(200) DEFAULT NULL,
  `a10` varchar(200) DEFAULT NULL,
  `a11` varchar(200) DEFAULT NULL,
  `a12` varchar(200) DEFAULT NULL,
  `a13` varchar(200) DEFAULT NULL,
  `a14` varchar(200) DEFAULT NULL,
  `a15` varchar(200) DEFAULT NULL,
  `a16` varchar(200) DEFAULT NULL,
  `a17` varchar(200) DEFAULT NULL,
  `a18` varchar(200) DEFAULT NULL,
  `a19` varchar(200) DEFAULT NULL,
  `a20` varchar(200) DEFAULT NULL,
  `a21` varchar(200) DEFAULT NULL,
  `a22` text,
  `a23` varchar(200) DEFAULT NULL,
  `a24` varchar(200) DEFAULT NULL,
  `a25` varchar(200) DEFAULT NULL,
  `a26` varchar(200) DEFAULT NULL,
  `a27` varchar(200) DEFAULT NULL,
  `a28` varchar(200) DEFAULT NULL,
  `a29` varchar(200) DEFAULT NULL,
  `a30` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `approved_status` varchar(200) DEFAULT NULL,
  `round_off` decimal(10,2) DEFAULT NULL,
  `warehouse` varchar(90) DEFAULT NULL,
  `created_on` date DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `other_charges` decimal(10,2) DEFAULT NULL,
  `company_profile` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
