미니포르젝트
테이블 (6)
admin_users
- admin_uuid — CHAR(36)
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — ENUM('SUPER_ADMIN', 'ADMIN', 'VIEWER') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
device_software
- device_id — BIGINT — 기본 키 — NOT NULL
- sw_id — BIGINT — 기본 키 — NOT NULL
- installed_at — DATETIME
devices
- device_id — BIGINT
- device_name — VARCHAR(100) — NOT NULL
- install_place — VARCHAR(100) — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'ERROR') — NOT NULL
- registered_at — DATETIME — NOT NULL
- deleted_at — DATETIME
event_logs
- event_id — BIGINT
- device_id — BIGINT
- admin_uuid — CHAR(36)
- event_type — ENUM('REGISTER', 'SW_UPLOAD', 'UPDATE', 'ERROR', 'INFO')
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
measurements
- measurement_id — BIGINT
- device_id — BIGINT — NOT NULL
- region — VARCHAR(50) — NOT NULL
- measured_at — DATETIME — NOT NULL
- value — DOUBLE — NOT NULL
- INDEX — idx_measured_at
software
- sw_id — BIGINT
- sw_name — VARCHAR(100) — NOT NULL
- sw_version — VARCHAR(50) — NOT NULL
- installed_at — DATETIME — NOT NULL
- created_by — CHAR(36) — NOT NULL