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