team board

Tables (8)

board_members

  • id — BIGINT
  • board_id — BIGINT — Foreign key → boards.id — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • board_role — VARCHAR(50) — NOT NULL

boards

  • id — BIGINT — 게시판 고유 ID
  • name — VARCHAR(255) — NOT NULL — 게시판 이름
  • color — VARCHAR(255) — NOT NULL — 색깔
  • description — TEXT — 게시판 설명
  • status — VARCHAR(255)

comments

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • content — TEXT — NOT NULL
  • parent_id — BIGINT
  • group_id — BIGINT
  • depth — INT
  • is_deleted — BOOLEAN
  • created_at — DATETIME — NOT NULL

members

  • id — BIGINT — 회원 고유 ID
  • username — VARCHAR(255) — NOT NULL — 로그인 아이디
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • role — VARCHAR(255) — NOT NULL — 시스템 권한

post_files

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • stored_path — VARCHAR(255) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • inline — TINYINT

post_members

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL — 대상 게시글 ID
  • member_id — BIGINT — Foreign key → members.id — NOT NULL — 담당자로 지정된 회원 ID

post_rejections

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • rejected_by — BIGINT — Foreign key → members.id
  • reason — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

posts

  • id — BIGINT
  • board_id — BIGINT — Foreign key → boards.id — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL — 작성자 ID
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • due_date — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME