한국어교원 물리 ERD

한국어교원 자격 시스템 추가 테이블 설계

테이블 (11)

개인심사신청내역 (individual_judge)

  • receipt_no — CHAR(10) — 기본 키 — NOT NULL — PK
  • user_idx — CHAR(6)
  • request_year — CHAR(4)
  • request_cnt — CHAR(2)
  • manageno — VARCHAR(15)
  • area_code — CHAR(5)
  • nat_code — CHAR(5)
  • reqclass1 — VARCHAR(3)
  • reqclass2 — VARCHAR(3)
  • certificate_no — VARCHAR(20)
  • certificate_kind — CHAR(2)
  • schooling_startdate — VARCHAR(8)
  • schooling_enddate — VARCHAR(8)
  • schooling_desc — VARCHAR(100)
  • degree_idx — CHAR(6)
  • training_startdate — VARCHAR(8)
  • training_enddate — VARCHAR(8)
  • training_organname — VARCHAR(100)
  • training_time — VARCHAR(4)
  • non_org_idx — CHAR(6)
  • receipt_code — CHAR(5)
  • success_code — CHAR(5)
  • success_reqclass1 — VARCHAR(3)
  • success_reqclass2 — VARCHAR(3)
  • user_name — VARCHAR(50)
  • user_eng_name1 — VARCHAR(50)
  • birthday — VARCHAR(12)
  • e_mail — VARCHAR(50)
  • tel — VARCHAR(60)
  • fax — VARCHAR(60)
  • phone — VARCHAR(60)
  • foreign_liv — CHAR(1)
  • addr1 — VARCHAR(400)
  • addr2 — VARCHAR(400)
  • zip1 — VARCHAR(30)
  • zip2 — VARCHAR(30)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • dlt_yn — CHAR(1)
  • remark — VARCHAR(4000)
  • sex — CHAR(1)
  • user_eng_name_rear — VARCHAR(60)
  • user_eng_name — VARCHAR(500)
  • agegroup — CHAR(2)
  • bigo — VARCHAR(4000)
  • pre — CHAR(1)
  • academic_desc — CHAR(500)
  • academic_idx — CHAR(100)
  • non_deg_note — VARCHAR(3)
  • non_deg_interview — VARCHAR(3)
  • tel1 — VARCHAR(5)
  • tel2 — VARCHAR(5)
  • tel3 — VARCHAR(5)
  • phone1 — VARCHAR(50)
  • phone2 — VARCHAR(50)
  • phone3 — VARCHAR(50)
  • eng_name1 — VARCHAR(50)
  • eng_name2 — VARCHAR(50)
  • org_type_code — CHAR(5)
  • step — VARCHAR(3)
  • … +18

개인자격 심사일정 (users_period)

  • request_year — CHAR(10) — 기본 키 — NOT NULL — PK
  • request_cnt — CHAR(10) — 기본 키 — NOT NULL — PK
  • request_startdate — CHAR(8)
  • request_starttime — CHAR(4)
  • request_enddate — CHAR(8)
  • request_endtime — CHAR(4)
  • success_date — CHAR(8)
  • success_time — CHAR(4)
  • judge_date — CHAR(8)
  • app_status — CHAR(1)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • non_degree_cnt — INTEGER
  • activate_yn — CHAR(1)
  • comp_startdate — CHAR(14)
  • comp_starttime — CHAR(14)
  • comp_enddate — CHAR(14)
  • comp_endtime — CHAR(14)
  • overall_idx — CHAR(10)

관리자권한관리 (admin_his)

  • admin_his_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • admin_idx — CHAR(6) — users의 user_idx 사용 FK
  • admin_id — VARCHAR(20)
  • admin_ip — VARCHAR(255)
  • user_idx — CHAR(6) — 외래 키 → 회원정보.user_idx — NOT NULL — users의 user_idx 사용 FK
  • user_id — VARCHAR(20)
  • activity — VARCHAR(50)
  • regdate — CHAR(14)

안내고지내역 (notice_his)

  • notice_idx — CHAR(10) — 기본 키 — NOT NULL
  • notice_method — CHAR(10)
  • notice_content — VARCHAR(4000)
  • notice_sender_idx — CHAR(10)
  • user_name — VARCHAR(50)
  • post_yn — CHAR(1)
  • posting — CHAR(1)
  • regdate — CHAR(14)

안내고지수신인 (notice_receiver)

  • notice_receiver_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • notice_idx — CHAR(10) — 외래 키 → 안내고지내역.notice_idx — NOT NULL — notice_his의 notice_idx 사용 FK
  • user_idx — CHAR(6) — users의 user_idx 사용 FK
  • user_name — VARCHAR(50)
  • post_yn — CHAR(1)
  • posting — CHAR(1)
  • regdate — CHAR(14)

예비심사내역 (pre_judge)

  • pre_judge_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • receipt_no — CHAR(10)
  • request_year — CHAR(4)
  • request_cnt — CHAR(2)
  • org_type_code — CHAR(5)
  • pre_judge_order — VARCHAR(255)
  • pre_judge_result_code — VARCHAR(255)
  • checker_idx — VARCHAR(255)
  • requester_idx — VARCHAR(255)
  • re_comment — VARCHAR(4096)
  • re_reg_date — TIMESTAMP
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • pre_judge_cnt — CHAR(14)
  • entry_yn — CHAR(1)
  • re_pre_judge_result_code — VARCHAR(255)
  • re_regdate — CHAR(14)
  • re_entry_yn — CHAR(1)

자격증발급신청 (issue)

  • issue_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • receipt_no — CHAR(10) — 외래 키 → 개인심사신청내역.receipt_no — NOT NULL — individual_judge의 receipt_no 사용 FK
  • request_year — CHAR(4)
  • request_cnt — CHAR(2)
  • user_idx — CHAR(6) — users의 user_idx 사용 FK
  • manage_no — VARCHAR(15)
  • submission_method — CHAR(10)
  • nati — VARCHAR(50)
  • nati_num1 — VARCHAR(50)
  • nati_num2 — VARCHAR(50)
  • issue_status — CHAR(10)
  • reprint_request_yn — CHAR(1)
  • reprint_reason — CHAR(1)
  • reprint_bigo — VARCHAR(4000)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • issuedate — CHAR(14)
  • bigo — VARCHAR(4000)
  • file_name — VARCHAR(255)
  • file_extension — VARCHAR(255)
  • file_real_name — VARCHAR(255)
  • post_send_yn — CHAR(1)
  • post_no — BIGINT

정보변경신청 이력 (reinfo_his)

  • reinfo_his_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • reinfo_idx — CHAR(7) — 외래 키 → 정보변경신청내역.reinfo_idx — NOT NULL
  • field — CHAR(20) — 고유식별정보/성명/국가코드 등 변경 여부
  • pre_info — VARCHAR(50)
  • pre_info2 — VARCHAR(50) — 영문명2 등에만 적용
  • new_info — VARCHAR(50)
  • new_info2 — VARCHAR(50) — 영문명2 등에만 적용
  • status — CHAR(5)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • applydate — CHAR(14)
  • dlt_yn — CHAR(1)
  • apply_yn — CHAR(1)

정보변경신청내역 (reinfo)

  • reinfo_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • user_idx — CHAR(10) — 외래 키 → 회원정보.user_idx — users의 user_idx 사용 FK
  • user_name — VARCHAR(50)
  • eng_name1 — VARCHAR(50)
  • eng_name2 — VARCHAR(50)
  • nat_code — CHAR(5)
  • nati — VARCHAR(50) — 제출할 고유식별정보 선택
  • nati_num1 — VARCHAR(50)
  • nati_num2 — VARCHAR(50)
  • birthday — VARCHAR(12)
  • status_name — CHAR(5)
  • status — VARCHAR(255)
  • status_eng_name — CHAR(5)
  • status_birthday — CHAR(5)
  • status_nati — CHAR(5)
  • comp_bigo — VARCHAR(4000)
  • reject_bigo — VARCHAR(4000)
  • change_user_name — VARCHAR(50)
  • change_eng_name1 — VARCHAR(50)
  • change_eng_name2 — VARCHAR(50)
  • change_nat_code — CHAR(5)
  • change_birthday — VARCHAR(12)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • applydate — CHAR(14)
  • dlt_yn — CHAR(1)
  • apply_yn — CHAR(1) — 정보 변경 신청 후 재발급 여부

정보변경신청서류 (reinfo_certificate)

  • reinfo_certificate_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • reinfo_idx — CHAR(10) — 외래 키 → 정보변경신청내역.reinfo_idx — NOT NULL — reinfo의 reinfo_idx 사용 FK
  • file_idx — CHAR(10)
  • file_name — VARCHAR(255)
  • real_file_name — VARCHAR(255)
  • file_base64 — VARCHAR(1073741823)
  • file_extension — VARCHAR(255)
  • file_pass — VARCHAR(255)
  • dlt_yn — CHAR(1)
  • submitter — VARCHAR(10)
  • regdate — CHAR(14)
  • moddate — CHAR(14)

회원정보 (users)

  • user_idx — CHAR(10) — 기본 키 — NOT NULL — PK
  • user_id — VARCHAR(20)
  • password — VARCHAR(80)
  • passcnt — INTEGER
  • user_name — VARCHAR(50)
  • user_eng_name — VARCHAR(50)
  • birthday — VARCHAR(12)
  • e_mail — VARCHAR(50)
  • tel — VARCHAR(60)
  • fax — VARCHAR(60)
  • phone — VARCHAR(60)
  • addr1 — VARCHAR(400)
  • addr2 — VARCHAR(400)
  • zip1 — VARCHAR(10)
  • zip2 — VARCHAR(10)
  • user_type — CHAR(5)
  • org_code — CHAR(6)
  • dep_name — VARCHAR(100)
  • grade_name — VARCHAR(50)
  • _npki_cert — VARCHAR(100)
  • regdate — CHAR(14)
  • moddate — CHAR(14)
  • pass_mod_date — CHAR(14)
  • dlt_yn — CHAR(1)
  • npki_cert — VARCHAR(500)
  • ipin_cert — VARCHAR(500)
  • overlap_yn — CHAR(1)
  • user_eng_name_rear — VARCHAR(50)
  • eng_name1 — VARCHAR(50)
  • eng_name2 — VARCHAR(50)
  • tel1 — VARCHAR(50)
  • tel2 — VARCHAR(50)
  • tel3 — VARCHAR(50)
  • phone1 — VARCHAR(50)
  • phone2 — VARCHAR(50)
  • phone3 — VARCHAR(50)
  • area_code — CHAR(5)
  • nat_code — CHAR(5)
  • judge_date — CHAR(8)
  • org_idx — CHAR(6)
  • request_year — CHAR(4)
  • request_cnt — CHAR(2)
  • school_start_year — CHAR(4)
  • school_start_month — CHAR(2)
  • school_end_year — CHAR(4)
  • school_end_month — CHAR(2)
  • appro_yn — CHAR(1)
  • appro_date — CHAR(8)
  • appro_cause — VARCHAR(255)
  • sex — CHAR(1)
  • eval_type — CHAR(1)
  • standard_code — CHAR(5)
  • state_code — CHAR(5)
  • eval_org_name (Field17) — VARCHAR(50)
  • eval_col_name — VARCHAR(50)
  • eval_grad_name — VARCHAR(50)
  • eval_org_gb_code — CHAR(5)
  • eval_org_type_code — CHAR(5)
  • eval_lastgrade — VARCHAR(50)
  • eval_flag — VARCHAR(50)
  • … +26