종프2

테이블 (5)

AbnormalMetricLog (Untitled3)

  • number (Key) — Integer — 기본 키 — NOT NULL
  • target_id (Key2) — varchar(45) — 외래 키 → MonitoredMachineInventory.id — NOT NULL
  • metric_name (Field2) — varchar(45)
  • value (Field3) — double
  • timestamp (Field4) — TIMESTAMP

LatestAbnormalStatus (Untitled4)

  • number (Key) — Integer — 기본 키 — NOT NULL
  • target_id (Key2) — varchar(45) — 외래 키 → MonitoredMachineInventory.id — NOT NULL
  • metric_name (Field4) — varchar(45)
  • value (Field) — varchar(45)
  • detected_at (Field2) — TIMESTAMP
  • resolved (Field3) — boolean

MetricsByType (Untitled7)

  • number (Key) — Integer — 기본 키 — NOT NULL
  • type_id (Key2) — Integer — 외래 키 → TargetType.id — NOT NULL
  • metric_name (Field2) — varchar(45)
  • unit (Field3) — varchar(45)
  • threshold_value (Field4) — double

MonitoredMachineInventory (Untitled5)

  • id (Key) — varchar(45) — 기본 키 — NOT NULL
  • type_id (Key2) — Integer — 외래 키 → TargetType.id — NOT NULL
  • machine_id (Field2) — varchar(45)

TargetType (Untitled)

  • id (Key) — Integer — 기본 키 — NOT NULL
  • type (Field) — varchar(45)