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