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