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 — 메모 참조