test

Tables (6)

ANOMALY_POINT

  • ANOMALY_POINT_ID — INT — Primary key — NOT NULL
  • ANOMALY_DATE — DATE — NOT NULL
  • ES_TERM_ID — INT — Foreign key → ES_TERM.ES_TERM_ID — NOT NULL
  • 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

ES_KEYWORD_FIELD

  • ES_KEYWORD_FIELD_ID — INT — Primary key — NOT NULL
  • ES_INDEX_ID — INT — Foreign key → ES_INDEX.ES_INDEX_ID — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL

ES_TERM

  • ES_TERM_ID — INT — Primary key — NOT NULL
  • ES_KEYWORD_FIELD_ID — INT — Foreign key → ES_KEYWORD_FIELD.ES_KEYWORD_FIELD_ID — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL

ES_TEXT_FIELD

  • ES_TEXT_FIELD_ID — INT — Primary key — NOT NULL
  • ES_INDEX_ID — INT — Foreign key → ES_INDEX.ES_INDEX_ID — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL

SEARCH_RULE

  • SEARCH_RULE_ID — INT — Primary key — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • EXPR_TREE — JSON — NOT NULL
  • ES_TEXT_FIELD_ID — INT — Foreign key → ES_TEXT_FIELD.ES_TEXT_FIELD_ID