ㅁㄴㅇㅁㄴㅇ
테이블 (4)
(고객정보) (attender_info)
- 시퀀스 (seq) — serial
- emid — character varying(30)
- 고객명 (name) — character varying(30)
- 휴대폰 (mobile_num) — character varying(30)
- 생년월일 (birthday) — character varying(30)
- 성별 (gender) — character varying(1)
- 유입일 (created_at) — character varying(30)
- 분배여부 (bunbae_yn) — character varying(30)
- 분배상담원 (bunbae_agent) — character varying(30)
- 분배상담원ID (bunbae_id) — character varying(30)
- 분배일 (bunbae_day) — character varying(30)
- 전화번호1 (tel1) — character varying(30)
- 전화번호2 (tel2) — character varying(30)
- memo — text
- 통화결과 (sd_result) — character varying(30)
- 가입일 (join_day) — character varying(30)
상담정보 (sangdam)
- idx — serial
- 콜순서 (call_no) — character varying(30)
- 고객명 (cust_name) — character varying(30)
- 전화번호 (sd_cid) — character varying(30)
- 상담일자 (sd_date) — character varying(30)
- 통화시간 (sd_calltime) — character varying(10)
- 통화시작시간 (sd_stime) — character varying(30)
- 통화종료시간 (sd_etime) — character varying(30)
- 상담내용 (cd_context) — text
- 통화결과 (sd_result1) — character varying(30)
- 상세통화결과 (sd_result_dt) — character varying(30)
- 상담원id (agt_id) — character varying(30)
- 상담원 (agt_name) — character varying(30)
- 입력날짜 (input_day) — character varying(30)
예약 (reservation)
- 시퀀스 (seq) — serial
- 고객번호 (cust_cd) — character varying(30)
- 고객명 (cust_name) — character varying(30)
- 예약시간 (reservation_time) — character varying(30)
- 분배상담원 (bunbae_agent) — character varying(30)
- 분배상담원 ID (bunbae_id) — character varying(30)
- 전화번호 (mobile_num) — character varying(30)
- 전화번호1 (tel1) — character varying(30)
- 전화번호2 (tel2) — character varying(30)
통화결과 (code)
- idx — serial
- 통화결과 (cd_gbn) — character varying(30)
- 상세결과 (cd_nm1) — character varying(30)
- 상세결과(예비) (cd_nm2) — character varying(30)
- 상세결과(예비) (cd_nm3) — character varying(30)
- 상세결과(예비) (cd_nm4) — character varying(30)
- 결과순서 (cd_ord) — integer