Hello

Tables (12)

com_booking (예약정보)

  • no — int(100) — Primary key — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL
  • counsel_no (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • reg_date — datetime
  • hope_date — varchar(100)
  • i_name — varchar(100)
  • memo — text
  • state — varchar(50)
  • hope1_date — varchar(100)
  • hope1_time — varchar(50)
  • comments — text
  • card — int(11)
  • cash — int(11)
  • account — int(11) — 계좌입금
  • receipt — varchar(1) — 현금영수증
  • pay_memo — text
  • call_flag — char(1)
  • branch — varchar(5)
  • member — text
  • call_date — varchar(20)
  • comp — varchar(100)
  • dept — varchar(100)
  • random_no — varchar(30)
  • get_time — varchar(30)
  • in_type — varchar(20)
  • counselor_note — text
  • counselee_note — text
  • naver_type — varchar(50)
  • naver_no — int(11)
  • admin_id — int(11)
  • multi_code — int(11)

com_guest (내담자 정보)

  • no (일련번호) — int(11) — Primary key — NOT NULL
  • hpnum (연락처(통합)) — varchar(20) — 전화1' PRIMARY KEY (`no`

com_guest_adult (성인 사전 면접지)

  • no (일련번호) — int(11) — Primary key — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL

com_guest_child (아동 사전 면접지)

  • no (일련번호) — int(11) — Primary key — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL

com_guest_test (심리검사 결과)

  • no (일련번호) — int(100) — Primary key — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL

com_member (상담사)

  • no — int(11) — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • user_id — varchar(50) — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(100) — NOT NULL
  • isadmin — varchar(50) — NOT NULL
  • level — int(11) — NOT NULL
  • date — datetime — NOT NULL
  • ipadd — varchar(100)
  • lasttime — datetime
  • memo — text
  • branch — varchar(10)
  • flag — varchar(1) — NOT NULL
  • tel — varchar(15)
  • photo — varchar(100) — 기본급
  • role — varchar(100)
  • m_id — varchar(100)
  • profile — text — 프로필
  • online — varchar(5)
  • base_amt — int(11)
  • idx — int(11)
  • can_test — char(1)

com_pay (월별 급여)

  • no — int(11) — Primary key — NOT NULL
  • doc (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • branch — varchar(10) — NOT NULL
  • pay_ym — varchar(10) — NOT NULL
  • base_amt — int(11) — NOT NULL
  • case_amt — int(11) — NOT NULL
  • etc1_amt — int(11) — NOT NULL
  • etc1_note — text
  • etc2_amt — int(11) — NOT NULL
  • etc2_note — text
  • total_amt — int(11) — NOT NULL
  • flag — char(1) — NOT NULL
  • flag_date — datetime
  • pay_pyo — varchar(100) — 급여명세표(정직원)

com_pay_etc (기타수당 정보)

  • no (Key) — Primary key — NOT NULL
  • doc (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • branch — varchar(10) — NOT NULL
  • pay_ym — varchar(10) — NOT NULL
  • etc1_amt — int(11) — NOT NULL
  • etc1_note — text
  • etc2_amt — int(11) — NOT NULL
  • etc2_note — text
  • note — text

com_pay_list (상담별 수당)

  • no — int(11) — Primary key — NOT NULL
  • doc (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL
  • branch — varchar(10) — NOT NULL
  • pay_ym — varchar(10) — NOT NULL
  • state — varchar(110) — NOT NULL
  • case_amt — int(11) — NOT NULL
  • note — text

com_pay_set (기초수당)

  • no — int(11) — Primary key — NOT NULL
  • doc (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • state — varchar(50) — NOT NULL
  • pay_amt — int(11) — 기본급
  • etc_amt — varchar(5)

com_reserv (상담 예약신청 정보)

  • no — int(100) — Primary key — NOT NULL
  • guest_no (내담자 일련번호) — int(11) — Foreign key → com_guest.no — NOT NULL
  • reg_date — datetime
  • hope_date — varchar(100)
  • memo — text
  • state — varchar(50)
  • hope1_date — varchar(100)
  • hope1_time — varchar(50)
  • admin — varchar(100)
  • comments — text
  • branch — varchar(10)
  • comp — varchar(50)
  • dept — varchar(100)
  • ipadd — varchar(100)

com_schedules (상담사 상담 가능 스케줄)

  • id — int(11) — Primary key — NOT NULL
  • doc_id (상담사 일련번호) — int(11) — Foreign key → com_member.no — NOT NULL
  • date — date — NOT NULL
  • start_time — time — NOT NULL
  • end_time — time — NOT NULL
  • status — enum('ON','OFF') — NOT NULL
  • description — varchar(255)