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