Pebble
Tables (10)
ActivityLog
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- date — DATE — NOT NULL
- completedCount — 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)
- isCompleted — BOOLEAN — NOT NULL
- 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
Milestone
- id — INT — Primary key — NOT NULL
- categoryId — INT — Foreign key → Category.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- dateType — ENUM('SINGLE', 'RANGE', 'REPEAT') — NOT NULL
- startDate — DATE
- endDate — DATE
- repeatDays — VARCHAR(50)
- 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', 'TASK_DUE', 'REPORT') — NOT NULL
- relatedId — INT
- isRead — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
Report
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → User.id — NOT NULL
- month — VARCHAR(7) — NOT NULL
- gifUrl — VARCHAR(500) — NOT NULL
- expiresAt — DATETIME — NOT NULL
- createdAt — DATETIME — NOT NULL
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', 'CANCELLED', 'EXPIRED') — NOT NULL
- originalTransactionId — VARCHAR(255)
- 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
- milestoneId — INT — Foreign key → Milestone.id
- name — VARCHAR(200) — NOT NULL
- dateType — ENUM('SINGLE', 'RANGE', 'REPEAT') — NOT NULL
- startDate — DATE
- endDate — DATE
- repeatDays — VARCHAR(50)
- color — VARCHAR(20)
- isCompleted — BOOLEAN — NOT NULL
- completedAt — DATETIME
- displayOrder — INT — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
User
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- profileImageUrl — VARCHAR(500)
- bio — TEXT
- lastNicknameChangedAt — DATETIME
- notifyTaskDue — BOOLEAN — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL