논문연구

테이블 (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)