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