인어스트리

테이블 (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