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