html_vector

html_vector

HTML을 벡터화한 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`html_vector` (
  `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의 오름차순 순번',
  PRIMARY KEY (`id`),
  INDEX `fk_url_id_idx` (`url_id` ASC) VISIBLE,
  INDEX `fk_tag_id_idx` (`tag_id` ASC) VISIBLE,
  INDEX `fk_lang_mst_id_idx` (`lang_id` ASC) VISIBLE,
  CONSTRAINT `fk_domain_url_id`
    FOREIGN KEY (`url_id`)
    REFERENCES `yummy_spam`.`domain_url` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_lang_mst_id`
    FOREIGN KEY (`lang_id`)
    REFERENCES `yummy_spam`.`lang_mst` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tag_id`
    FOREIGN KEY (`tag_id`)
    REFERENCES `yummy_spam`.`tag` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_word_id`
    FOREIGN KEY (`word_id`)
    REFERENCES `yummy_spam`.`word` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB