project2
Tables (12)
bookmarks
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
categories
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- display_order — INT
chat_messages
- id — BIGINT
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP
chat_rooms
- id — BIGINT
- created_at — TIMESTAMP
comments
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- parent_id — BIGINT — Foreign key → comments.id — 대댓글인 경우 원댓글의 ID
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- deleted_at — TIMESTAMP
forbidden_words
- id — BIGINT
- word — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
notifications
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(20) — NOT NULL — COMMENT, REPLY, CHAT, NOTICE
- message — TEXT — NOT NULL
- reference_id — BIGINT — 이동할 상세 페이지의 PK
- is_read — BOOLEAN
- created_at — TIMESTAMP
post_likes
- id — BIGINT
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
posts
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- is_notice — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
reports
- id — BIGINT
- reporter_id — BIGINT — Foreign key → users.id — NOT NULL
- target_user_id — BIGINT — Foreign key → users.id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL — POST, COMMENT
- target_id — BIGINT — NOT NULL — 게시글 또는 댓글의 ID
- reason — TEXT — NOT NULL
- status — VARCHAR(20) — RECEIVED, PROCESSING, COMPLETED
- admin_comment — TEXT — EX
- created_at — TIMESTAMP
user_chat_rooms
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL — 로그인 ID
- password — VARCHAR(255) — NOT NULL — 암호화된 비밀번호
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(255)
- introduction — TEXT
- role — VARCHAR(20) — USER, ADMIN
- status — VARCHAR(20) — ACTIVE, WARNED, BANNED
- created_at — TIMESTAMP