Saboten ERD
Tables (12)
TB_CategortInPost (tb_category_in_post)
- CategoryId (category_id) — Foreign key → TB_Category.CategoryId — NOT NULL — 카테고리PK
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK
TB_Category (tb_category)
- CategoryId (category_id) — Primary key — NOT NULL — 카테고리PK
- CategoryName (category_name) — Varchar(50) — NOT NULL — 카테고리명
TB_Comment (tb_comment)
- CommentId (comment_id) — Long — Primary key — NOT NULL — 게시글PK
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK
- UserID (user_id) — Long — Foreign key → TB_User.UserID — NOT NULL — 유저PK
- CommentText (comment_text) — Varchar(255) — NOT NULL — 댓글내용
- CommentLikeCount (comment_like_count) — Long — NOT NULL — 댓글 좋아요수
- CommentRegistDate (comment_regist_date) — datetime — NOT NULL — 댓글 등록날짜
TB_Post (tb_post)
- PostId (post_id) — Long — Primary key — NOT NULL — 게시글PK
- UserID (user_id) — Long — Foreign key → TB_User.UserID — NOT NULL — 유저PK
- PostTitle (post_title) — Varchar(255) — NOT NULL — 게시글 제목
- PostText (post_text) — Varchar(255) — NOT NULL — 게시글 본문
- PostLikeCount (post_like_count) — Long — NOT NULL — 게시글 찜(좋아요) 수-
- PostRegistDate (post_regist_date) — datetime — NOT NULL — 게시글 등록날짜
- PostModifyDate (post_modify_date) — datetime — 게시글 수정날짜
- Field — 스크랩
TB_PostImage (tb_post_image)
- PostImageId (post_image_id) — Primary key — NOT NULL — 이미지id 복합키
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK 복합키
- PostImage (post_image) — NOT NULL — 이미지 경로
TB_PostLike (tb_post_like)
- UserID (user_id) — Long — Foreign key → TB_User.UserID — NOT NULL — 유저PK
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK
TB_Refresh_Token (tb_refresh_token)
- UserID (user_id) — Long — Foreign key → TB_User.UserID — NOT NULL — 유저PK
- RefreshToken (refresh_token) — Varchar(255) — NOT NULL — 리프레쉬 토큰
TB_Setteing (tb_setting)
- terms_of_serviceID (Key) — Foreign key → TB_Terms_Of_Service.terms_of_serviceID — NOT NULL
TB_Terms_Of_Service (tb_terms_of_service)
- terms_of_serviceID (Key) — Primary key — NOT NULL
TB_User (tb_user)
- UserID (user_id) — Long — Primary key — NOT NULL — 유저PK
- NickName (user_nickname) — Varchar(50) — NOT NULL — 닉네임
- Age (user_age) — int — 나이대
- MyPageIntroduction (user_mypage_introduction) — Varchar(255) — 한줄 소개
- RegistDate (user_regist_date) — datetime — NOT NULL — 등록날짜
- ModifyDate (user_modify_date) — datetime — 수정날짜
- Gender (user_gender) — int — 1남,2여
TB_Vote (tb_vote)
- VoteId (vote_id) — Long — Primary key — NOT NULL
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK
- Topic (topic) — Varchar(24) — NOT NULL — 투표주제
- Count (count) — int — NOT NULL — 투표수
TB_VoteSelect (tb_vote_select)
- PostId (post_id) — Long — Foreign key → TB_Post.PostId — NOT NULL — 게시글PK
- UserID (user_id) — Long — Foreign key → TB_User.UserID — NOT NULL — 유저PK
- VoteResult (vote_result) — int — NOT NULL — 선택한 투표