ERD_LMS

Tables (49)

ALLOCATION

  • ALT_DT — VARCHAR2(10) — Primary key — NOT NULL
  • ROOM_CD — NUMBER — Foreign key → ROOM.ROOM_CD — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • ALT_ST — DATE — NOT NULL
  • ALT_EN — DATE — NOT NULL

APPROVAL

  • APPR_CD — NUMBER — Primary key — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO — NOT NULL
  • EMP_NO — NUMBER — Foreign key → EMPLOYEE.EMP_NO — NOT NULL
  • APPR_CATE — NUMBER — NOT NULL
  • APPR_DT — DATE
  • APPR_SDT — DATE — NOT NULL
  • APPR_YN — NUMBER — NOT NULL
  • APPR_RSN — VARCHAR2(3000)

ATTACH

  • ATCH_FILE_ID — NUMBER — Primary key — NOT NULL
  • FILE_SN — NUMBER — Primary key — NOT NULL
  • FILE_STRE_COURS — VARCHAR2(2000) — NOT NULL
  • STRE_FILE_NM — VARCHAR2(300) — NOT NULL
  • ORIGNL_FILE_NM — VARCHAR2(300) — NOT NULL
  • FILE_EXTSN — VARCHAR2(20) — NOT NULL
  • FILE_SIZE — NUMBER — NOT NULL
  • CREATE_DT — DATE — NOT NULL

ATTENADENCE

  • ATEN_DT — DATE — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • ATEN_CATE — VARCHAR2(20) — NOT NULL

A_SCHEDULE

  • COL — NUMBER — Primary key — NOT NULL
  • ASCH_MEM — VARCHAR2(4)
  • ASCH_CON — VARCHAR2(3000) — NOT NULL
  • ASCH_ST — DATE — NOT NULL
  • ASCH_EN — DATE — NOT NULL
  • ASCH_CATE — VARCHAR2(4) — NOT NULL

BUILING

  • BLD_CD — NUMBER — Primary key — NOT NULL
  • BLD_NM — VARCHAR2(300) — NOT NULL
  • BLD_SNM — VARCHAR2(200)

COMMON

  • COM_CD — VARCHAR2(10) — Primary key — NOT NULL
  • COM_NM — VARCHAR2(300) — NOT NULL
  • COM_CONT — VARCHAR2(3000) — NOT NULL
  • COM_REG — TIMESTAMP(6) — NOT NULL
  • COM_MEM — NUMBER — NOT NULL
  • COM_UPD_TS — TIMESTAMP(6)
  • COM_UPD_ID — NUMBER

COMMON_DETAIL

  • COMD_CD — VARCHAR2(10) — Primary key — NOT NULL
  • COM_CD — VARCHAR2(10) — Foreign key → COMMON.COM_CD — NOT NULL
  • COMD_NM — VARCHAR2(300) — NOT NULL
  • COMD_CON — VARCHAR2(3000) — NOT NULL
  • COMD_YN — VARCHAR2(4) — NOT NULL
  • COMD_ORDR — NUMBER — NOT NULL
  • COMD_REG — TIMESTAMP(6) — NOT NULL
  • COMD_MEM — NUMBER — NOT NULL
  • COMD_UPD_TS — TIMESTAMP(6)
  • COMD_UPD_ID — NUMBER

COUNSEL

  • CNSL_CD — NUMBER — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO
  • CNSL_CATE — VARCHAR2(20) — NOT NULL
  • CNSL_TTL — VARCHAR2(300) — NOT NULL
  • CNSL_CON — VARCHAR2(3000) — NOT NULL
  • CNSL_REG — DATE — NOT NULL
  • CNSL_DT — DATE — NOT NULL
  • CNSL_RPL — VARCHAR2(3000) — NOT NULL

CREDIT

  • CRD_CD — NUMBER — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • CRD_YR — NUMBER — NOT NULL
  • CRD_LV — NUMBER — NOT NULL
  • CRD_SEM — NUMBER — NOT NULL
  • CRD_MRC — NUMBER — NOT NULL
  • CRD_MOC — NUMBER — NOT NULL
  • CRD_CRC — NUMBER — NOT NULL
  • CRD_COC — NUMBER — NOT NULL
  • CRD_AC — NUMBER — NOT NULL

DEPARTMENT

  • DEP_CD — NUMBER — Primary key — NOT NULL
  • DEP_NM — VARCHAR2(50) — NOT NULL
  • DEP_DES — VARCHAR2(3000) — NOT NULL
  • PRO_NO — NUMBER — NOT NULL
  • DEP_CAP — NUMBER — NOT NULL
  • DEP_TEL — VARCHAR2(30) — NOT NULL
  • EMP_NO — NUMBER — Foreign key → EMPLOYEE.EMP_NO

EMPLOYEE

  • EMP_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • EMP_NM — VARCHAR2(300) — NOT NULL
  • EMP_NME — VARCHAR2(300) — NOT NULL
  • EMP_BIR — VARCHAR2(10) — NOT NULL
  • EMP_TEL — VARCHAR2(15) — NOT NULL
  • EMP_TEL2 — VARCHAR2(15)
  • EMP_ZIP — NUMBER — NOT NULL
  • EMP_ADDR1 — VARCHAR2(300) — NOT NULL
  • EMP_ADDR2 — VARCHAR2(300) — NOT NULL
  • EMP_REG — VARCHAR2(15) — NOT NULL
  • EMP_BANK_CD — VARCHAR2(10) — NOT NULL
  • EMP_DEPO — VARCHAR2(30) — NOT NULL
  • EMP_ACT — VARCHAR2(20) — NOT NULL
  • EMP_JOIN — DATE — NOT NULL
  • EMP_PIC — VARCHAR2(500) — NOT NULL
  • EMP_RET — DATE
  • EMP_DIV — VARCHAR2(100)
  • EMP_POS — VARCHAR2(100)

EVALUATION

  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • EVL_SCORE — NUMBER — NOT NULL
  • EVL_ETC — VARCHAR2(3000) — NOT NULL

EVALUATION_Q

  • EVLQ_CD — NUMBER — Primary key — NOT NULL
  • EVLQ_CON — VARCHAR2(3000) — NOT NULL

FACILITY

  • FAC_CD — NUMBER — Primary key — NOT NULL
  • FAC_NM — VARCHAR2(300) — NOT NULL

GRDT_CND

  • RDC_YR — NUMBER — Primary key — NOT NULL
  • DEP_CD — NUMBER — Foreign key → DEPARTMENT.DEP_CD — NOT NULL
  • RDC_GRD — NUMBER — NOT NULL
  • RDC_MRC — NUMBER — NOT NULL
  • RDC_MOC — NUMBER — NOT NULL
  • RDC_CRC — NUMBER — NOT NULL
  • RDC_COC — NUMBER — NOT NULL
  • RDC_REQ_CRD — NUMBER — NOT NULL

LECTURE

  • LECA_CD — NUMBER — Primary key — NOT NULL
  • SUB_CD — NUMBER — Foreign key → SUBJECT.SUB_CD — NOT NULL
  • LEC_YN — VARCHAR2(10) — NOT NULL
  • LEC_HCNT — NUMBER — NOT NULL
  • LECA_YN — VARCHAR2(10) — NOT NULL

LEC_APPLY

  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO
  • LECA_YR — NUMBER — NOT NULL
  • LECA_SEM — NUMBER — NOT NULL
  • LECA_NM — VARCHAR2(200) — NOT NULL
  • LECA_CON — VARCHAR2(3000) — NOT NULL
  • LECA_TRG — NUMBER — NOT NULL
  • LECA_CRD — NUMBER — NOT NULL
  • LECA_PER — NUMBER — NOT NULL
  • LECA_CAP — NUMBER — NOT NULL
  • LECA_TT — VARCHAR2(20) — NOT NULL
  • LECA_HALL — VARCHAR2(100) — NOT NULL
  • LECA_UNIT — NUMBER — NOT NULL
  • LECA_BOOK — VARCHAR2(1000)
  • LECA_NOTE — VARCHAR2(1000)
  • LECA_DT — DATE — NOT NULL
  • LECA_GRADE — NUMBER — NOT NULL
  • LECA_IMSI_YN — VARCHAR2(4) — NOT NULL
  • LECA_CATE — VARCHAR2(50) — NOT NULL
  • CRTR_MP — NUMBER — NOT NULL
  • CRTR_FP — NUMBER — NOT NULL
  • CRTR_TP — NUMBER — NOT NULL
  • CRTR_AP — NUMBER — NOT NULL

LEC_DATA

  • LDT_CD — NUMBER — Primary key — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • LDT_TTL — VARCHAR2(300) — NOT NULL
  • LDT_CON — VARCHAR2(3000) — NOT NULL
  • LDT_REG — DATE — NOT NULL
  • LDT_WRITER — VARCHAR2(30) — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL

LEC_NOTICE

  • LNTC_CD — NUMBER — Primary key — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • LNTC_TTL — VARCHAR2(300) — NOT NULL
  • LNTC_CON — VARCHAR2(3000) — NOT NULL
  • LNTC_REG — DATE — NOT NULL
  • LNTC_UPD — DATE — NOT NULL

LEC_QNA

  • LQNA_CD — NUMBER — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • LQNA_TTL — VARCHAR2(300) — NOT NULL
  • LQNA_CON — VARCHAR2(3000) — NOT NULL
  • LQNA_DT — DATE — NOT NULL
  • LQNA_HIT — NUMBER — NOT NULL

LEC_QNAR

  • LQNA_CD — NUMBER — Foreign key → LEC_QNA.LQNA_CD — NOT NULL
  • LQNAR_CON — VARCHAR2(3000) — NOT NULL
  • LQNAR_DT — DATE — NOT NULL

MEMBER

  • MEM_NO — NUMBER — Primary key — NOT NULL
  • MEM_TEL — VARCHAR2(15) — NOT NULL
  • MEM_PASS — VARCHAR2(500) — NOT NULL

NOTICE

  • NTC_CD — NUMBER — Primary key — NOT NULL
  • EMP_NO — NUMBER — Foreign key → EMPLOYEE.EMP_NO
  • NTC_TTL — VARCHAR2(500) — NOT NULL
  • NTC_CON — VARCHAR2(3000) — NOT NULL
  • NTC_CATE — VARCHAR2(4) — NOT NULL
  • NTC_DT — DATE — NOT NULL
  • NTC_HIT — NUMBER — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL

NOTIFICATION

  • NTF_CD — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • NTF_CON — VARCHAR2(300) — NOT NULL
  • NTF_TM — DATE — NOT NULL
  • NTF_READ — NUMBER — NOT NULL
  • NTF_CATE — VARCHAR2(50) — NOT NULL

OBJECTION

  • OBJ_CD — NUMBER — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • OBJ_TTL — VARCHAR2(300) — NOT NULL
  • OBJ_CON — VARCHAR2(3000) — NOT NULL
  • OBJ_DT — DATE — NOT NULL
  • OBJ_YN — NUMBER — NOT NULL
  • OBJ_RPL — VARCHAR2(3000) — NOT NULL

PAYMENT

  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • PAY_SEM — NUMBER — NOT NULL
  • PAY_DT — DATE — NOT NULL
  • PAY_AMT — NUMBER — NOT NULL
  • PAY_YN — NUMBER — NOT NULL

POPUP

  • POP_CD — NUMBER — Primary key — NOT NULL
  • POP_TTL — VARCHAR2(300) — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL
  • POP_SDT — DATE — NOT NULL
  • POP_EDT — DATE — NOT NULL
  • POP_YN — VARCHAR2(4) — NOT NULL

PORTLET

  • PO_CD — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • PO_CATE — VARCHAR2(4) — NOT NULL
  • PO_SEQ — VARCHAR2(4) — NOT NULL
  • PO_YN — NUMBER — NOT NULL

POST_MSG

  • PM_CD — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • PM_SEN — NUMBER — NOT NULL
  • PM_TTL — VARCHAR2(300) — NOT NULL
  • PM_CON — CLOB — NOT NULL
  • PM_IMSI_YN — VARCHAR2(4) — NOT NULL
  • PM_TM — DATE — NOT NULL
  • PM_ST — VARCHAR2(4) — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL

PROFESSOR

  • PRO_NO — NUMBER — Foreign key → EMPLOYEE.EMP_NO — NOT NULL
  • DEP_CD — NUMBER — Foreign key → DEPARTMENT.DEP_CD — NOT NULL
  • PRO_POS — VARCHAR2(100) — NOT NULL

QNA_REPLY

  • QRPL_CD — NUMBER — Foreign key — NOT NULL
  • EMP_NO — NUMBER — Foreign key → EMPLOYEE.EMP_NO
  • QRPL_CON — VARCHAR2(3000) — NOT NULL
  • QRPL_DT — DATE — NOT NULL

RECORD

  • REC_CD — NUMBER — Primary key — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • RGB_CD — VARCHAR2(10) — NOT NULL
  • REC_YR — NUMBER — NOT NULL
  • REC_SEM — NUMBER — NOT NULL
  • REC_PER — NUMBER — NOT NULL
  • REC_RSN — VARCHAR2(3000) — NOT NULL
  • REC_DT — DATE — NOT NULL
  • REC_YN — NUMBER — NOT NULL
  • REC_REJ — VARCHAR2(3000)

RESERVATION

  • RSV_CD — NUMBER — Primary key — NOT NULL
  • FAC_CD — NUMBER — Foreign key → FACILITY.FAC_CD — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • RSV_ST — DATE — NOT NULL
  • RSV_EN — DATE — NOT NULL

ROOM

  • ROOM_CD — NUMBER — Primary key — NOT NULL
  • BLD_CD — NUMBER — Foreign key → BUILING.BLD_CD — NOT NULL
  • ROOM_NO — NUMBER — NOT NULL

SCHEDULE

  • SCH_CD — NUMBER — Primary key — NOT NULL
  • MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • SCH_TTL — VARCHAR2(300) — NOT NULL
  • SCH_ST — DATE — NOT NULL
  • SCH_ET — DATE — NOT NULL

SCHOLARSHIP

  • SCL_CD — NUMBER — Primary key — NOT NULL
  • SCL_NM — VARCHAR2(500) — NOT NULL
  • SCL_AMT — NUMBER — NOT NULL
  • SCL_DETAIL — VARCHAR2(3000) — NOT NULL
  • SCL_CAP — NUMBER — NOT NULL

SCL_HISTORY

  • SCLH_CD — NUMBER — Primary key — NOT NULL
  • SCL_CD — NUMBER — Foreign key → SCHOLARSHIP.SCL_CD — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO
  • SCLH_YR — NUMBER — NOT NULL
  • SCLH_SEM — NUMBER — NOT NULL
  • SCLH_DT — DATE — NOT NULL
  • SCLH_YN — VARCHAR2(10) — NOT NULL
  • SCLH_PAY_YN — VARCHAR2(10) — NOT NULL
  • SCLH_AMT — NUMBER
  • SCLH_RCMD — VARCHAR2(3000)

STUDENT

  • STU_NO — NUMBER — Foreign key → MEMBER.MEM_NO — NOT NULL
  • DEP_CD — NUMBER — Foreign key → DEPARTMENT.DEP_CD — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO
  • STU_YR — NUMBER — NOT NULL
  • STU_SEM — NUMBER — NOT NULL
  • STU_NM — VARCHAR2(300) — NOT NULL
  • STU_NME — VARCHAR2(300) — NOT NULL
  • STU_BIR — VARCHAR2(10) — NOT NULL
  • STU_TEL — VARCHAR2(15) — NOT NULL
  • STU_ZIP — NUMBER — NOT NULL
  • STU_ADDR1 — VARCHAR2(300) — NOT NULL
  • STU_ADDR2 — VARCHAR2(300) — NOT NULL
  • STU_REG — VARCHAR2(15) — NOT NULL
  • STU_BANK_CD — VARCHAR2(10)
  • STU_DEPO — VARCHAR2(30)
  • STU_ACT — VARCHAR2(20)
  • STU_PIC — VARCHAR2(500) — NOT NULL

STU_LEC

  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL
  • SL_SCORE — NUMBER — NOT NULL

STU_TEST

  • ST_CD — NUMBER — Primary key — NOT NULL
  • TEST_CD — NUMBER — Foreign key → TEST.TEST_CD — NOT NULL
  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • ST_SCORE — NUMBER — NOT NULL
  • ST_YN — VARCHAR2(4) — NOT NULL

STU_TEST_DETAIL

  • ST_CD — NUMBER — Foreign key → STU_TEST.ST_CD — NOT NULL
  • TEST_CD — NUMBER — Foreign key → STU_TEST.TEST_CD — NOT NULL
  • TEQ_CD — NUMBER — Foreign key → TEST_Q.TEQ_CD — NOT NULL
  • STD_ANSWER — NUMBER — NOT NULL

SUBJECT

  • SUB_CD — NUMBER — Primary key — NOT NULL
  • PRO_NO — NUMBER — Foreign key → PROFESSOR.PRO_NO — NOT NULL
  • DEP_CD — NUMBER — Foreign key → DEPARTMENT.DEP_CD — NOT NULL
  • SUB_NM — VARCHAR2(500) — NOT NULL

TASK

  • TASK_CD — NUMBER — Primary key — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • TASK_NM — VARCHAR2(300) — NOT NULL
  • TASK_CON — VARCHAR2(3000) — NOT NULL
  • TASK_SDT — DATE — NOT NULL
  • TASK_EDT — DATE — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL

TASK_SUBMIT

  • TSUB_CD — NUMBER — Primary key — NOT NULL
  • TASK_CD — NUMBER — Foreign key → TASK.TASK_CD — NOT NULL
  • STU_NO — NUMBER — Foreign key → STU_LEC.STU_NO — NOT NULL
  • LECA_CD — NUMBER — Foreign key → STU_LEC.LECA_CD — NOT NULL
  • TSUB_DT — DATE — NOT NULL
  • TSUB_CON — VARCHAR2(3000) — NOT NULL
  • TSUB_SCORE — NUMBER — NOT NULL
  • ATCH_FILE_ID — NUMBER — NOT NULL

TEST

  • TEST_CD — NUMBER — Primary key — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • TEST_NM — VARCHAR2(300) — NOT NULL
  • TEST_CON — VARCHAR2(3000) — NOT NULL
  • TEST_REG — DATE — NOT NULL
  • TEST_SDT — DATE — NOT NULL
  • TEST_EDT — DATE — NOT NULL

TEST_Q

  • TEQ_CD — NUMBER — Primary key — NOT NULL
  • TEST_CD — NUMBER — Foreign key → TEST.TEST_CD — NOT NULL
  • TEQ_SEQ — NUMBER — NOT NULL
  • TEQ_OPTION1 — VARCHAR2(1000) — NOT NULL
  • TEQ_OPTION2 — VARCHAR2(1000) — NOT NULL
  • TEQ_OPTION3 — VARCHAR2(1000) — NOT NULL
  • TEQ_OPTION4 — VARCHAR2(1000) — NOT NULL
  • TEQ_ANSWER — NUMBER — NOT NULL

WEEKPLAN

  • WP_NO — NUMBER — Primary key — NOT NULL
  • LECA_CD — NUMBER — Foreign key → LEC_APPLY.LECA_CD — NOT NULL
  • WP_CON — VARCHAR2(3000) — NOT NULL

WISH

  • LECA_CD — NUMBER — Foreign key → LECTURE.LECA_CD — NOT NULL
  • STU_NO — NUMBER — Foreign key → STUDENT.STU_NO — NOT NULL