DawonDNS

테이블 (5)

log (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • requestTime (Field)
  • responsTime (Field2)
  • logType (Field3)
  • logMessage (Field4)

power_company (Untitled)

  • powerCompanyNo (Key) — 기본 키 — NOT NULL
  • powerId (Field)
  • clientID (Field2)
  • clientPWD (Field3)
  • baseURL (Field4)
  • lowGroupId (Field5)
  • powerName (Field6)

실시간 상태정보 (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • measuredTime (Field5)
  • volatge (Field6)
  • current (Field7)
  • powerfactor (Field8)
  • momen_power (Field9)
  • cumul_power (Field10)
  • switch_status (Field11)
  • temperature (Field)
  • id (Key2) — 외래 키 → 장치.id — NOT NULL

장치 (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • device_id (Field3)
  • latitude (Field)
  • conn_status (Field4)
  • model_id (Field2)
  • firmware_version (Field5)
  • etc_id (Field6)
  • display_name (Field7)
  • register_count (Field8)
  • register_time (Field9)
  • low_group_id (Field10)
  • group_id (Field11)
  • user_id (Field12)
  • sub_group_id (Field13)
  • power (Field14)
  • longitude (Field15)
  • powerCompanyNo (Key2) — 외래 키 → power_company.powerCompanyNo — NOT NULL

전력 데이터 (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • value (Field)
  • measuredTime (Field2)
  • ymdh (Field4) — enum
  • id (Key2) — 외래 키 → 장치.id — NOT NULL