역량 ERD
테이블 (25)
TB_L_COUNSEL
- COUNSEL_NO — NUMBER — 기본 키
- TYPE_CD — VARCHAR2(20) — 외래 키 → TB_L_COUNSEL_TYPE.TYPE_CD — NOT NULL
- SCHEDULE_NO — NUMBER — 외래 키 → TB_L_COUNSEL_SCHEDULE.SCHEDULE_NO — NOT NULL
- COUNSEL_FORM — VARCHAR2(30)
- LEARNER_NO — VARCHAR2(30)
- LEARNER_GRADE — VARCHAR2(2)
- LEARNER_CAMPUS — VARCHAR2(30)
- COUNSELOR_NO — VARCHAR2(30)
- CENTER_CD — VARCHAR2(20)
- DETAIL_BOARD_NO — NUMBER
- REPLY_BOARD_NO — NUMBER
- PROG_STATE — VARCHAR2(30)
- REPLY_DT — DATE
- RESUME_NO — VARCHAR2(14)
- COVER_LETTER_NO — VARCHAR2(14)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- REJECT_REASON — CLOB
- REALTIME_CONTENTS — VARCHAR2(4000)
- REALTIME_LINK — VARCHAR2(1000)
TB_L_COUNSEL_ATTACH_FILE
- COUNSEL_NO — NUMBER — 외래 키 → TB_L_COUNSEL.COUNSEL_NO
- BOARD_NO — NUMBER — 외래 키 → TB_L_COUNSEL_BOARD.BOARD_NO — NOT NULL
- ATTACH_FILE_NO — NUMBER — NOT NULL
- ATTACH_FILE_SAVE_NM — VARCHAR2(500)
- ATTACH_FILE_NM — VARCHAR2(200)
- ATTACH_FILE_SIZE — NUMBER
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
TB_L_COUNSEL_BOARD
- BOARD_NO — NUMBER — 기본 키 — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- SUBJECT — VARCHAR2(500) — NOT NULL
- CONTENTS — CLOB
- IS_OPEN — VARCHAR2(2)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
TB_L_COUNSEL_SCHEDULE
- SCHEDULE_NO — NUMBER — 기본 키 — NOT NULL
- COUNSELOR_NO — VARCHAR2(30) — NOT NULL
- COUNSEL_BEGIN — DATE — NOT NULL
- COUNSEL_END — DATE — NOT NULL
- REPEAT_TYPE — VARCHAR2(2)
- REPEAT_DETAIL — VARCHAR2(3)
- COUNSEL_PLACE — VARCHAR2(140)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- SCHEDULE_STATE — VARCHAR2(2)
TB_L_COUNSEL_TYPE
- TYPE_CD — VARCHAR2(20) — 기본 키 — NOT NULL
- TYPE_NM — VARCHAR2(100) — NOT NULL
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- USE_YN — VARCHAR2(2)
TB_L_COURSE
- COURSE_ID — VARCHAR2(50) — 기본 키 — NOT NULL
- PRG_CD — VARCHAR2(30) — 외래 키 — NOT NULL
- SITE_ID — VARCHAR2(30) — NOT NULL
- ASP_ID — VARCHAR2(30) — NOT NULL
- COURSE_GUBUN — VARCHAR2(30)
- COURSE_TYPE — VARCHAR2(30)
- COURSE_NM — VARCHAR2(200)
- COURSE_NM_EN — VARCHAR2(200)
- COURSE_NM_JP — VARCHAR2(200)
- COURSE_NM_CN — VARCHAR2(200)
- COURSE_NM_AR — VARCHAR2(200)
- CREDIT — NUMBER(3,1)
- COURSE_REQUEST_STR_DT — VARCHAR2(14)
- COURSE_REQUEST_END_DT — VARCHAR2(14)
- COURSE_STR_DT — VARCHAR2(14)
- COURSE_END_DT — VARCHAR2(14)
- STUDYDT_GUBUN — VARCHAR2(30)
- STUDY_DAY — NUMBER(5,0)
- REVIEW_DAY — NUMBER(5,0)
- CAPACITY — NUMBER(5,0)
- RESULT_OPEN_DT — VARCHAR2(14)
- COURSE_PLAN_FILE_PATH — VARCHAR2(200)
- COURSE_IMAGE_FILE_PATH — VARCHAR2(200)
- COURSE_EVAL_YN — VARCHAR2(1)
- ATTEND_RATIO — NUMBER(5,2)
- REPORT_RATIO — NUMBER(5,2)
- FORMATIVEEVAL_RATIO — NUMBER(5,2)
- MIDEXAM_RATIO — NUMBER(5,2)
- FINALEXAM_RATIO — NUMBER(5,2)
- QUIZ_RATIO — NUMBER(5,2)
- QNA_RATIO — NUMBER(5,2)
- STUDYACTIVITY_RATIO — NUMBER(5,2)
- DISCUSS_RATIO — NUMBER(5,2)
- TEAMPROJECT_RATIO — NUMBER(5,2)
- ETC_EVALITEM_NM1 — VARCHAR2(200)
- ETC_EVALITEM_RATIO1 — NUMBER(5,2)
- ETC_EVALITEM_NM2 — VARCHAR2(200)
- ETC_EVALITEM_RATIO2 — NUMBER(5,2)
- ETC_EVALITEM_NM3 — VARCHAR2(200)
- ETC_EVALITEM_RATIO3 — NUMBER(5,2)
- ADD_SCR_OPEN_YN — VARCHAR2(1)
- ETC_SCR1_OPEN_YN — VARCHAR2(1)
- ETC_SCR2_OPEN_YN — VARCHAR2(1)
- ETC_SCR3_OPEN_YN — VARCHAR2(1)
- SCR_OPEN_YN — VARCHAR2(1)
- PASS_SCR — NUMBER(5,2)
- PASS_PROGRESS_RATIO — NUMBER(5,2)
- FEE — NUMBER(10,0)
- SMALL_RETURNFEE — NUMBER(10,0)
- LARGE_RETURNFEE — NUMBER(10,0)
- TERM_NO — NUMBER(12,0)
- COURSE_CATEGORY_ID — VARCHAR2(30)
- USE_YN — VARCHAR2(1)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- COURSE_STEP — NUMBER(2,0)
- GRADE — NUMBER(2,0)
- COURSE_EVAL_STR_DT — VARCHAR2(14)
- … +113
TB_L_COURSE_REQUEST
- COURSE_ID — VARCHAR2(50) — 외래 키 → TB_L_COURSE.COURSE_ID — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- SITE_ID — VARCHAR2(30) — NOT NULL
- ASP_ID — VARCHAR2(30) — NOT NULL
- COURSE_REQUEST_DT — VARCHAR2(14)
- COURSE_REQUEST_STATE — VARCHAR2(30)
- PAY_NO — NUMBER(12,0)
- PAY_STATE — VARCHAR2(30)
- BATCH_INSERT_YN — VARCHAR2(1)
- GROUP_ID — VARCHAR2(30)
- GROUP_NM — VARCHAR2(200)
- DEPT_NM — VARCHAR2(200)
- POSITION_NM — VARCHAR2(200)
- REJECT_REASON — VARCHAR2(2000)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- CLASS_NO — VARCHAR2(10)
- DOC_FILE_PATH — VARCHAR2(200)
- INSERT_GUBUN — VARCHAR2(1)
- AUDIT_YN — CHAR(1)
- MIGRATION_YN — CHAR(1)
- PRE_CLASS_NO — VARCHAR2(30)
- COURSE_ID_USER_NO — VARCHAR2(100)
- TERM_YEAR — VARCHAR2(4)
- TERM_CD — VARCHAR2(10)
- PAY_YN — CHAR(1)
- PAY_PRICE — VARCHAR2(30)
- PAY_APP_YN — CHAR(1)
- PAY_METHOD — VARCHAR2(30)
- PAY_DT — VARCHAR2(14)
- BANK_NM — VARCHAR2(500)
- ACCOUNT_NO — VARCHAR2(500)
- RE_YN — CHAR(1)
- CANCEL_DT — VARCHAR2(14)
- REFUND_DT — VARCHAR2(14)
- TEMP_YN — VARCHAR2(1)
- INFO_MSG_YN — VARCHAR2(1)
- REISU_YEAR — VARCHAR2(4)
- REISU_TERM_CD — VARCHAR2(10)
TB_L_COURSE_STUDENT
- COURSE_ID — VARCHAR2(50) — 외래 키 → TB_L_COURSE.COURSE_ID — NOT NULL
- SITE_ID — VARCHAR2(30) — NOT NULL
- ASP_ID — VARCHAR2(30) — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- CLASS_NO — VARCHAR2(10)
- COURSE_STR_DT — VARCHAR2(14)
- COURSE_END_DT — VARCHAR2(14)
- ATTEND_SCR — NUMBER(5,2)
- REPORT_SCR — NUMBER(5,2)
- FORMATIVEEVAL_SCR — NUMBER(5,2)
- MIDEXAM_SCR — NUMBER(5,2)
- FINALEXAM_SCR — NUMBER(5,2)
- QUIZ_SCR — NUMBER(5,2)
- STUDY_ACTIVITY_SCR — NUMBER(5,2)
- DISCUSS_SCR — NUMBER(5,2)
- TEAMPROJECT_SCR — NUMBER(5,2)
- ETC_EVAL1_SCR — NUMBER(5,2)
- ETC_EVAL2_SCR — NUMBER(5,2)
- ETC_EVAL3_SCR — NUMBER(5,2)
- ADD_SCR — NUMBER(5,2)
- ADD_SCR_REASON — VARCHAR2(4000)
- TOTAL_SCR — NUMBER(5,2)
- RANK — NUMBER(5,0)
- PASS_YN — VARCHAR2(1)
- PASS_NO — VARCHAR2(150)
- PASS_ACTION_DT — VARCHAR2(14)
- GROUP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- COURSE_REVIEW_STR_DT — VARCHAR2(14)
- COURSE_REVIEW_END_DT — VARCHAR2(14)
- ATTEND_RATIO — NUMBER(5,2)
- EXAM_PASS_YN — VARCHAR2(1)
- DOC_FILE_PATH — VARCHAR2(200)
- INSERT_GUBUN — VARCHAR2(1)
- FINAL_SCR — NUMBER(5,2)
- DEPT_ID — VARCHAR2(20)
- DEPT_NM — VARCHAR2(200)
- COMPANY_NM — VARCHAR2(200)
- DIVISION_NM — VARCHAR2(200)
- POSITION_NM — VARCHAR2(200)
- FINISH_GUBUN — VARCHAR2(20)
- ACT_SCR — NUMBER(5,2)
- AUDIT_YN — CHAR(1)
- LEARN_OPINION_SCR — NUMBER(5,2)
- GRADE_MARK — VARCHAR2(2)
- GRADE_POINT — NUMBER(22,2)
- GRADE_AVG — NUMBER(22,2)
- PRE_CLASS_NO — VARCHAR2(30)
- UNIV_RANK — NUMBER(22,0)
- ETC_EVAL4_SCR — NUMBER(22,0)
- ETC_EVAL5_SCR — NUMBER(22,0)
- ETC_EVAL6_SCR — NUMBER(22,0)
- COURSE_ID_USER_NO — VARCHAR2(100)
- TERM_YEAR — VARCHAR2(4)
- TERM_CD — VARCHAR2(10)
- EXAMAPPLY_IP — VARCHAR2(50)
- SCR_CONFIRM_YN — VARCHAR2(1)
- … +34
TB_L_DEPT
- DEPT_ID — VARCHAR2(30) — 기본 키 — NOT NULL
- DEPT_NM — VARCHAR2(200)
- DEPT_NM_EN — VARCHAR2(200)
- ZIP — VARCHAR2(7)
- ADDR1 — VARCHAR2(200)
- ADDR2 — VARCHAR2(200)
- GROUP_CD — VARCHAR2(30)
- SUB_GROUP_CD — VARCHAR2(30)
- USE_YN — VARCHAR2(1)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- INSERT_GUBUN — VARCHAR2(1)
- MAP_LATITUDE — VARCHAR2(200)
- MAP_LONGITUDE — VARCHAR2(200)
- GU — VARCHAR2(30)
- DONG — VARCHAR2(30)
- UPPER_DEPT_ID — VARCHAR2(30)
- CAMPUS_CD — CHAR(1)
- DAEHAK_NM — VARCHAR2(200)
- DEPT_ORD — VARCHAR2(20)
TB_L_MENU
- MENU_ID — VARCHAR2(30) — 기본 키 — NOT NULL
- MENU_NM — VARCHAR2(200)
- MENU_NM_EN — VARCHAR2(200)
- MENU_NM_JA — VARCHAR2(200)
- MENU_NM_ZH — VARCHAR2(200)
- MENU_NM_AR — VARCHAR2(200)
- MENU_URL — VARCHAR2(255)
- MENU_TYPE — VARCHAR2(30)
- MENU_DEPTH — NUMBER(5,0)
- UPPER_MENU_ID — VARCHAR2(30)
- MENU_ORDERS — NUMBER(12,0)
- MODULE_NO — NUMBER(12,0)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(255)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- MENU_TARGET — VARCHAR2(30)
- REFERENCE_ASP_ID — VARCHAR2(200)
- MENU_DISPLAY_YN — CHAR(1)
- MENU_NM_TW — VARCHAR2(200)
- MENU_GROUP — NUMBER(5,0)
- MENU_COMMENT — VARCHAR2(2000)
- MENU_NM_JP — VARCHAR2(200)
- MENU_NM_CN — VARCHAR2(200)
- IMG_UPLOAD_PATH — VARCHAR2(2000)
- MENU_ICON — VARCHAR2(100)
- MENU_LINE_YN — CHAR(1)
TB_L_REPORT
- COURSE_ID — VARCHAR2(50) — 외래 키 → TB_L_COURSE.COURSE_ID — NOT NULL
- Key (REPORT_NO) — NUMBER — 외래 키 → TB_L_REPORT_APPLY.Key — NOT NULL
- REPORT_SEQ — NUMBER(2,0) — NOT NULL
- REPORT_NM — VARCHAR2(200)
- REPORT_CONTENT — VARCHAR2(4000)
- REPORT_FILE_SAVE_NM — VARCHAR2(500)
- REPORT_FILE_NM — VARCHAR2(200)
- REPORT_FILE_SIZE — NUMBER(20,0)
- REPORT_APPLY_METHOD — VARCHAR2(4000)
- REPORT_APPLY_STR_DT — VARCHAR2(14)
- REPORT_APPLY_END_DT — VARCHAR2(14)
- REPORT_OPEN_YN — VARCHAR2(1)
- RESULT_OPEN_YN — VARCHAR2(1)
- REPORT_WEIGHT — NUMBER(5,2)
- COPY_ANSWER_CHECK_YN — VARCHAR2(1)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- CLASS_NO — VARCHAR2(10)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- SCHEDULE_MAPPING_YN — VARCHAR2(1)
- REPORT_HANDICAP — NUMBER(5,2)
- ADD_STR_DT — VARCHAR2(14)
- ADD_END_DT — VARCHAR2(14)
- REPORT_OPEN_TYPE — CHAR(1)
- RESULT_OPEN_STR_DT — VARCHAR2(14)
- RESULT_OPEN_END_DT — VARCHAR2(14)
- REPORT_SOURCE_NO — NUMBER(12,0)
- ALLOT_SCR — NUMBER(5,2)
- USE_YN — CHAR(1)
- EXAM_NO — NUMBER(22,0)
- STAT_OPEN_YN — VARCHAR2(1)
- PLAN_YN — VARCHAR2(1)
- EVAL_COL_USE_YN — CHAR(1)
- EVAL_TYPE — CHAR(1)
- TEMP_SAVE_YN — CHAR(1)
- REPORT_GUBUN — VARCHAR2(1)
TB_L_REPORT_APPLY
- Key (REPORT_NO) — NUMBER — 기본 키 — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- SITE_ID — VARCHAR2(30) — NOT NULL
- ASP_ID — VARCHAR2(30) — NOT NULL
- COURSE_ID — VARCHAR2(30) — NOT NULL
- APPLY_CONTENT — CLOB
- APPLY_FILE_SAVE_NM — VARCHAR2(500)
- APPLY_FILE_NM — VARCHAR2(200)
- APPLY_FILE_SIZE — NUMBER(20,0)
- REPORT_SCR — NUMBER(5,2)
- REPORT_APPLY_CMT — CLOB
- COPY_ANSWER_YN — VARCHAR2(1)
- COPY_ANSWER_CMT — CLOB
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- CLASS_NO — VARCHAR2(10) — NOT NULL
- APPLY_YN — VARCHAR2(1)
- MARK_YN — VARCHAR2(1)
- APPLY_DT — VARCHAR2(14)
- MARK_DT — VARCHAR2(14)
- REPORT_SEQ — NUMBER(2,0) — NOT NULL
- REPORT_RATIO_SCR — NUMBER(5,2)
- UCC_URL — VARCHAR2(500)
- COPY_ANSWER_RATE — NUMBER(5,2)
- EXCELLENT_YN — CHAR(1)
- ATTACH_FILE_NM — VARCHAR2(200)
- ATTACH_FILE_SAVE_NM — VARCHAR2(500)
- ATTACH_FILE_SIZE — NUMBER(20,0)
- APPLY_FILE_YN — VARCHAR2(1) — NOT NULL
- PASS_YN — VARCHAR2(1)
- TEAM_NO — NUMBER
TB_L_REPORT_APPLY_ATTACH_FILE
- Key (REPORT_NO) — NUMBER — 외래 키 → TB_L_REPORT_APPLY.Key — NOT NULL
- REPORT_SEQ — NUMBER — NOT NULL
- ATTACH_FILE_SEQ — NUMBER — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- COURSE_ID — VARCHAR2(30) — NOT NULL
- CLASS_NO — VARCHAR2(10) — NOT NULL
- ATTACH_FILE_SAVE_NM — VARCHAR2(500) — NOT NULL
- ATTACH_FILE_NM — VARCHAR2(300) — NOT NULL
- ATTACH_FILE_SIZE — NUMBER(20,0) — NOT NULL
- SITE_ID — VARCHAR2(30) — NOT NULL
- ASP_ID — VARCHAR2(30) — NOT NULL
- INSERT_DT — VARCHAR2(14) — NOT NULL
- INSERT_USER_NO — VARCHAR2(30) — NOT NULL
- COMMENT_ATTACH_FILE_YN — VARCHAR2(1)
TB_L_ROLE
- ROLE_NO — NUMBER(12,0) — 기본 키 — NOT NULL
- ROLE_NM — VARCHAR2(200)
- ROLE_CMT — VARCHAR2(4000)
- SYSTEM_MNG_YN — VARCHAR2(1)
- USE_YN — VARCHAR2(1)
- USER_GROUP — VARCHAR2(30)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- ROLE_NM_EN — VARCHAR2(200)
TB_L_ROLE_MENU
- ROLE_NO — NUMBER(12,0) — 외래 키 → TB_L_ROLE.ROLE_NO — NOT NULL
- MENU_ID — VARCHAR2(30) — 외래 키 → TB_L_MENU.MENU_ID — NOT NULL
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
TB_L_SURVEY_APPLY
- SURVEY_NO — NUMBER(12,0) — 외래 키 — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- SURVEY_STR_DT — VARCHAR2(14)
- SURVEY_APPLY_DT — VARCHAR2(14)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- SURVEY_TARGET — VARCHAR2(30) — NOT NULL
- MIGRATION_YN — CHAR(1)
- SEQ_NO — NUMBER(1,0)
- SURVEY_TARGET_ID — VARCHAR2(100) — NOT NULL
TB_L_SURVEY_APPLY_LOG
- SURVEY_QUESTION_NO — NUMBER(12,0) — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- SURVEY_ANSWER — VARCHAR2(4000)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- SURVEY_TARGET — VARCHAR2(30) — NOT NULL
- SURVEY_ETC — VARCHAR2(4000)
- MIGRATION_YN — CHAR(1)
- SEQ_NO — NUMBER(1,0)
- GRADE — CHAR(1)
- SURVEY_TARGET_ID — VARCHAR2(100) — NOT NULL
- SURVEY_NO — NUMBER(12,0) — 외래 키 — NOT NULL
TB_L_USER
- USER_NO — VARCHAR2(30) — 기본 키 — NOT NULL
- DEPT_ID — VARCHAR2(30) — 외래 키 → TB_L_DEPT.DEPT_ID — NOT NULL
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- GROUP_CD — VARCHAR2(30)
- SUB_GROUP_CD — VARCHAR2(30)
- USER_ID — VARCHAR2(30)
- USER_PASSWORD — VARCHAR2(200)
- LAST_NAME — VARCHAR2(200)
- FIRST_NAME — VARCHAR2(200)
- LAST_NAME_EN — VARCHAR2(200)
- FIRST_NAME_EN — VARCHAR2(200)
- SEX — VARCHAR2(1)
- BIRTHDAY — VARCHAR2(10)
- FOREIGNER_YN — VARCHAR2(1)
- YNUNIV_USER_YN — VARCHAR2(1)
- EMAIL — VARCHAR2(200)
- EMAIL_OPEN_YN — VARCHAR2(1)
- PHONE_NO — VARCHAR2(40)
- PHONE_NO_OPEN_YN — VARCHAR2(1)
- CELLPHONE_NO — VARCHAR2(100)
- CELLPHONE_NO_OPEN_YN — VARCHAR2(1)
- ZIP — VARCHAR2(100)
- ADDR1 — VARCHAR2(200)
- ADDR2 — VARCHAR2(200)
- ADDR_NO_OPEN_YN — VARCHAR2(1)
- PICTURE_FILE_PATH — VARCHAR2(1000)
- PICTURE_OPEN_YN — VARCHAR2(150)
- SMS_YN — VARCHAR2(1)
- EMAIL_YN — VARCHAR2(1)
- WITHDRAW_YN — VARCHAR2(1)
- WITHDRAW_REASON — VARCHAR2(4000)
- WITHDRAW_DT — VARCHAR2(14)
- USER_DUPLICATE_INFO — VARCHAR2(64)
- COMPANY_NM — VARCHAR2(200)
- DIVISION_NM — VARCHAR2(200)
- POSITION_NM — VARCHAR2(200)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- INTRO — VARCHAR2(4000)
- NICKNAME — VARCHAR2(20)
- INSERT_GUBUN — VARCHAR2(1)
- USER_TYPE — VARCHAR2(1)
- DEPT_NM — VARCHAR2(200)
- MOBILE_PASSWORD — VARCHAR2(200)
- USER_NM — VARCHAR2(20)
- HOMEPAGE — VARCHAR2(200)
- CHANGE_PW_YN — VARCHAR2(1) — NOT NULL
- GRADE — CHAR(1)
- PKI_DN — VARCHAR2(255)
- MIGRATION_YN — CHAR(1)
- PW_UPD_YN — CHAR(1)
- CELLPHONE_NO2 — VARCHAR2(20)
- DEPT_NM_EN — VARCHAR2(200)
- USER_STATE — VARCHAR2(100)
- JOB — VARCHAR2(30)
- INFO_MSG_YN — VARCHAR2(1)
- LOGIN_ACCESS_STR_DT — VARCHAR2(14)
- … +19
TB_L_USER_MILEAGE_LOG
- COURSE_ID — VARCHAR2(50) — 외래 키 → TB_L_COURSE.COURSE_ID — NOT NULL
- LOG_NO — NUMBER
- USER_NO — VARCHAR2(200) — NOT NULL
- POINT — NUMBER
- INSERT_USER_NO — VARCHAR2(200)
- INSERT_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(200)
- UPDATE_DT — VARCHAR2(14)
- SAVE_USE_FLAG — VARCHAR2(20)
- MILEAGE_TYPE — VARCHAR2(100) — NOT NULL
- CERTIFY_YN — VARCHAR2(1) — NOT NULL
- SAVE_USE_DT — VARCHAR2(14)
- TERM_YEAR — VARCHAR2(20) — NOT NULL
- TERM_CD — VARCHAR2(20) — NOT NULL
- MIGRATION_YN — VARCHAR2(1)
- REASON — VARCHAR2(300)
- DETAIL — VARCHAR2(300)
TB_L_USER_ROLE
- USER_NO — VARCHAR2(30) — 외래 키 → TB_L_USER.USER_NO — NOT NULL
- ROLE_NO — NUMBER(12,0) — 외래 키 → TB_L_ROLE.ROLE_NO — NOT NULL
- ROLE_USE_STRDAY — VARCHAR2(8)
- ROLE_USE_ENDDAY — VARCHAR2(8)
- USE_YN — VARCHAR2(1)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- INSERT_GUBUN — VARCHAR2(1)
- MIGRATION_YN — CHAR(1)
TB_N_COURSE_DETAIL
- COURSE_ID — VARCHAR2(50) — 외래 키 → TB_L_COURSE.COURSE_ID — NOT NULL
- REQ_CONT — VARCHAR2(2)
- PNT_ONE — NUMBER
- PNT_MAX — NUMBER
- COURSE_GRADE — VARCHAR2(20)
- AVG_SCR_MIN — VARCHAR2(20)
- AVG_SCR_MAX — VARCHAR2(20)
- TOEIC_MIN — NUMBER
- TOEIC_MAX — NUMBER
- INSERT_DT — VARCHAR2(20)
- INSERT_USER_NO — VARCHAR2(20)
- UPDATE_DT — VARCHAR2(20)
- UPDATE_USER_NO — VARCHAR2(20)
- COURSE_TERM — VARCHAR2(100)
- APP_CONT — VARCHAR2(2)
- COURSE_TARGET — VARCHAR2(20)
- CLASS_DESC — VARCHAR2(100)
- MAJOR_DESC — VARCHAR2(200)
- MODULE — VARCHAR2(20)
- GUBUN_TYPE — VARCHAR2(20)
- TEAM_YN — VARCHAR2(2)
- LINK_URL — VARCHAR2(200)
- LINK_NM — VARCHAR2(200)
- JOIN_PAY — NUMBER
- PHON_NO — VARCHAR2(200)
- PROGRAM_TYPE — VARCHAR2(20)
- CERTIFY_YN — VARCHAR2(1)
- CERTIFY_PNT — VARCHAR2(5 CHAR)
- APPLY_METHOD — VARCHAR2(500)
- CENTER_DEPT_FLAG — VARCHAR2(1)
- HOST_GUBUN — VARCHAR2(100)
- APPROVE_YN — VARCHAR2(1)
- SUBJECT_YN — VARCHAR2(1)
- APPLY_PART — VARCHAR2(10)
- APPLY_PROGRAM — VARCHAR2(10)
- COMPARE_SCHEDULE_YN — VARCHAR2(1)
- OPER_SUMMARY — VARCHAR2(500)
- OPER_PARTICI_TARGET — VARCHAR2(500)
- OPER_RESOURCES — VARCHAR2(2)
- OPER_PERFORM_MANAGE — VARCHAR2(500)
- OPER_ACTIVI_TIME — VARCHAR2(500)
- OPER_SCHOLAR_POINT — NUMBER
- OPER_BUDGET — NUMBER
- OPER_BENEFIT — VARCHAR2(1000)
- RESULT_SATISFY — VARCHAR2(1000)
- RESULT_INSERT_DT — VARCHAR2(20)
- RESULT_INSERT_USER_NO — VARCHAR2(20)
- RESULT_UPDATE_DT — VARCHAR2(20)
- RESULT_UPDATE_USER_NO — VARCHAR2(20)
- RESULT_BUDGET — NUMBER
- CERT_ACHIEVE_STANDARDS — VARCHAR2(1000)
- MAIN_CORE_CD — VARCHAR2(50)
TB_S_EXAM
- EXAM_NO — NUMBER(12,0) — 기본 키 — NOT NULL
- EXAM_PARENT — NUMBER(12,0)
- COURSE_ID — VARCHAR2(30)
- CLASS_NO — VARCHAR2(10)
- EXAM_TITLE — VARCHAR2(200)
- EXAM_CONTENT — CLOB
- TOTAL_SCORE — NUMBER(5,0)
- QUE_COUNT — NUMBER(5,0)
- APP_COUNT — NUMBER(5,0)
- SUB_RATIO — NUMBER(5,2)
- EXAM_WEIGHT — NUMBER(5,2)
- EXAM_TIME — NUMBER(5,0)
- EXAM_ODATE — VARCHAR2(14)
- EXAM_SDATE — VARCHAR2(14)
- EXAM_EDATE — VARCHAR2(14)
- RANGE_SJUCHA — NUMBER(5,0)
- RANGE_EJUCHA — NUMBER(5,0)
- EXAM_TYPE — VARCHAR2(30)
- MARK_TYPE — VARCHAR2(30)
- EVAL_TYPE — VARCHAR2(30)
- EXAM_OPT — NUMBER
- USE_YN — VARCHAR2(1)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- EXAM_CATEGORY — CHAR(1)
- ALLOT_SCR — NUMBER(5,0)
- BASIC_SCORE — NUMBER(5,2)
- REEXAM_SDATE — VARCHAR2(14)
- REEXAM_EDATE — VARCHAR2(14)
- SCORE_SDATE — VARCHAR2(14)
- SCORE_EDATE — VARCHAR2(14)
- WEEK_NO — NUMBER
- SEQ_NO — NUMBER
- APPROVAL_YN — CHAR(1)
- VIEW_CNT — NUMBER
- WRONGANSWER_OPEN_YN — CHAR(1)
- IP_CHECK — CHAR(1)
- PLAN_YN — VARCHAR2(1)
- COMMON_CD — VARCHAR2(30)
- CENTER_CD — VARCHAR2(100)
- TERM_YEAR — VARCHAR2(4)
- EXAM_USER_STATE — VARCHAR2(3)
- AVG_SCR — NUMBER
TB_S_EXAMAPPLOG
- EXAM_NO — NUMBER(12,0) — 외래 키 → TB_S_EXAM.EXAM_NO — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- QUE_NO — NUMBER(12,0) — NOT NULL
- APPLY_ANS — VARCHAR2(4000)
- APPLY_CMT — CLOB
- CORRECT_YN — VARCHAR2(1)
- APPQUE_ORDER — NUMBER(3,0)
- APPLY_EXPS — VARCHAR2(200)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- MARK_SCORE — NUMBER(6,2)
- APPBAK_ANS — VARCHAR2(4000)
- APPBAK_CMT — CLOB
- APPBAK_EXPS — VARCHAR2(200)
- APPBAK_CORRYN — VARCHAR2(1)
- CHECK_ANS — VARCHAR2(1)
TB_S_EXAMAPPLY
- EXAM_NO — NUMBER(12,0) — 외래 키 → TB_S_EXAM.EXAM_NO — NOT NULL
- USER_NO — VARCHAR2(30) — NOT NULL
- APPLY_STIME — VARCHAR2(14)
- APPLY_ETIME — VARCHAR2(14)
- EVAL_TIME — VARCHAR2(14)
- EXAM_SCORE — NUMBER(6,2)
- APPLY_DESC — VARCHAR2(4000)
- ELAPSED — NUMBER(14,0)
- APPLY_OPT — NUMBER
- USE_YN — VARCHAR2(1)
- CONN_IP — VARCHAR2(20)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)
- UPDATE_DT — VARCHAR2(14)
- UPDATE_USER_NO — VARCHAR2(30)
- ATTACH_FILE_SAVE_NM — VARCHAR2(500)
- ATTACH_FILE_NM — VARCHAR2(200)
- ATTACH_FILE_SIZE — NUMBER(20,0)
- APPBAK_STIME — VARCHAR2(14)
- APPBAK_ETIME — VARCHAR2(14)
- APPBAK_SCORE — NUMBER(5,2)
- APPBAK_ELAPSED — NUMBER(14,0)
- TIME_STOP_YN — VARCHAR2(1)
- APPLY_OPT_FINISH — NUMBER
- PERMISSION_IP — VARCHAR2(50)
- PROF_BACKUP_YN — VARCHAR2(1)
- RESULT_CMT — VARCHAR2(1000)
- GRADE — CHAR(1)
- DEPT_ID — VARCHAR2(200)
- SEX — VARCHAR2(1)
- TEMP_EXAM_TIME — NUMBER(5,0)
- TEMP_SAVE_DT — VARCHAR2(14)
TB_S_EXAMPAPER
- EXAM_NO — NUMBER(12,0) — 외래 키 → TB_S_EXAM.EXAM_NO — NOT NULL
- QUE_NO — NUMBER(12,0) — 외래 키 — NOT NULL
- QUE_SCORE — NUMBER(6,2)
- QUE_ORDER — NUMBER(3,0)
- SITE_ID — VARCHAR2(30)
- ASP_ID — VARCHAR2(30)
- INSERT_DT — VARCHAR2(14)
- INSERT_USER_NO — VARCHAR2(30)