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면 새 비번 설정 강제