/*!40000 ALTER TABLE `RegistroPonto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SilkProd`
--

DROP TABLE IF EXISTS `SilkProd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SilkProd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `data` date NOT NULL,
  `qtd_tela_revelada` int DEFAULT '0',
  `frente_qtd_cor` int DEFAULT '0',
  `frente_qtd_peca` int DEFAULT '0',
  `frente_mesa_corrida` tinyint(1) DEFAULT '0',
  `frente_mesa_termica` tinyint(1) DEFAULT '0',
  `costa_qtd_cor` int DEFAULT '0',
  `costa_qtd_peca` int DEFAULT '0',
  `costa_mesa_corrida` tinyint(1) DEFAULT '0',
  `costa_mesa_termica` tinyint(1) DEFAULT '0',
  `peito_qtd_cor` int DEFAULT '0',
  `peito_qtd_peca` int DEFAULT '0',
  `peito_mesa_corrida` tinyint(1) DEFAULT '0',
  `peito_mesa_termica` tinyint(1) DEFAULT '0',
  `manga_esq_qtd_cor` int DEFAULT '0',
  `manga_esq_qtd_peca` int DEFAULT '0',
  `manga_esq_mesa_corrida` tinyint(1) DEFAULT '0',
  `manga_esq_mesa_termica` tinyint(1) DEFAULT '0',
  `manga_dir_qtd_cor` int DEFAULT '0',
  `manga_dir_qtd_peca` int DEFAULT '0',
  `manga_dir_mesa_corrida` tinyint(1) DEFAULT '0',
  `manga_dir_mesa_termica` tinyint(1) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `ordem_servico_id` int DEFAULT NULL,
  `funcionario_id` int DEFAULT NULL,
  `cliente_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ordem_servico_id` (`ordem_servico_id`),
  KEY `funcionario_id` (`funcionario_id`),
  KEY `cliente_id` (`cliente_id`),
  CONSTRAINT `SilkProd_ibfk_58` FOREIGN KEY (`ordem_servico_id`) REFERENCES `OrdemServico` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `SilkProd_ibfk_59` FOREIGN KEY (`funcionario_id`) REFERENCES `Funcionario` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `SilkProd_ibfk_60` FOREIGN KEY (`cliente_id`) REFERENCES `Cliente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SilkProd`
--

LOCK TABLES `SilkProd` WRITE;
/*!40000 ALTER TABLE `SilkProd` DISABLE KEYS */;
/*!40000 ALTER TABLE `SilkProd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TipoTecido`
--

DROP TABLE IF EXISTS `TipoTecido`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TipoTecido` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nome` (`nome`),
  UNIQUE KEY `nome_2` (`nome`),
  UNIQUE KEY `nome_3` (`nome`),
  UNIQUE KEY `nome_4` (`nome`),
  UNIQUE KEY `nome_5` (`nome`),
  UNIQUE KEY `nome_6` (`nome`),
  UNIQUE KEY `nome_7` (`nome`),
  UNIQUE KEY `nome_8` (`nome`),
  UNIQUE KEY `nome_9` (`nome`),
  UNIQUE KEY `nome_10` (`nome`),
  UNIQUE KEY `nome_11` (`nome`),
  UNIQUE KEY `nome_20` (`nome`),
  UNIQUE KEY `nome_21` (`nome`),
  UNIQUE KEY `nome_22` (`nome`),
  UNIQUE KEY `nome_23` (`nome`),
  UNIQUE KEY `nome_24` (`nome`),
  UNIQUE KEY `nome_25` (`nome`),
  UNIQUE KEY `nome_26` (`nome`),
  UNIQUE KEY `nome_27` (`nome`),
  UNIQUE KEY `nome_28` (`nome`),
  UNIQUE KEY `nome_29` (`nome`),
  UNIQUE KEY `nome_30` (`nome`),
  UNIQUE KEY `nome_31` (`nome`),
  UNIQUE KEY `nome_32` (`nome`),
  UNIQUE KEY `nome_33` (`nome`),
  UNIQUE KEY `nome_34` (`nome`),
  UNIQUE KEY `nome_35` (`nome`),
  UNIQUE KEY `nome_36` (`nome`),
  UNIQUE KEY `nome_37` (`nome`),
  UNIQUE KEY `nome_38` (`nome`),
  UNIQUE KEY `nome_39` (`nome`),
  UNIQUE KEY `nome_40` (`nome`),
  UNIQUE KEY `nome_41` (`nome`),
  UNIQUE KEY `nome_42` (`nome`),
  UNIQUE KEY `nome_43` (`nome`),
  UNIQUE KEY `nome_44` (`nome`),
  UNIQUE KEY `nome_45` (`nome`),
  UNIQUE KEY `nome_46` (`nome`),
  UNIQUE KEY `nome_47` (`nome`),
  UNIQUE KEY `nome_48` (`nome`),
  UNIQUE KEY `nome_49` (`nome`),
  UNIQUE KEY `nome_50` (`nome`),
  UNIQUE KEY `nome_51` (`nome`),
  UNIQUE KEY `nome_52` (`nome`),
  UNIQUE KEY `nome_53` (`nome`),
  UNIQUE KEY `nome_54` (`nome`),
  UNIQUE KEY `nome_55` (`nome`),
  UNIQUE KEY `nome_56` (`nome`),
  UNIQUE KEY `nome_57` (`nome`),
  UNIQUE KEY `nome_58` (`nome`),
  UNIQUE KEY `nome_59` (`nome`),
  UNIQUE KEY `nome_60` (`nome`),
  UNIQUE KEY `nome_61` (`nome`),
  UNIQUE KEY `nome_62` (`nome`),
  UNIQUE KEY `nome_63` (`nome`),
  UNIQUE KEY `nome_18` (`nome`),
  UNIQUE KEY `nome_19` (`nome`),
  UNIQUE KEY `nome_12` (`nome`),
  UNIQUE KEY `nome_13` (`nome`),
  UNIQUE KEY `nome_14` (`nome`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TipoTecido`
--

LOCK TABLES `TipoTecido` WRITE;
/*!40000 ALTER TABLE `TipoTecido` DISABLE KEYS */;
INSERT INTO `TipoTecido` VALUES (1,'ALGODÃO FIO 30','2025-06-21 16:10:16','2025-07-31 00:40:03'),(2,'MALHA PV','2025-07-31 00:39:16','2025-07-31 00:40:12'),(3,'HELANCA COLEGIAL','2025-07-31 00:40:27','2025-07-31 00:40:27'),(4,'HELANCA POLIAMIDA','2025-07-31 00:40:42','2025-07-31 00:40:42'),(5,'SUPLEX','2025-07-31 00:40:54','2025-07-31 00:40:54'),(6,'PIQUET MIX','2025-07-31 00:41:14','2025-07-31 00:41:14'),(7,'PIQUET PV','2025-07-31 00:41:26','2025-07-31 00:41:26'),(9,'DRAY','2025-07-31 01:45:29','2025-07-31 01:45:29'),(10,'DRAY COM ELASTANO','2025-07-31 01:45:51','2025-07-31 01:45:51'),(11,'BRIM PESADO','2025-07-31 01:46:07','2025-07-31 01:46:07'),(12,'BRIM LEVE','2025-07-31 01:46:21','2025-07-31 01:46:21'),(13,'MOLETOM','2025-07-31 01:46:38','2025-07-31 01:46:38'),(14,'OXFORD','2025-07-31 01:47:21','2025-07-31 01:47:21'),(15,'GABADIRNE','2025-07-31 01:47:50','2025-07-31 01:47:50'),(16,'TRICOLINE','2025-07-31 01:47:59','2025-07-31 01:47:59'),(17,'GRAFIL','2025-07-31 01:49:00','2025-07-31 01:49:00');
/*!40000 ALTER TABLE `TipoTecido` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `VpontoBone`
--

DROP TABLE IF EXISTS `VpontoBone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `VpontoBone` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qtd_peca` int NOT NULL,
  `valor_ponto` decimal(10,2) NOT NULL,
  `valor_minimo` decimal(10,2) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `VpontoBone`
--

LOCK TABLES `VpontoBone` WRITE;
/*!40000 ALTER TABLE `VpontoBone` DISABLE KEYS */;
INSERT INTO `VpontoBone` VALUES (1,1,2.50,10.00,'2025-11-23 22:41:55','2025-11-23 22:41:55'),(2,2,2.25,9.00,'2025-11-29 18:52:56','2025-11-29 18:52:56'),(3,3,2.00,8.00,'2025-11-29 18:53:45','2025-11-29 18:53:45'),(4,4,1.90,7.00,'2025-11-29 18:54:27','2025-11-29 18:54:27'),(5,5,1.80,6.00,'2025-11-29 18:57:52','2025-11-29 18:57:52'),(6,10,1.70,5.00,'2025-11-29 18:58:04','2025-11-29 18:58:04'),(7,20,1.60,5.00,'2025-11-29 18:58:14','2025-11-29 18:58:14'),(8,30,1.50,5.00,'2025-11-29 18:58:29','2025-11-29 18:58:29');
/*!40000 ALTER TABLE `VpontoBone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `VpontoPeca`
--

DROP TABLE IF EXISTS `VpontoPeca`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `VpontoPeca` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qtd_peca` int NOT NULL,
  `valor_ponto` decimal(10,2) NOT NULL,
  `valor_minimo` decimal(10,2) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `VpontoPeca`
--

LOCK TABLES `VpontoPeca` WRITE;
/*!40000 ALTER TABLE `VpontoPeca` DISABLE KEYS */;
INSERT INTO `VpontoPeca` VALUES (1,1,1.50,7.00,'2025-11-23 22:41:55','2025-11-23 22:41:55'),(2,2,1.30,6.00,'2025-11-29 18:52:56','2025-11-29 18:52:56'),(3,3,1.20,5.00,'2025-11-29 18:53:45','2025-11-29 18:53:45'),(4,4,1.10,4.50,'2025-11-29 18:54:27','2025-11-29 18:54:27'),(5,5,1.00,4.00,'2025-11-29 18:55:00','2025-11-29 18:55:00'),(6,6,0.90,3.50,'2025-11-29 18:55:19','2025-11-29 18:55:19'),(7,7,0.80,3.00,'2025-11-29 18:55:31','2025-11-29 18:55:31'),(8,8,0.70,2.50,'2025-11-29 18:55:54','2025-11-29 18:55:54'),(9,16,0.60,2.25,'2025-11-29 18:56:13','2025-11-29 18:56:13'),(10,32,0.55,2.00,'2025-11-29 18:56:25','2025-11-29 18:56:25'),(11,48,0.50,1.80,'2025-11-29 18:56:44','2025-11-29 18:56:44'),(12,72,0.48,1.70,'2025-11-29 18:57:01','2025-11-29 18:57:01'),(13,96,0.46,1.60,'2025-11-29 18:57:17','2025-11-29 18:57:17'),(14,200,0.44,1.50,'2025-11-29 18:57:36','2025-11-29 18:57:36');
/*!40000 ALTER TABLE `VpontoPeca` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `acabamentos`
--

DROP TABLE IF EXISTS `acabamentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `acabamentos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `data` datetime NOT NULL,
  `os_manual` varchar(255) DEFAULT NULL,
  `quantidade` int NOT NULL DEFAULT '1',
  `detalhes_peca` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `cliente_id` int DEFAULT NULL,
  `tecido_id` int DEFAULT NULL,
  `modelo_peca_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `os_manual` (`os_manual`),
  UNIQUE KEY `os_manual_2` (`os_manual`),
  UNIQUE KEY `os_manual_3` (`os_manual`),
  UNIQUE KEY `os_manual_4` (`os_manual`),
  UNIQUE KEY `os_manual_5` (`os_manual`),
  UNIQUE KEY `os_manual_6` (`os_manual`),
  KEY `cliente_id` (`cliente_id`),
  KEY `tecido_id` (`tecido_id`),
  KEY `modelo_peca_id` (`modelo_peca_id`),
  CONSTRAINT `acabamentos_ibfk_16` FOREIGN KEY (`cliente_id`) REFERENCES `Cliente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `acabamentos_ibfk_17` FOREIGN KEY (`tecido_id`) REFERENCES `TipoTecido` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `acabamentos_ibfk_18` FOREIGN KEY (`modelo_peca_id`) REFERENCES `ModeloPeca` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `acabamentos`
--

LOCK TABLES `acabamentos` WRITE;
/*!40000 ALTER TABLE `acabamentos` DISABLE KEYS */;
/*!40000 ALTER TABLE `acabamentos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auxilios_colab`
--

DROP TABLE IF EXISTS `auxilios_colab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `auxilios_colab` (
  `id` int NOT NULL AUTO_INCREMENT,
  `funcionario_id` int NOT NULL,
  `tipo` enum('transporte','alimentacao') NOT NULL,
  `valor_base` decimal(10,2) NOT NULL DEFAULT '0.00',
  `valor_calculado` decimal(10,2) DEFAULT NULL COMMENT 'Valor final após descontos',
  `mes` int NOT NULL,
  `ano` int NOT NULL,
  `saldo` decimal(10,2) DEFAULT '0.00' COMMENT 'Zerado após processamento',
  `dias_uteis_mes` int DEFAULT NULL,
  `dias_trabalhados` int DEFAULT NULL,
  `dias_desconto` int DEFAULT NULL COMMENT 'Faltas (transporte) ou dias < 6h (alimentação)',
  `status` enum('ativo','processado','zerado') DEFAULT 'ativo',
  `observacao` text,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `funcionario_id` (`funcionario_id`),
  CONSTRAINT `auxilios_colab_ibfk_1` FOREIGN KEY (`funcionario_id`) REFERENCES `Funcionario` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auxilios_colab`
--

LOCK TABLES `auxilios_colab` WRITE;
/*!40000 ALTER TABLE `auxilios_colab` DISABLE KEYS */;
/*!40000 ALTER TABLE `auxilios_colab` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `configuracoes`
--

DROP TABLE IF EXISTS `configuracoes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `configuracoes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chave` varchar(255) NOT NULL,
  `valor` varchar(255) NOT NULL,
  `jornada_padrao` varchar(255) NOT NULL,
  `tolerancia_minutos` int DEFAULT NULL,
  `numero_destino` varchar(255) NOT NULL,
  `whatsapp_notificacoes` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `chave` (`chave`),
  UNIQUE KEY `chave_2` (`chave`),
  UNIQUE KEY `chave_3` (`chave`),
  UNIQUE KEY `chave_4` (`chave`),
  UNIQUE KEY `chave_5` (`chave`),
  UNIQUE KEY `chave_6` (`chave`),
  UNIQUE KEY `chave_7` (`chave`),
  UNIQUE KEY `chave_8` (`chave`),
  UNIQUE KEY `chave_9` (`chave`),
  UNIQUE KEY `chave_23` (`chave`),
  UNIQUE KEY `chave_24` (`chave`),
  UNIQUE KEY `chave_25` (`chave`),
  UNIQUE KEY `chave_26` (`chave`),
  UNIQUE KEY `chave_27` (`chave`),
  UNIQUE KEY `chave_28` (`chave`),
  UNIQUE KEY `chave_29` (`chave`),
  UNIQUE KEY `chave_30` (`chave`),
  UNIQUE KEY `chave_31` (`chave`),
  UNIQUE KEY `chave_32` (`chave`),
  UNIQUE KEY `chave_33` (`chave`),
  UNIQUE KEY `chave_34` (`chave`),
  UNIQUE KEY `chave_35` (`chave`),
  UNIQUE KEY `chave_36` (`chave`),
  UNIQUE KEY `chave_37` (`chave`),
  UNIQUE KEY `chave_38` (`chave`),
  UNIQUE KEY `chave_39` (`chave`),
  UNIQUE KEY `chave_40` (`chave`),
  UNIQUE KEY `chave_41` (`chave`),
  UNIQUE KEY `chave_42` (`chave`),
  UNIQUE KEY `chave_43` (`chave`),
  UNIQUE KEY `chave_44` (`chave`),
  UNIQUE KEY `chave_45` (`chave`),
  UNIQUE KEY `chave_46` (`chave`),
  UNIQUE KEY `chave_47` (`chave`),
  UNIQUE KEY `chave_48` (`chave`),
  UNIQUE KEY `chave_49` (`chave`),
  UNIQUE KEY `chave_50` (`chave`),
  UNIQUE KEY `chave_51` (`chave`),
  UNIQUE KEY `chave_52` (`chave`),
  UNIQUE KEY `chave_53` (`chave`),
  UNIQUE KEY `chave_54` (`chave`),
  UNIQUE KEY `chave_55` (`chave`),
  UNIQUE KEY `chave_56` (`chave`),
  UNIQUE KEY `chave_57` (`chave`),
  UNIQUE KEY `chave_58` (`chave`),
  UNIQUE KEY `chave_59` (`chave`),
  UNIQUE KEY `chave_60` (`chave`),
  UNIQUE KEY `chave_61` (`chave`),
  UNIQUE KEY `chave_62` (`chave`),
  UNIQUE KEY `chave_63` (`chave`),
  UNIQUE KEY `chave_10` (`chave`),
  UNIQUE KEY `chave_11` (`chave`),
  UNIQUE KEY `chave_12` (`chave`),
  UNIQUE KEY `chave_13` (`chave`),
  UNIQUE KEY `chave_14` (`chave`),
  UNIQUE KEY `chave_15` (`chave`),
  UNIQUE KEY `chave_16` (`chave`),
  UNIQUE KEY `chave_17` (`chave`),
  UNIQUE KEY `chave_18` (`chave`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `configuracoes`
--

LOCK TABLES `configuracoes` WRITE;
/*!40000 ALTER TABLE `configuracoes` DISABLE KEYS */;
INSERT INTO `configuracoes` VALUES (1,'capacidade_diaria','100','08:48',5,'556283023020',1);
/*!40000 ALTER TABLE `configuracoes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cortes`
--

DROP TABLE IF EXISTS `cortes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cortes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `data` datetime NOT NULL,
  `os_manual` varchar(255) NOT NULL,
  `quantidade` int NOT NULL DEFAULT '1',
  `detalhes_peca` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `cliente_id` int DEFAULT NULL,
  `tecido_id` int DEFAULT NULL,
  `modelo_peca_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `os_manual` (`os_manual`),
  UNIQUE KEY `os_manual_2` (`os_manual`),
  UNIQUE KEY `os_manual_3` (`os_manual`),
  UNIQUE KEY `os_manual_4` (`os_manual`),
  UNIQUE KEY `os_manual_5` (`os_manual`),
  UNIQUE KEY `os_manual_6` (`os_manual`),
  UNIQUE KEY `os_manual_7` (`os_manual`),
  UNIQUE KEY `os_manual_8` (`os_manual`),
  KEY `cliente_id` (`cliente_id`),
  KEY `tecido_id` (`tecido_id`),
  KEY `modelo_peca_id` (`modelo_peca_id`),
  CONSTRAINT `cortes_ibfk_22` FOREIGN KEY (`cliente_id`) REFERENCES `Cliente` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `cortes_ibfk_23` FOREIGN KEY (`tecido_id`) REFERENCES `TipoTecido` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `cortes_ibfk_24` FOREIGN KEY (`modelo_peca_id`) REFERENCES `ModeloPeca` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cortes`
--

LOCK TABLES `cortes` WRITE;
/*!40000 ALTER TABLE `cortes` DISABLE KEYS */;
/*!40000 ALTER TABLE `cortes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feriados`
--

DROP TABLE IF EXISTS `feriados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `feriados` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  `data` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feriados`
--

LOCK TABLES `feriados` WRITE;
/*!40000 ALTER TABLE `feriados` DISABLE KEYS */;
INSERT INTO `feriados` VALUES (1,'dia da independencia','2026-09-07'),(2,'Senhora Aparecida','2026-10-12'),(3,'Proclamação da Republica','2026-11-15'),(5,'Aniversário de Goiânia','2026-10-24'),(6,'Dia de finados','2026-11-02'),(7,'Consciência negra','2026-11-20'),(8,'natal','2026-12-25'),(9,'ano novo','2027-01-01'),(10,'Dia do Trabalhador','2026-05-01'),(11,'Corpus Christi','2026-06-04'),(12,'Tiradentes','2026-04-21'),(13,'Paixão de Cristo','2026-04-03'),(14,'ano novo','2026-01-01');
/*!40000 ALTER TABLE `feriados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prod_costura`
--

DROP TABLE IF EXISTS `prod_costura`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prod_costura` (
  `id` int NOT NULL AUTO_INCREMENT,
  `data` date NOT NULL,
  `os_manual` varchar(255) DEFAULT NULL,
  `funcionario` varchar(255) NOT NULL,
  `maquina` varchar(255) NOT NULL,
  `tecido` varchar(255) NOT NULL,
  `processo` varchar(255) NOT NULL,
  `inicio_processo` datetime NOT NULL,
  `fim_processo` datetime NOT NULL,
  `tempo_total` int NOT NULL COMMENT 'duração em segundos',
  `tempo_medio` int NOT NULL COMMENT 'média em segundos por peça',
  `qtd_peca` int NOT NULL,
  `modelo_peca` varchar(255) NOT NULL,
  `detalhes_peca` text,
  `observacao` text,
  `cliente` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `os_manual` (`os_manual`),
  UNIQUE KEY `os_manual_2` (`os_manual`),
  UNIQUE KEY `os_manual_3` (`os_manual`),
  UNIQUE KEY `os_manual_4` (`os_manual`),
  UNIQUE KEY `os_manual_5` (`os_manual`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prod_costura`
--

LOCK TABLES `prod_costura` WRITE;
/*!40000 ALTER TABLE `prod_costura` DISABLE KEYS */;
/*!40000 ALTER TABLE `prod_costura` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibos_pgt`
--

DROP TABLE IF EXISTS `recibos_pgt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `recibos_pgt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `funcionario_id` int NOT NULL,
  `data_pagamento` date NOT NULL,
  `periodo_inicio` date NOT NULL,
  `periodo_fim` date NOT NULL,
  `salario_bruto` decimal(10,2) NOT NULL,
  `salario_liquido` decimal(10,2) NOT NULL DEFAULT '0.00',
  `auxilio_refeicao` decimal(10,2) DEFAULT '0.00',
  `auxilio_transporte` decimal(10,2) DEFAULT '0.00',
  `comissao` decimal(10,2) DEFAULT '0.00',
  `produtividade` decimal(10,2) DEFAULT '0.00',
  `eficiencia` decimal(10,2) DEFAULT '0.00',
  `outros_beneficios` decimal(10,2) DEFAULT '0.00',
  `outros_descontos` decimal(10,2) DEFAULT '0.00',
  `total_proventos` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_descontos` decimal(10,2) DEFAULT '0.00',
  `observacoes` text,
  `numero_recibo` varchar(255) DEFAULT NULL,
  `status` enum('pendente','pago','cancelado') DEFAULT 'pendente',
  `emitido_por` varchar(255) DEFAULT NULL,
  `data_emissao` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `numero_recibo` (`numero_recibo`),
  UNIQUE KEY `numero_recibo_2` (`numero_recibo`),
  KEY `funcionario_id` (`funcionario_id`),
  CONSTRAINT `recibos_pgt_ibfk_1` FOREIGN KEY (`funcionario_id`) REFERENCES `Funcionario` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibos_pgt`
--

LOCK TABLES `recibos_pgt` WRITE;
/*!40000 ALTER TABLE `recibos_pgt` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibos_pgt` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-04-09  8:26:28
