ㅁㄴㅇㅁㄴㅇ

테이블 (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