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