--
-- Estrutura da tabela `tpexame`
--

CREATE TABLE IF NOT EXISTS `tpexame` (
  `id_tpexam` int(4) NOT NULL AUTO_INCREMENT,
  `nom_tpexam` varchar(50) NOT NULL,
  `idexam_tpexam` int(4) NOT NULL,
  `nomexam_tpexam` varchar(50) NOT NULL,
  `mensagem_tpexam` text DEFAULT NULL,
  `laudo_tpexam` text DEFAULT NULL,
  `diagnostico_tpexam` text DEFAULT NULL,
  `codsus_tpexam` varchar(14) DEFAULT NULL,
  `valor_tpexam` float(9,2) DEFAULT NULL,
  PRIMARY KEY (`id_tpexam`),
  KEY `idexam_tpexam` (`idexam_tpexam`,`id_tpexam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


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