RuleUp
Tables (29)
Challenge
- id — BINARY(16) — Primary key — NOT NULL
- creatorId — BINARY(16) — Foreign key → User.id — NOT NULL — 방장(OWNER), 위임 시 변경
- title — VARCHAR(30) — NOT NULL
- description — VARCHAR(200)
- imageUrl — VARCHAR(500)
- category — VARCHAR(20) — NOT NULL
- participationType — VARCHAR(10) — NOT NULL — SOLO/GROUP
- minMannerTemperature — DECIMAL(4, 1)
- maxParticipants — INT
- repeatDays — JSON — NOT NULL
- startDate — DATE — NOT NULL
- endDate — DATE — NOT NULL
- templateId — BIGINT — Foreign key → RoutineTemplate.id
- verificationConfig — JSON — NOT NULL
- params — JSON — NOT NULL
- penaltyConfig — JSON — NOT NULL
- rewardConfig — JSON — NOT NULL
- anonymity — VARCHAR(10) — NOT NULL — REAL/ANONYMOUS
- status — VARCHAR(10) — NOT NULL — UPCOMING/ACTIVE/COMPLETED
- moderationStatus — VARCHAR(20) — NOT NULL — NONE/PENDING_REVIEW/APPROVED/REJECTED
- fixDeadline — DATETIME(6)
- aiAssisted — TINYINT(1) — NOT NULL
- participantCount — INT — NOT NULL
- trendingScore — DOUBLE — NOT NULL
- failCount — INT — NOT NULL
- verificationType — VARCHAR(10) — AUTO/MANUAL 승격 컬럼
ChallengeDelegation
- id — BINARY(16) — Primary key — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- requesterId — BINARY(16) — Foreign key → User.id — NOT NULL
- targetUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- status — VARCHAR(10) — NOT NULL — PENDING/ACCEPTED/REJECTED/CANCELED/EXPIRED
- expiresAt — DATETIME(6) — NOT NULL
- resolvedAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
ChallengeMember
- id — BINARY(16) — Primary key — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- role — VARCHAR(10) — NOT NULL — OWNER/MANAGER/MEMBER
- status — VARCHAR(10) — NOT NULL — PENDING/ACTIVE/LEFT/REMOVED
- joinedAt — DATETIME(6) — NOT NULL
- todayStatus — VARCHAR(20) — PENDING/SUCCESS/FAILED_PROVISIONAL/FAILED/NOT_TARGET/NOT_REQUIRED
- lastSyncedAt — DATETIME(6)
- curPeriodStart — DATE
- curPeriodEnd — DATE
- curPeriodCompleted — INT
- anchors — JSON
- anchorUpdatedAt — DATETIME(6)
- screenApps — JSON
- screenAppsAppliedFrom — DATETIME(6)
- pendingScreenApps — JSON
- pendingScreenAppsEffectiveDate — DATE
- screenAppsUpdatedAt — DATETIME(6)
- fallbackUsedPeriodStart — DATE
- ghostPushedAt — DATETIME(6)
DeviceToken
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- platform — VARCHAR(10) — NOT NULL
- lastSeenAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
InvitationSignup
- id — BINARY(16) — Primary key — NOT NULL
- inviterUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- inviteeUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- occurredAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
InviteCode
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- code — VARCHAR(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
Milestone
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- dedupKey — VARCHAR(60) — NOT NULL
- label — VARCHAR(100) — NOT NULL
- achievedAt — DATE — NOT NULL
Notice
- id — BINARY(16) — Primary key — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- authorId — BINARY(16) — Foreign key → User.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- pinned — TINYINT(1) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
NoticeRead
- id — BINARY(16) — Primary key — NOT NULL
- noticeId — BINARY(16) — Foreign key → Notice.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- readAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
Notification
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- type — VARCHAR(40) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- readAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
Objection
- id — BINARY(16) — Primary key — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- challengeMemberId — BINARY(16) — Foreign key → ChallengeMember.id — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- targetDate — DATE — NOT NULL
- type — VARCHAR(20) — NOT NULL — FAILURE
- content — VARCHAR(1000) — NOT NULL
- imageUrl — VARCHAR(500)
- status — VARCHAR(10) — NOT NULL — PENDING/APPROVED/REJECTED
- deadline — DATETIME(6) — NOT NULL
- decidedBy — BINARY(16) — Foreign key → User.id
- decidedAt — DATETIME(6)
- decisionReason — VARCHAR(500)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
PushOutbox
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- targetDate — DATE — NOT NULL
- type — VARCHAR(40) — NOT NULL
- signalType — VARCHAR(40)
- status — VARCHAR(20) — NOT NULL
- scheduledAt — DATETIME(6) — NOT NULL
- sentAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
RefreshToken
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- tokenHash — VARCHAR(255) — NOT NULL
- expiresAt — DATETIME(6) — NOT NULL
- revokedAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
ReputationScore
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- mannerTemperature — DECIMAL(4,1) — NOT NULL
- lastQualifyingDate — DATE
- lastCalculatedDate — DATE
- peakTemperature — DECIMAL(4,1)
- peakAchievedAt — DATE
ReputationSnapshot
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- snapshotDate — DATE — NOT NULL
- temperature — DECIMAL(4,1) — NOT NULL
- delta — DECIMAL(4,1) — NOT NULL
- label — VARCHAR(40)
- createdAt — DATETIME(6) — NOT NULL
RoutineOutcome
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- challengeMemberId — BINARY(16) — Foreign key → ChallengeMember.id — NOT NULL
- templateId — BIGINT — Foreign key → RoutineTemplate.id
- category — VARCHAR(20)
- targetDate — DATE — NOT NULL
- status — VARCHAR(16) — NOT NULL
- verifiedVia — VARCHAR(20)
- failureReason — VARCHAR(40)
- confirmedAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
RoutineTemplate
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- category — VARCHAR(20) — NOT NULL
- paramKeys — JSON
- rationale — VARCHAR(255)
RoutineVerification
- templateId — BIGINT — Foreign key → RoutineTemplate.id — NOT NULL
- autoVerificationType — VARCHAR(20)
- autoSignalSource — VARCHAR(20)
- autoWearableReq — VARCHAR(20)
- autoExternalService — VARCHAR(40)
SegmentTypeWeight
- segmentType — VARCHAR(20) — Primary key — NOT NULL
- weight — DECIMAL(6,4) — NOT NULL
- sampleSize — BIGINT — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
TemplateStats
- templateId — BIGINT — Foreign key → RoutineTemplate.id — NOT NULL
- usageCount — BIGINT — NOT NULL
- completedParticipants — BIGINT — NOT NULL
- totalParticipants — BIGINT
User
- id — BINARY(16) — Primary key — NOT NULL
- oauthProvider — VARCHAR(20) — NOT NULL — KAKAO/NAVER/GOOGLE/APPLE
- oauthSubject — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(255) — NOT NULL
- nicknameStatus — VARCHAR(20) — NOT NULL — PENDING/APPROVED/REJECTED
- profileImageUrl — VARCHAR(255)
- profileImageStatus — VARCHAR(20) — NOT NULL
- moderationCheckedAt — DATETIME(6)
- interestCategories — JSON — NOT NULL
- countryCode — VARCHAR(2)
- birthDate — DATE
- gender — VARCHAR(20)
- platform — VARCHAR(16) — ANDROID/IOS
- appVersionCode — INT
- appVersionName — VARCHAR(32)
- osVersion — VARCHAR(32)
- sdkInt — INT
- deviceModel — VARCHAR(64)
- manufacturer — VARCHAR(64)
- lowRam — TINYINT(1)
- deviceInfoUpdatedAt — DATETIME(6)
- nicknameChangedAt — DATETIME(6)
- deletedAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
UserAgreement
- id — BINARY(16) — Primary key — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- agreementType — VARCHAR(30) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- revokedAt — DATETIME(6)
- agreedAt — DATETIME(6) — NOT NULL
VerificationDaily
- id — BINARY(16) — Primary key — NOT NULL
- challengeMemberId — BINARY(16) — Foreign key → ChallengeMember.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- userId — BINARY(16) — Foreign key → User.id — NOT NULL
- targetDate — DATE — NOT NULL
- method — VARCHAR(40)
- failureReason — VARCHAR(40)
- windowClosesAt — DATETIME(6)
- finalizeAfter — DATETIME(6)
- verifiedAt — DATETIME(6)
- verifiedVia — VARCHAR(20) — AUTO/MANUAL/MANUAL_FALLBACK/OBJECTION
- disputeClosesAt — DATETIME(6) — 이의 제기 창 마감
- fallbackApprovalStatus — VARCHAR(20)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
VerificationMethodResult
- id — BINARY(16) — Primary key — NOT NULL
- verificationDailyId — BINARY(16) — Foreign key → VerificationDaily.id — NOT NULL
- method — VARCHAR(40) — NOT NULL
- polarity — VARCHAR(20)
- evidence — JSON
- lastEvaluatedAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
Watcher
- id — BINARY(16) — Primary key — NOT NULL
- invitationId — BINARY(16) — Foreign key → WatcherInvitation.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- inviterUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- type — VARCHAR(20)
- channel — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- watcherUserId — BINARY(16) — Foreign key → User.id
- contactMasked — VARCHAR(32)
- displayName — VARCHAR(40)
- unsubscribeToken — VARCHAR(64)
- consentedAt — DATETIME(6)
- revokedAt — DATETIME(6)
- invitedAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL
WatcherBlock
- id — BINARY(16) — Primary key — NOT NULL
- inviterUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- subjectKey — VARCHAR(64) — NOT NULL
- blockedUntil — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
WatcherInvitation
- id — BINARY(16) — Primary key — NOT NULL
- token — VARCHAR(64) — NOT NULL
- inviterUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expiresAt — DATETIME(6) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
WatcherNotification
- id — BINARY(16) — Primary key — NOT NULL
- watcherId — BINARY(16) — Foreign key → Watcher.id — NOT NULL
- challengeId — BINARY(16) — Foreign key → Challenge.id — NOT NULL
- failedUserId — BINARY(16) — Foreign key → User.id — NOT NULL
- targetDate — DATE — NOT NULL
- channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- scheduledAt — DATETIME(6) — NOT NULL
- sentAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL
WatcherOtp
- id — BINARY(16) — Primary key — NOT NULL
- invitationId — BINARY(16) — Foreign key → WatcherInvitation.id — NOT NULL
- phoneHash — VARCHAR(64) — NOT NULL
- codeHash — VARCHAR(64) — NOT NULL
- expiresAt — DATETIME(6) — NOT NULL
- resendAvailableAt — DATETIME(6) — NOT NULL
- consumedAt — DATETIME(6)
- createdAt — DATETIME(6) — NOT NULL