html_vector_2

depth를 고려한 HTML을 벡터화한 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`html_vector_with_depth` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `url_id` INT UNSIGNED NOT NULL COMMENT 'domain_url 테이블의 primary key(id)',
  `lang_id` INT UNSIGNED NOT NULL COMMENT 'lang_mst 테이블의 primary key(id)',
  `tag_id` INT UNSIGNED NOT NULL COMMENT 'tag 테이블의 primary key(id)',
  `tag_order` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'HTML 파일내의 동일한 tag의 오름차순 순번',
  `word_id` INT UNSIGNED NOT NULL COMMENT 'word 테이블의 primary key(id)',
  `word_order` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'HTML 파일내의 동일한 word의 오름차순 순번',
  `depth` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'HTML 태그의 깊이',
  PRIMARY KEY (`id`),
  INDEX `fk_url_id_idx_with_depth` (`url_id` ASC),
  INDEX `fk_tag_id_idx_with_depth` (`tag_id` ASC),
  INDEX `fk_lang_mst_id_idx_with_depth` (`lang_id` ASC),
  CONSTRAINT `fk_domain_url_id_with_depth`
    FOREIGN KEY (`url_id`)
    REFERENCES `yummy_spam`.`domain_url` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_lang_mst_id_with_depth`
    FOREIGN KEY (`lang_id`)
    REFERENCES `yummy_spam`.`lang_mst` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tag_id_with_depth`
    FOREIGN KEY (`tag_id`)
    REFERENCES `yummy_spam`.`tag` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_word_id_with_depth`
    FOREIGN KEY (`word_id`)
    REFERENCES `yummy_spam`.`word` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;