PentaCats

Tables (3)

Board (board)

  • ID (id) — Primary key — NOT NULL
  • Category (category)
  • Title (title)
  • Author (author) — keycloack에 있는 AuthorID
  • CreatedDate (created_date)
  • LastEditDate (last_edit_date)
  • Contents (contents)
  • ImageURI (image_uri)

Image (image)

  • ID (id) — Primary key — NOT NULL
  • Image (image)
  • BoardID (board_id) — Foreign key → Board.ID — NOT NULL

Reply (reply)

  • ID (id) — Primary key — NOT NULL
  • Contents (contents)
  • Depth (depth)
  • Author (author)
  • CreatedDate (created_date)
  • LastEditDate (last_edit_date)
  • BoardID (board_id) — Foreign key → Board.ID — NOT NULL
  • ParentID (parent_id) — Foreign key → Reply.ID — NOT NULL