onboarding

Tables (8)

board_members

  • id — BIGINT
  • board_id — BIGINT — Foreign key → boards.id — NOT NULL — 게시판 ID (FK)
  • member_id — BIGINT — Foreign key → members.id — NOT NULL — 회원 ID (FK)
  • board_role — VARCHAR(50) — NOT NULL — 게시판 내 역할 (USER / MANAGER)

boards

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

comments

  • id — BIGINT — 댓글 고유 ID
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL — 대상 게시글 ID (FK)
  • member_id — BIGINT — Foreign key → members.id — NOT NULL — 작성자 ID (FK)
  • content — TEXT — NOT NULL — 댓글 내용
  • created_at — DATETIME — NOT NULL
  • parent_id — BIGINT
  • group_id — BIGINT
  • depth — BIGINT
  • is_deleted — BOOLEAN

members

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

post_assignees

  • id — BIGINT
  • post_id — BIGINT — NOT NULL — 대상 게시글 ID
  • member_id — BIGINT — NOT NULL — 담당자로 지정된 회원 ID

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

post_rejections

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL — 대상 게시글 ID (FK)
  • rejected_by — BIGINT — Foreign key → members.id — 반려한 관리자 ID (FK)
  • reason — TEXT — NOT NULL — 반려 사유
  • created_at — DATETIME — NOT NULL

posts

  • id — BIGINT — 게시글 고유 ID
  • board_id — BIGINT — Foreign key → boards.id — NOT NULL — 소속 게시판 ID (FK)
  • member_id — BIGINT — Foreign key → members.id — NOT NULL — 작성자 ID (FK)
  • title — VARCHAR(255) — NOT NULL — 게시글 제목
  • content — TEXT — NOT NULL — 게시글 본문
  • status — VARCHAR(255) — NOT NULL — 상태 (PROGRESS / REQUESTED / COMPLETED)
  • due_date — DATETIME — 마감일
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME