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