-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:6446
-- Generation Time: Jun 17, 2020 at 11:27 AM
-- Server version: 8.0.20
-- PHP Version: 7.4.7

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `firm`
--

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

--
-- Table structure for table `firm_db_ad`
--

CREATE TABLE `firm_db_ad` (
  `id` int UNSIGNED NOT NULL COMMENT 'ID',
  `active` tinyint UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Nesmazáno',
  `date_modified` date DEFAULT NULL COMMENT 'Upraveno',
  `date_added` date DEFAULT NULL COMMENT 'Vytvořeno',
  `firm_closed` date DEFAULT NULL COMMENT 'Datum ukončení činnosti',
  `firm_created` date DEFAULT NULL COMMENT 'Datum založení firmy',
  `firm_modified` date DEFAULT NULL COMMENT 'Datum změny firmy',
  `tax_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'DIČ',
  `id_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IČ',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Název',
  `count_email` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Počet emailů',
  `count_fax` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Počet faxů',
  `count_phone` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Počet telefonů',
  `count_www` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Počet webů',
  `source_detail_id` int UNSIGNED DEFAULT NULL COMMENT 'Podrobnosti zdroje údaje',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Popis',
  `legal_form` int UNSIGNED DEFAULT NULL COMMENT 'Právní forma',
  `share_capital` float DEFAULT NULL COMMENT 'Základní kapitál',
  `share_capital_currency_global_id` int UNSIGNED DEFAULT NULL COMMENT 'Měna (Základní kapitál)',
  `source_id` int UNSIGNED NOT NULL COMMENT 'Zdroj údaje',
  `firm_db_id` int UNSIGNED NOT NULL COMMENT 'Vazba na FirmDb',
  `is_alive` tinyint UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Firma nemá ukončenou činnost'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Databáze firem AD' ROW_FORMAT=DYNAMIC;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `firm_db_ad`
--
ALTER TABLE `firm_db_ad`
  ADD PRIMARY KEY (`id`) USING BTREE,
  ADD UNIQUE KEY `firm_db_id` (`firm_db_id`) USING BTREE,
  ADD UNIQUE KEY `id_number` (`id_number`) USING BTREE,
  ADD KEY `count_email` (`count_email`) USING BTREE,
  ADD KEY `count_fax` (`count_fax`) USING BTREE,
  ADD KEY `count_phone` (`count_phone`) USING BTREE,
  ADD KEY `count_www` (`count_www`) USING BTREE,
  ADD KEY `firm_closed` (`firm_closed`) USING BTREE,
  ADD KEY `legal_form` (`legal_form`) USING BTREE,
  ADD KEY `name` (`name`) USING BTREE,
  ADD KEY `share_capital_currency_global_id` (`share_capital_currency_global_id`) USING BTREE,
  ADD KEY `tax_number` (`tax_number`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `firm_db_ad`
--
ALTER TABLE `firm_db_ad`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- Constraints for dumped tables
--

--
-- Constraints for table `firm_db_ad`
--
ALTER TABLE `firm_db_ad`
  ADD CONSTRAINT `fk_2304876011` FOREIGN KEY (`firm_db_id`) REFERENCES `firm_db` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_2758825568` FOREIGN KEY (`legal_form`) REFERENCES `global`.`table_column_option` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_2901393631` FOREIGN KEY (`share_capital_currency_global_id`) REFERENCES `global`.`currency_global` (`id`) ON UPDATE CASCADE;
SET FOREIGN_KEY_CHECKS=1;

/*!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 */;