Pebble_be

Tables (13)

ActivityLog

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • date — DATE — NOT NULL — KST 기준
  • completedTaskCount — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Category

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL — 소유 유저(오너)
  • name — VARCHAR(100) — NOT NULL
  • color — VARCHAR(20) — NOT NULL
  • imageUrl — VARCHAR(500) — NULL이면 기본 이미지
  • isHidden — BOOLEAN — NOT NULL — 내 화면 숨김(하위 연동)
  • isPublic — BOOLEAN — NOT NULL — 팔로워 공개 여부
  • isCompleted — BOOLEAN — NOT NULL
  • isShared — BOOLEAN
  • displayOrder — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Follow

  • id — INT — Primary key — NOT NULL
  • followerId — INT — Foreign key → User.id — NOT NULL — 요청자
  • followingId — INT — Foreign key → User.id — NOT NULL — 대상
  • status — ENUM('PENDING', 'ACCEPTED') — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL — 수락 시각

Milestone

  • id — INT — Primary key — NOT NULL
  • categoryId — INT — Foreign key → Category.id — NOT NULL
  • seriesId — INT
  • name — VARCHAR(100) — NOT NULL
  • dateType — ENUM('SINGLE','RANGE','MULTI') — NOT NULL
  • startDate — DATE
  • endDate — DATE
  • isCompleted — BOOLEAN — NOT NULL
  • displayOrder — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Notification

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • type — ENUM('FOLLOW_REQUEST', 'FOLLOW_ACCEPTED', 'FOLLOW_REJECTED', 'TASK_DUE', 'MILESTONE_DUE', 'REPORT', 'CATEGORY_INVITE', 'CATEGORY_DELETED', 'CATEGORY_ACCEPTED ') — NOT NULL
  • relatedId — INT — type별 상이, FK 없음
  • isRead — BOOLEAN — NOT NULL
  • expiresAt — DATETIME — NOT NULL — 생성 후 30일 자동삭제
  • createdAt — DATETIME — NOT NULL

Report

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • month — VARCHAR(7) — NOT NULL — YYYY-MM
  • reportImageUrl — VARCHAR(500) — NOT NULL
  • expiresAt — DATETIME — NOT NULL — 발송 후 1주일
  • createdAt — DATETIME — NOT NULL
  • statsData — JSON

SharedCategoryMember

  • id — INT — Primary key — NOT NULL
  • categoryId — INT — Foreign key → Category.id — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • role — ENUM('OWNER', 'MEMBER') — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED') — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME

SocialAccount

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • provider — ENUM('google', 'naver') — NOT NULL
  • providerAccountId — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL

Subscription

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • status — ENUM('ACTIVE', 'CANCELED', 'EXPIRED') — NOT NULL
  • originalTransactionId — VARCHAR(255) — 애플 IAP
  • startDate — DATETIME — NOT NULL
  • endDate — DATETIME — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Task

  • id — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.id — NOT NULL
  • categoryId — INT — Foreign key → Category.id — NOT NULL
  • milestoneId — INT — Foreign key → Milestone.id — 종속=NOT NULL, 단일=NULL
  • name — VARCHAR(100) — NOT NULL
  • dateType — ENUM('SINGLE', 'RANGE', 'MULTIPLE') — NOT NULL — SINGLE: startDate 사용, endDate null RANGE: startDate, endDate 사용 MULTI: startDate/endDate는 사용하지 않고 TaskDate에서 날짜 목록 관리
  • startDate — DATE
  • endDate — DATE
  • color — VARCHAR(20) — NOT NULL — 단일 태스크 색상. 종속 태스크는 상위 카테고리/마일스톤 색상을 따른다.
  • isCompleted — BOOLEAN — NOT NULL
  • completedAt — DATETIME — KST 일별 집계 기준, 해제 시 NULL
  • displayOrder — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

TaskDate (Untitled)

  • id — INT — Primary key — NOT NULL
  • taskId — INT — Foreign key → Task.id — NOT NULL
  • date — DATE
  • isCompleted — BOOLEAN
  • completecdAt (completedAt) — DATETIME
  • createdAt — DATETIME
  • updatedAt (updateAt) — DATETIME

TaskException (Untitled2)

  • id — INT — Primary key — NOT NULL
  • taskDateId — INT — Foreign key → TaskDate.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • color — VARCHAR(20) — NOT NULL
  • createdAt — DATETIME
  • updatedAt (updateAt) — DATETIME

User

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — bcrypt 해시, 소셜은 NULL
  • nickname — VARCHAR(100) — NOT NULL — 중복 허용
  • uniqueTag — VARCHAR(10) — NOT NULL — 닉네임#태그의 태그값(4자리)
  • profileImageUrl — VARCHAR(500)
  • bio — TEXT
  • lastNicknameChangedAt — DATETIME — 15일 쿨다운
  • activityColor — VARCHAR(20) — 징검다리 색상
  • notifyTaskDue — BOOLEAN — NOT NULL
  • refreshToken — VARCHAR(500) — 로그아웃 시 파기용(해시 저장)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • theme — ENUM('LIGHT', 'DARK') — NOT NULL — 앱 테마 (PLB-042
  • isTempPassword — BOOLEAN — NOT NULL — 임시 비번 상태, TRUE면 새 비번 설정 강제