
--
-- Структура таблицы `lab_analyses`
--

CREATE TABLE IF NOT EXISTS `lab_analyses` (
  `number_research` int(5) NOT NULL,
  `patient_id` int(6) NOT NULL,
  `id_type_research` int(5) NOT NULL,
  `data` date NOT NULL,
  `lpu_id` int(4) NOT NULL,
  `clinical_payment` set('0','1') NOT NULL,
  `contingent_code` int(11) NOT NULL COMMENT 'контингент код'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Дамп данных таблицы `lab_analyses`
--

INSERT INTO `lab_analyses` (`number_research`, `patient_id`, `id_type_research`, `data`, `lpu_id`, `clinical_payment`, `contingent_code`) VALUES
(7402, 46, 3, '2010-02-09', 1, '1', 102),
(7403, 46, 4, '2010-02-09', 64, '1', 102),
(7404, 46, 7, '2010-02-09', 20, '1', 105),
(7405, 46, 12, '2010-02-09', 64, '1', 109),
(7406, 46, 11, '2010-02-09', 1, '1', 102),
(7407, 46, 7, '2010-02-09', 64, '1', 123);

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

--
-- Структура таблицы `s_contingent_cod`
--

CREATE TABLE IF NOT EXISTS `s_contingent_cod` (
  `code_id` int(3) NOT NULL,
  `name` varchar(500) NOT NULL,
  KEY `code_id` (`code_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Справочник: контингент код';

--
-- Дамп данных таблицы `s_contingent_cod`
--

INSERT INTO `s_contingent_cod` (`code_id`, `name`) VALUES
(118, ''),
(200, ''),
(102, ''),
(103, ''),
(104, ''),
(105, ''),
(106, ''),
(108, ''),
(109, ''),
(111, ''),
(112, ''),
(113, ''),
(114, ''),
(116, ''),
(121, ''),
(122, ''),
(123, ''),
(124, ''),
(115, ''),
(125, ''),
(128, ''),
(120, '');
