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`