역량 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)