미니포르젝트

테이블 (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