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