domain_url

도메인별 url관리 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`domain_url` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `domain_id` INT(6) UNSIGNED NOT NULL COMMENT 'domain_mst 테이블의 primary key (id)',
  `url` VARCHAR(225) NOT NULL COMMENT '해당 도메인의 url',
  `is_notice` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '공지사항 여부',
  `has_change` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '공지사항 변경 여부',
  PRIMARY KEY (`id`),
  INDEX `fk_domain_mst_id_idx` (`domain_id` ASC) VISIBLE,
  INDEX `is_notice` (`is_notice` ASC) VISIBLE,
  INDEX `has_change` (`has_change` ASC) VISIBLE,
  CONSTRAINT `fk_domain_mst_id`
    FOREIGN KEY (`domain_id`)
    REFERENCES `yummy_spam`.`domain_mst` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB