test

Tables (6)

BOARD_FILE (게시판파일)

  • F_NUM (파일번호) — NUMBER — Primary key — NOT NULL
  • B_NUM (게시번호) — NUMBER — Foreign key → STUDY_BOARD&FREE_BOARD.B_NUM — NOT NULL
  • F_NAME (파일이름) — VARCHAR2(400)
  • ORINAME (Field) — VARCHAR2(400)

HEART (좋아요)

  • LIKE_NUM (번호) — NUMBER — Primary key — NOT NULL
  • B_NUM (게시번호) — NUMBER — Foreign key → STUDY_BOARD&FREE_BOARD.B_NUM — NOT NULL
  • USER_ID (아이디) — VARCHAR2(200)

LECTURE_EVALUATION (수강평)

  • NUM (번호) — NUMBER — Primary key — NOT NULL
  • WRITER (작성자) — VARCHAR2(200)
  • SCORE (수강평점수) — NUMBER
  • CONTENTS (내용) — CLOB
  • REG_DATE (게시날짜) — DATE
  • LECTURE_NUM (강의번호) — NUMBER

NOTICE (공지사항)

  • N_NUM (게시번호) — NUMBER — Primary key — NOT NULL
  • WRITER (작성자) — VARCHAR2(200)
  • TITLE (제목) — VARCHAR2(400)
  • REG_DATE (게시날짜) — DATE
  • HIT (조회수) — NUMBER
  • CONTENTS (내용) — CLOB

REPLY (댓글)

  • NUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • B_NUM (게시번호) — NUMBER — Foreign key → STUDY_BOARD&FREE_BOARD.B_NUM — NOT NULL
  • CONTENTS (내용) — CLOB
  • WRITER (작성자) — VARCHAR2(200)
  • REG_DATE (작성일) — DATE

STUDY_BOARD&FREE_BOARD (학습게시판/자유게시판)

  • B_NUM (게시번호) — NUMBER — Primary key — NOT NULL
  • WRITER (작성자) — VARCHAR2(200)
  • TITLE (제목) — VARCHAR2(400)
  • REG_DATE (게시날짜) — DATE
  • ANSWER (답변) — NUMBER
  • HIT (조회수) — NUMBER
  • CONTENTS (내용) — CLOB
  • CATEGORY (카테고리) — VARCHAR2(200)
  • REF (원본글) — NUMBER
  • STEP (순서) — NUMBER
  • DEPTH (깊이) — NUMBER
  • LIKE_COUNT (좋아요수) — NUMBER