genius

테이블 (13)

counsel_people

  • num — int — 기본 키 — NOT NULL
  • idx값임 (category) — char(20)
  • 다 NULL임 (states) — char(20)
  • vb || ppeum (partner_id) — char(150)
  • 상담사 이름 (counsel_name) — char(150)
  • 상담사 전화번호 (counsel_hp) — char(50)
  • 다 NULL임 (hospital_id) — char(50)
  • 다 NULL임 (event_name) — char(250)
  • 다 NULL임 (hospital_sub_id) — char(50)
  • 상담사 메모 (counsel_memo) — text
  • 아이피 (counsel_ip) — char(20)
  • site_type — char(5)
  • event_num — char(10)
  • admin_memo — text
  • etc1 — text
  • etc2 — char(50)
  • etc3 — text
  • etc4 — text
  • etc5 — text
  • etc6 — text — NOT NULL
  • etc7 — text — NOT NULL
  • etc8 — text — NOT NULL
  • etc9 — text
  • etc10 — int — NOT NULL
  • insertTime — char(30)
  • counsel_age — char(10)
  • counsel_time — char(100)
  • partner_name — char(100)
  • categorys — char(20)
  • insertType — char(10)
  • insertFile — char(30)
  • portal_site — char(30)
  • REFERER_Domin — char(200)
  • deleteyn — int — NOT NULL
  • dateY — char(4)
  • dateM — char(2)
  • dateD — char(2)
  • dateH — char(2)
  • dateMin — char(2)
  • dateDate — char(8)
  • dateTime — char(4)
  • updateTime — char(30)
  • updateid — char(30) — NOT NULL
  • cp_cjs_idx — int
  • cp_cjs_name — varchar(500)
  • cp_cms_idx — int

counsel_people_state_statistic_2021

  • cpss_idx — int — 기본 키 — NOT NULL
  • cpss_regdate — datetime — NOT NULL — 등록일시
  • cpss_AdminNo — int — admin_info 테이블 키값
  • cpss_states_id — int
  • cpss_jubsu_no — int — 접수번호
  • cpss_etc8 — text
  • cpss_etc9 — text
  • cpss_states — varchar(20)
  • cpss_etc5 — text
  • cpss_etc7 — varchar(50)

counsel_people_state_statistic_2022

  • cpss_idx — int — 기본 키 — NOT NULL
  • cpss_regdate — datetime — NOT NULL
  • cpss_AdminNo — int
  • cpss_state — int — NOT NULL
  • cpss_jubsu_no — int
  • cpss_etc8 — text
  • cpss_etc9 — text
  • cpss_states — varchar(20)
  • cpss_etc5 — text
  • cpss_etc7 — varchar(50)

partner

  • num — int — 기본 키 — NOT NULL
  • uid — varchar(20) — NOT NULL
  • name — varchar(50) — NOT NULL
  • nickname — varchar(50)
  • passwd — varchar(20) — NOT NULL
  • passwd_question — varchar(200)
  • passwd_answer — varchar(200)
  • jumin1 — varchar(6) — NOT NULL
  • jumin2 — varchar(7) — NOT NULL
  • zipcode — varchar(10)
  • address — varchar(100)
  • address_ext — varchar(100)
  • email — varchar(200)
  • email_etc — varchar(200)
  • tel — char(35)
  • company — varchar(100)
  • company_position — varchar(100)
  • company_zipcode — varchar(10)
  • company_address — varchar(100)
  • company_address_ext — varchar(100)
  • company_tel — varchar(15)
  • hp — char(35)
  • fax — varchar(15)
  • job — varchar(100)
  • school — varchar(100)
  • grade — int
  • introduce — text
  • sex — char(5)
  • sms — enum('y','n')
  • wedding — enum('y','n')
  • mailing — enum('y','n')
  • mileage — int
  • modifyTime — int
  • loginCount — int
  • loginTime — int
  • insertTime — int
  • birthday — varchar(20)
  • birthday_type — varchar(10)
  • order_Cnt — int
  • recommend_id — varchar(20)
  • skype — char(50)
  • photo — char(50)
  • ages — int
  • etc1 — text
  • etc2 — text

로그인 정보 (admin_info)

  • AdminNo — int — 기본 키 — NOT NULL
  • AdminID — char(20) — NOT NULL
  • AdminPass — char(20) — NOT NULL
  • AdminName — char(20)
  • AdminGrade — int
  • InsertTime — int
  • siteType — char(10)
  • priority — int
  • mobile — varchar(20)
  • groups — varchar(100)
  • available — int

매체 (callcenter_media_setting)

  • cms_idx — int — 기본 키 — NOT NULL
  • cms_name — varchar(50) — NOT NULL
  • cms_seq — int — NOT NULL
  • cms_use_chk — bit(1) — NOT NULL

문자 설정 리스트 (sms)

  • id — int — 기본 키 — NOT NULL
  • title — varchar(100)
  • content — text
  • available — int
  • priority — int

상담내역 (counsel_history)

  • historyNo — int — 기본 키 — NOT NULL
  • AdminNo — int
  • num — int
  • etc8 — text
  • etc9 — text
  • states — varchar(20)
  • updateTime — varchar(30)
  • etc5 — text
  • etc7 — varchar(30)

설정관리 비번 (setting)

  • id — int — 기본 키 — NOT NULL
  • pw — varchar(60)

지점 리스트 (callcenter_jijum_list)

  • cjl_idx — int — 기본 키 — NOT NULL
  • cjl_name — varchar(50) — NOT NULL
  • cjl_use_chk — bit(1) — NOT NULL
  • cjl_auto_distribution_id — varchar(50)
  • cjl_type — varchar(50) — 유입지점, 예약지점
  • cjl_order_by — int
  • cjl_group — tinyint
  • cjl_option — varchar(200) — 옵션(Talkcrm url)

진료 그룹 (callcenter_jinryo_group)

  • cjg_idx — int — 기본 키 — NOT NULL
  • cjg_name — varchar(100)
  • cjg_use_chk — bit(1)
  • cjg_option — varchar(100)
  • cjg_seq — int

진료 서비스 (callcenter_jinryo_service)

  • cjs_idx — int — 기본 키 — NOT NULL
  • cjs_name — varchar(200) — 진료서비스 명칭
  • cjs_use_chk — bit(1) — 사용여부
  • cjs_seq — int — 순서
  • cjs_cjg_idx — int — 진료그룹 참조키

통화구분 (states)

  • id — int — 기본 키 — NOT NULL
  • name — varchar(30)
  • available — int
  • priority — int
  • option — varchar(20) — 옵션(자동문자 발송 번호입력)