jpa

Tables (5)

Comment (댓글)

  • id — Primary key — NOT NULL
  • content
  • uploadDate
  • post_id — Foreign key → Post.id — NOT NULL
  • member_id — Foreign key → Member.id — NOT NULL
  • comment_id (parent) — Foreign key → Comment.id — NOT NULL

Follow (팔로우)

  • id — Primary key — NOT NULL
  • member_id — Foreign key → Member.id — NOT NULL
  • follow_member_id (팔로우 되는 member) — Foreign key → Member.id — NOT NULL

Member (회원)

  • id — Primary key — NOT NULL
  • nickname (닉네임)
  • email
  • password
  • introduce (소개 글)
  • profileImage (프로필 이미지)
  • authority (권한)

Post (게시글)

  • id — Primary key — NOT NULL
  • content
  • member_id (member_fk) — Foreign key → Member.id — NOT NULL
  • uploadDate

PostImage (게시글 사진)

  • id — Primary key — NOT NULL
  • image (사진)
  • post_id — Foreign key → Post.id — NOT NULL