5/6

Tables (15)

attachments

  • id — NUMBER
  • post_id — NUMBER — Foreign key → posts.id — NOT NULL
  • uploader_id — NUMBER — Foreign key → users.id — NOT NULL
  • file_path — VARCHAR2(500) — NOT NULL
  • original_name — VARCHAR2(255) — NOT NULL
  • file_size — NUMBER
  • file_type — VARCHAR2(50)
  • is_image — NUMBER(1)
  • uploaded_at — DATE — NOT NULL

boards

  • id — NUMBER
  • category_id — NUMBER — Foreign key → categories.id — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • description — VARCHAR2(500)
  • board_type — VARCHAR2(20) — NOT NULL
  • read_level — VARCHAR2(20) — NOT NULL
  • write_level — VARCHAR2(20) — NOT NULL
  • is_active — NUMBER(1) — NOT NULL
  • post_count — NUMBER
  • sort_order — NUMBER
  • created_at — DATE — NOT NULL

categories

  • id — NUMBER
  • name — VARCHAR2(50) — NOT NULL
  • sort_order — NUMBER
  • created_at — DATE — NOT NULL

comment_likes

  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • comment_id — NUMBER — Foreign key → comments.id — NOT NULL
  • created_at — DATE — NOT NULL

comments

  • id — NUMBER
  • post_id — NUMBER — Foreign key → posts.id — NOT NULL
  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • parent_id — NUMBER — Foreign key → comments.id
  • content — VARCHAR2(1000) — NOT NULL
  • is_anonymous — NUMBER(1)
  • status — VARCHAR2(20) — NOT NULL
  • like_count — NUMBER
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • deleted_at — DATE

hashtags

  • id — NUMBER
  • name — VARCHAR2(50) — NOT NULL
  • post_count — NUMBER
  • created_at — DATE — NOT NULL

messages

  • id — NUMBER
  • sender_id — NUMBER — Foreign key → users.id — NOT NULL
  • receiver_id — NUMBER — Foreign key → users.id — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • content — VARCHAR2(2000) — NOT NULL
  • is_read — NUMBER(1)
  • is_deleted_by_sender — NUMBER(1)
  • is_deleted_by_receiver — NUMBER(1)
  • sent_at — DATE — NOT NULL

notifications

  • id — NUMBER
  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • type — VARCHAR2(30) — NOT NULL
  • message — VARCHAR2(300) — NOT NULL
  • link_url — VARCHAR2(500)
  • is_read — NUMBER(1)
  • created_at — DATE — NOT NULL

post_hashtags

  • post_id — NUMBER — Foreign key → posts.id — NOT NULL
  • hashtag_id — NUMBER — Foreign key → hashtags.id — NOT NULL

post_likes

  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • post_id — NUMBER — Foreign key → posts.id — NOT NULL
  • like_type — VARCHAR2(10) — NOT NULL
  • created_at — DATE — NOT NULL

posts

  • id — NUMBER
  • board_id — NUMBER — Foreign key → boards.id — NOT NULL
  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • content_type — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • is_anonymous — NUMBER(1)
  • is_pinned — NUMBER(1)
  • view_count — NUMBER
  • like_count — NUMBER
  • comment_count — NUMBER
  • thumbnail — VARCHAR2(500)
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL
  • deleted_at — DATE

reports

  • id — NUMBER
  • reporter_id — NUMBER — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR2(20) — NOT NULL
  • target_id — NUMBER — NOT NULL
  • reason — VARCHAR2(50) — NOT NULL
  • description — VARCHAR2(500)
  • status — VARCHAR2(20) — NOT NULL
  • resolved_by — NUMBER — Foreign key → users.id
  • resolved_at — DATE
  • created_at — DATE — NOT NULL

scraps

  • id — NUMBER
  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • post_id — NUMBER — Foreign key → posts.id — NOT NULL
  • memo — VARCHAR2(200)
  • created_at — DATE — NOT NULL

user_activity_logs

  • id — NUMBER
  • user_id — NUMBER — Foreign key → users.id — NOT NULL
  • activity_type — VARCHAR2(30) — NOT NULL
  • point_delta — NUMBER
  • description — VARCHAR2(200)
  • created_at — DATE — NOT NULL

users

  • id — NUMBER
  • email — VARCHAR2(100) — NOT NULL
  • password_hash — VARCHAR2(255) — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL
  • profile_image — VARCHAR2(500)
  • bio — VARCHAR2(300)
  • role — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • point — NUMBER
  • warning_count — NUMBER
  • last_login_at — DATE
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL