한국어교원 물리 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