battery
테이블 (7)
DEVICES_ORIGIN
- PK (ID_DEVICE_ORIGIN) — INT — 기본 키 — NOT NULL
- (SERIAL_NUM) — VARCHAR(100)
관리자 (ADMINS)
- PK (ADMIN_ID) — VARCHAR(40) — 기본 키 — NOT NULL
- (ADMIN_PW) — VARCHAR(300)
- (ADMIN_NAME) — VARCHAR(40)
- (MOBILE) — VARCHAR(40)
- (EMAIL) — VARCHAR(100)
- (JOIN_DATE) — DATETIME
센서 (SENSORS)
- Key (ID_SENSOR) — INT — 기본 키 — NOT NULL
- Key (ID_DEVICE) — INT — 외래 키 → 장비.Key — NOT NULL
- PK (ID_DEVICE_ORIGIN) — INT — 외래 키 → 장비.PK — NOT NULL
- UK (SERIAL_NUM) — VARCHAR(100)
- (BATTERY) — FLOAT — NOT NULL
- (LIQUID) — FLOAT — NOT NULL
- (UPDATE_DATE) — DATETIME
- (BATTERY_ALARM_YN) — INT — NOT NULL
- (LIQUID_ALARM_YN) — INT — NOT NULL
- (BATTERY_LIMIT) — FLOAT — NOT NULL
- (LIQUID_LIMIT) — FLOAT — NOT NULL
- (COUNT_LIQUID) — INT
- (COUNT_BATTERY) — INT — NOT NULL
- (FLAG_COUNT_LIQUID) — INT
- (FLAG_COUNT_BATTERY) — INT
- (WISH_DATE) — INT
- FK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
- UK (EMAIL) — VARCHAR(40)
센서로그 (SENSORS_LOG)
- (SERIAL_NUM) — VARCHAR(100)
- (BATTERY) — FLOAT
- (LIQUID) — FLOAT
- (UPDATE_DATE) — DATETIME
- (EMAIL) — VARCHAR(40)
장비 (DEVICES)
- Key (ID_DEVICE) — INT — 기본 키 — NOT NULL
- PK (ID_DEVICE_ORIGIN) — 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
- UK (SERIAL_NUM) — VARCHAR(100) — NOT NULL
- FK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
- UK (EMAIL) — VARCHAR2(40)
푸시알림정보 (TOKENS)
- PK (ID_TOKEN) — INT — 기본 키 — NOT NULL
- (TOKEN) — VARCHAR(300) — NOT NULL
- FK (ID_USER) — INT — 외래 키 → 회원.PK — NOT NULL
- (EMAIL) — VARCHAR(40)
회원 (USERS)
- PK (ID_USER) — 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
- UK (EMAIL) — VARCHAR(40) — NOT NULL