인어스트리
테이블 (4)
report
- report_id — BIGINT
- status — INT — NOT NULL — 0:시작되지 않음, 1:청소 중, 2:일시 중지, 3:작업 중단, 4:작업 종료, 5:비정상, 6:취소
- start_time — DATETIME
- end_time — DATETIME
- clean_time — FLOAT — h
- task_area — FLOAT — ㎡
- clean_area — FLOAT — ㎡
- mode — INT — 1:스크러빙, 2:스위핑
- cost_battery — BIGINT — % (전기사용량/100)*1.3=전력사용량(kwh)
- cost_water — BIGINT — ml
- robot_id — BIGINT — NOT NULL
robot
- robot_id — BIGINT
- model — ENUM('CC1','MT1') — NOT NULL
- sn — VARCHAR(20) — NOT NULL
- mac — CHAR(17) — NOT NULL
- nickname — VARCHAR(255)
- store_id — BIGINT — NOT NULL
store
- store_id — BIGINT
- store_name — VARCHAR(20) — NOT NULL
- industry — ENUM('헬스케어','교육','창고 및 물류','산업','소매') — NOT NULL
- address — VARCHAR(30) — NOT NULL
users
- user_id — BIGINT
- id — VARCHAR(20) — NOT NULL
- pw — VARCHAR(50) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- address — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- role — INT — NOT NULL — 0:관리자, 1:매장 담당자, 2:매장 직원
- store_id — BIGINT — NOT NULL