데이터모델링

테이블 (6)

ALERT_EVENT

  • alert_id — BIGINT — 기본 키 — NOT NULL
  • sensor_id — BIGINT — 외래 키 → SENSOR.sensor_id — NOT NULL
  • triggered_at — DATETIME — NOT NULL
  • cleared_at — DATETIME
  • alert_level — VARCHAR(20) — NOT NULL
  • message — VARCHAR(255)

FAILURE_LOG

  • failure_id — BIGINT — 기본 키 — NOT NULL
  • machine_id — BIGINT — 외래 키 → MACHINE.machine_id — NOT NULL
  • start_ts — DATETIME — NOT NULL
  • end_ts — DATETIME
  • cause_code — VARCHAR(50)
  • severity — VARCHAR(20) — NOT NULL

MACHINE

  • machine_id — BIGINT — 기본 키 — NOT NULL
  • machine_name — VARCHAR(100) — NOT NULL
  • machine_type — VARCHAR(50)
  • install_date — DATE
  • location — VARCHAR(50)

MEASUREMENT

  • measurement_id — BIGINT — 기본 키 — NOT NULL
  • sensor_id — BIGINT — 외래 키 → SENSOR.sensor_id — NOT NULL
  • ts — DATETIME — NOT NULL
  • value — DECIMAL(10,2) — NOT NULL
  • quality_flag — CHAR(1)

SENSOR

  • sensor_id — BIGINT — 기본 키 — NOT NULL
  • machine_id — BIGINT — 외래 키 → MACHINE.machine_id — NOT NULL
  • sensor_name — VARCHAR(100) — NOT NULL
  • sensor_type — VARCHAR(50) — NOT NULL
  • unit — VARCHAR(20)
  • status — VARCHAR(20) — NOT NULL

Untitled

  • id — int — NOT NULL — 기본키는 notnull로 제한
  • name — char() — NOT NULL — char(문자 갯수 제한)
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7