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