테스트

테이블 (4)

comments

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

likes

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

posts

  • post_id — NUMBER
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • author_id — NUMBER — 외래 키 → users.user_id — NOT NULL
  • view_count — NUMBER
  • is_public — CHAR(1)
  • created_at — DATE
  • updated_at — DATE

users

  • user_id — NUMBER
  • username — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(255) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • role — VARCHAR2(20) — NOT NULL
  • created_at — DATE
  • updated_at — DATE