-- https://www.phpmyadmin.net/
--

START TRANSACTION;











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

--
-- Table structure for table `supplier_catalog_items`
--

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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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
('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');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `supplier_catalog_items`
--
ALTER TABLE `supplier_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supplier_vendors`
--
ALTER TABLE `supplier_vendors`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `supplier_catalog_items`
--
ALTER TABLE `supplier_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

