Titae-ERD

Tables (19)

acheived_title (칭호)

  • Key (a-t-id) — int — Primary key — NOT NULL — 기본키값
  • Key (challenge-id) — int — Foreign key → challenge.Key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (name) — varchar(255) — NOT NULL — 칭호 이름
  • Field2 (acheived) — boolean — 장착 여부
  • Field3 (icon) — varchar(255) — 칭호 아이콘
  • Field4 (minCount) — int — 칭호 획득 횟수

attendance (출석)

  • Key (attendance-id) — int — Primary key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (date) — date — NOT NULL — 출석 날짜
  • Field2 (isAttended) — boolean — 출석 여부

budget (가계부)

  • Key (budget-id) — int — Primary key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (date) — varchar(255) — 가계부 생성날짜
  • Field2 (totalIncome) — decimal — 총 수입
  • Field3 (totalExpense) — decimal — 총 지출
  • Field4 (targetExpense) — decimal — 월 지출목표금액

budgetdetail (가계부 세부사항)

  • Key (budget_detail_id) — int — Primary key — NOT NULL — 기본키값
  • Key (budget-id) — int — Foreign key → budget.Key — NOT NULL — 기본키값
  • Field (content) — varchar(255) — 지출수입내용
  • Field2 (price) — decimal — 비용
  • Field3 (category) — varchar(255) — 항목
  • Field4 (date) — varchar(255) — 날짜
  • Field5 (type) — varchar(255) — NOT NULL — 수입 or 지출
  • Field6 (createdAt) — timestamp — 생성일자
  • Field7 (modifiedAt) — timestamp — 수정일자
  • Field8 (activated) — boolean — 삭제 여부

challenge (챌린지 목록)

  • Key (challenge-id) — int — Primary key — NOT NULL — 기본키값
  • Field (name) — varchar(255) — NOT NULL — 챌린지 이름
  • Field2 (description) — varchar(255) — 챌린지 설명
  • Field3 (type) — varchar(255) — NOT NULL — 챌린지 종류
  • Field4 (exp) — int — 경험치
  • Field5 (icon) — varchar(255) — 챌린지 아이콘
  • Field6 (total) — int — 성공기준횟수

challenge_count (챌린지 반복)

  • Key (challenge-count-id) — int — Primary key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Key (challenge-id) — int — Foreign key → challenge.Key — NOT NULL — 기본키값
  • Field (count) — int — 진행횟수(=progress)
  • Field2 (createdAt) — timestamp — 생성일자
  • Field3 (modifiedAt) — timestamp — 수정일자
  • Field4 (activated) — boolean — 삭제 여부

commuinity_post (게시글)

  • Key (post-id) — Long — Primary key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (title) — varchar(255) — NOT NULL — 게시글 제목
  • Field2 (content) — varchar(255) — 게시글 내용
  • Field3 (likeCount) — int — 좋아요 개수
  • Field4 (commentCount) — int — 댓글 개수
  • Field5 (category) — varchar(255) — 게시글 카테고리
  • Field6 (challengeCategory) — 챌린지 카테고리
  • Field7 (createdAt) — timestamp — 생성일자
  • Field8 (modifiedAt) — timestamp — 수정일자
  • Field9 (activated) — boolean — 삭제 여부

community_bookmark (북마크)

  • Key (c-bookmark-id) — int — Primary key — NOT NULL — 기본키값
  • Key (post-id) — Long — Foreign key → commuinity_post.Key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (createdAt) — timestamp — 생성일자
  • Field2 (modifiedAt) — boolean — 수정일자
  • Field3 (activated) — boolean — 삭제여부

community_comment (댓글)

  • Key (comment-id) — int — Primary key — NOT NULL — 기본키값
  • Key (post-id) — Long — Foreign key → commuinity_post.Key — NOT NULL — 기본키값
  • Key (memberId) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (comment) — text — NOT NULL — 댓글 내용
  • Field2 (createdAt) — timestamp — 생성일자
  • Field3 (modifiedAt) — timestamp — 수정일자
  • Field4 (activated) — boolean — 삭제 여부

community_like (좋아요)

  • Key (like-id) — int — Primary key — NOT NULL — 기본키값
  • Key (post-id) — Long — Foreign key → commuinity_post.Key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (createdAt) — timestamp — 생성일자
  • Field2 (modifiedAt) — boolean — 수정일자
  • Field3 (activated) — boolean — 삭제 여부

email_verification

  • Key (emailVerificationId) — Long — Primary key — NOT NULL
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (email) — VARCHAR(255) — NOT NULL
  • Field (verification_code) — VARCHAR(255) — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (expires_at) — TIMESTAMP — NOT NULL
  • Field (verified) — BOOLEAN — NOT NULL

festival (축제)

  • Key (festival-id) — int — Primary key — NOT NULL — 기본키값
  • Field (name) — varchar(255) — 축제이름
  • Field2 (location) — varchar(255) — 축제시군구
  • Field3 (category) — varchar(255) — 축제테마
  • Field4 (address) — varchar(255) — 상세주소
  • Field5 (startAt) — localDate — 시작날짜
  • Field (target) — varchar(255) — 주요고객
  • Field2 (createdAt) — timestamp — 생성날짜
  • Field3 (modifiedAt) — timestamp — 수정날짜
  • Field (activated) — boolean — 활성화
  • Field (url) — varchar(255) — 축제url
  • Field (longitude) — Float — 위도
  • Field2 (latitude) — Float — 경도
  • Field (endAt) — localDate — 종료날짜

invite_code

  • invite_code_id — BIGINT — Primary key — NOT NULL
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • code — VARCHAR(20) — NOT NULL
  • creator_id — BIGINT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used — BOOLEAN — NOT NULL
  • activated — BOOLEAN
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP

library (도서관)

  • Key (library-id) — Primary key — NOT NULL — 기본키값
  • Field (name) — varchar(255) — 도서관 이름
  • Field2 (address) — varchar(255) — 도서관 주소
  • Field3 (longitude) — Float — 도서관 위도
  • Field4 (latitude) — Float — 도서관 경도
  • Field5 (url) — varchar(255) — 도서관 홈페이지 주소
  • Field6 (activated) — boolean — 삭제 여부
  • Field7 (createdAt) — timestamp — 생성일자
  • Field (modifiedAt) — timestamp — 수정일자
  • Field (location) — varchar(255) — 축제시군구
  • Field (contact) — varchar(255)

member (회원)

  • Key (member-id) — Long — Primary key — NOT NULL — 기본키값
  • Field (email) — varchar(255) — NOT NULL — 이메일주소
  • Field (password) — varchar(255) — 비밀번호
  • Field2 (name) — varchar(255) — NOT NULL — 사용자이름
  • Field3 (role) — varchar(255) — NOT NULL — 계정역할
  • Field4 (phoneNumber) — varchar(255) — NOT NULL — 전화번호
  • Field5 (activated) — boolean — 계정활성화여부
  • Field6 (createdAt) — timestamp — 생성일자
  • Field7 (modifiedAt) — timestamp — 수정일자
  • Field8 (nickname) — varchar(255) — NOT NULL — 별명
  • Field (pofiileImage) — varchar(1024) — 프로필이미지
  • Field (level) — int — NOT NULL — 레벨
  • Field2 (totalExp) — int — NOT NULL — 누적 경험치
  • Field (goalAmount) — decimal — 목표금액
  • Field2 (goalStuff) — varchar(255) — 목표 물품
  • Field (equipped_title_id) — int — 장착한 칭호
  • Field (provider) — varchar(255) — 소셜로그인플랫폼
  • Field2 (kakaoId) — varchar(255) — 소셜로그인아이디
  • Field3 (socialEmail) — varchar(255) — 소셜이메일

notification (알림)

  • Key (notificationId) — Long — Primary key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (message) — varchar(255) — NOT NULL — 알림메세지
  • Field2 (isRead) — boolean — 읽음여부
  • Field3 (createdAt) — timestamp — 생성일자
  • Field4 (modifiedAt) — timestamp — 수정일자
  • Field5 (activated) — boolean — 삭제 여부
  • Field6 (senderId) — Long — NOT NULL — 보낸이
  • Field7 (type) — varchar(255) — 알림타입

place_bookmark (장소즐겨찾기)

  • Key (p-bookmark-id) — int — Primary key — NOT NULL — 기본키값
  • Key (library-id) — Foreign key → library.Key — NOT NULL — 기본키값
  • Key (store-id) — int — Foreign key → store.Key — NOT NULL — 기본키값
  • Key (festival-id) — int — Foreign key → festival.Key — NOT NULL — 기본키값
  • Key (member-id) — Long — Foreign key → member.Key — NOT NULL — 기본키값
  • Field (createdAt) — timestamp — 생성일자
  • Field2 (activated) — boolean — 삭제 여부

post_image (이미지첨부)

  • Key (image-id) — int — Primary key — NOT NULL — 기본키값
  • Key (post-id) — Long — Foreign key → commuinity_post.Key — NOT NULL — 기본키값
  • Field (imageUrl) — varchar(1024) — NOT NULL — 이미지 경로
  • Field2 (sortOrder) — int — 이미지 업로드 순서
  • Field3 (createdAt) — timestamp — 생성일자
  • Field4 (modifiedAt) — boolean — 수정일자
  • Field5 (activated) — boolean — 삭제여부

store (착한가게)

  • Key (store-id) — int — Primary key — NOT NULL — 기본키값
  • Field (name) — varchar(255) — 가게명
  • Field2 (address) — varchar(255) — 상세주소
  • Field3 (longitude) — Float — 위도
  • Field4 (latitude) — Float — 경도
  • Field5 (category) — varchar(255) — 식당/미용실/(업종)
  • Field (createdAt) — timestamp — 생성날짜
  • Field2 (modifiedAt) — timestamp — 수정날짜
  • Field3 (activated) — boolean — 활성화
  • Field (location) — varchar(255) — 시군
  • Field (firstmenu) — varchar(255) — 메뉴
  • Field2 (firstprice) — decimal — 가격
  • Field3 (secondmunu) — varchar(255) — 메뉴
  • Field4 (secondprice) — decimal — 가격
  • Field (thirdmenu) — varchar(255) — 메뉴
  • Field2 (thirdprice) — decimal — 가격
  • Field (contact) — Integer — 전화번호
  • Field (sido) — varchar(255) — 시도