-- Respaldo Nativo generado por Sistema CRM TS --
-- Base de datos: trydvnte_bameredith.com_core_supplier --
-- Conexión: mysql_supplier --
-- Fecha: 2026-08-24 01:01:53 --

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `supplier_catalog_items`;
CREATE TABLE `supplier_catalog_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catalogs_id` int(11) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int(11) NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int(11) NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;