-- MySQL dump 10.13  Distrib 8.0.21, for Win64 (x86_64)
--
-- Host: localhost    Database: elan_europ_production2
-- ------------------------------------------------------
-- Server version	8.0.21

/*!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 `activity`
--

DROP TABLE IF EXISTS `activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity` (
  `act_id` int NOT NULL AUTO_INCREMENT,
  `act_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `act_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `act_active` tinyint(1) NOT NULL DEFAULT '1',
  `act_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `act_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `act_deleted` int NOT NULL DEFAULT '0',
  `act_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`act_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activity_detail`
--

DROP TABLE IF EXISTS `activity_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `activity_detail` (
  `actDet_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `act_id` int NOT NULL,
  `actDet_code` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `actDet_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `actDet_active` int NOT NULL DEFAULT '0',
  `actDet_createdDate` timestamp NULL DEFAULT NULL,
  `actDet_updatedDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `actDet_equipment` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`actDet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `article` (
  `art_id` int NOT NULL AUTO_INCREMENT,
  `art_ordre` int NOT NULL DEFAULT '0',
  `art_code` int DEFAULT NULL,
  `art_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `art_active` tinyint(1) NOT NULL DEFAULT '1',
  `art_createdDate` timestamp NULL DEFAULT NULL,
  `art_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `art_costPrice` decimal(10,2) DEFAULT NULL,
  `art_selPrice` decimal(10,2) DEFAULT NULL,
  `art_coef` decimal(10,2) DEFAULT NULL,
  `art_brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `art_supplierReference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `art_reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`art_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `article_quote`
--

DROP TABLE IF EXISTS `article_quote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `article_quote` (
  `artQuo_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `art_id` int DEFAULT NULL,
  `element_id` int DEFAULT NULL,
  `artQuo_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `artQuo_amountHt` double(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`artQuo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `authorised_ip`
--

DROP TABLE IF EXISTS `authorised_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `authorised_ip` (
  `autIp_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `autIp_ipValue` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `autIp_active` int NOT NULL DEFAULT '0',
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `autIp_createdDate` timestamp NULL DEFAULT NULL,
  `autIp_updatedDate` timestamp NULL DEFAULT NULL,
  `autIp_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `autIp_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`autIp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2535 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `billingcompany`
--

DROP TABLE IF EXISTS `billingcompany`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `billingcompany` (
  `bil_id` int NOT NULL AUTO_INCREMENT,
  `bil_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bil_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int NOT NULL,
  `bil_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `bil_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `bil_siret` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_tvaIntra` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `payPer_id` int DEFAULT NULL,
  `bil_paymentPeriod` int DEFAULT NULL,
  `bil_active` tinyint(1) NOT NULL DEFAULT '1',
  `cus_id` int NOT NULL,
  `bil_createdDate` timestamp NULL DEFAULT NULL,
  `bil_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `bil_compteComptable` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_deleted` int NOT NULL DEFAULT '0',
  `bil_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`bil_id`)
) ENGINE=InnoDB AUTO_INCREMENT=432 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bordereaux`
--

DROP TABLE IF EXISTS `bordereaux`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bordereaux` (
  `bor_id` int unsigned NOT NULL AUTO_INCREMENT,
  `cus_id` int NOT NULL,
  `bil_id` int NOT NULL,
  `bor_createdDate` timestamp NOT NULL,
  `bor_updatedDate` timestamp NULL DEFAULT NULL,
  `bor_invoiceCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bor_totalAmountHT` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bor_totalAmountTTC` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`bor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `call_incoming_outgoing`
--

DROP TABLE IF EXISTS `call_incoming_outgoing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `call_incoming_outgoing` (
  `CalIncOut_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `CalIncOut_caller` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_receiver` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_statut` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_sonnerie` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_conversation` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_totals` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_cost` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_play` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `CalIncOut_createdDate` timestamp NOT NULL,
  `CalIncOut_updatedDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`CalIncOut_id`)
) ENGINE=InnoDB AUTO_INCREMENT=150065 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `city`
--

DROP TABLE IF EXISTS `city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `city` (
  `cit_id` int NOT NULL AUTO_INCREMENT,
  `cit_name` varchar(30) DEFAULT NULL,
  `cit_zc` varchar(10) DEFAULT NULL,
  `dep_id` int DEFAULT NULL,
  `reg_id` int DEFAULT NULL,
  `cou_id` int NOT NULL,
  `cit_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int NOT NULL,
  `com_idUpdater` int NOT NULL,
  `cit_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int NOT NULL,
  PRIMARY KEY (`cit_id`),
  KEY `CPC` (`cit_zc`),
  KEY `NomC` (`cit_name`)
) ENGINE=InnoDB AUTO_INCREMENT=37043 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contact`
--

DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact` (
  `con_id` int NOT NULL AUTO_INCREMENT,
  `con_firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_id` int NOT NULL DEFAULT '0',
  `sit_id` int NOT NULL DEFAULT '0',
  `con_createdDate` timestamp NULL DEFAULT NULL,
  `con_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `use_idUpdater` int NOT NULL,
  `con_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_fonction` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cus_id` int DEFAULT NULL,
  `pro_id` int DEFAULT NULL,
  PRIMARY KEY (`con_id`)
) ENGINE=InnoDB AUTO_INCREMENT=928 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contract`
--

DROP TABLE IF EXISTS `contract`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract` (
  `con_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `con_startDate` date DEFAULT NULL,
  `con_endDate` date DEFAULT NULL,
  `con_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `con_deleted` int NOT NULL DEFAULT '0',
  `con_createdDate` date DEFAULT NULL,
  `con_updatedDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `con_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_refNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `con_nbDiPrev` int DEFAULT NULL,
  `con_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `con_typeContract` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `cus_id` int NOT NULL,
  `con_estimatedCa` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`con_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contract_file`
--

DROP TABLE IF EXISTS `contract_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract_file` (
  `conFil_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `con_id` int NOT NULL,
  `conFil_description` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conFil_createdDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `conFil_updatedDate` date DEFAULT NULL,
  `conFil_visibleProvider` int NOT NULL DEFAULT '1',
  `conFil_visibleSite` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`conFil_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contract_invoice`
--

DROP TABLE IF EXISTS `contract_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract_invoice` (
  `conInv_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `con_id` int NOT NULL,
  `conInv_description` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conInv_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conInv_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conInv_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `conInv_intNb` int NOT NULL DEFAULT '0',
  `conInv_intList` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `conInv_amountHt` double(8,2) NOT NULL DEFAULT '0.00',
  `conInv_amountTtc` double(8,2) NOT NULL DEFAULT '0.00',
  `conInv_createdDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `conInv_updatedDate` date DEFAULT NULL,
  PRIMARY KEY (`conInv_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country` (
  `cou_id` int NOT NULL AUTO_INCREMENT,
  `cou_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cou_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cou_indicative` smallint NOT NULL,
  `cou_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int NOT NULL,
  `com_idUpdater` int NOT NULL,
  `cou_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int NOT NULL,
  PRIMARY KEY (`cou_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `cus_id` int NOT NULL AUTO_INCREMENT,
  `cus_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cus_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int NOT NULL,
  `cus_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cus_active` tinyint(1) NOT NULL DEFAULT '1',
  `cus_createdDate` timestamp NULL DEFAULT NULL,
  `cus_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `cus_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_comments` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cus_juridicForm` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cus_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`cus_id`),
  KEY `id` (`cus_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_invoice`
--

DROP TABLE IF EXISTS `customer_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_invoice` (
  `cusInv_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `cusInv_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusInv_achievementDate` date DEFAULT NULL,
  `cusInv_deadlineDate` date DEFAULT NULL,
  `cusInv_payed` int NOT NULL DEFAULT '0',
  `cusInv_paymentDate` date DEFAULT NULL,
  `cusInv_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sta_id` int NOT NULL,
  `cusInv_amountHT` decimal(10,2) NOT NULL,
  `cusInv_tva` decimal(5,2) NOT NULL,
  `cusInv_amountTTC` decimal(10,2) NOT NULL,
  `use_idCreator` int DEFAULT NULL,
  `cusQuo_id` int NOT NULL DEFAULT '0',
  `cusInv_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusInv_createdDate` timestamp NULL DEFAULT NULL,
  `cusInv_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `cusInv_exported` int NOT NULL DEFAULT '0',
  `cusInv_exportedDate` datetime DEFAULT NULL,
  `cusInv_sended` tinyint unsigned DEFAULT NULL,
  `cusInv_dateSendedMailInvoice` datetime DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `bil_id` int DEFAULT '0',
  `cusInv_lastRelaunchDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusInv_exportUserId` int DEFAULT NULL,
  `bor_id` int DEFAULT NULL,
  PRIMARY KEY (`cusInv_id`),
  KEY `cusQuo_id` (`cusQuo_id`),
  KEY `int_id` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29488 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_invoice_detail`
--

DROP TABLE IF EXISTS `customer_invoice_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_invoice_detail` (
  `cusInvDet_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cusInv_id` int NOT NULL,
  `art_id` int DEFAULT NULL,
  `cusInvDet_order` int DEFAULT NULL,
  `cusInvDet_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusInvDet_qty` decimal(10,2) DEFAULT '0.00',
  `cusInvDet_amountHT` decimal(10,2) DEFAULT '0.00',
  `cusInvDet_title` int NOT NULL DEFAULT '0',
  `cusInvDet_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusInvDet_createdDate` datetime DEFAULT NULL,
  `cusInvDet_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`cusInvDet_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96427 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_quote`
--

DROP TABLE IF EXISTS `customer_quote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_quote` (
  `cusQuo_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int DEFAULT NULL,
  `cusQuo_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusQuo_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuo_achievementDate` date DEFAULT NULL,
  `cusQuo_replyDate` datetime DEFAULT NULL,
  `cusQuo_raisonRefus` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sta_id` int DEFAULT NULL,
  `cusQuo_amountHT` decimal(10,2) DEFAULT NULL,
  `cusQuo_tva` decimal(5,2) DEFAULT NULL,
  `cusQuo_amountTTC` decimal(10,2) DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `cusInv_id` int DEFAULT '0',
  `cusQuo_createdDate` timestamp NULL DEFAULT NULL,
  `cusQuo_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `intFil_id_bpa` int DEFAULT NULL,
  `cusQuo_sended` tinyint unsigned DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `cusQuo_conditions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuo_sendedDate` date DEFAULT NULL,
  `cusQuo_lastRelaunchDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`cusQuo_id`),
  KEY `cusInv_id` (`cusInv_id`),
  KEY `int_id` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20633 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_quote_detail`
--

DROP TABLE IF EXISTS `customer_quote_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_quote_detail` (
  `cusQuoDet_id` int NOT NULL AUTO_INCREMENT,
  `cusQuo_id` int NOT NULL,
  `cusInv_id` int NOT NULL DEFAULT '0',
  `art_id` int DEFAULT '0',
  `cusQuoDet_order` int DEFAULT NULL,
  `cusQuoDet_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuoDet_qty` decimal(10,2) DEFAULT '0.00',
  `cusQuoDet_amountHT` decimal(10,2) DEFAULT '0.00',
  `cusQuoDet_title` int DEFAULT '0',
  `cusQuoDet_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusQuoDet_createdDate` datetime DEFAULT NULL,
  `cusQuoDet_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  PRIMARY KEY (`cusQuoDet_id`),
  KEY `cusQuo_id` (`cusQuo_id`),
  KEY `cusInv_id` (`cusInv_id`)
) ENGINE=InnoDB AUTO_INCREMENT=123313 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_quote_detail_type`
--

DROP TABLE IF EXISTS `customer_quote_detail_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_quote_detail_type` (
  `cusQuoDetTyp_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cusQuoTyp_id` int DEFAULT NULL,
  `art_id` int DEFAULT NULL,
  `cusQuoDetTyp_order` int DEFAULT NULL,
  `cusQuoDetTyp_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuoDetTyp_qty` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusQuoDetTyp_amountHT` decimal(10,2) DEFAULT NULL,
  `cusQuoDetTyp_title` int DEFAULT NULL,
  `cusQuoDetTyp_unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusQuoDetTyp_createdDate` date DEFAULT NULL,
  `cusQuoDetTyp_updatedDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  PRIMARY KEY (`cusQuoDetTyp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customer_quote_type`
--

DROP TABLE IF EXISTS `customer_quote_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_quote_type` (
  `cusQuoTyp_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cusQuoTyp_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cusQuoTyp_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuoTyp_amountHT` decimal(10,2) DEFAULT NULL,
  `cusQuoTyp_tva` decimal(5,2) DEFAULT NULL,
  `cusQuoTyp_amountTTC` decimal(10,2) DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `cusQuoTyp_conditions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `cusQuoTyp_createdDate` date DEFAULT NULL,
  `cusQuoTyp_updatedDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `cusQuoDetTyp_default` int DEFAULT '0',
  PRIMARY KEY (`cusQuoTyp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `departement`
--

DROP TABLE IF EXISTS `departement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `departement` (
  `dep_id` int NOT NULL AUTO_INCREMENT,
  `dep_code` char(3) NOT NULL DEFAULT '',
  `dep_name` varchar(255) DEFAULT NULL,
  `reg_id` int DEFAULT NULL,
  `cou_id` int NOT NULL,
  PRIMARY KEY (`dep_id`),
  KEY `Reference` (`reg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `divers`
--

DROP TABLE IF EXISTS `divers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `divers` (
  `div_id` int NOT NULL AUTO_INCREMENT,
  `div_order` tinyint NOT NULL,
  `div_abbrFr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_abbrEn` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_libelleEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_texteFr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_texteEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_active` tinyint(1) NOT NULL DEFAULT '1',
  `div_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `div_endMonth` tinyint NOT NULL,
  `div_defaut` tinyint(1) NOT NULL,
  `men_id` int NOT NULL,
  `div_value` int DEFAULT NULL,
  `div_updatedDate` datetime DEFAULT NULL,
  `div_createdDate` datetime DEFAULT NULL,
  `div_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int NOT NULL,
  `use_idUpdater` int NOT NULL,
  `com_idUpdater` int NOT NULL,
  PRIMARY KEY (`div_id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `equipment`
--

DROP TABLE IF EXISTS `equipment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `equipment` (
  `equ_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `act_id` int NOT NULL,
  `actDet_id` int DEFAULT NULL,
  `equ_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `equ_mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `equ_reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `equ_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `equ_createdDate` timestamp NULL DEFAULT NULL,
  `equ_updatedDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`equ_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `equipment_site`
--

DROP TABLE IF EXISTS `equipment_site`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `equipment_site` (
  `equSit_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `equ_id` int NOT NULL,
  `sit_id` int NOT NULL,
  `equSit_serialNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `equSit_internalNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `equSit_nextActionDate` date DEFAULT NULL,
  `equSit_endGuaranteeDate` date DEFAULT NULL,
  `equSit_installDate` timestamp NULL DEFAULT NULL,
  `equSit_active` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`equSit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `failed_jobs_uuid_index` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=682 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_cusinv`
--

DROP TABLE IF EXISTS `import_cusinv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import_cusinv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_import` int NOT NULL DEFAULT '0',
  `int_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusInv_amountHT` double(8,2) DEFAULT NULL,
  `cusInv_amountTTC` double(8,2) DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `staImp_id` int NOT NULL DEFAULT '0',
  `importable` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_int_cloturecompta`
--

DROP TABLE IF EXISTS `import_int_cloturecompta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import_int_cloturecompta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_import` int NOT NULL DEFAULT '0',
  `int_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `importable` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_majcusinv`
--

DROP TABLE IF EXISTS `import_majcusinv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import_majcusinv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_import` int NOT NULL DEFAULT '0',
  `cusInv_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusInv_amountHT` double(8,2) DEFAULT NULL,
  `cusInv_paymentDate` date DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `staImp_id` int NOT NULL DEFAULT '0',
  `importable` int NOT NULL DEFAULT '0',
  `cusInv_reglee` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_majproinv`
--

DROP TABLE IF EXISTS `import_majproinv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import_majproinv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_import` int NOT NULL DEFAULT '0',
  `proInv_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `proInv_amountHT` double(8,2) DEFAULT NULL,
  `proInv_paymentDate` date DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `staImp_id` int NOT NULL DEFAULT '0',
  `importable` int NOT NULL DEFAULT '0',
  `proInv_reglee` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_proinv`
--

DROP TABLE IF EXISTS `import_proinv`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `import_proinv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_import` int NOT NULL DEFAULT '0',
  `proReq_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `proInv_amountHT` double(8,2) DEFAULT NULL,
  `proInv_amountTTC` double(8,2) DEFAULT NULL,
  `provider_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `staImp_id` int NOT NULL DEFAULT '0',
  `importable` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention`
--

DROP TABLE IF EXISTS `intervention`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention` (
  `int_id` int NOT NULL AUTO_INCREMENT,
  `int_nextId` int DEFAULT NULL,
  `int_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sta_id` int NOT NULL,
  `cus_id` int NOT NULL,
  `sig_id` int NOT NULL,
  `sit_id` int NOT NULL,
  `bil_id` int DEFAULT NULL,
  `act_id` int NOT NULL,
  `int_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `int_desiredPlanningDate` date DEFAULT NULL,
  `int_closingDate` date DEFAULT NULL,
  `int_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `int_customerRef` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `int_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `int_idLinked` int DEFAULT NULL,
  `int_urgency` int DEFAULT '0',
  `int_complex` int DEFAULT '0',
  `int_astreinte` int DEFAULT '0',
  `int_updatedDate` datetime DEFAULT NULL,
  `int_createdDate` datetime DEFAULT NULL,
  `estRat_id` int DEFAULT NULL,
  `int_estimatedRate` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `int_excludeCA` int DEFAULT '0',
  `int_contractNumber` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `int_contact` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `int_type` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pro_idAssigned` int DEFAULT NULL,
  `use_idAssigned` int DEFAULT NULL,
  `use_idAgentAssigned` int DEFAULT NULL,
  `int_amountHT` double(8,2) DEFAULT NULL,
  `int_planningDate` date DEFAULT NULL,
  `int_deleted` int NOT NULL DEFAULT '0',
  `int_qualControlDate` date DEFAULT NULL,
  `int_prevId` int DEFAULT NULL,
  `actDet_id` int DEFAULT NULL,
  `int_achievementDate` date DEFAULT NULL,
  `con_id` int DEFAULT NULL,
  `int_travaux` int NOT NULL DEFAULT '0',
  `int_closed` int NOT NULL DEFAULT '0',
  `int_refused` int NOT NULL DEFAULT '0',
  `int_linkKey_provider` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `int_datePossible` date DEFAULT NULL,
  `int_dateLater` date DEFAULT NULL,
  `sitCon_id` int DEFAULT NULL,
  `int_clotureCompta` tinyint(1) DEFAULT '0',
  `int_dateClotureCompta` datetime DEFAULT NULL,
  `int_linkKey_customer` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `gcalendarEventId` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wor_id` int DEFAULT NULL,
  `int_conStartDate` date DEFAULT NULL,
  `int_conEndDate` date DEFAULT NULL,
  `conInv_id` int DEFAULT NULL,
  `int_gpType` int DEFAULT '0',
  `int_archived` int DEFAULT '0',
  PRIMARY KEY (`int_id`),
  KEY `idx_int_type` (`int_type`),
  KEY `idx_int_statut` (`sta_id`),
  KEY `idx_int_site` (`sit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44292 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_connexion`
--

DROP TABLE IF EXISTS `intervention_connexion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_connexion` (
  `intCon_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `useLog_id` int NOT NULL,
  `intCon_createdDate` datetime NOT NULL,
  `intCon_updatedDate` datetime NOT NULL,
  `use_idCreator` int NOT NULL,
  `use_idUpdater` int NOT NULL,
  PRIMARY KEY (`intCon_id`),
  KEY `int_conne_int_id` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1041673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_detail`
--

DROP TABLE IF EXISTS `intervention_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_detail` (
  `intDet_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `use_idAssigned` int DEFAULT NULL,
  `pro_idAssigned` int DEFAULT NULL,
  `intDet_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `intDet_startDate` date DEFAULT NULL,
  `intDet_endDate` date DEFAULT NULL,
  `intDet_startHour` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intDet_endHour` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intDet_nbMinutes` int DEFAULT NULL,
  `intDet_createdDate` date DEFAULT NULL,
  `intDet_updatedDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  PRIMARY KEY (`intDet_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_equipment`
--

DROP TABLE IF EXISTS `intervention_equipment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_equipment` (
  `intEqu_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `equSit_id` int NOT NULL DEFAULT '0',
  `int_id` int NOT NULL,
  `intEqu_comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`intEqu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_file`
--

DROP TABLE IF EXISTS `intervention_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_file` (
  `intFil_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL DEFAULT '0',
  `intFil_name` varchar(255) NOT NULL DEFAULT '',
  `intFil_oldName` varchar(255) NOT NULL DEFAULT '',
  `intFil_ext` varchar(4) NOT NULL,
  `cat_id` int NOT NULL DEFAULT '0',
  `intFil_visibleCustomer` tinyint NOT NULL DEFAULT '0',
  `intFil_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `intFil_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `intFil_description` varchar(255) DEFAULT NULL,
  `intFil_size` int DEFAULT NULL,
  `intFil_visibleProvider` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`intFil_id`),
  KEY `int_id` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=249894 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_file_category`
--

DROP TABLE IF EXISTS `intervention_file_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_file_category` (
  `intFilCat_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `intFilCat_order` int NOT NULL,
  `intFilCat_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `intFilCat_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intFilCat_active` int DEFAULT NULL,
  `intFilCat_updatedDate` datetime DEFAULT NULL,
  `intFilCat_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `intFilCat_deleted` int DEFAULT NULL,
  `intFilCat_oldId` int DEFAULT NULL,
  `intFilCat_valParam` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intFilCat_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intFilCat_forWorksites` int DEFAULT '1',
  PRIMARY KEY (`intFilCat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_log`
--

DROP TABLE IF EXISTS `intervention_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_log` (
  `intLog_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `intLog_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `intLog_texte` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `use_id` int NOT NULL,
  `intLog_createdDate` timestamp NULL DEFAULT NULL,
  `sta_id` int DEFAULT NULL,
  PRIMARY KEY (`intLog_id`),
  KEY `int_id` (`int_id`),
  KEY `use_id` (`use_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1692048 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_message`
--

DROP TABLE IF EXISTS `intervention_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_message` (
  `intMes_id` int NOT NULL AUTO_INCREMENT,
  `use_id` int DEFAULT NULL,
  `intMes_private` int DEFAULT '0',
  `intMes_to` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intMes_object` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intMes_texte` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `int_id` int DEFAULT NULL,
  `intMes_updatedDate` datetime DEFAULT NULL,
  `intMes_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `intMes_deleted` int DEFAULT '0',
  `intMes_attachHistory` int DEFAULT '0',
  `intMes_customer` int DEFAULT '0',
  `intMes_compta` int DEFAULT '0',
  `intMes_cc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intMes_moreAddresses` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `intMes_note` int DEFAULT '0',
  `intMes_noteDone` int DEFAULT '0',
  `intMes_noteAlertDate` date DEFAULT NULL,
  `intMess_noteUserAssigned` int DEFAULT NULL,
  `intMes_visibleTech` int NOT NULL DEFAULT '1',
  `intMes_pin` int DEFAULT '0',
  `intMes_provider` int DEFAULT '0',
  PRIMARY KEY (`intMes_id`),
  KEY `use_id` (`use_id`),
  KEY `int_id` (`int_id`),
  KEY `intMess_noteUserAssigned` (`intMess_noteUserAssigned`),
  KEY `use_idCreator` (`use_idCreator`)
) ENGINE=InnoDB AUTO_INCREMENT=819407 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `intervention_status_group`
--

DROP TABLE IF EXISTS `intervention_status_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `intervention_status_group` (
  `intStaGro_id` int NOT NULL AUTO_INCREMENT,
  `intStaGro_order` tinyint NOT NULL,
  `intStaGro_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `intStaGro_active` tinyint(1) NOT NULL DEFAULT '1',
  `intStaGro_isCustomer` tinyint(1) NOT NULL DEFAULT '0',
  `intStaGro_createdDate` timestamp NULL DEFAULT NULL,
  `intStaGro_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int NOT NULL,
  `com_idUpdater` int NOT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int NOT NULL,
  PRIMARY KEY (`intStaGro_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=184901 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `langue`
--

DROP TABLE IF EXISTS `langue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `langue` (
  `lan_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `lan_libelle` varchar(50) NOT NULL DEFAULT '',
  `lan_abbr` varchar(5) NOT NULL DEFAULT '',
  `lan_picto` varchar(255) NOT NULL DEFAULT '',
  `lan_actif` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`lan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `legal_status`
--

DROP TABLE IF EXISTS `legal_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `legal_status` (
  `legSta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `legSta_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `legSta_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`legSta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `notifications_user`
--

DROP TABLE IF EXISTS `notifications_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications_user` (
  `use_id` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `create_user` int NOT NULL DEFAULT '0',
  `add_proQuo_presta` int NOT NULL DEFAULT '0',
  `int_planification_presta` int NOT NULL DEFAULT '0',
  `int_realisation_presta` int NOT NULL DEFAULT '0',
  `add_int_site` int NOT NULL DEFAULT '0',
  `add_int_message` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`use_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `parameter`
--

DROP TABLE IF EXISTS `parameter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `parameter` (
  `par_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `par_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `par_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `par_descriptionFr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `par_descriptionEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `par_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`par_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `payment_periods`
--

DROP TABLE IF EXISTS `payment_periods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_periods` (
  `payPer_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payPer_order` int NOT NULL DEFAULT '0',
  `payPer_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `payPer_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `payPer_value` int DEFAULT NULL,
  `payPer_endMonth` int NOT NULL DEFAULT '0',
  `payPer_dayNextMonth` int DEFAULT NULL,
  `payPer_active` int DEFAULT NULL,
  `payPer_updatedDate` datetime DEFAULT NULL,
  `payPer_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `payPer_deleted` int DEFAULT NULL,
  PRIMARY KEY (`payPer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `prospect`
--

DROP TABLE IF EXISTS `prospect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prospect` (
  `pro_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pro_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_synonymous` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_nature` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_web` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_actions` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_comments` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_request` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pro_descStatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_dateActionComm` date DEFAULT NULL,
  `pro_dateActiontech` date DEFAULT NULL,
  `pro_createdDate` datetime DEFAULT NULL,
  `pro_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  PRIMARY KEY (`pro_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider`
--

DROP TABLE IF EXISTS `provider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider` (
  `pro_id` int NOT NULL AUTO_INCREMENT,
  `pro_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pro_siret` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int DEFAULT NULL,
  `pro_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_active` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `pro_lat` decimal(11,8) DEFAULT NULL,
  `pro_lng` decimal(11,8) DEFAULT NULL,
  `pro_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_maxInterventionInProgress` int DEFAULT NULL,
  `pro_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pro_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pro_private` tinyint(1) NOT NULL DEFAULT '1',
  `pro_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pro_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `pro_forceCoordonnate` int NOT NULL DEFAULT '0',
  `pro_zipCode` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_tvaDefault` int DEFAULT '1',
  `pro_satisfactionQuality` int DEFAULT NULL,
  `pro_deleted` int NOT NULL DEFAULT '0',
  `pro_numTva` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_apeCode` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_juridicForm` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_autoEntrep` int NOT NULL DEFAULT '0',
  `pro_numberCompta` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_astreinte` int NOT NULL DEFAULT '0',
  `pro_urgency` int NOT NULL DEFAULT '0',
  `pro_satisfactionReactivity` decimal(5,2) DEFAULT NULL,
  `pro_satisfactionPrice` decimal(5,2) DEFAULT NULL,
  `pro_satisfactionPunctuality` decimal(5,2) DEFAULT NULL,
  `pro_satisfactionPresentation` decimal(5,2) DEFAULT NULL,
  `pro_satisfactionDetails` decimal(5,2) DEFAULT NULL,
  `pro_ribIban` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_ribBic` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_ribDomiciliation` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_docsUpToDate` int NOT NULL DEFAULT '0',
  `pro_caLastYear` int DEFAULT NULL,
  `pro_caElan` int DEFAULT NULL,
  `pro_externalCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_contactName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pro_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `payPer_id` int DEFAULT NULL,
  PRIMARY KEY (`pro_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9107 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_defaults`
--

DROP TABLE IF EXISTS `provider_defaults`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_defaults` (
  `proDef_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pro_id` int NOT NULL,
  `act_ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proDef_createdDate` timestamp NULL DEFAULT NULL,
  `proDef_updatedDate` timestamp NULL DEFAULT NULL,
  `dep_ids` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  PRIMARY KEY (`proDef_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_file`
--

DROP TABLE IF EXISTS `provider_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_file` (
  `proFil_id` int NOT NULL AUTO_INCREMENT,
  `pro_id` int NOT NULL DEFAULT '0',
  `proFil_name` varchar(255) NOT NULL DEFAULT '',
  `proFil_oldName` varchar(255) NOT NULL DEFAULT '',
  `proFil_ext` varchar(4) NOT NULL,
  `cat_id` int NOT NULL DEFAULT '0',
  `proFil_dueDate` date DEFAULT NULL,
  `proFil_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `use_idCreator` int NOT NULL,
  `proFil_updatedDate` timestamp NULL DEFAULT NULL,
  `proFil_description` varchar(255) DEFAULT NULL,
  `proFil_obligatory` tinyint(1) DEFAULT '0',
  `util1` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`proFil_id`),
  KEY `int_id` (`pro_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11074 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_file_category`
--

DROP TABLE IF EXISTS `provider_file_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_file_category` (
  `proFilCat_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `proFilCat_order` int DEFAULT NULL,
  `proFilCat_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `proFilCat_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proFilCat_active` int DEFAULT NULL,
  `proFilCat_updatedDate` datetime DEFAULT NULL,
  `proFilCat_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `proFilCat_deleted` int DEFAULT NULL,
  `proFilCat_obligatory` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`proFilCat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_invoice`
--

DROP TABLE IF EXISTS `provider_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_invoice` (
  `proInv_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int DEFAULT NULL,
  `pro_id` int DEFAULT NULL,
  `proInv_number` int DEFAULT NULL,
  `proInv_achievementDate` date DEFAULT NULL,
  `proInv_deadlineDate` date DEFAULT NULL,
  `proInv_payed` int DEFAULT '0',
  `proInv_paymentDate` date DEFAULT NULL,
  `proInv_providerNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sta_id` int DEFAULT NULL,
  `proInv_amountHT` double DEFAULT NULL,
  `proInv_tva` double DEFAULT NULL,
  `proInv_amountTTC` double DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `proReq_id` int DEFAULT NULL,
  `proInv_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `use_idUpdater` int DEFAULT NULL,
  `proInv_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `proInv_updatedDate` datetime DEFAULT NULL,
  `proInv_InvoiceDate` date DEFAULT NULL,
  `proInv_exported` tinyint(1) DEFAULT '0',
  `proInv_exportedDate` datetime DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `intFil_id` int DEFAULT NULL,
  `proInv_avoir` int DEFAULT '0',
  `proInv_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proInv_validated` int DEFAULT '0',
  `proInv_validatedDate` date DEFAULT NULL,
  `tva_taux` decimal(4,2) NOT NULL DEFAULT '0.00',
  `proInv_motifRefus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proInv_receiptDate` date DEFAULT NULL,
  `proInv_exportUserId` int DEFAULT NULL,
  PRIMARY KEY (`proInv_id`),
  KEY `cusQuo_id` (`proReq_id`),
  KEY `int_id` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30391 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_invoice_export_compta`
--

DROP TABLE IF EXISTS `provider_invoice_export_compta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_invoice_export_compta` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `proInv_id` int DEFAULT NULL,
  `exportDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_link_activity`
--

DROP TABLE IF EXISTS `provider_link_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_link_activity` (
  `proAct_id` int NOT NULL AUTO_INCREMENT,
  `pro_id` int NOT NULL,
  `act_id` int NOT NULL,
  `proLinAct_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`proAct_id`),
  KEY `pro_id` (`pro_id`,`act_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82114 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_quote`
--

DROP TABLE IF EXISTS `provider_quote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_quote` (
  `proQuo_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `proQuo_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pro_id` int NOT NULL,
  `proQuo_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proQuo_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proQuo_requestDate` date DEFAULT NULL,
  `proQuo_desiredDateReturn` date DEFAULT NULL,
  `proQuo_realDateReturn` date DEFAULT NULL,
  `sta_id` int NOT NULL,
  `proQuo_amountHT` double DEFAULT NULL,
  `proQuo_tva` double DEFAULT NULL,
  `proQuo_amountTTC` double DEFAULT NULL,
  `proQuo_nbRelance` int NOT NULL DEFAULT '0',
  `use_idCreator` int NOT NULL,
  `proQuo_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `proQuo_updatedDate` datetime DEFAULT NULL,
  `proReq_id` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `intFil_id` int DEFAULT NULL,
  `proQuo_lastRelaunchDate` date DEFAULT NULL,
  `proQuo_RelaunchCount` int DEFAULT '0',
  `proQuo_autoRelaunchCount` int DEFAULT '0',
  `intFil_id_bpa` int DEFAULT NULL,
  `proQuo_validated` int NOT NULL DEFAULT '0',
  `proQuo_validatedDate` date DEFAULT NULL,
  `proQuo_visitDate` date DEFAULT NULL,
  `proQuo_satisfactionReactivity` int DEFAULT NULL,
  `proQuo_satisfactionPrice` int DEFAULT NULL,
  `proQuo_satisfactionDetails` int DEFAULT NULL,
  `proQuo_predefinedText1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proQuo_predefinedText2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  PRIMARY KEY (`proQuo_id`),
  KEY `int_id` (`int_id`),
  KEY `pro_id` (`pro_id`),
  KEY `int_id_2` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45556 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_request`
--

DROP TABLE IF EXISTS `provider_request`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_request` (
  `proReq_id` int NOT NULL AUTO_INCREMENT,
  `int_id` int NOT NULL,
  `proReq_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pro_id` int NOT NULL,
  `proReq_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReq_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReq_requestDate` date DEFAULT NULL,
  `proReq_planningDate` date DEFAULT NULL,
  `proReq_qualityControlDate` date DEFAULT NULL,
  `proReq_achievementDate` date DEFAULT NULL,
  `sta_id` int NOT NULL,
  `proReq_amountHT` double DEFAULT NULL,
  `proReq_tva` double DEFAULT NULL,
  `proReq_amountTTC` double DEFAULT NULL,
  `proReq_satisfactionQuality` int DEFAULT NULL,
  `proReq_satisfactionComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReq_nbRelance` int NOT NULL DEFAULT '0',
  `proReq_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `proReq_updatedDate` datetime DEFAULT NULL,
  `proQuo_id` int DEFAULT NULL,
  `proInv_id` int DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `proReq_TVAType` int DEFAULT NULL,
  `proReq_InvoiceDate` date DEFAULT NULL,
  `tva_id` int DEFAULT NULL,
  `intFilBi_id` int DEFAULT NULL,
  `proReq_lastRelaunchDate` date DEFAULT NULL,
  `proReq_satisfactionPunctuality` int DEFAULT NULL,
  `proReq_satisfactionPresentation` int DEFAULT NULL,
  `proReq_linkKey` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReq_linkKey_binumeric` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReq_linkKey_binumeric_cus` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReq_predefinedText1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReq_predefinedText2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  PRIMARY KEY (`proReq_id`),
  KEY `int_id` (`int_id`),
  KEY `pro_id` (`pro_id`),
  KEY `int_id_2` (`int_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_request_bi`
--

DROP TABLE IF EXISTS `provider_request_bi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_request_bi` (
  `proReqBi_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `proReq_id` int NOT NULL DEFAULT '0',
  `int_id` int NOT NULL DEFAULT '0',
  `proReqBi_job` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReqBi_equipment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReqBi_nbPeople` int NOT NULL DEFAULT '1',
  `proReqBi_customerComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReqBi_nameSignataire` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReqBi_validated` int NOT NULL DEFAULT '0',
  `proReqBi_validatedTime` datetime DEFAULT NULL,
  `proReqBi_date` datetime DEFAULT NULL,
  `proReqBi_dateTech` datetime DEFAULT NULL,
  `proReqBi_dateValidCus` datetime DEFAULT NULL,
  `proReqBi_step` int DEFAULT '0',
  `proReqBi_filesTech` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `proReqBi_providerComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `proReqBi_spentTimeHours` int DEFAULT NULL,
  `proReqBi_spentTimeMn` int DEFAULT NULL,
  `intFil_idTampon` int DEFAULT '0',
  `intFil_idSignature` int DEFAULT '0',
  PRIMARY KEY (`proReqBi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5584 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provider_tmp`
--

DROP TABLE IF EXISTS `provider_tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `provider_tmp` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) DEFAULT NULL,
  `compte` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=481 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `region`
--

DROP TABLE IF EXISTS `region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `region` (
  `reg_id` int NOT NULL AUTO_INCREMENT,
  `reg_code` int DEFAULT NULL,
  `reg_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`reg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `rights_admin`
--

DROP TABLE IF EXISTS `rights_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rights_admin` (
  `rig_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `rig_element` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rig_admin` int NOT NULL DEFAULT '1',
  `rig_responsable` int NOT NULL DEFAULT '1',
  `rig_agent` int NOT NULL DEFAULT '1',
  `rig_comptable` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`rig_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `secteur`
--

DROP TABLE IF EXISTS `secteur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `secteur` (
  `sec_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sec_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sec_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_id` int DEFAULT NULL,
  `bil_id` int DEFAULT NULL,
  `sec_active` int NOT NULL DEFAULT '0',
  `sec_updatedDate` datetime DEFAULT NULL,
  `sec_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `sec_deleted` int NOT NULL DEFAULT '0',
  `sec_dirName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sec_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`sec_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sign`
--

DROP TABLE IF EXISTS `sign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sign` (
  `sig_id` int NOT NULL AUTO_INCREMENT,
  `cus_id` int DEFAULT NULL,
  `sig_socialReason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sig_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int NOT NULL,
  `sig_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_fax` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `bil_id` int DEFAULT NULL,
  `sig_active` int NOT NULL DEFAULT '0',
  `sig_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sig_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sig_deleted` int NOT NULL DEFAULT '0',
  `sig_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_prices` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sig_mailInvoice` tinyint unsigned DEFAULT NULL,
  `sig_recipientInvoiceEmails` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_recipientQuoteEmails` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_codeWs` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_emailCompta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_biNumeric` int DEFAULT '0',
  PRIMARY KEY (`sig_id`),
  KEY `cus_id` (`cus_id`),
  KEY `cou_id` (`cou_id`)
) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site`
--

DROP TABLE IF EXISTS `site`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site` (
  `sit_id` int NOT NULL AUTO_INCREMENT,
  `sit_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sit_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int DEFAULT NULL,
  `sit_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sig_id` int NOT NULL,
  `sit_active` tinyint(1) NOT NULL DEFAULT '1',
  `sit_lat` decimal(11,8) DEFAULT NULL,
  `sit_lng` decimal(11,8) DEFAULT NULL,
  `sit_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sit_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sit_hours` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sit_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_typePlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_emailDirector` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sitImp_id` int DEFAULT NULL,
  `sec_id` int NOT NULL DEFAULT '0',
  `sit_surface` int DEFAULT NULL,
  `sit_internalComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sit_openDate` timestamp NULL DEFAULT NULL,
  `sit_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_respName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_code1` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_portable` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_deleted` int NOT NULL DEFAULT '0',
  `bil_id` int DEFAULT NULL,
  `sit_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`sit_id`),
  KEY `ens_id` (`sig_id`),
  KEY `cou_id` (`cou_id`),
  KEY `sig_id` (`sig_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site_control`
--

DROP TABLE IF EXISTS `site_control`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_control` (
  `sitCon_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sig_id` int NOT NULL,
  `sit_id` int NOT NULL,
  `act_id` int NOT NULL,
  `pro_idAssigned` int DEFAULT NULL,
  `sitCon_realised` int NOT NULL DEFAULT '0',
  `sitCon_action` int NOT NULL DEFAULT '0',
  `sitCon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sitCon_deleted` int DEFAULT '0',
  `sitCon_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sitCon_visitDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sitCon_createdDate` timestamp NULL DEFAULT NULL,
  `sitCon_updatedDate` timestamp NULL DEFAULT NULL,
  `actDet_id` int DEFAULT NULL,
  `sitCon_remindDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sitCon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site_control_file`
--

DROP TABLE IF EXISTS `site_control_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_control_file` (
  `sitConFil_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sitCon_id` int NOT NULL,
  `sitConFil_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sitConFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sitConFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sitConFil_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sitConFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sitConFil_createdDate` timestamp NULL DEFAULT NULL,
  `sitConFil_updatedDate` timestamp NULL DEFAULT NULL,
  `sitConFil_visibleProvider` int NOT NULL DEFAULT '1',
  `sitConFil_visibleSite` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`sitConFil_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site_file`
--

DROP TABLE IF EXISTS `site_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_file` (
  `sitFil_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sit_id` int NOT NULL,
  `sitFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sitFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sitFil_ext` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cat_id` int NOT NULL,
  `sitFil_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `use_idCreator` int NOT NULL,
  `sitFil_updatedDate` timestamp NULL DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sitFil_deleted` int DEFAULT NULL,
  `sitFil_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sitFil_visibleProvider` int NOT NULL DEFAULT '1',
  `sitFil_visibleSite` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`sitFil_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site_implantation`
--

DROP TABLE IF EXISTS `site_implantation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_implantation` (
  `sitImp_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sitImp_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sitImp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `site_temp`
--

DROP TABLE IF EXISTS `site_temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_temp` (
  `sit_id` int NOT NULL AUTO_INCREMENT,
  `sit_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sit_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int DEFAULT NULL,
  `sit_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sig_id` int NOT NULL,
  `sit_active` tinyint(1) NOT NULL DEFAULT '1',
  `sit_lat` decimal(11,8) DEFAULT NULL,
  `sit_lng` decimal(11,8) DEFAULT NULL,
  `sit_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_createdDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sit_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `sit_hours` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sit_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_typePlace` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_emailDirector` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sitImp_id` int DEFAULT NULL,
  `sec_id` int NOT NULL DEFAULT '0',
  `sit_surface` int DEFAULT NULL,
  `sit_internalComment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `sit_openDate` timestamp NULL DEFAULT NULL,
  `sit_correspondance` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_respName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_code1` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_portable` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_deleted` int NOT NULL DEFAULT '0',
  `bil_id` int DEFAULT NULL,
  `sit_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sit_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `importer` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`sit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `status`
--

DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status` (
  `sta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sta_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sta_oldId` int DEFAULT NULL,
  `sta_order` int DEFAULT NULL,
  `sta_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sta_nameEn` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sta_active` int NOT NULL DEFAULT '1',
  `sta_updatedDate` datetime DEFAULT NULL,
  `sta_createdDate` datetime DEFAULT NULL,
  `sta_color` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `sta_deleted` int DEFAULT NULL,
  `sta_preventive` int DEFAULT NULL,
  `staGro_id` int DEFAULT NULL,
  `sta_curative` int DEFAULT NULL,
  `sta_cliNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sta_proNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`sta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=402 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `status_group`
--

DROP TABLE IF EXISTS `status_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status_group` (
  `staGro_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staGro_order` int NOT NULL DEFAULT '0',
  `staGro_libelleFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staGro_active` int NOT NULL DEFAULT '1',
  `staGro_createdDate` date DEFAULT NULL,
  `staGro_updatedDate` date DEFAULT NULL,
  `staGro_cliNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staGro_proNameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staGro_bgClient` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `staGro_visibleClient` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`staGro_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `status_params`
--

DROP TABLE IF EXISTS `status_params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status_params` (
  `staPar_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staPar_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staPar_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staPar_descriptionFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staPar_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`staPar_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `status_rules`
--

DROP TABLE IF EXISTS `status_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `status_rules` (
  `staRul_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staRul_table` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staRul_type` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `staRul_active` int NOT NULL DEFAULT '1',
  `staRul_staId` int NOT NULL,
  `staRul_destStaId` int NOT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `staRul_createdDate` timestamp NULL DEFAULT NULL,
  `staRul_updatedDate` timestamp NULL DEFAULT NULL,
  `staRul_tableDest` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`staRul_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `texte`
--

DROP TABLE IF EXISTS `texte`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `texte` (
  `tex_id` int NOT NULL AUTO_INCREMENT,
  `tex_nameFr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tex_nameEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `tex_textFr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tex_textEn` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `tex_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tex_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tex_mailObject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tex_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `todo_list`
--

DROP TABLE IF EXISTS `todo_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `todo_list` (
  `todLis_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `todLis_startDate` date DEFAULT NULL,
  `todLis_endDate` date DEFAULT NULL,
  `todLis_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `todLis_createdDate` datetime DEFAULT NULL,
  `todLis_updatedDate` datetime DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`todLis_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tva`
--

DROP TABLE IF EXISTS `tva`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tva` (
  `tva_id` int NOT NULL AUTO_INCREMENT,
  `tva_order` int DEFAULT NULL,
  `tva_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tva_value` decimal(5,2) NOT NULL,
  `tva_active` tinyint(1) NOT NULL DEFAULT '1',
  `cou_id` int NOT NULL,
  `tva_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tva_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `com_idUpdater` int DEFAULT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int DEFAULT NULL,
  `tva_autoliquidation` tinyint(1) DEFAULT '0',
  `tva_exoneration` tinyint(1) DEFAULT '0',
  `tva_comCompVentes` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_comCompAchats` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_comCompVentesHt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tva_comCompAchatsHt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tva_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tvatype`
--

DROP TABLE IF EXISTS `tvatype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tvatype` (
  `tvatype_id` int NOT NULL AUTO_INCREMENT,
  `tvatype_order` tinyint NOT NULL,
  `tvatype_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tvatype_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tvatype_active` tinyint(1) NOT NULL DEFAULT '1',
  `cou_id` int NOT NULL,
  `tvatype_createdDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tvatype_updatedDate` datetime DEFAULT NULL,
  `use_idUpdater` int NOT NULL,
  `com_idUpdater` int NOT NULL,
  `use_idCreator` int NOT NULL,
  `com_idCreator` int NOT NULL,
  PRIMARY KEY (`tvatype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `unity`
--

DROP TABLE IF EXISTS `unity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unity` (
  `uni_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uni_order` int DEFAULT NULL,
  `uni_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `uni_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `uni_active` tinyint(1) DEFAULT '1',
  `uni_updatedDate` datetime DEFAULT NULL,
  `uni_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`uni_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_astreinte`
--

DROP TABLE IF EXISTS `user_astreinte`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_astreinte` (
  `useAst_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `use_id` int DEFAULT NULL,
  `useAst_etatAstreinte` tinyint(1) NOT NULL DEFAULT '1',
  `useAst_startDate` datetime DEFAULT NULL,
  `useAst_endDate` datetime DEFAULT NULL,
  PRIMARY KEY (`useAst_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9585 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_customer`
--

DROP TABLE IF EXISTS `user_customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_customer` (
  `useCus_id` int NOT NULL AUTO_INCREMENT,
  `use_id` int DEFAULT '0',
  `cus_id` int DEFAULT '0',
  `useCus_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`useCus_id`),
  KEY `cus_id` (`cus_id`),
  KEY `use_id` (`use_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_log`
--

DROP TABLE IF EXISTS `user_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_log` (
  `useLog_id` int NOT NULL AUTO_INCREMENT,
  `use_id` int NOT NULL,
  `useLog_ip` varchar(255) DEFAULT NULL,
  `useLog_valid` tinyint(1) NOT NULL DEFAULT '0',
  `useLog_connexion` tinyint(1) NOT NULL DEFAULT '0',
  `useLog_connectionDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `useLog_lastActionDate` datetime DEFAULT NULL,
  `useLog_lastAction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`useLog_id`),
  KEY `use_id` (`use_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18899 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_params`
--

DROP TABLE IF EXISTS `user_params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_params` (
  `usePar_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `use_id` int NOT NULL,
  `usePar_diNewOnglet` int NOT NULL DEFAULT '1',
  `usePar_editPdfOption` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'see',
  `usePar_template` int NOT NULL DEFAULT '2',
  PRIMARY KEY (`usePar_id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_sign`
--

DROP TABLE IF EXISTS `user_sign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_sign` (
  `useSig_id` int NOT NULL AUTO_INCREMENT,
  `use_id` int DEFAULT '0',
  `sig_id` int DEFAULT '0',
  `useSig_createdDate` timestamp NULL DEFAULT NULL,
  `use_idCreator` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`useSig_id`),
  KEY `cus_id` (`sig_id`),
  KEY `use_id` (`use_id`)
) ENGINE=InnoDB AUTO_INCREMENT=279 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_wallet`
--

DROP TABLE IF EXISTS `user_wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_wallet` (
  `useWal_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `use_id` int DEFAULT NULL,
  `wal_id` int DEFAULT NULL,
  PRIMARY KEY (`useWal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `userbo`
--

DROP TABLE IF EXISTS `userbo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `userbo` (
  `use_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `use_nom` varchar(255) NOT NULL DEFAULT '',
  `use_prenom` varchar(255) NOT NULL DEFAULT '',
  `use_login` varchar(255) NOT NULL DEFAULT '',
  `use_password` varchar(255) NOT NULL DEFAULT '',
  `use_niveau` int NOT NULL DEFAULT '1',
  `use_email` varchar(255) NOT NULL DEFAULT '',
  `use_actif` tinyint(1) NOT NULL DEFAULT '1',
  `use_created` datetime DEFAULT NULL,
  `use_modified` datetime DEFAULT NULL,
  `use_createdDate` datetime DEFAULT NULL,
  `use_updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`use_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `userbo_type`
--

DROP TABLE IF EXISTS `userbo_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `userbo_type` (
  `useTyp_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `useTyp_niveau` int NOT NULL DEFAULT '0',
  `useTyp_libelle` varchar(255) NOT NULL DEFAULT '',
  `useTyp_actif` tinyint(1) NOT NULL DEFAULT '1',
  `useTyp_modified` datetime DEFAULT NULL,
  `useTyp_created` datetime DEFAULT NULL,
  PRIMARY KEY (`useTyp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `use_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_active` tinyint(1) NOT NULL DEFAULT '1',
  `use_lastVisit` datetime DEFAULT NULL,
  `use_lastIP` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `token_2fa` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `token_2fa_expiry` datetime DEFAULT NULL,
  `use_fonction` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_pwdSendedDate` date DEFAULT NULL,
  `use_valProQuo` int NOT NULL DEFAULT '1',
  `use_valProInv` int NOT NULL DEFAULT '1',
  `use_roleAdd` int NOT NULL DEFAULT '1',
  `use_roleEdit` int NOT NULL DEFAULT '1',
  `use_roleDelete` int NOT NULL DEFAULT '1',
  `use_roleExport` int NOT NULL DEFAULT '1',
  `cus_id` int NOT NULL,
  `sig_id` int NOT NULL,
  `use_astreinte` tinyint(1) DEFAULT NULL,
  `use_logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_gmailAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_useGmailCalendar` int DEFAULT '0',
  `use_assocTech` int DEFAULT '0',
  `use_address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_zipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cou_id` int DEFAULT NULL,
  `use_lat` decimal(11,8) DEFAULT NULL,
  `use_lng` decimal(11,8) DEFAULT NULL,
  `use_formattedAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `active_ipFilter` int NOT NULL DEFAULT '1',
  `use_gpType` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `use_email` (`email`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wallet`
--

DROP TABLE IF EXISTS `wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wallet` (
  `wal_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wal_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wal_managerName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wal_informations` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `wal_updatedDate` datetime DEFAULT NULL,
  `wal_createdDate` datetime DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  PRIMARY KEY (`wal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wallet_objectif`
--

DROP TABLE IF EXISTS `wallet_objectif`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wallet_objectif` (
  `walObj_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wal_id` int NOT NULL,
  `walObj_month` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `walObj_caValue` int DEFAULT NULL,
  `walObj_margeBruteValue` double DEFAULT NULL,
  `walObj_productivityValue` int DEFAULT NULL,
  PRIMARY KEY (`walObj_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `wallet_sign`
--

DROP TABLE IF EXISTS `wallet_sign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wallet_sign` (
  `walSig_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wal_id` int DEFAULT NULL,
  `sig_id` int DEFAULT NULL,
  PRIMARY KEY (`walSig_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10103 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `worksite`
--

DROP TABLE IF EXISTS `worksite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worksite` (
  `wor_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `cus_id` int NOT NULL,
  `sig_id` int NOT NULL,
  `sit_id` int NOT NULL,
  `sta_id` int DEFAULT NULL,
  `wor_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wor_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `wor_refNumber` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wor_createdDate` date DEFAULT NULL,
  `wor_closingDate` date DEFAULT NULL,
  `wor_estimatedAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `worCat_id` int DEFAULT NULL,
  `wor_closed` int NOT NULL DEFAULT '0',
  `wor_startDate` date DEFAULT NULL,
  `wor_endDate` date DEFAULT NULL,
  `wor_sinister` int NOT NULL DEFAULT '0',
  `wor_updatedDate` date DEFAULT NULL,
  `wor_responsibleThird` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wor_sinisterDate` date DEFAULT NULL,
  `wor_deductibleAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `wor_provisionAmount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`wor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `worksite_budgets`
--

DROP TABLE IF EXISTS `worksite_budgets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worksite_budgets` (
  `worBud_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `act_id` int DEFAULT NULL,
  `wor_id` int DEFAULT NULL,
  `worBud_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worBud_createdDate` date DEFAULT NULL,
  `worBud_updatedDate` date DEFAULT NULL,
  PRIMARY KEY (`worBud_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `worksite_category`
--

DROP TABLE IF EXISTS `worksite_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worksite_category` (
  `worCat_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `worCat_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worCat_createdDate` date DEFAULT NULL,
  `worCat_active` int NOT NULL DEFAULT '1',
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `worCat_updatedDate` date DEFAULT NULL,
  PRIMARY KEY (`worCat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `worksite_file`
--

DROP TABLE IF EXISTS `worksite_file`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worksite_file` (
  `worFil_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wor_id` int DEFAULT NULL,
  `worFil_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worFil_oldName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worFil_ext` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worFil_createdDate` date DEFAULT NULL,
  `wor_closingDate` date DEFAULT NULL,
  `wor_estimatedAmount` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worFil_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `worFil_deleted` int DEFAULT NULL,
  `worFil_size` int DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `worFil_updatedDate` date DEFAULT NULL,
  `cat_id` int DEFAULT NULL,
  PRIMARY KEY (`worFil_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `worksite_reimbursement`
--

DROP TABLE IF EXISTS `worksite_reimbursement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worksite_reimbursement` (
  `worRei_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `wor_id` int DEFAULT NULL,
  `worRei_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `worRei_description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `worRei_amountHt` decimal(11,2) DEFAULT NULL,
  `worRei_payed` int NOT NULL DEFAULT '0',
  `worRei_createdDate` date DEFAULT NULL,
  `use_idCreator` int DEFAULT NULL,
  `use_idUpdater` int DEFAULT NULL,
  `worRei_updatedDate` date DEFAULT NULL,
  PRIMARY KEY (`worRei_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-02-13 16:07:00
