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