anomaly

Tables (4)

anomaly_detection

  • id (Key) — Primary key — NOT NULL
  • scenario_id — int
  • anomaly_category — varchar
  • place — varchar
  • place_detail — varchar
  • detection_time — date
  • status — string
  • author_id — int
  • is_alarm — int
  • issue_category — varchar

anomaly_detection_data

  • id (Key) — Primary key — NOT NULL
  • anomaly_detection_id — Foreign key → anomaly_detection.id — NOT NULL
  • detect_node_name — varchar
  • sensor_name — varchar
  • ai_class — varchar
  • roi_name — varchar
  • roi_color — varchar
  • img_with_color_box — varchar
  • img_original — varchar
  • resource_id — int
  • measurement_item — varchar
  • detection_data — string
  • sensor_avg — int
  • threshold — int
  • type — string

scenario

  • id — int — Primary key — NOT NULL
  • scenario_name — varchar
  • activate — boolean
  • scenario_folder_id — int
  • place_id — int
  • project_id — varchar
  • detection_category — json
  • is_deleted — boolean

users

  • id — Primary key — NOT NULL
  • Field