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) — 옵션(자동문자 발송 번호입력)