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