MORU

Tables (17)

App

  • id — UUID — Primary key
  • name — VARCHAR(255) — NOT NULL
  • packageName — VARCHAR(255) — NOT NULL
  • iconUrl — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL

Routine

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • isSimple — BOOLEAN — NOT NULL
  • isPublic — BOOLEAN — NOT NULL
  • likeCount — INT — NOT NULL
  • requiredTime — TIME — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

RoutineApp

  • id — UUID — Primary key
  • routineId — UUID — NOT NULL
  • appId — UUID — NOT NULL
  • createdAt — DATETIME — NOT NULL

RoutineLike

  • id — UUID — Primary key
  • routineId — UUID — NOT NULL
  • userId — UUID — NOT NULL
  • createdAt — DATETIME — NOT NULL

RoutineLog

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • routineId — UUID — NOT NULL
  • startedAt — DATETIME — NOT NULL
  • endedAt — DATETIME — NOT NULL
  • totalTime — TIME — NOT NULL
  • createdAt — DATETIME — NOT NULL

RoutineSchedule

  • id — UUID — Primary key
  • routineId — UUID — NOT NULL
  • dayOfWeek — ENUM('MON', 'TUE', 'WED', 'THU', 'FRI', 'SAT', 'SUN') — NOT NULL
  • time — TIME — NOT NULL

RoutineScrap

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • routineId — UUID — NOT NULL
  • createdAt — DATETIME — NOT NULL

RoutineStep

  • id — UUID — Primary key
  • routineId — UUID — NOT NULL
  • estimatedTime — TIME
  • order — INT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

RoutineStepLog

  • id — UUID — Primary key
  • routineLogId — UUID — NOT NULL
  • stepOrder — INT — NOT NULL
  • note — TEXT — NOT NULL
  • actualTime — TIME — NOT NULL
  • startedAt — DATETIME — NOT NULL
  • endedAt — DATETIME — NOT NULL
  • pausedDurations — JSON

RoutineTag

  • id — UUID — Primary key
  • routineId — UUID — NOT NULL
  • tagId — UUID — NOT NULL
  • createdAt — DATETIME — NOT NULL

Tag

  • id — UUID — Primary key
  • name — VARCHAR(5) — NOT NULL
  • createdAt — DATETIME — NOT NULL

User

  • id — UUID — Primary key
  • nickname — VARCHAR(255) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • birthYear — INT — NOT NULL
  • bio — TEXT — NOT NULL
  • profileImageUrl — TEXT
  • createAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

UserFavoriteTag

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • tagId — UUID — NOT NULL
  • createdAt — DATETIME — NOT NULL

UserFollow

  • id — UUID — Primary key
  • followerId — UUID — Foreign key → User.id
  • followingId — UUID — Foreign key → User.id
  • createdAt — DATETIME — NOT NULL

UserInsight

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • insightDate — DATE — NOT NULL
  • totalRoutineCount — INT — NOT NULL
  • completedRoutineCount — INT — NOT NULL
  • completionRate — FLOAT — NOT NULL
  • focusedRoutineCount — INT — NOT NULL
  • simpleRouineCount — INT — NOT NULL
  • routineTimeSlotCounts — JSON — NOT NULL
  • adherenceRate — FLOAT — NOT NULL
  • totalStepCount — INT — NOT NULL
  • averageTimePerStep — TIME — NOT NULL
  • createdAt — DATETIME — NOT NULL

UserOnboarding

  • id — UUID — Primary key
  • userId — UUID — NOT NULL
  • stepCompleted — INT — NOT NULL
  • finishedAt — DATETIME
  • id (id2) — UUID — Foreign key → User.id

UserPermission

  • id — UUID — Primary key
  • userId — UUID — Foreign key → User.id
  • location — BOOLEAN — NOT NULL
  • notification — BOOLEAN — NOT NULL
  • createdAt — DATETIME — NOT NULL