NoticeBoard

Tables (4)

ChildComment (CHILD_COMMENT)

  • childComment (child_comment_id) — Long — Primary key — NOT NULL
  • parent (comment_id) — Long — Foreign key → CommentEntity.id — NOT NULL
  • post (post_id) — Long — Foreign key → PostEntity.id — NOT NULL
  • user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
  • content — String — NOT NULL
  • createdDateTime (create_at) — DATE — NOT NULL

CommentEntity (COMMENT)

  • id (comment_id) — Long — Primary key — NOT NULL
  • post (post_id) — Long — Foreign key → PostEntity.id — NOT NULL
  • user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
  • content — String — NOT NULL
  • createdDateTime (create_at) — DATE

PostEntity (POST)

  • id (post_id) — Long — Primary key — NOT NULL
  • user (user_id) — Long — Foreign key → UserEntity.id — NOT NULL
  • title — String — NOT NULL
  • content — String — NOT NULL
  • createdDateTime (created_at) — Date

UserEntity (USER)

  • id (user_id) — Long — Primary key — NOT NULL
  • email — String — NOT NULL
  • password — String — NOT NULL
  • nickname — String — NOT NULL
  • role — String — NOT NULL
  • createdDateTime (create_at) — Date — NOT NULL
  • profieImageUrl (profile_image_url) — String — NOT NULL