PATCH_ERD

Tables (4)

color_marker_values

  • id — BIGINT — Primary key — NOT NULL
  • measurement_id — BIGINT — Foreign key → measurements.id — NOT NULL
  • color_type — VARCHAR(20) — NOT NULL
  • raw_r — INT — NOT NULL
  • raw_g — INT — NOT NULL
  • raw_b — INT — NOT NULL
  • corrected_r — INT
  • corrected_g — INT
  • corrected_b — INT
  • created_at — TIMESTAMP — NOT NULL

dressing_schedules

  • id — BIGINT — Primary key — NOT NULL
  • cycle_hours — INT — NOT NULL
  • last_changed_at — DATETIME
  • next_change_at — DATETIME
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

measurement_sensor_values

  • id — BIGINT — Primary key — NOT NULL
  • measurement_id — BIGINT — Foreign key → measurements.id — NOT NULL
  • sensor_type — VARCHAR(30) — NOT NULL
  • raw_r — INT
  • raw_g — INT
  • raw_b — INT
  • corrected_r — INT
  • corrected_g — INT
  • corrected_b — INT
  • predicted_value — VARCHAR(50) — NOT NULL
  • numeric_value — DECIMAL(10,2)
  • unit — VARCHAR(20)
  • delta_e — DECIMAL(10,2)
  • status_code — VARCHAR(30)
  • status_label — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL

measurements

  • id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • captured_at — DATETIME — NOT NULL
  • calibration_applied — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • dressing_id — BIGINT — Foreign key → dressing_schedules.id — NOT NULL