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)