25-1-capstone

Tables (5)

Boards (게시판)

  • id (Key) — Primary key — NOT NULL
  • type (유형) — tip, culture, question

Bookmarks (북마크 게시판)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Post.id — NOT NULL
  • user_id (작성자) — Foreign key → Post.user_id — NOT NULL
  • board_id (소속 게시판) — Foreign key → Post.board_id — NOT NULL
  • post_id (게시글)
  • user_id (사용자)
  • saved_at (스크랩 시간) — LocalDateTime.now()
  • Field

Comment (댓글)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → User.id — NOT NULL
  • id (Key3) — Foreign key → Post.id — NOT NULL
  • user_id (작성자2) — Foreign key → Post.user_id — NOT NULL
  • board_id (소속 게시판) — Foreign key → Post.board_id — NOT NULL
  • post_id (게시글)
  • user_id (작성자)
  • content (내용)
  • created_at (작성일) — LocalDateTime.now()

Post (게시글)

  • id (Key) — Primary key — NOT NULL
  • user_id (작성자) — Foreign key → User.id — NOT NULL
  • board_id (소속 게시판) — Foreign key → Boards.id — NOT NULL
  • title (제목)
  • content (내용)
  • created_at (작성일) — LocalDateTime.now()

User (유저)

  • id (Key) — Primary key — NOT NULL
  • name (이름(닉네임))
  • email (이메일)
  • password (비밀번호)
  • org (소속)
  • grade (등급) — yb, ob, admin
  • registered_at (가입일) — LocalDateTime.now()