CHAT_V2

테이블 (33)

ars(자동메세지) (ars)

  • no — int(11) — 기본 키 — NOT NULL
  • type — tinyint(4) — NOT NULL — 1: 근무시간 내\r2: 근무시간 외\r3: 점심시간\r4: 종료 안내\r5: 상담지연\r6: 답변 유도\n
  • title — varchar(128) — NOT NULL
  • content — varchar(512) — NOT NULL
  • not_connect_time — int(11)
  • no_reply_time — int(11)
  • end_time — int(11)
  • end_content — varchar(256)

blacklist(블랙리스트) (blacklist)

  • no — int(11) — 기본 키 — NOT NULL
  • consultant_no — int(11) — NOT NULL
  • product_name — varchar(128)
  • reason — varchar(512) — NOT NULL
  • create_time — timestamp — NOT NULL
  • customer_no (no2) — int(11) — 외래 키 → customer(고객).no — NOT NULL

chat(채팅메세지) (chat)

  • no — int(11) — 기본 키 — NOT NULL
  • user_no — int(11) — NOT NULL — 삭제 하자
  • type — tinyint(4) — NOT NULL
  • user_type — tinyint(4) — NOT NULL
  • name — varchar(16)
  • content — varchar(1300) — NOT NULL
  • create_time — timestamp — NOT NULL
  • flag — tinyint(1)
  • room_no (no2) — int(11) — 외래 키 → room (방정보).no — NOT NULL
  • no (no22) — int(11) — 외래 키 → room (방정보).consult_no — NOT NULL

consult (상담정보) (consult)

  • no — int(11) — 기본 키 — NOT NULL
  • status — tinyint(4) — NOT NULL
  • item_detail — varchar(45)
  • consultant_no — int(11) — NOT NULL
  • memo — varchar(128)
  • flag — tinyint(4)
  • create_time — timestamp — NOT NULL
  • distribute_time — datetime
  • start_time — datetime
  • end_time — datetime
  • end_type — tinyint(4)
  • response_time — int(11)
  • eval_rate — int(11)
  • eval_comment — varchar(45)
  • alarm_time — datetime
  • channel — tinyint(4)
  • bot — tinyint(4)
  • customer_no — int(11) — 외래 키 → customer(고객).no — NOT NULL
  • item_no(카테고리번호) (item_no) — int(11) — 외래 키 → consult_category.no — NOT NULL

consult_category

  • no — int(11) — 기본 키 — NOT NULL
  • parent_no — int(11) — NOT NULL
  • ancestor_no — int(11)
  • depth — tinyint(4) — NOT NULL
  • title — varchar(32) — NOT NULL
  • content — varchar(64)
  • order_no — int(11)

consult_dist_group

  • group_no — int(11) — 기본 키 — NOT NULL
  • category_no (no2) — int(11) — 외래 키 → consult_category.no — NOT NULL

consult_distribute(자동분배설정) (consult_distribute)

  • no — int(11) — 기본 키 — NOT NULL
  • user_no (no2) — int(11) — 외래 키 → user(상담원).no — NOT NULL

consult_param(상담파라메터) (consult_param)

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32) — NOT NULL
  • used — tinyint(4)
  • description — varchar(128)

consult_setting(상담설정) (consult_setting)

  • no (no2) — int(11) — 외래 키 → service(회사).no — NOT NULL
  • consult_greeting — varchar(256)
  • consult_image_url — varchar(128)
  • consult_title — varchar(64)
  • direct — tinyint(1)
  • direct_type — tinyint(4)
  • ivr — tinyint(1)
  • ivr_script — int(11)
  • ivr_greeting — varchar(256)
  • ivr_image_url — varchar(128)
  • btn_info — varchar(1024)

customer(고객) (customer)

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32)
  • phone — varchar(32)
  • phone2 — varchar(32)
  • email — varchar(64)
  • category_no — int(11)
  • memo — varchar(128)
  • create_time — timestamp — NOT NULL
  • sock_id — varchar(256)
  • user_key — varchar(256)

group_list

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32) — NOT NULL

group_user

  • group_no — int(11) — 외래 키 → group_list.no — NOT NULL
  • user_no — int(11) — 외래 키 → user(상담원).no — NOT NULL

ivr(자동응대시나리오) (ivr)

  • no — int(11) — 기본 키 — NOT NULL
  • title — varchar(128) — NOT NULL
  • content — varchar(1024) — NOT NULL
  • status — tinyint(4) — NOT NULL
  • create_time — datetime — NOT NULL
  • update_time — datetime — NOT NULL
  • endcontent — varchar(1024)
  • filename — varchar(255)

ivr_question(질문) (ivr_question)

  • no — int(11) — 기본 키 — NOT NULL
  • list_order — int(11) — NOT NULL
  • category_no — int(11) — NOT NULL
  • content — varchar(1100) — NOT NULL
  • type — tinyint(4) — NOT NULL
  • image_url — varchar(128)
  • button_url — varchar(128)
  • button_name — varchar(32)
  • con_agent — tinyint(1)
  • con_prev — tinyint(1)
  • con_first — tinyint(1)
  • con_end — tinyint(4)
  • header — varchar(20)
  • filename — varchar(255)
  • ivr_no — int(11) — 외래 키 → ivr(자동응대시나리오).no — NOT NULL

ivr_question_choice(답변) (ivr_question_choice)

  • no — int(11) — 기본 키 — NOT NULL
  • list_order — int(11) — NOT NULL
  • content — varchar(128) — NOT NULL
  • con_no — int(11)
  • maxcount — int(11)
  • buttonlink — varchar(255)
  • question_no — int(11) — 외래 키 → ivr_question(질문).no — NOT NULL

keyword

  • no — int(11) — 기본 키 — NOT NULL
  • user_no — int(11)
  • type — tinyint(4) — NOT NULL
  • question — varchar(255) — NOT NULL
  • answer — mediumtext — NOT NULL
  • use_count — int(11)
  • list_order — int(11)
  • confirm — tinyint(4)
  • create_time — timestamp
  • show_top — tinyint(4) — NOT NULL
  • sub_info — varchar(1024)
  • gubun — tinyint(4)
  • keyword_category값 (category_no) — int(11) — 외래 키 → keyword_category.no — NOT NULL

keyword_category

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32) — NOT NULL

keyword_list

  • content — varchar(16) — NOT NULL
  • no — int(11) — 외래 키 → keyword.no — NOT NULL

logging(로그) (logging)

  • no — int(11) — 기본 키 — NOT NULL
  • user_no — int(11) — NOT NULL
  • type — int(11) — NOT NULL
  • info — varchar(256) — NOT NULL
  • create_time — datetime

notice(공지사항) (notice)

  • no — int(11) — 기본 키 — NOT NULL
  • type — tinyint(4) — NOT NULL
  • create_time — timestamp — NOT NULL
  • title — varchar(128)
  • content — varchar(1024) — NOT NULL
  • user_no — int(11) — 외래 키 → user(상담원).no — NOT NULL

partner

  • no — int(11) — 기본 키 — NOT NULL
  • company — varchar(64) — NOT NULL
  • department — varchar(64) — NOT NULL
  • manager — varchar(16) — NOT NULL
  • phone1 — varchar(16) — NOT NULL
  • phone2 — varchar(16)
  • etc — varchar(64)
  • create_time — datetime

permission(권한) (permission)

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32)
  • admin — tinyint(4)
  • admin_home — tinyint(4)
  • admin_setting — tinyint(4)
  • admin_schedule — tinyint(4)
  • admin_holiday — tinyint(4)
  • admin_ars — tinyint(4)
  • admin_ivr — tinyint(4)
  • admin_consult_category — tinyint(4)
  • admin_consult_distribute — tinyint(4)
  • admin_consult_distribute_off — tinyint(4)
  • admin_support_parameter — tinyint(4)
  • admin_support_keyword — tinyint(4)
  • admin_support_develop — tinyint(4)
  • admin_support_service — tinyint(4)
  • admin_consult_setting — tinyint(4)
  • admin_partner — tinyint(4)
  • admin_blacklist — tinyint(4)
  • admin_slang — tinyint(4)
  • admin_account_group — tinyint(4)
  • admin_account_manage — tinyint(4)
  • admin_account_permission — tinyint(4)
  • admin_account_security — tinyint(4)
  • admin_notice — tinyint(4)
  • admin_help — tinyint(4)
  • admin_faq — tinyint(4)
  • manager — tinyint(4)
  • manager_home — tinyint(4)
  • manager_consultant_info — tinyint(4)
  • manager_customer_info — tinyint(4)
  • manager_status_proceeding — tinyint(4)
  • manager_status_waiting — tinyint(4)
  • manager_status_complete — tinyint(4)
  • manager_status_req_change — tinyint(4)
  • manager_status_req_review — tinyint(4)
  • manager_stat_month — tinyint(4)
  • manager_stat_day — tinyint(4)
  • manager_stat_report — tinyint(4)
  • manager_stat_consult — tinyint(4)
  • manager_notice — tinyint(4)
  • manager_help — tinyint(4)
  • manager_faq — tinyint(4)
  • consult — tinyint(4)

room (방정보) (room)

  • no — int(11) — 기본 키 — NOT NULL
  • consult_no — int(11) — 외래 키 → consult (상담정보).no — NOT NULL
  • type — tinyint(4) — 1: 일반\n2: 팀\n3: 협력업체 ?\n
  • manager_no — int(11) — NOT NULL
  • title — varchar(128)
  • params — varchar(1024)
  • last_update — datetime
  • last_user — tinyint(4)
  • last_chat_no — int(11)
  • channel — varchar(45)
  • user_key — varchar(45)
  • pf_id — varchar(45)

room_member

  • member_no — int(11) — 기본 키 — NOT NULL
  • room_no — int(11) — 외래 키 → room (방정보).no — NOT NULL

room_partner

  • partner_no — int(11) — 외래 키 → partner.no — NOT NULL
  • room_no — int(11) — 외래 키 → room (방정보).no — NOT NULL
  • no (no2) — int(11) — 외래 키 → room (방정보).consult_no — NOT NULL

service(회사) (service)

  • no — int(11) — 기본 키 — NOT NULL
  • name — varchar(32) — NOT NULL
  • account_count — int(11)
  • account_max — int(11) — NOT NULL

service_setting(서비스설정) (service_setting)

  • service_no — int(11) — 외래 키 → service(회사).no — NOT NULL
  • auto_change — tinyint(1) — NOT NULL
  • alarm_default_time — int(11) — NOT NULL
  • consult_status — tinyint(1) — NOT NULL
  • consult_excess_count — int(11) — NOT NULL
  • consult_excess_email — varchar(64) — NOT NULL
  • consult_evaluate — tinyint(1) — NOT NULL
  • consult_evaluate_comment — varchar(512) — NOT NULL
  • auth_otp — tinyint(1) — NOT NULL
  • auth_sms — tinyint(1) — NOT NULL
  • consult_offtime — tinyint(1)
  • pf_id — mediumtext

slang(욕설) (slang)

  • no — int(11) — 기본 키 — NOT NULL
  • content — varchar(32) — NOT NULL

stat_1h ( 1시간단위통계) (stat_1h)

  • time — datetime — 기본 키 — NOT NULL
  • cat_no — int(11) — 기본 키 — NOT NULL
  • incoming_count — int(11)
  • start_count — int(11) — NOT NULL
  • end_count — int(11) — NOT NULL
  • avg_time — int(11) — NOT NULL
  • eval_count — int(11) — NOT NULL
  • avg_star — int(11) — NOT NULL
  • end_consultant — int(11) — NOT NULL
  • end_customer — int(11) — NOT NULL
  • user_no — int(11) — 외래 키 → user(상담원).no — NOT NULL

user(상담원) (user)

  • no — int(11) — 기본 키 — NOT NULL
  • id — varchar(64) — NOT NULL
  • password — varchar(128) — NOT NULL
  • name — varchar(32) — NOT NULL
  • phone — varchar(32) — NOT NULL
  • email — varchar(64) — NOT NULL
  • group_no — int(11)
  • consult_enable — tinyint(1)
  • status — int(11)
  • avatar_type — tinyint(4) — NOT NULL
  • alarm_type — tinyint(4)
  • alarm_popup_type — tinyint(4)
  • create_time — timestamp — NOT NULL
  • excess_email_date — date
  • start_time — time
  • end_time — time
  • zendesk_id — varchar(45)
  • zendesk_role — varchar(45)
  • permission_no (no2) — int(11) — 외래 키 → permission(권한).no — NOT NULL

user_holiday(휴일) (user_holiday)

  • no — int(11) — 기본 키 — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • used — tinyint(1) — NOT NULL
  • comment — varchar(128)
  • comment_no — int(11) — NOT NULL
  • user_no (no2) — int(11) — 외래 키 → user(상담원).no — NOT NULL

user_rest(휴식) (user_rest)

  • no — int(11) — 기본 키 — NOT NULL
  • user_no — int(11) — NOT NULL
  • start_time — datetime — NOT NULL
  • end_time — datetime — NOT NULL
  • reason — varchar(64) — NOT NULL
  • user_no (no2) — int(11) — 외래 키 → user(상담원).no — NOT NULL

user_schedule(스케줄) (user_schedule)

  • no — int(11) — 기본 키 — NOT NULL
  • date — date — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL
  • launch_start_time — time — NOT NULL
  • launch_end_time — time — NOT NULL
  • launch_comment_no — int(11) — NOT NULL
  • off_comment_no — int(11) — NOT NULL
  • user_no (no2) — int(11) — 외래 키 → user(상담원).no — NOT NULL