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)