404

D7net
:/ var / www / html / chatweb02 / upload / perfil /
Filename : chamados.sql
back
-- MySQL Script generated by MySQL Workbench
-- Tue Jun 23 16:51:24 2020
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema devcodes24
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema devcodes24
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `devcodes24` DEFAULT CHARACTER SET utf8 ;
USE `devcodes24` ;

-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_usuario`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_usuario` (
  `tkt_usu_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_usu_nome` VARCHAR(120) NULL,
  `tkt_usu_login` VARCHAR(120) NULL,
  `tkt_usu_senha` VARCHAR(240) NULL,
  PRIMARY KEY (`tkt_usu_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_empresa`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_empresa` (
  `tkt_emp_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_emp_razaosocial` VARCHAR(240) NULL,
  PRIMARY KEY (`tkt_emp_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_unidade`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_unidade` (
  `tkt_uni_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_uni_nome` VARCHAR(120) NULL,
  `tkt_` VARCHAR(45) NULL,
  `tkt_emp_id` INT NOT NULL,
  PRIMARY KEY (`tkt_uni_id`),
  INDEX `fk_tkt_unidade_tkt_empresa1_idx` (`tkt_emp_id` ASC),
  CONSTRAINT `fk_tkt_unidade_tkt_empresa1`
    FOREIGN KEY (`tkt_emp_id`)
    REFERENCES `devcodes24`.`tkt_empresa` (`tkt_emp_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_grupo_motivo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_grupo_motivo` (
  `tkt_gmo_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_gmo_nome` VARCHAR(120) NULL,
  PRIMARY KEY (`tkt_gmo_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_motivo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_motivo` (
  `tkt_mot_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_mot_nome` VARCHAR(45) NULL,
  `tkt_mot_temporesposta` INT NULL,
  `tkt_gmo_id` INT NOT NULL,
  PRIMARY KEY (`tkt_mot_id`),
  INDEX `fk_tkt_motivo_tkt_grupo_motivo1_idx` (`tkt_gmo_id` ASC),
  CONSTRAINT `fk_tkt_motivo_tkt_grupo_motivo1`
    FOREIGN KEY (`tkt_gmo_id`)
    REFERENCES `devcodes24`.`tkt_grupo_motivo` (`tkt_gmo_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_prioridade`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_prioridade` (
  `tkt_pri_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_pri_nome` VARCHAR(120) NULL,
  `tkt_pri_cor` VARCHAR(45) NULL,
  PRIMARY KEY (`tkt_pri_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_chamado`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_chamado` (
  `tkt_cha_id` INT NOT NULL AUTO_INCREMENT,
  `tkt_cha_assunto` VARCHAR(240) NOT NULL,
  `tkt_cha_observacao` BLOB NOT NULL,
  `tkt_pri_id` INT NOT NULL,
  `tkt_mot_id` INT NOT NULL,
  `tkt_cha_dhcad` DATETIME NOT NULL,
  `tkt_cha_dhalt` DATETIME NULL,
  `tkt_cha_email` VARCHAR(480) NULL,
  `tkt_usu_id_responsavel` INT NOT NULL,
  `tkt_usu_id_solicitante` INT NOT NULL,
  `tkt_cha_status` VARCHAR(1) NOT NULL,
  `tkt_cha_ponto` VARCHAR(1) NOT NULL,
  PRIMARY KEY (`tkt_cha_id`),
  INDEX `fk_tkt_chamado_tkt_prioridade1_idx` (`tkt_pri_id` ASC),
  INDEX `fk_tkt_chamado_tkt_motivo1_idx` (`tkt_mot_id` ASC),
  INDEX `fk_tkt_chamado_tkt_usuario1_idx` (`tkt_usu_id_responsavel` ASC),
  INDEX `fk_tkt_chamado_tkt_usuario2_idx` (`tkt_usu_id_solicitante` ASC),
  CONSTRAINT `fk_tkt_chamado_tkt_prioridade1`
    FOREIGN KEY (`tkt_pri_id`)
    REFERENCES `devcodes24`.`tkt_prioridade` (`tkt_pri_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_chamado_tkt_motivo1`
    FOREIGN KEY (`tkt_mot_id`)
    REFERENCES `devcodes24`.`tkt_motivo` (`tkt_mot_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_chamado_tkt_usuario1`
    FOREIGN KEY (`tkt_usu_id_responsavel`)
    REFERENCES `devcodes24`.`tkt_usuario` (`tkt_usu_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_chamado_tkt_usuario2`
    FOREIGN KEY (`tkt_usu_id_solicitante`)
    REFERENCES `devcodes24`.`tkt_usuario` (`tkt_usu_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_calendario_feriados`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_calendario_feriados` (
  `tkt_cfe_data` DATE NOT NULL,
  `tkt_cfe_descricao` VARCHAR(120) NULL,
  `tkt_emp_id` INT NOT NULL,
  PRIMARY KEY (`tkt_cfe_data`),
  INDEX `fk_tkt_calendario_feriados_tkt_empresa1_idx` (`tkt_emp_id` ASC),
  CONSTRAINT `fk_tkt_calendario_feriados_tkt_empresa1`
    FOREIGN KEY (`tkt_emp_id`)
    REFERENCES `devcodes24`.`tkt_empresa` (`tkt_emp_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_usuario_unidade`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_usuario_unidade` (
  `tkt_usu_id` INT NOT NULL,
  `tkt_uni_id` INT NOT NULL,
  PRIMARY KEY (`tkt_usu_id`, `tkt_uni_id`),
  INDEX `fk_tkt_usuario_has_tkt_unidade_tkt_unidade1_idx` (`tkt_uni_id` ASC),
  INDEX `fk_tkt_usuario_has_tkt_unidade_tkt_usuario_idx` (`tkt_usu_id` ASC),
  CONSTRAINT `fk_tkt_usuario_has_tkt_unidade_tkt_usuario`
    FOREIGN KEY (`tkt_usu_id`)
    REFERENCES `devcodes24`.`tkt_usuario` (`tkt_usu_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_usuario_has_tkt_unidade_tkt_unidade1`
    FOREIGN KEY (`tkt_uni_id`)
    REFERENCES `devcodes24`.`tkt_unidade` (`tkt_uni_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_chamado_anexo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_chamado_anexo` (
  `tkt_cha_id` INT NOT NULL,
  `tkt_can_id` INT NOT NULL,
  `tkt_can_caminho` VARCHAR(240) NULL,
  `tkt_can_arquivo` VARCHAR(120) NULL,
  PRIMARY KEY (`tkt_cha_id`, `tkt_can_id`),
  CONSTRAINT `fk_tkt_chamado_anexo_tkt_chamado1`
    FOREIGN KEY (`tkt_cha_id`)
    REFERENCES `devcodes24`.`tkt_chamado` (`tkt_cha_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_responsaveis`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_responsaveis` (
  `tkt_usu_id` INT NOT NULL,
  `tkt_mot_id` INT NOT NULL,
  PRIMARY KEY (`tkt_usu_id`, `tkt_mot_id`),
  INDEX `fk_tkt_usuario_has_tkt_motivo_tkt_motivo1_idx` (`tkt_mot_id` ASC),
  INDEX `fk_tkt_usuario_has_tkt_motivo_tkt_usuario1_idx` (`tkt_usu_id` ASC),
  CONSTRAINT `fk_tkt_usuario_has_tkt_motivo_tkt_usuario1`
    FOREIGN KEY (`tkt_usu_id`)
    REFERENCES `devcodes24`.`tkt_usuario` (`tkt_usu_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_usuario_has_tkt_motivo_tkt_motivo1`
    FOREIGN KEY (`tkt_mot_id`)
    REFERENCES `devcodes24`.`tkt_motivo` (`tkt_mot_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `devcodes24`.`tkt_chamado_mensagem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `devcodes24`.`tkt_chamado_mensagem` (
  `tkt_cha_id` INT NOT NULL,
  `tkt_men_id` INT NOT NULL,
  `tkt_men_dhcad` DATETIME NOT NULL,
  `tkt_men_obs` BLOB NOT NULL,
  `tkt_usu_id` INT NOT NULL,
  PRIMARY KEY (`tkt_cha_id`, `tkt_men_id`),
  INDEX `fk_tkt_chamado_mensagem_tkt_chamado1_idx` (`tkt_cha_id` ASC),
  INDEX `fk_tkt_chamado_mensagem_tkt_usuario1_idx` (`tkt_usu_id` ASC),
  CONSTRAINT `fk_tkt_chamado_mensagem_tkt_chamado1`
    FOREIGN KEY (`tkt_cha_id`)
    REFERENCES `devcodes24`.`tkt_chamado` (`tkt_cha_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tkt_chamado_mensagem_tkt_usuario1`
    FOREIGN KEY (`tkt_usu_id`)
    REFERENCES `devcodes24`.`tkt_usuario` (`tkt_usu_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;