木漏れ日

Tables (8)

devices (기기리스트)

  • id (Key) — int — Primary key — NOT NULL
  • manufacture_date (Field) — datetime
  • certification (Field2) — on/off

error_lists (오류내역)

  • num (Key) — int — Primary key — NOT NULL
  • device_id (Key2) — int — Foreign key → register_devices.device_id — NOT NULL
  • error_id (Key3) — int — Foreign key → errors.id — NOT NULL
  • error_date (Field) — datetime
  • error_state (Field2) — on/off

errors (오류정보)

  • id (Key) — int — Primary key — NOT NULL
  • error (Field) — varchar(40)

grades (등급)

  • id (Key) — int — Primary key — NOT NULL
  • grade (Field) — varchar(20)

managements (관리자)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → users.id — NOT NULL
  • area_name (Field) — varchar(40)
  • area_si (Field2) — varchar(40)
  • area_gu (Field3) — varchar(40)
  • area_dong (Field4) — varchar(225)
  • area_addr (Field5) — varchar(225)

measurements (측정정보)

  • num (Key) — int — Primary key — NOT NULL
  • device_id (Key2) — int — Foreign key → register_devices.device_id — NOT NULL
  • ultrafine_dust (Field) — float
  • fine_dust (Field2) — float
  • temperature (Field3) — float
  • humidity (Field4) — float
  • latitude (Field5) — float
  • longitude (Field6) — float
  • co2 (Field7) — int
  • vocs (Field8) — int
  • measurements_time (Field10) — datetime

register_devices (등록기기)

  • device_id (Key) — int — Foreign key → devices.id — NOT NULL
  • user_id (Key2) — int — Foreign key → users.id — NOT NULL
  • certification_date (Field) — datetime
  • place (Field2) — on/off
  • details_name (Field3) — varchar(40)
  • management_id (Key23) — int — Foreign key → managements.id — NOT NULL

users (사용자)

  • id (Key) — int — Primary key — NOT NULL
  • email (Key2) — varchar(80) — Primary key — NOT NULL
  • grade_id (Key3) — int — Foreign key → grades.id — NOT NULL
  • password (Field) — varchar(80)
  • user_name (Field2) — varchar(30)
  • join_date (Field3) — datetime
  • token (Field4) — varchar(80)