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 — 선택한 투표