木漏れ日
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)