Test
Tables (59)
ACCEPT_INFO
- id — int — Primary key — NOT NULL
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- site_id — int — Foreign key → STUDENT_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → STUDENT_INFO.site_code — NOT NULL — 학원코드
- id3 — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- id4 — int — Foreign key → STUDENT_PAYMENT_INFO.id — NOT NULL
- transaction_no — varchar(20) — 거래번호
- payment_type — varchar(100) — 납입구분: 청구,납입
- claim_item_type — varchar(100) — 수강료.교재,기타
- class_name — varchar(200) — 클래스명
- book_id — int — 쿄재 정보
- content — text — 수납내역
- begin_dt — timestamp — 클래스시작일
- end_dt — timestamp — 클래스종료일
- target_amount — int — 청구내역의원금
- quantity — int — 수량
- sale_apply_amount — int — 할인금액
- prepayment_carried_over_apply_amount — int — 선납/이월금수강료적용
- claim_amount — int — 원금에서할인금액을뺀값
- deadline — timestamp — 납입기한
- process_type — varchar(100) — 결제완료,환불완료
- cancel_amount — int
- refund_method — varchar(100) — 신용카드,가상계좌,선납/이월금,현금
- refund_date — timestamp
- refund_amount — int — 환불금액
- manager_id — int
- manager_name — varchar(20)
- manager_date — timestamp
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ACCEPT_PAYMENT_HISTORY
- id — int — Primary key — NOT NULL
- id2 — int — Foreign key → ACCEPT_INFO.id — NOT NULL
- id22 — int — Foreign key → ACCEPT_INFO.id2 — NOT NULL — 학생아이디
- site_id — int — Foreign key → ACCEPT_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → ACCEPT_INFO.site_code — NOT NULL — 학원코드
- id3 — int — Foreign key → ACCEPT_INFO.id3 — NOT NULL — 클래스아이디
- id4 — int — Foreign key → ACCEPT_INFO.id4 — NOT NULL
- payment_type — varchar(100) — 결제완료,환불대기,환불완료
- cancel_content — varchar(100) — 이사,학업종료,타학원이동,서비스불만,직접입력
- memo — text — 취소사유 직접입력
- payment_way — varchar(10) — 결제방식: 현금,카드,복합
- transaction_no — varchar(20) — 거래번호
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ADM_MANAGER_INFO
- id — int — Primary key — NOT NULL — 관리자 인덱스
- admin_id — varchar(200) — 유저 아이디
- password — varchar(20) — 비밀번호
- email — varchar(200) — 이메일
- Field — VARCHAR(255)
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ANNUAL_USAGE
- id — int — Primary key — NOT NULL — 연차아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- vacation_type — varchar(10) — 휴가구분 : 연차,반차
- begin_dt — timestamp — 시작일
- end_dt — timestamp — 종료일
- usage_count — int — 사용일수
- content — text — 사유
- memo — text — 비고
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ATTENDANCE_INFO
- id — int — Primary key — NOT NULL — 출석관리아이디
- student_id — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- site_id — int — Foreign key → STUDENT_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → STUDENT_INFO.site_code — NOT NULL — 학원코드
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
BOOK_DETAIL_RELEASE_HISTORY
- id — int — Primary key — NOT NULL — 출고아이디
- book_id — int — Foreign key → BOOK_INFO.id — NOT NULL — 교재아이디
- seller_id — int — Foreign key → BOOK_INFO.seller_id — NOT NULL — 공급업체아이디
- site_id — int — Foreign key → BOOK_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → BOOK_INFO.site_code — NOT NULL — 학원코드
- book_regist_dt — timestamp — 입력일
- book_name — varchar(200) — 교재명
- buyer_code — varchar(10) — 대상 코드 : 어린이 ,중학생
- buyer_id — int — 구매자아이디
- buyer_name — varchar(20) — 구매자명
- state_code — varchar(10) — 상태코드 : 판매,반품,폐기,증정
- price — int — 단가
- amount_price — int — 판매가
- count — int — 수량
- memo — text — 비고
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
BOOK_ENTRY_EXIT_INFO
- id — int — Primary key — NOT NULL — 입반출아이디
- book_id — int — Foreign key → BOOK_INFO.id — NOT NULL — 교재아이디
- seller_id — int — Foreign key → BOOK_INFO.seller_id — NOT NULL — 공급업체아이디
- site_id — int — Foreign key → BOOK_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → BOOK_INFO.site_code — NOT NULL — 학원코드
- book_regist_dt — timestamp — 입력일
- category_code — varchar(10) — 유형코드 : 입고,반품,증정,폐기
- storage_code — varchar(10) — 창고입출고 코드 : 창고입고,창고출고
- count — int — 수량
- memo — text — 비고
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
BOOK_INFO
- id — int — Primary key — NOT NULL — 교재아이디
- seller_id — int — Foreign key → BOOK_SELLER_INFO.id — NOT NULL — 공급업체아이디
- site_id — int — Foreign key → BOOK_SELLER_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → BOOK_SELLER_INFO.site_code — NOT NULL — 학원코드
- seller_name — varchar(20) — 업체명
- book_name — varchar(200) — 교제명
- price — int — 단가
- amount_price — int — 판매가
- bar_code — varchar(20) — 바코드
- code — varchar(10) — 대상 : 유아,초등,중등,고등,
- subject — varchar(200) — 과목1,과목2
- memo — text — 메모
- state_yn — boolean — 상태 : 사용(Y),미사용(N)
- stock — int — 현재재고량
- amount_count — int — 판매수량
- free_count — int — 증정수량
- return_count — int — 반품수량
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
BOOK_SELLER_INFO
- id — int — Primary key — NOT NULL — 공급업체아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- seller_name — varchar(20) — 업체명
- ceo_phone_no — varchar(15) — 대표번호
- agent_name — varchar(20) — 담당자명
- agent_phone_no — varchar(15) — 담당자연락처
- email — varchar(200) — 이메일
- memo — text — 메모
- state_type — varchar(10) — 상태코드
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CAREER_INFO
- id — int — Primary key — NOT NULL — 경력정보아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- career_begin_dt — timestamp — 경력시작일
- career_end_dt — timestamp — 경력종료일
- title — varchar(200) — 경력타이틀
- content — text — 내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_INFO
- id — int — Primary key — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → COURCE_DETAIL_INFO.id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → COURCE_DETAIL_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → COURCE_DETAIL_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- site_id — int — Foreign key → COURCE_DETAIL_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → COURCE_DETAIL_INFO.site_code — NOT NULL — 학원코드
- class_name — varchar(200) — 클래스명
- type_code — varchar(10) — 정규,회차
- activated_yn — boolean — 운영여부 :운영(Y),미사용(N)
- code — varchar(10) — 대상코드
- subject_code — varchar(10) — 과목코드
- cource_name — varchar(200) — 코스명
- total — int — 정원
- turn — int — 회차
- current — int — 현재수강생수
- begin_dt — timestamp — 시작일
- end_dt — timestamp — 종료일
- grade_code — varchar(10) — 성적코드
- book — varchar(200) — 교재명
- zoom — varchar(100) — zoom 코드
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_PROGRESS_INFO
- id — int — Primary key — NOT NULL — 진도아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → CLASS_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- class_name — varchar(200) — 클래스명
- employee_name — varchar(20) — 강사명
- book_name — varchar(200) — 교재명
- Field — VARCHAR(255)
- content — text — 진도내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_REINFORCEMENT_INFO
- id — int — Primary key — NOT NULL — 보강아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → CLASS_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- class_name — varchar(200) — 클래스명
- classroom — varchar(20) — 교실
- student_name — varchar(20) — 학생명
- parent_mobile_no — varchar(15) — 부모 핸드폰 번호
- nick — varchar(20) — 닉네임
- group_one_code — varchar(10) — 그룹1코드
- group_two_code — varchar(10) — 그룹2코드
- reinforcement_date — timestamp — 보강일
- absent_date — timestamp — 결석일
- content — text — 보강내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_STUDENT_INFO
- id — int — Primary key — NOT NULL — 클래스수강생아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- student_id — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- Field — VARCHAR(255)
- class_name — varchar(200) — 클래스명
- student_type — varchar(20) — 수강생타입 : 배정,이동,취소
- student_name — varchar(20) — 학생이름
- nick — varchar(20) — 닉네임
- school_year — varchar(20) — 학년
- Field2 — int
- mobile_no — varchar(15) — 연락처
- parent_mobile_no — varchar(15) — 학부모연락처
- parent_id — int — 학부모아이디
- total — int — 총회차
- current — int — 현재회차
- in_available_dt — timestamp — 수강 유효기간
- acceptance_history_status — varchar(10) — 수납완료,미납
- in_dt — timestamp — 수강 기간 : 1개월,2개월
- Field3 — timestamp
- Field5 — timestamp
- Field6 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — boolean
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_TASK_EVALUATION
- id — int — Primary key — NOT NULL — 클래스평가아이디
- id2 — int — Foreign key → CLASS_TASK_INFO.id — NOT NULL — 클래스과제아이디
- class_id — int — Foreign key → CLASS_TASK_INFO.class_id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_TASK_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_TASK_INFO.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → CLASS_TASK_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_TASK_INFO.site_code — NOT NULL — 학원코드
- employee_id — int — Foreign key → CLASS_TASK_INFO.employee_id — NOT NULL — 직원아이디
- student_name — varchar(20) — 이름
- nick — varchar(20) — 닉네임
- evaluation_code — varchar(10) — 평가코드 : A,B,C,D,제출,미제출,직접입력
- evaluation_condent — text — 평가내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_TASK_INFO
- id — int — Primary key — NOT NULL — 클래스과제아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- class_name — varchar(200) — 클래스명
- employee_name — varchar(20) — 강사명
- task_regist_dt — timestamp — 과제등록일
- task_end_dt — timestamp — 과제마김일
- content — text — 과제내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CLASS_TEACHER_INFO
- id — int — Primary key — NOT NULL — 클래스회차강사 아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- name — varchar(20) — 강사명
- classroom — varchar(20) — 교실
- begin_hour — varchar(2) — 시작시간
- begin_minuet — varchar(2) — 시작시간분
- end_hour — varchar(2) — 종료시간
- end_minuet — varchar(2) — 종료시간분
- day — int — 요일
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
COMMON_CODE
- id — int — Primary key — NOT NULL — 코드아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- type_a — varchar(10) — 대분류
- type_b — varchar(10) — 중분류
- type_c — varchar(10) — 소분류
- type_a_name — varchar(100) — 대분류 코드이름
- type_b_name — varchar(100) — 중분류 코드이름
- type_c_name — varchar(100) — 소분류 코드이름
- use_yn — boolean — Y,N
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CONSULTING_STUDENT_INFO
- id — int — Primary key — NOT NULL — 학생상담아이디
- student_id — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- id2 — int — Foreign key → ROUTINE_CONSULTING.id — NOT NULL — 정기상담아이디
- class_id — int — Foreign key → ROUTINE_CONSULTING.class_id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → ROUTINE_CONSULTING.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → ROUTINE_CONSULTING.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → ROUTINE_CONSULTING.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → ROUTINE_CONSULTING.site_code — NOT NULL — 학원코드
- student_name — varchar(20) — 학생명
- consulting_dt — varchar(8) — 상담날짜
- content — text — 상담내용
- consulting_progress_type — varchar(10) — 상담진행상태코드 : 진행중,완료
- employee_name — varchar(20) — 직원명
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
CONTRACT_INFO_HISTORY
- id — int — Primary key — NOT NULL — 계약정보아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- contract_begin_dt — timestamp — 계약시작일
- contract_end_dt — timestamp — 계약종료일
- pay_type — varchar(10) — 급여종류
- pay — int — 급여
- contract_content — text — 계약내용
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
COURCE_BOOK_INFO
- id — int — Primary key — NOT NULL
- course_id — int — Foreign key → COURCE_INFO.id — NOT NULL — 코스아이디
- site_id — int — Foreign key → COURCE_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → COURCE_INFO.site_code — NOT NULL — 학원코드
- grade_form_id — int — Foreign key → COURCE_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- book_id — int — Foreign key → BOOK_INFO.id — NOT NULL — 교재아이디
- seller_id — int — Foreign key → BOOK_INFO.seller_id — NOT NULL — 공급업체아이디
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
COURCE_DETAIL_INFO
- id — int — Primary key — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → COURCE_INFO.id — NOT NULL — 코스아이디
- site_id — int — Foreign key → COURCE_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → COURCE_INFO.site_code — NOT NULL — 학원코드
- grade_form_id — int — Foreign key → COURCE_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- cource_name — varchar(200) — 코스명
- year — varchar(4) — YYYY.MM
- begin_dt — timestamp — 시작일
- end_dt — timestamp — 종료일
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
COURCE_INFO
- id — int — Primary key — NOT NULL — 코스아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- grade_form_id — int — Foreign key → GRADE_FORM_INFO.id — NOT NULL — 성적표양식아이디
- code — varchar(10) — 유아,초등,중등,고등,전체
- subject_code — varchar(10) — 과목코드
- group_one_code — varchar(10) — 그룹원
- group_two_code — varchar(10) — 그룹2
- cource_category — varchar(10) — 정규,회차,전체
- cource_type — varchar(10) — 코스상태 : 은영중,미사용,종료,전체
- cource_name — varchar(200) — 코스명
- cource_begin_dt — timestamp — 코스시작일
- cource_end_dt — timestamp — 코스종료일
- total — int — 정원
- price — int — 수강료
- end_dt_yn — boolean — 종료일 미지정 : Y,N
- sum — int — 합계
- price_claim_dt — int — 수강료청구일 : int
- deadline_dt — int — 납기기한일
- auto_claim_yn — boolean — 자동청구여부 : Y,N
- etc_claim_list — longtext — JSON형식
- etc_price — int — 기타청구금액
- turn — int — 회차
- in_avaliable_dt — int — 수강유효기간
- book_list — longtext — JSON형식의 리스트
- cource_register_period — int — 코스생성주기 : 세부개설일
- class_open_dt — int — 클래스 오픈일 지정 - 월시작일부터 몇일
- wait — int — 대기자
- grade_name — varchar(200) — 성적표이름
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
DAILY_WORK
- id — int — Primary key — NOT NULL — 일일업무아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- content — text — 내용
- work_dt — varchar(8) — 업무날짜
- check_yn — boolean — 확인여부 : Y,N
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
EMAIL_SEND_HISTORY
- id — int — Primary key — NOT NULL
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- target_email — varchar(200) — 대상이메일
- target_id — int — 대상장아이디
- target_name — varchar(20) — 대상자명
- content — text — 발송내용
- target_yn — VARCHAR(255) — 발송여부 : Y,N
- send_user_id — int
- send_name — varchar(20)
- send_dt — timestamp
EMPLOYEE_ANNUAL_INFO
- id — int — Primary key — NOT NULL — 연차정보아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- year — varchar(4) — 연도
- day — int — 발생일수
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
EMPLOYEE_INFO
- id — int — Primary key — NOT NULL — 직원아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- Field — varchar(200)
- password — varchar(20) — 비밀번호
- password_regist_dt — timestamp — 비밀번호 등록일
- name — varchar(20) — 이름
- code — varchar(10) — 출결코드
- employee_type — varchar(10) — 직원유형 : 원장,관리자,강사,직원,기사
- employee_group — varchar(10) — 직원그룹 : 행정,강사,관리자
- email — varchar(200) — 이메일
- employee_status — varchar(10) — 직원상태 : 재직,휴직,퇴직
- mobile_no — varchar(15) — 핸드폰
- birthday — varchar(8) — 생년월일 : yyyymmdd
- zipcode — varchar(7) — 우편번호
- address1 — varchar(200) — 주소1
- address2 — varchar(200) — 주소2
- contract_begin_dt — timestamp — 계약시작일
- contract_end_dt — timestamp — 계약종료일
- pay_type — varchar(10) — 급여타입 : 월급제,비율제
- pay_amount — int — 급여액수
- contract_content — text — 계약내용
- leave_begin_dt — timestamp — 휴직시작일
- leave_end_dt — timestamp — 휴직종료일
- retierment_dt — timestamp — 퇴직일
- join_dt — timestamp — 입사일
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
FILE_INFO
- id — int — Primary key — NOT NULL — 파일아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- type — varchar(10) — 진도,보강,과제,알림,공지사항
- type_id — int — 아이디값
- Field — VARCHAR(255)
- file_name — varchar(100) — 파일명
- file_path — varchar(200) — 파일경로
- file_size — int — 파일사이즈
- study_dt — timestamp — 수업일
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
GENERAL_CONSULTING
- id — int — Primary key — NOT NULL — 일반상담아이디
- id2 — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- id3 — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보마스터아이디
- site_code2 — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- id4 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- employee_name — varchar(20) — 직원명
- student_name — varchar(20) — 학생명
- content — text — 상담내용
- consulting_type — varchar(10) — 상담구분 : 결제
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
GRADE_FORM_INFO
- id — int — Primary key — NOT NULL — 성적표양식아이디
- grade_type — varchar(10) — 기본형,그래프형
- grade_name — varchar(200) — 성적표이름
- memo — text — 비고
- selection — int — 항목수
- selection_list — longtext — JSON 형식
- option_code — varchar(10) — 그래프형일때 이전성적비교
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
GRADE_INFO
- id — int — Primary key — NOT NULL — 성적표관리아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → CLASS_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — 직원아이디
- class_name — varchar(200) — 클래스명
- employee_name — varchar(20) — 강사명
- begin_dt — timestamp — 시작일
- end_dt — timestamp — 종료일
- grade_name — varchar(200) — 성적표이름
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MASTER_PAYMENT_HISTORY
- id — int — Primary key — NOT NULL — 결제내역아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- sell_dt — varchar(8) — 매출일
- payment_type — varchar(100) — 결제상태 :미납,결제완료,환불
- payment_method — varchar(10) — 결제방식 : 계좌이체,가상계좌
- seller_name — varchar(20) — 업체명
- amount — int — 금액
- sale_amount — int — 할인금액
- sell_amount — int — 매출금액
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MMS_GROUP_ADDRESS
- id — int — Primary key — NOT NULL — 주소록아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- site_name — varchar(200) — 학원명
- group_name — varchar(200) — 그룹명
- group_users — varchar(200) — 그룹원 : JSON형식으로 대상자를 저장한다
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MMS_GROUP_USER_DETAIL
- id — int — Primary key — NOT NULL — 주소록대상아이디
- id2 — int — Foreign key → MMS_GROUP_ADDRESS.id — NOT NULL — 주소록아이디
- site_id — int — Foreign key → MMS_GROUP_ADDRESS.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → MMS_GROUP_ADDRESS.site_code — NOT NULL — 학원코드
- student_id — int — 학생아이디
- student_name — varchar(20) — 학생명
- school — varchar(50) — 학교명
- school_year — varchar(20) — 학년
- mobile_no — varchar(15) — 학생핸드폰
MMS_SAVE_INFO
- id — int — Primary key — NOT NULL — 문자저장내역아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- type — varchar(10) — 분류 : 문자,메일
- content — text — 내용
- mms_type — varchar(10) — 문자 구분 : 단문,푸시,mms
- title — varchar(200) — 제목
- Field — int
- file_path — varchar(200) — 파일경로
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MMS_SEND_HISTORY
- id — int — Primary key — NOT NULL — 발송이력아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- target_id — int — 발송대상자아이디
- traget_name — varchar(20) — 발송대상자명
- target_no — varchar(15) — 대상자번호
- content — text — 발송내용
- target_yn — text — 발송여부 : Y,N
- Field — VARCHAR(255)
- send_user_id — int — 발송자아이디
- send_name — varchar(20) — 발송자명
- send_dt — timestamp — 발송일
MOVIE_CONTENT_INFO
- id — int — Primary key — NOT NULL — 동영상강의아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- content — text — 동영상내용
- title — varchar(200) — 제목
- comment — text — 설명
- open_yn — boolean — 공개설정 : 공개(Y),비공개(N)
- html_yn — boolean — html 사용여부 : Y,N
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MOVIE_MANAGE_INFO
- id — int — Primary key — NOT NULL — 동영상파일아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- id2 — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- Field — varchar(200)
- movie_url — varchar(200) — 동영상 url
- title — varchar(200) — 제목
- content — text — 설명
- employee_name — varchar(20) — 강사명
- share_count — int — 공유대상수
- share_list — longtext — 공유대상 목록 :JONS형식으로 이름과 아이디저장
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
MOVIE_SHARE_USER_INFO
- id — int — Primary key — NOT NULL — 동영상공유아이디
- id3 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- id2 — int — Foreign key → MOVIE_MANAGE_INFO.id — NOT NULL — 동영상파일아이디
- employee_id — int — Foreign key → MOVIE_MANAGE_INFO.employee_id — NOT NULL — 직원아이디
- employee_name — varchar(20) — 직원이름
- student_name — varchar(20) — 학생이름
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
NONMEMBER_CONSULTING_INFO
- id — int — Primary key — NOT NULL — 비회원상담아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- employee_name — varchar(20) — 담당직원이름
- consulting_type — varchar(10) — 신규,결제,휴원,학습
- content — text — 상담내용
- phone_no — varchar(15) — 전화번호
- consulting_name — varchar(20) — 상담자이름
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
NOTICE
- id — int — Primary key — NOT NULL — 공지사항아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- notice_yn — boolean — 공지여부 : Y,N
- title — varchar(200) — 제목
- content — text — 내용
- count — int — 조회수
- Field5 — int
- Field6 — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
NOTICE_SEND_HISTORY
- id — int — Primary key — NOT NULL — 발송이력아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → CLASS_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → CLASS_INFO.site_code — NOT NULL — 학원코드
- class_name — varchar(200) — 클래스명
- title — varchar(200) — 제목
- content — text — 내용
- selection_type — varchar(10) — 선택항목 :
- target_ids — longtext — 대상자아이디리스트
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
RESERVATION_MMS_INFO
- id — int — Primary key — NOT NULL — 예약문자아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- mms_send_dt — timestamp — 발송일
- content — text — 발송내용
- state_code — varchar(10) — 전송상태 : 예약,발송
- send_user_count — int — 발송대상자 숫자
- send_phone_no_list — longtext — json 형식의 리스트
- success_count — int — 성공갯수
- send_user_id — int — 발송자 아이디
- send_name — varchar(20) — 발송자명
- send_nick — varchar(20) — 발송자닉네임
- send_dt — timestamp — 발송일
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ROUTINE_CONSULTING
- id — int — Primary key — NOT NULL — 정기상담아이디
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → EMPLOYEE_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → EMPLOYEE_INFO.site_code — NOT NULL — 학원코드
- class_name — varchar(200) — 클래스명
- consulting_begin_dt — timestamp — 상담시작일
- consulting_end_dt — timestamp — 상담종료일
- consulting_code — varchar(10) — 상담코드
- consulting_type — varchar(10) — 상담구분
- count — int — 인원수
- done_count — int — 완료인원수
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
ROUTINE_CONSULTING_MANAGER_INFO
- id — int — Primary key — NOT NULL — 정기상담담당자아이디
- routine_consulting_id — int — Foreign key → ROUTINE_CONSULTING.id — NOT NULL — 정기상담아이디
- class_id — int — Foreign key → ROUTINE_CONSULTING.class_id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → ROUTINE_CONSULTING.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → ROUTINE_CONSULTING.course_id — NOT NULL — 코스아이디
- site_id — int — Foreign key → ROUTINE_CONSULTING.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → ROUTINE_CONSULTING.site_code — NOT NULL — 학원코드
- id2 — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- employee_name — varchar(20) — 강사이름
- class_name — varchar(200) — 클래스명
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
SALE_CONSULTING
- id — int — Primary key — NOT NULL — 영업상담 아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- name — varchar(20) — 이름
- phone_no — varchar(15) — 연락처
- rank — varchar(200) — 직급
- email — varchar(200) — 이메일
- site_name — varchar(200) — 학원명
- subject — varchar(200) — 과목
- content — text — 상담내용
- consulting_type — varchar(10) — 상담유형 : 사용문의,데모신청,가격문의,제휴문의,기타
- modifier_id — int — 수정자아이디
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
SALE_INFO
- id — int — Primary key — NOT NULL
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- site_id — int — Foreign key → STUDENT_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → STUDENT_INFO.site_code — NOT NULL — 학원코드
- sale_title — varchar(200) — 할인제목
- sale_type — varchar(10) — %, 금액 표시여부
- sale_amount — int — 할인금액
- begin_dt — timestamp — 할인시작일
- end_dt — timestamp — 할인종료일 값이 없으면 무제한
- Field5 — int
- Field6 — varchar(20)
- Field7 — timestamp
- Field8 — int
- Field9 — varchar(20)
- Field10 — timestamp
SITE_INFO
- id — int — Primary key — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Primary key — NOT NULL — 학원코드
- site_name — varchar(200) — 학원명
- biz_no — varchar(15) — 사업자등록번호
- file_path — varchar(200) — 파일경로
- biz_ — form` — 사업자 형태 :개인,법인
- coporation_no — varchar(15) — 법인등록번호
- site_regist_no — varchar(15) — 학원등록번호
- address1 — varchar(200) — 주소1
- address2 — varchar(200) — 주소2
- zipcode — varchar(7) — 우편번호
- biz_type — varchar(50) — 업태
- biz_sort — varchar(50) — 종목
- url — varchar(200) — 홈페이지
- phone_no — varchar(15) — 연락처
- chief_name — varchar(20) — 대표자이름
- chief_en_name — varchar(20) — 대표자영문이름
- chief_reg_no — varchar(15) — 대표자 주민번호
- chief_phone_no — varchar(15) — 대표자연락처
- agent_name — varchar(20) — 담당자이름
- agent_email — varchar(100) — 담당자이메일
- agent_phone_no — varchar(15) — 연락처
- contract_type — varchar(10) — 계약상태 : 서비스 사용 여부표시 (사용,중지,종료,폐업)
- free_contract_begin_dt — timestamp — 무료계약시작일
- free_contract_end_dt — timestamp — 무료계약종료일
- contract_begin_dt — timestamp — 계약기간시작일
- contract_end_dt — timestamp — 계약기간종료일
- adjustment_period — varchar(10) — 정산주기 : 월단위,연단위
- adjustment_dt — varchar(8) — 정산일
- refund_account_no — varchar(20) — 환불계좌번호
- account_owner — varchar(20) — 예금주
- amount — int — 금액
- sale — double — 할인비율 : 5%(1년계약),3%(6개월계약),7%(2년계약)
- sell_amount — int — 매출금액
- bill_publish_yn — boolean — 발행,미발행
- payment_type — varchar(100) — 결제상태 : 결제완료,미납,환불
- payment_method — varchar(10) — 결제방식 : 계좌이체,가상계좌
- payment_amount — int — 결제금액
- sale_amount — int — 할인금액
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
SITE_INFO_CONSULTING_HISTORY
- id — int — Primary key — NOT NULL — 아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- consulting_content — text — 상담내역
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_GRADE_DETAIL_INFO
- id — int — Primary key — NOT NULL — 학생성적표상세아이디
- site_code — varchar(100) — Foreign key → GRADE_INFO.site_code — NOT NULL — 학원코드
- site_id — int — Foreign key → GRADE_INFO.site_id — NOT NULL — 학원정보아이디
- grade_id — int — Foreign key → GRADE_INFO.id — NOT NULL — 성적표관리아이디
- class_id — int — Foreign key → GRADE_INFO.class_id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → GRADE_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → GRADE_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → GRADE_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- employee_id — int — Foreign key → GRADE_INFO.employee_id — NOT NULL — 직원아이디
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- rank — varchar(200) — 석차
- student_name — varchar(20) — 학생이름
- nick — varchar(20) — 닉네임
- mobile_no — varchar(15) — 연락처
- parent_id — int — 부모 아이디
- parent_mobile_no — varchar(15) — 부모연락처
- grade_category — longtext — 성적표항목 : JSON형식,1차,2차,3차
- total — int — 총점
- average — double — 평균
- group_average — double — 전체평균
- push_code — varchar(10) — 푸시코드값 : 전송,미전송
- begin_dt — timestamp — 시작일
- end_dt — timestamp — 종료일
- comment — text — 종합의견
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_INFO
- id — int — Primary key — NOT NULL — 학생아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- student_name — varchar(20) — 학생명
- code — varchar(10) — 출결코드
- nick — varchar(20) — 닉네임
- birthday — varchar(8) — 생년월일
- sex — char(1) — 성별 : M,W
- parent_mobile_no — varchar(15) — 학보모핸드폰
- mobile_no — varchar(15) — 학생핸드폰
- email — varchar(200) — 이메일
- school — varchar(50) — 학교명
- school_year — varchar(20) — 학년
- student_type — varchar(20) — 학생상태 : 미등록,재원,휴원,퇴원,대기자,신규,재등록
- zipcode — varchar(7) — 우편번호
- address1 — varchar(200) — 주소1
- address2 — varchar(200) — 주소2
- memo — text — 메모
- first_regist_dt — varchar(8) — 최초 배정된 클래스 결제일자
- wait_type_yn — boolean — Y,N (대기정보가 있을경우 Y)
- sale_apply_list — longtext — 할인적용리스트 :JSON형식 리스트값
- sale_auto_extension_yn — boolean — 할인자동연장여부 : Y,N
- leave_begin_dt — timestamp — 학생상태가 휴원으로 변경시
- leave_end_dt — timestamp — 학생상태가 휴원으로 변경시
- retierment_dt — timestamp — 학생상태가 퇴원으로 변경시
- retierment_memo — text — 학생상태가 퇴원으로 변경시
- in_dt — timestamp — 학생상태가 재원으로 변경시
- parent_id — int — 학보모아이디
- parent_password — varchar(20) — 학부모패스워드
- parent_mobile_no1 — varchar(15) — 학부모핸드폰번호1
- parent_mobile_no2 — varchar(15) — 학부모핸드폰번호2
- receipt_no — varchar(20) — 현금영수증번호
- receipt_type — varchar(10) — 현금영수증구분코드 : 핸드폰,사업자
- in_type — varchar(10) — 수강상태
- payment_type — varchar(100) — 결제상태
- privacy_yn — boolean — 개인정보 수집 :Y,N
- event_yn — boolean — 이벤트동의 : Y,N
- prepayment_support_amount — int
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_PAYMENT_INFO
- id — int — Primary key — NOT NULL
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- id3 — int — NOT NULL — 클래스수강생아이디
- class_id — int — NOT NULL — 클래스아이디
- course_detail_id — int — NOT NULL — 코스세부아이디
- course_id — int — NOT NULL — 코스아이디
- site_id — int — NOT NULL — 학원정보아이디
- site_code — varchar(100) — NOT NULL — 학원코드
- book_id — int — 교재아이디
- payment_type — varchar(100) — 수강료,교재,기타
- payment_yn — boolean — 결제완료 여부
- contnent — text — 결제할내역
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_PREPAYMENT_HISTORY
- id — int — Primary key — NOT NULL — 선납금이력아이디
- id2 — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- site_id — int — Foreign key → STUDENT_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → STUDENT_INFO.site_code — NOT NULL — 학원코드
- charging_amount — int — 충전금액
- sale_amount — int — 할인금액
- memo — text — 메모
- payment_type — varchar(10) — 결제방식
- payment_amount — int — 결제금액
- refund_amount — int — 환불금액
- refune_type — varchar(20) — 환불방식
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_SALE_INFO
- id — int — Primary key — NOT NULL — 수납 할인목록정보아아디
- id2 — int — Foreign key → SALE_INFO.id — NOT NULL
- id22 — int — Foreign key → SALE_INFO.id2 — NOT NULL — 학생아이디
- site_id — int — Foreign key → SALE_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SALE_INFO.site_code — NOT NULL — 학원코드
- id3 — int — Foreign key → ACCEPT_INFO.id — NOT NULL
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
STUDENT_SCORE_INFO
- id — int — Primary key — NOT NULL — 학생별성적정보아이디
- id2 — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.id — NOT NULL — 학생성적표상세아이디
- site_code — varchar(100) — Foreign key → STUDENT_GRADE_DETAIL_INFO.site_code — NOT NULL — 학원코드
- site_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.site_id — NOT NULL — 학원정보아이디
- grade_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.grade_id — NOT NULL — 성적표관리아이디
- class_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.class_id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.course_id — NOT NULL — 코스아이디
- grade_form_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- employee_id — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.employee_id — NOT NULL — 직원아이디
- id22 — int — Foreign key → STUDENT_GRADE_DETAIL_INFO.id2 — NOT NULL — 학생아이디
- score — int
- title — varchar(200)
- Field — int
- Field2 — varchar(20)
- Field3 — timestamp
- Field4 — int
- Field5 — varchar(20)
- Field6 — timestamp
TEST_PAPER_INFO
- id — int — Primary key — NOT NULL — 시험자료아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- name — varchar(20) — 이름
- folder_yn — boolean — 폴더여부 : Y,N
- parent_id — int — 부모id
- depth — int — 파일 깊이
- file_path — varchar(200) — 파일경로
- file_size — int — 파일사이즈
- down_count — int — 다운로드카운트
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
VIDEO_CLASS_ACCEPT_INFO
- id — int — Primary key — NOT NULL
- class_id — int — Foreign key → CLASS_INFO.id — NOT NULL — 클래스아이디
- course_detail_id — int — Foreign key → CLASS_INFO.course_detail_id — NOT NULL — 코스세부아이디
- course_id — int — Foreign key → CLASS_INFO.course_id — NOT NULL — 코스아이디
- video_id — int — Foreign key → VIDEO_CONTENT_INFO.id — NOT NULL — 화상강의아이디
- employee_id — int — Foreign key → VIDEO_CONTENT_INFO.employee_id — NOT NULL — 직원아이디
- site_id — int — Foreign key → VIDEO_CONTENT_INFO.site_id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → VIDEO_CONTENT_INFO.site_code — NOT NULL — 학원코드
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
VIDEO_CONTENT_INFO
- id — int — Primary key — NOT NULL — 화상강의아이디
- employee_id — int — Foreign key → EMPLOYEE_INFO.id — NOT NULL — 직원아이디
- site_id — int — Foreign key → SITE_INFO.id — NOT NULL — 학원정보마스터아이디
- site_code — varchar(100) — Foreign key → SITE_INFO.site_code — NOT NULL — 학원코드
- class_name — varchar(200) — 클래스명
- title — varchar(200) — 강의명
- employee_name — varchar(20) — 강사명
- video_state — varchar(10) — 화상강의상태
- url — varchar(200) — zoom url
- password — varchar(20) — 강의비밀번호
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp
WAITING_STUDENT_INFO
- id — int — Primary key — NOT NULL — 대기자아이디
- course_id — int — Foreign key → COURCE_INFO.id — NOT NULL — 코스아이디
- site_id — int — Foreign key → COURCE_INFO.site_id — NOT NULL — 학원정보아이디
- site_code — varchar(100) — Foreign key → COURCE_INFO.site_code — NOT NULL — 학원코드
- grade_form_id — int — Foreign key → COURCE_INFO.grade_form_id — NOT NULL — 성적표양식아이디
- student_id — int — Foreign key → STUDENT_INFO.id — NOT NULL — 학생아이디
- order_no — int — 순번
- name — varchar(20) — 이름
- mobile_no — varchar(15) — 학생핸드폰
- parent_mobile_no — varchar(15) — 학부모핸드폰
- birthday — varchar(8) — 생년월일
- memo — text — 메모
- modifier_id — int
- modifier — varchar(20)
- modified_dt — timestamp
- registant_id — int
- registant — varchar(20)
- regist_dt — timestamp