OOTD

Tables (9)

COMMENT (댓글)

  • CommentId (댓글 ID) — INT — Primary key — NOT NULL — Auto Increment
  • DiaryId (게시글 ID) — INT — Foreign key → DIARY.DiaryId — NOT NULL — Auto Increment
  • UserId (사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment
  • CommentId (대상 댓글 ID) — INT — Foreign key → COMMENT.CommentId — 대댓글인 경우
  • CommentContent (댓글 내용) — TEXT — NOT NULL
  • CommentCreateDate (댓글 생성일자) — VARCHAR(255) — NOT NULL
  • CommentUpdateDate (댓글 수정일자) — VARCHAR(255) — NOT NULL
  • isUpdated (댓글 수정여부) — VARCHAR(255) — NOT NULL

DIARY (게시글)

  • DiaryId (게시글 ID) — INT — Primary key — NOT NULL — Auto Increment
  • UserId (사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment
  • DiaryTitle (게시글 제목) — TEXT — NOT NULL
  • DiaryContent (게시글 내용) — TEXT
  • DiaryCreateDate (게시글 생성일자) — VARCHAR(255) — NOT NULL
  • DiaryUpdateDate (게시글 수정일자) — VARCHAR(255) — NOT NULL
  • isUpdated (게시글 수정여부) — VARCHAR(255) — NOT NULL
  • DiaryPublicScope (게시글 공개범위) — VARCHAR(255) — NOT NULL — ALL, FOLLOW, ME

DIARY_IMAGE (게시글 사진)

  • DiaryImageId (게시글 옷 ID) — INT — Primary key — NOT NULL — Auto Increment
  • DressId (옷 ID) — INT — Foreign key → DRESS.DressId — NOT NULL — Auto Increment
  • DiaryId (게시글 ID) — INT — Foreign key → DIARY.DiaryId — NOT NULL — Auto Increment
  • ImageOrder (사진 순서) — INT — NOT NULL
  • ImageUrl (사진 URL) — TEXT — NOT NULL

DIARY_LIKE (게시글 좋아요)

  • DiaryLikeId (좋아요 ID) — INT — Primary key — NOT NULL — Auto Increment
  • DiaryId (게시글 ID) — INT — Foreign key → DIARY.DiaryId — NOT NULL — Auto Increment
  • UserId (사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment

DRESS (옷)

  • DressId (옷 ID) — INT — Primary key — NOT NULL — Auto Increment
  • UserId (사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment
  • DressName (옷 이름) — VARCHAER(255) — NOT NULL
  • DressType (옷 종류) — VARCHAR(255) — NOT NULL — 메모 참조
  • DressImgUrl (옷 대표이미지 URL) — TEXT — NOT NULL

FOLLOW (팔로우)

  • FollowId (팔로우 ID) — INT — Primary key — NOT NULL — Auto Increment
  • UserId (사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment
  • FolloweeId (대상 사용자 ID) — INT — Foreign key → USER.UserId — NOT NULL — Auto Increment
  • FollowStatus (팔로우 상태) — VARCHAR(255) — NOT NULL — ACTIVE, CANCELED

HASHTAG (해시태그)

  • HashTagId (해시태그 ID) — INT — Primary key — NOT NULL — Auto Increment
  • DiaryId (게시글 ID) — INT — Foreign key → DIARY.DiaryId — NOT NULL — Auto Increment
  • TagName (해시태그명) — VARCHAR(255) — NOT NULL — 메모 참조

USER (사용자)

  • UserId (사용자 ID) — INT — Primary key — NOT NULL — Auto Increment
  • Email (사용자 이메일) — VARCHAR(255) — NOT NULL
  • Password (사용자 비밀번호) — TEXT — NOT NULL
  • UserName (사용자 이름) — VARCHAR(255) — NOT NULL
  • FCMAccesToken (Access Token) — TEXT
  • ProfileIMG (사용자 프로필 이미지) — TEXT — NOT NULL
  • UserBirth (사용자 생년월일) — VARCHAR(255) — NOT NULL
  • UserRole (사용자 구분) — VARCHAR(255) — NOT NULL — USER, ADMIN

WEATHER (날씨)

  • WeatherId (날씨 ID) — INT — Primary key — NOT NULL — Auto Increment
  • DiaryId (게시글 ID) — INT — Foreign key → DIARY.DiaryId — NOT NULL — Auto Increment
  • Weather (날씨) — VARCHAR(255) — NOT NULL — 메모 참조