statistics-before

Tables (6)

tb_notification_msg_record

  • message_id — VARCHAR(20) — Primary key — NOT NULL — 메세지id' COLLATE 'utf8mb4_general_ci
  • solution_type — VARCHAR(10) — 솔루션타입' COLLATE 'utf8mb4_general_ci
  • user_type — VARCHAR(10) — 사용자타입' COLLATE 'utf8mb4_general_ci
  • fk_company — BIGINT(20)
  • fk_company_staff_ai — BIGINT(20)
  • create_date — DATETIME(6)
  • updated_date — DATETIME(6)
  • id — VARCHAR(255)
  • num_from — VARCHAR(64) — 발신번호' COLLATE 'utf8mb4_general_ci
  • num_to — VARCHAR(64) — 수신번호' COLLATE 'utf8mb4_general_ci
  • message_type — VARCHAR(64)
  • message_err — VARCHAR(255)
  • noti_status — VARCHAR(255)
  • reserved_time — VARCHAR(255)
  • sms_kind — VARCHAR(255)
  • tkt_seq — INT(11)
  • message — TEXT
  • req_msg_time — DATETIME(6)
  • fee — CHAR(25)
  • fk_writer — BIGINT(20)
  • fd_regdate — DATETIME
  • fk_modifier — BIGINT(20)
  • fd_moddate — DATETIME
  • INDEX — `idx_notification_msg_record_solution_type`
  • INDEX — `idx_notification_msg_record_user_type`
  • INDEX — `idx_notification_msg_record_id`
  • INDEX — `idx_notification_msg_record_noti_status`
  • INDEX — `idx_notification_msg_record_sms_kind`
  • INDEX — `idx_notification_msg_record_tkt_seq`
  • INDEX — `idx_notification_msg_record_create_date`
  • INDEX — `idx_notification_msg_record_fk_company`
  • INDEX — `idx_notification_msg_record_message_type`
  • INDEX — `idx_notification_msg_record_fk_company_staff_ai`

tbl_issue_contact

  • pk_issue_contact — VARCHAR(64) — Primary key — NOT NULL — 컨텍 pk' COLLATE 'utf8mb4_general_ci
  • fk_issue_contact_parent — VARCHAR(64) — 부모 call_id' COLLATE 'utf8mb4_general_ci
  • room_id — VARCHAR(64)
  • tb_broker_id — VARCHAR(256)
  • bound_io — VARCHAR(10)
  • solution_type — VARCHAR(10) — 솔루션타입' COLLATE 'utf8mb4_general_ci
  • user_type — VARCHAR(10) — 사용자타입' COLLATE 'utf8mb4_general_ci
  • vgw_id — VARCHAR(20) — voice-gw id' COLLATE 'utf8mb4_general_ci
  • dnis — VARCHAR(64) — ai직원별 착신번호' COLLATE 'utf8mb4_general_ci
  • fk_issue_ticket — BIGINT(20) — 티켓 fk
  • fk_company — BIGINT(20) — 회사 fk
  • fk_company_staff — BIGINT(20) — staff pk
  • fk_company_dept — BIGINT(20) — 부서pk
  • fk_company_staff_ai — BIGINT(20) — ai staff pk
  • fd_contact_status_code — VARCHAR(64) — 컨텍 상태 코드' COLLATE 'utf8mb4_general_ci
  • fd_contact_channel_code — VARCHAR(64) — 컨텍 채널 코드' COLLATE 'utf8mb4_general_ci
  • caller_type — VARCHAR(64) — 스태프,고객 구분' COLLATE 'utf8mb4_general_ci
  • fk_caller — BIGINT(20)
  • fd_customer_uid — VARCHAR(64) — 고객 인식 uid' COLLATE 'utf8mb4_general_ci
  • caller_name — VARCHAR(64)
  • fd_ai_call_type — VARCHAR(64) — AI 콜 타입' COLLATE 'utf8mb4_general_ci
  • fd_role_type — VARCHAR(64) — role_type' COLLATE 'utf8mb4_general_ci
  • call_dt_req — DATETIME
  • call_dt_from — DATETIME
  • call_dt_to — DATETIME
  • dur_sec — INT(11)
  • path_rec_file — VARCHAR(255)
  • path_rec_aws — VARCHAR(255)
  • reaction_type_last — VARCHAR(64) — 톡봇 대화 종료전 액션' COLLATE 'utf8mb4_general_ci
  • transfer_dest — VARCHAR(64) — 호전환 대상' COLLATE 'utf8mb4_general_ci
  • transfer_staff — VARCHAR(64) — 호전환 직원 pk' COLLATE 'utf8mb4_general_ci
  • transfer_dt_req — DATETIME — 호전환 요청일시
  • transfer_answer — VARCHAR(24) — 호전환 응답' COLLATE 'utf8mb4_general_ci
  • transfer_dt_from — DATETIME — 호전환 시작일시
  • fk_writer — BIGINT(20) — 직원등록자 fk
  • fd_regdate — TIMESTAMP — 직원등록일시
  • fk_modifier — BIGINT(20) — 직원수정자 fk
  • fd_moddate — TIMESTAMP — 직원수정일시
  • INDEX — `tbl_issue_contact_fk_issue_ticket_index`
  • INDEX — `idx_issue_contact_solution_type`
  • INDEX — `idx_issue_contact_user_type`
  • INDEX — `idx_issue_contact_fk_company`
  • INDEX — `idx_issue_contact_fk_company_staff`
  • INDEX — `idx_issue_contact_fk_company_dept`
  • INDEX — `idx_issue_contact_fk_issue_contact_parent`
  • INDEX — `idx_issue_contact_contact_status_code`
  • INDEX — `idx_issue_contact_contact_channel_code`
  • INDEX — `idx_issue_contact_customer_uid`
  • INDEX — `idx_issue_contact_fk_company_staff_ai`
  • INDEX — `idx_issue_contact_tb_broker_id`
  • INDEX — `idx_issue_contact_call_dt_to`
  • INDEX — `idx_issue_contact_call_dt_from`
  • INDEX — `idx_issue_contact_room_id`
  • INDEX — `idx_issue_contact_reaction_type_last`
  • INDEX — `idx_issue_contact_transfer_staff`
  • INDEX — `idx_issue_contact_call_dt_req`

tbl_issue_dialogue

  • pk_issue_dialogue — BIGINT(20) — Primary key — NOT NULL — 컨텍 fk' COLLATE 'utf8mb4_general_ci
  • fk_issue_contact — VARCHAR(64) — 부모 call_id' COLLATE 'utf8mb4_general_ci
  • fk_issue_contact_parent — VARCHAR(64) — 고객 인식 uid' COLLATE 'utf8mb4_general_ci
  • dnis — VARCHAR(64)
  • fd_customer_uid — VARCHAR(256) — 직원 fk
  • fk_company_customer — BIGINT(20)
  • fk_company_staff — BIGINT(20) — 콜 브로커 id' COLLATE 'utf8mb4_general_ci
  • fk_company_staff_ai — BIGINT(20)
  • fd_call_broker_id — VARCHAR(256) — 대화 상태 코드' COLLATE 'utf8mb4_general_ci
  • fd_dialogue_status_code — VARCHAR(64) — 대화 내용' COLLATE 'utf8mb4_general_ci
  • fd_dialogue_message_code — VARCHAR(64)
  • fd_message — VARCHAR(4096) — talkbot reaction type' COLLATE 'utf8mb4_general_ci
  • fd_reaction_type — VARCHAR(64) — talkbot control code' COLLATE 'utf8mb4_general_ci
  • fd_ctrl_code — VARCHAR(64) — 읽음 여부YN' COLLATE 'utf8mb4_general_ci
  • job_type — VARCHAR(64)
  • form_data — VARCHAR(2000)
  • fd_read_yn — CHAR(1) — 등록일시
  • fk_writer — BIGINT(20)
  • fd_regdate — TIMESTAMP — 티켓 pk
  • fk_modifier — BIGINT(20)
  • fd_moddate — DATETIME
  • INDEX — `tbl_issue_dialogue_fk_issue_contact_fd_read_yn_index`
  • INDEX — `idx_issue_dialogue_broker_id`
  • INDEX — `idx_issue_dialogue_fk_company_staff_ai`

tbl_issue_ticket

  • pk_issue_ticket — BIGINT(20) — Primary key — NOT NULL — 티켓 워크플로우 코드' COLLATE 'utf8mb4_general_ci
  • fk_issue_ticket_p — BIGINT(20) — 티켓 상태 코드' COLLATE 'utf8mb4_general_ci
  • dnis — VARCHAR(64)
  • fk_company — BIGINT(20)
  • fd_ticket_workflow_code — VARCHAR(64) — NOT NULL — 스태프,고객 구분' COLLATE 'utf8mb4_general_ci
  • fd_ticket_status_code — VARCHAR(64) — NOT NULL — 전화번호' COLLATE 'utf8mb4_general_ci
  • caller_type — VARCHAR(64) — 최초 대화 fk
  • customer_ani — VARCHAR(64) — 전화받은ai
  • caller_name — VARCHAR(64)
  • fk_company_customer — BIGINT(20)
  • fd_ticket_title — VARCHAR(256)
  • fk_issue_dialogue_start — BIGINT(20) — 담당직원 fk
  • fk_assign_ai — BIGINT(20) — 티켓 만료일시
  • fk_assign_staff — BIGINT(20) — NOT NULL — 티켓 처리 주체 uid' COLLATE 'utf8mb4_general_ci
  • fd_ticket_limit_date — TIMESTAMP — 직원등록자 fk
  • fd_ticket_owner_uid — VARCHAR(64) — 직원등록일시
  • fk_writer — BIGINT(20) — 직원수정자 fk
  • fd_regdate — TIMESTAMP — 직원수정일시
  • fk_modifier — BIGINT(20) — 티켓종료일시
  • fd_moddate — TIMESTAMP — 중요도' COLLATE 'utf8mb4_general_ci
  • fd_ticket_createdate — TIMESTAMP
  • dt_close — DATETIME
  • INDEX — `tbl_issue_ticket_fd_ticket_workflow_code_index`
  • INDEX — `idx_issue_ticket_fd_ticket_status_code`
  • INDEX — `idx_issue_ticket_fk_company`
  • INDEX — `idx_issue_ticket_assign_staff`
  • INDEX — `idx_issue_ticket_fk_priority`
  • INDEX — `idx_issue_ticket_ticket_createdate`
  • INDEX — `idx_issue_ticket_fk_assign_ai`
  • INDEX — `idx_issue_ticket_dt_close`

tbl_issue_{contact|ticket}_statistics

  • fk_company — BIGINT(20) — Primary key — NOT NULL — 회사fk
  • fk_member — BIGINT(20) — Primary key — NOT NULL — 직원fk
  • yyyy_mm_dd — DATE — Primary key — NOT NULL — 년월일
  • svc_type — VARCHAR(32) — Primary key — NOT NULL — 서비스유형
  • ctgr_01 — VARCHAR(32) — Primary key — NOT NULL — 카테고리01
  • ctgr_02 — VARCHAR(32) — Primary key — NOT NULL — 카테고리02
  • ctgr_03 — VARCHAR(32) — Primary key — NOT NULL — 카테고리03
  • ctgr_04 — VARCHAR(32) — Primary key — NOT NULL — 카테고리04
  • ctgr_05 — VARCHAR(32) — Primary key — NOT NULL — 카테고리05
  • ctgr_06 — VARCHAR(32) — Primary key — NOT NULL — 카테고리06
  • yyyy — SMALLINT(6) — 년
  • mm — TINYINT(4) — 월
  • dd — TINYINT(4) — 일
  • week — TINYINT(4) — 주
  • fd_company_name — VARCHAR(64) — 회사명
  • fd_member_name — VARCHAR(64) — 직원 이름
  • ai_work_code — VARCHAR(64) — ai 직무 코드
  • ai_work_name — VARCHAR(512) — ai 직무명
  • cntHH00 — BIGINT(20) — 카운트0시~1시
  • cntHH01 — BIGINT(20) — 카운트1시~2시
  • cntHH02 — BIGINT(20) — 카운트2시~3시
  • cntHH03 — BIGINT(20) — 카운트3시~4시
  • cntHH04 — BIGINT(20) — 카운트4시~5시
  • cntHH05 — BIGINT(20) — 카운트5시~6시
  • cntHH06 — BIGINT(20) — 카운트6시~7시
  • cntHH07 — BIGINT(20) — 카운트7시~8시
  • cntHH08 — BIGINT(20) — 카운트8시~9시
  • cntHH09 — BIGINT(20) — 카운트9시~10시
  • cntHH10 — BIGINT(20) — 카운트10시~11시
  • cntHH11 — BIGINT(20) — 카운트11시~12시
  • cntHH12 — BIGINT(20) — 카운트12시~13시
  • cntHH13 — BIGINT(20) — 카운트13시~14시
  • cntHH14 — BIGINT(20) — 카운트14시~15시
  • cntHH15 — BIGINT(20) — 카운트15시~16시
  • cntHH16 — BIGINT(20) — 카운트16시~17시
  • cntHH17 — BIGINT(20) — 카운트17시~18시
  • cntHH18 — BIGINT(20) — 카운트18시~19시
  • cntHH19 — BIGINT(20) — 카운트19시~20시
  • cntHH20 — BIGINT(20) — 카운트20시~21시
  • cntHH21 — BIGINT(20) — 카운트21시~22시
  • cntHH22 — BIGINT(20) — 카운트22시~23시
  • cntHH23 — BIGINT(20) — 카운트23시~24시
  • cntHHTot — BIGINT(20) — 카운트 총합 0시~24시
  • durHH00 — BIGINT(20) — 소요시간0시~1시
  • durHH01 — BIGINT(20) — 소요시간1시~2시
  • durHH02 — BIGINT(20) — 소요시간2시~3시
  • durHH03 — BIGINT(20) — 소요시간3시~4시
  • durHH04 — BIGINT(20) — 소요시간4시~5시
  • durHH05 — BIGINT(20) — 소요시간5시~6시
  • durHH06 — BIGINT(20) — 소요시간6시~7시
  • durHH07 — BIGINT(20) — 소요시간7시~8시
  • durHH08 — BIGINT(20) — 소요시간8시~9시
  • durHH09 — BIGINT(20) — 소요시간9시~10시
  • durHH10 — BIGINT(20) — 소요시간10시~11시
  • durHH11 — BIGINT(20) — 소요시간11시~12시
  • durHH12 — BIGINT(20) — 소요시간12시~13시
  • durHH13 — BIGINT(20) — 소요시간13시~14시
  • durHH14 — BIGINT(20) — 소요시간14시~15시
  • durHH15 — BIGINT(20) — 소요시간15시~16시
  • durHH16 — BIGINT(20) — 소요시간16시~17시
  • … +19

tbl_sum_cnt_channel

  • fk_company — BIGINT(20) — Primary key — NOT NULL
  • fk_member — BIGINT(20) — Primary key — NOT NULL
  • sum_ymd — DATE — Primary key — NOT NULL
  • svc_type — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_01 — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_02 — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_03 — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_04 — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_05 — VARCHAR(32) — Primary key — NOT NULL
  • ctgr_06 — VARCHAR(32) — Primary key — NOT NULL
  • sum_yy — SMALLINT(6)
  • sum_mm — TINYINT(4)
  • sum_dd — TINYINT(4)
  • sum_ww — TINYINT(4)
  • val00 — BIGINT(20)
  • val01 — BIGINT(20)
  • val02 — BIGINT(20)
  • val03 — BIGINT(20)
  • val04 — BIGINT(20)
  • val05 — BIGINT(20)
  • val06 — BIGINT(20)
  • val07 — BIGINT(20)
  • val08 — BIGINT(20)
  • val09 — BIGINT(20)
  • val10 — BIGINT(20)
  • val11 — BIGINT(20)
  • val12 — BIGINT(20)
  • val13 — BIGINT(20)
  • val14 — BIGINT(20)
  • val15 — BIGINT(20)
  • val16 — BIGINT(20)
  • val17 — BIGINT(20)
  • val18 — BIGINT(20)
  • val19 — BIGINT(20)
  • val20 — BIGINT(20)
  • val21 — BIGINT(20)
  • val22 — BIGINT(20)
  • val23 — BIGINT(20)
  • fk_writer — BIGINT(20)
  • fd_regdate — DATETIME
  • fk_modifier — BIGINT(20)
  • fd_moddate — DATETIME
  • INDEX — `idx_sum_cnt_channel_sum_yy`
  • INDEX — `idx_sum_cnt_channel_sum_mm`
  • INDEX — `idx_sum_cnt_channel_sum_dd`
  • INDEX — `idx_sum_cnt_channel_sum_ww`