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