범용게시판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