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