SmartHome DB (졸프이후)
테이블 (5)
DEVICE_STATE (Device State)
- DEVICE_CD (Key) — SEED — 기본 키 — NOT NULL
- DEVICE_NM (State Value) — VARCHAR(255)
- DEVICE_VAL (Field) — TINYINT(1)
DUST_INFO (Untitled2)
- COLLECT_SEQ (Key) — SEED — 기본 키 — NOT NULL
- DUST (Field) — INT
- COLLECT_TIME (Field2) — DATETIME
MODE
- MODE_CD (Mode_Code) — VARCHAR(255) — 기본 키 — NOT NULL
- MODE_NM (mode_name) — VARCHAR(255) — NOT NULL — UNIQUE
- MODE_STATE (Field) — TINYINT
- TIMER (set_timer) — INT
- SUNLIGHT (set_sunlight) — VARCHAR(255)
- DUST (set_dust) — INT(11)
- NUM_PERSON (set_person) — INT(11)
- VALVE (.) — TINYINT
- CLEANER (Field3) — TINYINT
- LIGHT (Field4) — TINYINT
- BLIND (Field5) — TINYINT
- WINDOW (Field6) — TINYINT
MOTION_INFO (Untitled)
- SENSOR_SEQ (Key) — SEED — 기본 키 — NOT NULL
- MOTION_A (Field) — INT
- MOTION_B (Field2) — INT
- A_TIME (Field3) — DATETIME
- B_TIME (Field4) — DATETIME
- Field5 — INT
SUNLIGHT_INFO (Sensor_info)
- SENSOR_SEQ (seq) — SEED — 기본 키 — NOT NULL
- SUNLIGHT (sunlight) — INT
- MEASURE_TIME (Field) — DATETIME