jwIoT
테이블 (9)
DEVICES (devices)
- PK (ID) — INT — 외래 키 → DEVICES_ORIGIN.PK — NOT NULL
- (DEVICE_NAME) — VARCHAR(100) — NOT NULL
- (DEVICE_NAME_ALIAS) — VARCHAR(100) — NOT NULL
- (INSTALLED_PLACE) — VARCHAR(100) — NOT NULL
- (INSTALLED_PLACE_DESC) — VARCHAR(100) — NOT NULL
- FK (ID_USER) — INT — 외래 키 → USERS.PK — NOT NULL
DEVICES_ORIGIN (devices_origin)
- PK (ID) — INT — 기본 키 — NOT NULL
- (SERIAL_NUM) — VARCHAR(100)
SENSORS (sensors)
- Key (ID) — INT — 기본 키 — NOT NULL
- (NUMBER)
- (SOC) — FLOAT — NOT NULL
- (UPDATE_DATE) — DATETIME
- (ALARM_YN) — INT — NOT NULL
- (LIMIT) — FLOAT — NOT NULL
- (COUNT) — INT — NOT NULL
- (FLAG_COUNT) — INT
- PK (ID_DEVICE) — INT — 외래 키 → DEVICES.PK — NOT NULL
SENSORS_LOG (sensors_log)
- (SERIAL_NUM) — VARCHAR(100)
- (SOC) — FLOAT
- (UPDATE_DATE) — DATETIME
- (EMAIL) — VARCHAR(40)
TOKENS (tokens)
- PK (ID) — INT — 기본 키 — NOT NULL
- (TOKEN) — VARCHAR(300) — NOT NULL
- FK (ID_USER) — INT — 외래 키 → USERS.PK — NOT NULL
USERS (users)
- PK (ID) — INT — 기본 키 — NOT NULL
- (USER_PW) — VARCHAR(300) — NOT NULL
- (USER_NAME) — VARCHAR(40) — NOT NULL
- (MOBILE) — VARCHAR(40) — NOT NULL
- (JOIN_DATE) — DATETIME — NOT NULL
- (EMAIL) — VARCHAR(40) — NOT NULL
sensors_info
- PK (ID) — INT — 기본 키 — NOT NULL
- (EXPLANATION) — VARCHAR(300)
- (EXPRESSION_NAME) — VARCHAR(300)
- (ATTR) — VARCHAR(100)
- (BYTE_LENGTH) — INT
- (FORMAT) — VARCHAR(100)
- (LOW_RANGE) — VARCHAR(100)
- (HIGH_RANGE) — VARCHAR(100)
- (SCALE) — FLOAT
- (DISPLAY_UNIT) — VARCHAR(30)
- (BLUETOOTH) — VARCHAR(100)
관리자 (admin)
- PK (ID) — INT — 기본 키 — NOT NULL
- (ADMINNAME) — VARCHAR(100)
- (PASSWORD) — VARCHAR(100)
- (ENABLE) — BOOL
권한 (authority)
- PK (ID) — INT — 기본 키 — NOT NULL
- (ADMINNAME) — VARCHAR(100)
- (AUTHORITY) — VARCHAR(100)
- PK (ID_ADMIN) — INT — 외래 키 → 관리자.PK — NOT NULL