html_vector_lite

html_vector_lite

HTML을 벡터화한 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`html_vector_lite` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `url_id` INT UNSIGNED NOT NULL COMMENT 'domain_url 테이블의 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의 오름차순 순번',
  `depth` INT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'HTML 태그의 깊이',
  PRIMARY KEY (`id`),
  INDEX `fk_url_id_idx_lite` (`url_id` ASC),
  INDEX `fk_tag_id_idx_lite` (`tag_id` ASC),
  CONSTRAINT `fk_domain_url_id_lite`
    FOREIGN KEY (`url_id`)
    REFERENCES `yummy_spam`.`domain_url` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tag_id_lite`
    FOREIGN KEY (`tag_id`)
    REFERENCES `yummy_spam`.`tag` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;