HAWKEYE_ES

Tables (6)

ANOMALY_POINT

  • ANOMALY_POINT_ID — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • 이상점 날짜 (ANOMALY_DATE) — DATE — NOT NULL
  • ES_TERM_ID (ES__TERM_ID) — INT — Foreign key → ES_TERM.ES_TERM_ID — NOT NULL
  • ES_KEYWORD_FIELD_ID — INT — Foreign key → ES_TERM.ES_KEYWORD_FIELD_ID — NOT NULL
  • ES_INDEX_ID — INT — Foreign key → ES_TERM.ES_INDEX_ID — NOT NULL
  • SEARCH RULE ID (SEARCH_RULE_ID) — INT — Foreign key → SEARCH_RULE.SEARCH RULE ID — NOT NULL

ES_INDEX

  • ES_INDEX_ID — INT — Primary key — NOT NULL
  • 이름 (NAME) — VARCHAR(100) — NOT NULL — UNIQUE

ES_KEYWORD_FIELD

  • ES_KEYWORD_FIELD_ID — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • ES_INDEX_ID — INT — Foreign key → ES_INDEX.ES_INDEX_ID — NOT NULL
  • 이름 (NAME) — VARCHR(100) — NOT NULL

ES_TERM

  • ES_TERM_ID (ES__TERM_ID) — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • ES_KEYWORD_FIELD_ID — INT — Foreign key → ES_KEYWORD_FIELD.ES_KEYWORD_FIELD_ID — NOT NULL
  • ES_INDEX_ID — INT — Foreign key → ES_KEYWORD_FIELD.ES_INDEX_ID — NOT NULL
  • 이름 (NAME) — VARCHAR(100) — NOT NULL

ES_TEXT_FIELD

  • ES_TEXT_FIELD_ID — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • ES_INDEX_ID — INT — Foreign key → ES_INDEX.ES_INDEX_ID — NOT NULL
  • 이름 (NAME) — VARCHR(100) — NOT NULL

SEARCH_RULE

  • SEARCH RULE ID (SEARCH_RULE_ID) — INT — Primary key — NOT NULL
  • 이름 (NAME) — VARCHAR(100) — NOT NULL — UNIQUE
  • 표현 트리 (EXPR_TREE) — JSON — NOT NULL
  • ES_TEXT_FIELD_ID — INT — Foreign key → ES_TEXT_FIELD.ES_TEXT_FIELD_ID — NOT NULL
  • ES_INDEX_ID — INT — Foreign key → ES_TEXT_FIELD.ES_INDEX_ID — NOT NULL