rgt_대시보드

테이블 (7)

agency (Untitled4)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • member_id (bigint(20)) — bigint(20) — 외래 키 → member.id — NOT NULL
  • name (Field3) — varchar(64) — NOT NULL
  • tel (Field11) — varchar(16)
  • fax (Field12) — varchar(16)
  • addr_fullname_old (Field4) — varchar(128)
  • addr_country (Field5) — varchar(32)
  • addr_postal_code (Field6) — varchar(16)
  • addr_state (Field7) — varchar(32)
  • addr_city (Field8) — varchar(32)
  • addr_street (Field9) — varchar(32)
  • addr_detail (Field10) — varchar(32)
  • create_date (Field) — datetime — NOT NULL
  • mod_date (Field2) — datetime — NOT NULL

member (멤버)

  • id (bigint(20)) — bigint(20) — 기본 키 — NOT NULL
  • account (Field) — varchar(32) — NOT NULL — 로그인id
  • pwd (Field2) — varchar(32) — NOT NULL
  • name (Field14) — varchar(32)
  • tel (Field15) — varchar(16)
  • fax (Field16) — varchar(16)
  • phone (Field17) — varchar(16)
  • create_date (Field4) — datetime — NOT NULL
  • mod_date (Field5) — datetime — NOT NULL

member_role (권한)

  • id (bigint(20)) — bigint(20) — 외래 키 → member.id — NOT NULL
  • id (Key2) — bigint(20) — 외래 키 → role.id — NOT NULL

robot (Untitled2)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • store_id (Key2) — bigint(20) — 외래 키 → store.id — NOT NULL
  • serial_num (Field3) — varchar(32) — NOT NULL
  • product_id (Field9) — varchar(32)
  • product_name (Field10) — varchar(32)
  • product_subname (Field11) — varchar(32)
  • product_inst_version (Field12) — varchar(32)
  • product_hw_version (Field13) — varchar(32)
  • product_fw_version (Field14) — varchar(32)
  • product_sw_version (Field15) — varchar(32)
  • product_appendix_customize (Field4) — varchar(128)
  • product_appendix_memo (Field7) — varchar(128)
  • remote_type (Field6) — varchar(16) — NOT NULL
  • co_developer (Field16) — varchar(64)
  • service_payment_amount (Field20) — int
  • service_type (Field19) — varchar(32)
  • service_memo (Field21) — varchar(128)
  • service_shipped_date (Field17) — datetime
  • service_recent_date (Field18) — datetime
  • remote_id (Field8) — varchar(32)
  • remote_pw (Field5) — varchar(32)
  • create_date (Field) — datetime — NOT NULL
  • mod_date (Field2) — datetime — NOT NULL

robot_log (Untitled3)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • robot_id (Key2) — bigint(20) — 외래 키 → robot.id — NOT NULL
  • work_type (Field3) — int
  • work_index (Field4) — int
  • dest_pos_x (Field5) — float
  • dest_pos_y (Field6) — float
  • start_time (Field7) — datetime
  • start_pos_x (Field8) — float
  • start_pos_y (Field9) — float
  • end_time (Field10) — datetime
  • end_pos_x (Field11) — float
  • end_pos_y (Field12) — float
  • pause_count (Field13) — int
  • elapsed_distance (Field14) — float
  • end_status (Field15) — int
  • create_date (Field) — datetime — NOT NULL
  • mod_date (Field2) — datetime — NOT NULL

role (Untitled)

  • id (bigint(20)) — bigint(20) — 기본 키 — NOT NULL
  • authority (varchar(100)) — enum — NOT NULL — ('관리자', '매장', '대리점')

store (Untitled5)

  • id (Key) — bigint(20) — 기본 키 — NOT NULL
  • agency_id (Key2) — bigint(20) — 외래 키 → agency.id — NOT NULL
  • name (Field3) — varchar(64) — NOT NULL
  • tel (Field11) — varchar(16)
  • fax (Field12) — varchar(16)
  • addr_fullname_old (Field4) — varchar(128)
  • addr_country (Field5) — varchar(32)
  • addr_postal_code (Field6) — varchar(16)
  • addr_state (Field7) — varchar(32)
  • addr_city (Field8) — varchar(32)
  • addr_street (Field9) — varchar(32)
  • addr_detail (Field10) — varchar(32)
  • create_date (Field) — datetime — NOT NULL
  • mod_date (Field2) — datetime — NOT NULL