hello
테이블 (9)
LIKE
- like_id — NUMBER
- post_id — NUMBER
- user_id — NUMBER
RECOMMEND
- recommend_id — NUMBER
- post_id — NUMBER
- user_id — NUMBER
게시글
- post_id — NUMBER
- board_type_id — NUMBER
- user_id — NUMBER
- title — VARCHAR2(200)
- content — CLOB
- view_count — NUMBER
- created_at — DATE
게시판종류
- board_type_id — NUMBER
- board_name — VARCHAR2(100)
댓글
- comment_id — NUMBER
- post_id — NUMBER
- user_id — NUMBER
- comment_text — VARCHAR2(1000)
- created_at — DATE
사용자
- user_id — NUMBER
- username — VARCHAR2(50)
- email — VARCHAR2(100)
- password — VARCHAR2(100)
좋아요
- like_id — NUMBER
- post_id — NUMBER
- user_id — NUMBER
첨부파일
- file_id — NUMBER
- post_id — NUMBER
- file_name — VARCHAR2(200)
- file_path — VARCHAR2(500)
추천
- recommend_id — NUMBER
- post_id — NUMBER
- user_id — NUMBER