-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-12-2022 a las 09:38:32
-- Versión del servidor: 8.0.31-0ubuntu0.20.04.2
-- Versión de PHP: 7.4.3

START TRANSACTION;












CREATE TABLE `supplier_catalog_items` (
  `id` int NOT NULL,
  `catalogs_id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int 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 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `supplier_vendors`
--

CREATE TABLE `supplier_vendors` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `country_id` int NOT NULL COMMENT 'Related to country table',
  `code` varchar(100) DEFAULT NULL,
  `full_name` varchar(250) NOT NULL,
  `nit` varchar(50) NOT NULL DEFAULT '0',
  `email` varchar(100) DEFAULT NULL,
  `social_media` text,
  `phones` varchar(150) DEFAULT NULL,
  `address` varchar(512) DEFAULT NULL,
  `references` mediumtext,
  `photo` varchar(250) DEFAULT NULL COMMENT 'Photo from customer',
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `supplier_vendors`
--

INSERT INTO `supplier_vendors` (`relative`, `users_sid`, `global_branch_office_id`, `country_id`, `code`, `full_name`, `nit`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('56bc1547-6955-44a3-8891-11adc5963971', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Amaszonas', '12312312312312', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-04-21 14:26:21', '2022-04-21 14:26:21'),
('8b1de46a-3e96-457b-b18d-dbfd51aebcd1', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'BOA-01', 'Boliviana de Aviacion (BOA)', '154422029', 'ventasweb@boa.bo', 'https://fb.com/boa', '2 2166500', 'Av. Camacho, La Paz', NULL, '1646314625-3196550-06787d19-416f-448d-840a-6792c525cfaf.png', 'A', '2022-03-03 09:37:05', '2022-03-03 09:37:05'),
('95d29aff-582e-4c21-87ae-34edbf7ff498', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Proveedor boliviano', '0', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-03-15 10:10:52', '2022-03-15 10:10:52');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `supplier_catalog_items`
--
ALTER TABLE `supplier_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `supplier_vendors`
--
ALTER TABLE `supplier_vendors`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `supplier_catalog_items`
--
ALTER TABLE `supplier_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

