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