smartIoT
테이블 (6)
DEVICE (Device)
- DEVICE_CD (Device_Code) — VARCHAR(255) — 기본 키 — NOT NULL
- DEVICE_NM (Device_Name) — VARCHAR(255)
DEVICE_STATE (Device State)
- STATE_CD (State_Code) — VARCHAR(255) — 기본 키 — NOT NULL
- DEVICE_CD (Device_Code) — VARCHAR(255) — 외래 키 → DEVICE.DEVICE_CD — NOT NULL
- SEQ (seq) — SEED — 외래 키 → SUNLIGHT_SENSOR_INFO.SUNLGIHT_SEQ — NOT NULL
- STATE_ NM (State Name) — VARCHAR(255)
- STATE_VALUE (State Value) — VARCHAR(255)
MODE
- MODE_CD (Mode_Code) — VARCHAR(255) — 기본 키 — NOT NULL
- MODE_STATE_CD — VARCHAR(255) — 기본 키 — NOT NULL
- DEVICE_CD (Device_Code) — VARCHAR(255) — 외래 키 → DEVICE.DEVICE_CD — NOT NULL
- MODE_NM (mode_name) — VARCHAR(255)
- TIMER (set_timer) — VARCHAR(255)
- SUNLIGHT (set_sunlight) — VARCHAR(255)
- DUST (set_dust) — INT(11)
- NUM_PERSON (set_person) — INT(11)
- MODE_STATE_NM (Mode_State_Name) — VARCHAR(255)
SUNLIGHT_SENSOR_INFO (Sensor_info)
- SUNLGIHT_SEQ (seq) — SEED — 기본 키 — NOT NULL
- SUNLIGHT (sunlight) — INT(11)
- MOTION_1 (motion1) — INT(11)
- MOTION_2 (motion2) — INT(11)
- DUST (Dust) — INT(11)
상태2 (Situation2)
- S_Code (Static Code) — VARCHAR(255) — 기본 키 — NOT NULL
- C_Time (Current Time) — INT(11)
장치1 (Device1)
- TYPE (Type) — VARCHAR(255) — 기본 키 — NOT NULL
- S_Code (Static Code) — VARCHAR(255) — 외래 키 → 상태2.S_Code — NOT NULL
- STATE_Name (STATE Name) — VARCHAR(255)
- S_Value (Static Value) — VARCHAR(255)