onboarding-erd
Tables (7)
board_participation_requests (스터디 게시판 참여 요청)
- id (참여 요청 Pk) — BIGINT — Primary key — NOT NULL
- requester_id (요청자 PK) — BIGINT — Foreign key → members.id — NOT NULL
- target_board_id (게시판 PK) — BIGINT — Foreign key → boards.id — NOT NULL
- status (처리상태) — VARCHAR(20)
- reject_reason (반려 사유) — VARCHAR(255)
- request_reason (참여 사유) — TEXT
- created_at (요청일자) — TIMESTAMP
- updated_at (처리일자) — TIMESTAMP
- updated_by (마지막수정자) — BIGINT
board_permissions (게시판 권한)
- id (게시판 권한 PK) — BIGINT — Primary key — NOT NULL
- member_id (유저 PK) — BIGINT — Foreign key → members.id — NOT NULL
- board_id (게시판 PK) — BIGINT — Foreign key → boards.id — NOT NULL
- role (해당 유저가 가진 해당 게시판의 권한) — VARCHAR(255)
- created_at (생성일자) — TIMESTAMP
- deleted_at (삭제일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- updated_by (마지막수정자) — BIGINT
- deleted_by (삭제자) — BIGINT
boards (게시판)
- id (게시판 PK) — BIGINT — Primary key — NOT NULL
- url (게시판 URL) — VARCHAR(255)
- name (게시판 이름) — VARCHAR(255)
- description (게시판 설명) — VARCHAR(255)
- created_at (생성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- deleted_at (삭제일자) — TIMESTAMP
- write_level (작성 가능 여부) — VARCHAR(255)
- updated_by (마지막수정자) — BIGINT
- deleted_by (삭제자) — BIGINT
comments (댓글)
- id (댓글 PK) — BIGINT — Primary key — NOT NULL
- writer_id (유저 PK) — BIGINT — Foreign key → members.id — NOT NULL
- post_id (게시글 PK) — BIGINT — Foreign key → posts.id — NOT NULL
- content (내용) — TEXT
- created_at (생성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- deleted_at (삭제일자) — TIMESTAMP
- updated_by (마지막수정자) — BIGINT
- deleted_by (삭제자) — BIGINT
members (사용자)
- id (유저 PK) — BIGINT — Primary key — NOT NULL
- login_id (로그인 아이디) — VARCHAR(255)
- pw (패스워드) — VARCHAR(70)
- name (유저 이름) — VARCHAR(255)
- role (유저 권한) — VARCHAR(255)
- created_at (생성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- deleted_at (탈퇴일자) — TIMESTAMP
- updated_by (마지막수정자) — BIGINT
- deleted_by (삭제자) — BIGINT
post_files (첨부파일)
- id (첨부파일 PK) — BIGINT — Primary key — NOT NULL
- post_id (게시물 PK) — BIGINT — Foreign key → posts.id — NOT NULL
- path (저장 경로) — VARCHAR(255)
- category (저장된 파일 종류) — VARCHAR(255)
- original_name (사용자가 지정한 파일 이름) — VARCHAR(255)
- size (파일 크기) — BIGINT
- created_at (생성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- deleted_at (삭제일자) — TIMESTAMP
posts (게시글)
- id (게시글 PK) — BIGINT — Primary key — NOT NULL
- board_id (게시판 PK) — BIGINT — Foreign key → boards.id — NOT NULL
- writer_id (유저 PK) — BIGINT — Foreign key → members.id — NOT NULL
- title (제목) — VARCHAR(255)
- content (내용) — TEXT
- created_at (생성일자) — TIMESTAMP
- updated_at (수정일자) — TIMESTAMP
- deleted_at (삭제일자) — TIMESTAMP
- updated_by (마지막수정자) — BIGINT
- deleted_by (삭제자) — BIGINT
- plain_text (순수텍스트) — TEXT