논문연구
테이블 (12)
TB_COURSE
- LECT_YEAR — 기본 키 — NOT NULL
- LECT_TERM — 기본 키 — NOT NULL
- CRS_CODE — 기본 키 — NOT NULL
- CRS_CODE (CRS_NAME)
- CRS_NAME (STATUS)
- STATUS (REGI_DATE)
TB_CRS_BOARD (강의실 자유게시판)
- USERID (Field6)
- TITLE (Field12)
- CONTENTS (Field2)
- FILENAME (Field5)
- REGI_USERID (Field)
- REGI_DATE (Field3)
- STATUS (Field4)
TB_CRS_NOTCIE (강의실 공지사항)
- LECT_YEAR (Key) — 기본 키 — NOT NULL
- LECT_TERM (Key2) — 기본 키 — NOT NULL
- CRS_CODE (Key3) — 기본 키 — NOT NULL
- SEQNO (Key5) — 기본 키 — NOT NULL
- USERID (Field6)
- TITLE (Field12)
- CONTENTS (Field2)
- FILENAME (Field5)
- REGI_USERID (Field)
- REGI_DATE (Field3)
- STATUS (Field4)
TB_CRS_PDS (강의실 자료실)
- USERID (Field6)
- TITLE (Field12)
- CONTENTS (Field2)
- FILENAME (Field5)
- REGI_USERID (Field)
- REGI_DATE (Field3)
- STATUS (Field4)
TB_CRS_QNA (강의실 질의응답)
- REFNO (Field7)
- USERID (Field6)
- TITLE (Field12)
- CONTENTS (Field2)
- FILENAME (Field5)
- REGI_USERID (Field)
- REGI_DATE (Field3)
- STATUS (Field4)
TB_HK_SCORE (수강생 과제 성적)
- HW_SEQNO (Key4) — 외래 키 → TB_HOMEWORK.HW_SEQNO — NOT NULL
- USERID (Key2) — 외래 키 → TB_HOMEWORK.USERID — NOT NULL
- LECT_YEAR (Key) — 외래 키 → TB_HOMEWORK.LECT_YEAR — NOT NULL
- LECT_TERM (Key22) — 외래 키 → TB_HOMEWORK.LECT_TERM — NOT NULL
- CRS_CODE (Key3) — 외래 키 → TB_HOMEWORK.CRS_CODE — NOT NULL
- SCORE (Field)
- FEEDBACK (Field12)
- STATUS (Field6)
- REGI_DATE (Field2)
- REGI_USERID (Field4)
- HW_SEQNO (Field8)
TB_HK_SUBMIT (수강생 과제 제출)
- HW_SEQNO (Key4) — 외래 키 → TB_HOMEWORK.HW_SEQNO — NOT NULL
- USERID (Key2) — 외래 키 → TB_HOMEWORK.USERID — NOT NULL
- LECT_YEAR (Key) — 외래 키 → TB_HOMEWORK.LECT_YEAR — NOT NULL
- LECT_TERM (Key22) — 외래 키 → TB_HOMEWORK.LECT_TERM — NOT NULL
- CRS_CODE (Key3) — 외래 키 → TB_HOMEWORK.CRS_CODE — NOT NULL
- SUBJECT (Field)
- CONTENTS (Field12)
- FILENAME (Field7)
- 1ST_DATE (Field3)
- 2ST_DATE (Field5)
- STATUS (Field6)
- REGI_DATE (Field2)
- REGI_USERID (Field4)
- HW_SEQNO (Field8)
TB_HOMEWORK (과제 리스트)
- HW_SEQNO (Key4) — 기본 키 — NOT NULL
- USERID (Key2) — 외래 키 → TB_MEMBER.USERID — NOT NULL
- LECT_YEAR (Key) — 외래 키 → TB_COURSE.LECT_YEAR — NOT NULL
- LECT_TERM (Key22) — 외래 키 → TB_COURSE.LECT_TERM — NOT NULL
- CRS_CODE (Key3) — 외래 키 → TB_COURSE.CRS_CODE — NOT NULL
- SUBJECT (Field)
- CONTENTS (Field12)
- FILENAME (Field7)
- 1ST_DATE (Field3)
- 2ST_DATE (Field5)
- STATUS (Field6)
- REGI_DATE (Field2)
- REGI_USERID (Field4)
- HW_SEQNO (Field8)
TB_LECTURE
- LECT_YEAR — 외래 키 → TB_COURSE.LECT_YEAR — NOT NULL
- LECT_TERM — 외래 키 → TB_COURSE.LECT_TERM — NOT NULL
- CRS_CODE — 외래 키 → TB_COURSE.CRS_CODE — NOT NULL
- STATUS
- REGI_DATE
- Field6
TB_MEMBER (수강생)
- USERID (Key) — 기본 키 — NOT NULL
- USER_NAME (Field2)
- USER_PASSWD (Field3)
- USER_SEX (Field11)
- USER_REGINO (Field4)
- ADDR1 (Field5)
- ADDR2 (Field6)
- ZIPCODE (Field7)
- MOBILE (Field8)
- USER_TYPE (Field9)
- USER_GRADE (Field10)
- STATUS (Field12)
TB_SCORE (과목성적)
- HW_SCORE (Field)
- EXAM_SCORE (Field2)
- ATT_SCORE (Field3)
- QUIZ_SOCRE (Field4)
- DISS_SCORE (Field5)
- PROJECT_SCORE (Field6)
- GRADE (Field7)
- TOTLA_SCORE (Field8)
- REGI_DATE (Field9)
TB_SURVEY (강의평가)
- SURVEY_SEQNO (Field)
- TITLE (Field2)
- CONTENTS (Field3)
- REGI_DATE (Field9)
- REGI_USERID (Field4)