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