범용게시판ERD

테이블 (12)

board

  • id — uuid — 기본 키
  • public_id — uuid
  • name — varchar(255)
  • created_date — timestamp
  • description — text
  • community_id — uuid — 외래 키 → community.id

chat_message

  • id — uuid — 기본 키
  • public_id — uuid
  • content — text
  • created_datec (created_date) — timestamp
  • reports_count — int
  • chat_room_id (char_room_id) — uuid — 외래 키 → public_chat_room.id
  • member_id — uuid — 외래 키 → member.id

comment

  • id — uuid — 기본 키
  • public_id — uuid
  • title — varchar(255)
  • content — text
  • created_date — timestamp
  • modified_date — timestamp
  • upvotes_count — int
  • downvotes_count — int
  • post_id — uuid — 외래 키 → post.id
  • member_id — uuid — 외래 키 → member.id

community

  • id — uuid — 기본 키
  • public_id — uuid
  • introduction — text
  • posts_count — bigint
  • members_count — bigint
  • contact_info — varchar(255)
  • privacy_policy — text
  • terms — text
  • ads_info — text
  • company_info — text

draft_post

  • id — uuid — 기본 키
  • public_id — uuid
  • title — varchar(255)
  • content — TEXT
  • created_date — timestamp
  • board_id — uuid — 외래 키 → board.id
  • member_id — uuid — 외래 키 → member.id
  • category_id — uuid — 외래 키 → post_category.id

image

  • id — uuid — 기본 키
  • public_id — uuid
  • url — varchar(255)
  • size — bigint
  • uploaded_date — timestamp
  • extension — varchar(10)
  • post_id — uuid — 외래 키 → post.id
  • member_id — uuid — 외래 키 → member.id

member

  • id — uuid — 기본 키
  • public_id — uuid
  • nickname — varchar(255)
  • created_date — timestamp
  • modified_date — timestamp
  • signup_id — varchar(255)
  • signup_password — varchar(255)
  • email — varchar(255)
  • expiration_date — timestamp
  • account_locked — boolean
  • role — varchar(255)

message

  • id — uuid — 기본 키
  • public_id — uuid
  • content — text
  • created_date — timestamp
  • sender_id — uuid — 외래 키 → member.id
  • receiver_id — uuid — 외래 키 → member.id

post

  • id — uuid — 기본 키
  • public_id — uuid
  • title — varchar(255)
  • content — text
  • created_date — timestamp
  • modified_date — timestamp
  • views_count — bigint
  • upvotes_count — int
  • downvotes_count — int
  • is_featured — boolean
  • post_url — varchar(255)
  • board_id — uuid — 외래 키 → board.id
  • post_category_id — uuid — 외래 키 → post_category.id
  • member_id — uuid — 외래 키 → member.id

post_category

  • id — uuid — 기본 키
  • public_id — uuid
  • name — varchar(255)
  • description — text
  • board_id — uuid — 외래 키 → board.id

public_chat_room

  • id — uuid — 기본 키
  • public_id — uuid
  • name — varchar(255)
  • participants_count — int
  • description — text
  • created_date — timestamp
  • board_id — uuid — 외래 키 → board.id

video

  • id — uuid — 기본 키
  • public_id — uuid
  • url — varchar(255)
  • size — bigint
  • uploaded_date — timestamp
  • extension — varchar(10)
  • post_id — uuid — 외래 키 → post.id
  • member_id — uuid — 외래 키 → member.id