테스트2

테이블 (6)

attachments

  • id — NUMBER
  • post_id — NUMBER — 외래 키 → posts.id — NOT NULL
  • file_path — VARCHAR2(500) — NOT NULL
  • original_name — VARCHAR2(255)
  • uploaded_at — DATE — NOT NULL

boards

  • id — NUMBER
  • name — VARCHAR2(50) — NOT NULL
  • description — VARCHAR2(500)

comments

  • id — NUMBER
  • post_id — NUMBER — 외래 키 → posts.id — NOT NULL
  • user_id — NUMBER — 외래 키 → users.id — NOT NULL
  • parent_id — NUMBER — 외래 키 → comments.id
  • content — VARCHAR2(1000) — NOT NULL
  • created_at — DATE — NOT NULL

likes

  • user_id — NUMBER — 외래 키 → users.id — NOT NULL
  • post_id — NUMBER — 외래 키 → posts.id — NOT NULL
  • created_at — DATE — NOT NULL

posts

  • id — NUMBER
  • board_id — NUMBER — 외래 키 → boards.id — NOT NULL
  • user_id — NUMBER — 외래 키 → users.id — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • view_count — NUMBER — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE

users

  • id — NUMBER
  • email — VARCHAR2(100) — NOT NULL
  • password_hash — VARCHAR2(255) — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL
  • role — VARCHAR2(20) — NOT NULL
  • created_at — DATE — NOT NULL