PR_DM

Tables (8)

Category (category)

  • CategoryId (category_id) — Primary key — 카테고리PK
  • CategoryName (category_name) — Varchar(50) — 카테고리명

CategoryInPost (category_in_post)

  • CategoryId (category_id) — Foreign key → Category.CategoryId — 카테고리PK
  • PostId (post_id) — Long — Foreign key → POST.PostId — NOT NULL — 게시글PK

Comment (comment)

  • CommentId (comment_id) — Long — Primary key — 댓글PK
  • PostId (post_id) — Long — Foreign key → POST.PostId — NOT NULL — 게시글PK
  • UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL — 유저PK
  • CommentText (comment_text) — Varchar(255) — NOT NULL — 댓글 내용
  • CommentRegistDate (comment_regist_date) — datetime — NOT NULL — 댓글 등록 날짜

POST (post)

  • PostId (post_id) — Long — Primary key — NOT NULL — 게시글PK
  • UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL — 유저PK
  • PostTitle (post_title) — Varchar(255) — NOT NULL — 게시글 제목
  • PostText (post_text) — Varchar(255) — NOT NULL — 게시글 본문
  • PostRegistDate (post_regist_date) — datetime — 게시글 등록 날짜
  • PostView (post_view) — int — 게시글 조회수

PostImage (post_image)

  • PostImageId (post_image_id) — Primary key — 이미지 id 복합키
  • PostId (post_id) — Long — Foreign key → POST.PostId — NOT NULL — 게시글PK
  • PostImagePath (post_image_path) — 이미지 경로

PostLike (post_like)

  • PostId (post_id) — Long — Foreign key → POST.PostId — NOT NULL — 게시글PK
  • UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL — 유저PK

Refresh_Token (refresh_token)

  • UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL — 유저PK
  • RefreshToken (refresh_token) — Varchar(255) — NOT NULL — 리프레쉬 토큰

User (user)

  • UserId (user_id) — Long — Primary key — NOT NULL — 유저PK
  • NickName (user_nickname) — Varchar(50) — 닉네임
  • Field2