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