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