Medium

Tables (4)

Member (회원)

  • Member_Id (id) — BIG INT — Primary key — NOT NULL
  • 이메일 (email) — varchar(255)
  • 닉네임 (nickname) — varchar(255)
  • 비밀번호 (password) — varchar(255)
  • 멤버쉽 (isPaid) — boolean
  • 생성날짜 (createDate) — datetime(6)
  • 수정날짜 (modifiedDate) — datetime(6)

Post (게시글)

  • Post_Id (id) — BIG INT — Primary key — NOT NULL
  • Member_Id (author) — BIG INT — Foreign key → Member.Member_Id — NOT NULL
  • 제목 (title) — varchar(255)
  • 내용 (content) — text
  • 조회수 (viewCount) — BIG INT
  • 유료 여부 (isPaid) — boolean
  • 생성날짜 (createDate) — datetime(6)
  • 수정날짜 (modifiedDate) — datetime(6)

PostRecommend (게시글 추천)

  • PostRecommend_Id (id) — BIG INT — Primary key — NOT NULL
  • Member_Id (member_id) — BIG INT — Foreign key → Member.Member_Id — NOT NULL
  • Post_Id (post_id) — BIG INT — Foreign key → Post.Post_Id — NOT NULL

Token (토큰 (Redis))

  • Token_Id (id) — Primary key — NOT NULL
  • 리프레쉬 토큰 (refreshToken)
  • 회원 아이디 (memberId)