This repository has been archived on 2026-11-17. You can view files and clone it, but cannot push or open issues or pull requests.
caelum0x 487e43129f fix(gitgram): fix broken messaging (Account/User id mismatch) + chat IDOR + SEO gap
Audited gitgram-ai end to end by actually running the backend against a
live Postgres instance (not just reading/trusting the existing Jest
suite, which mocks Prisma and therefore never hits real FK constraints
or real route wiring).

Critical, feature-breaking bug: Message.senderId/receiverId and
MessageReaction.userId are foreign keys into Account, but every
messaging controller function wrote/read req.userId (a User id) into
those columns directly. Verified live: every message send (1:1 DM and
group chat) failed with a Prisma foreign-key-constraint violation, and
group messages additionally violated the (until now) required
non-null receiverId column since group messages have no single
receiver. Messaging has never worked through this code path. Fixed by
resolving the caller's Account id once per request (matching the
`prisma.account.findFirst({ where: { userId } })` pattern already used
elsewhere in the codebase, e.g. followRequestController) and using it
consistently for every Message/MessageReaction read, write, and
ownership check, while keeping ChatMember/UserBlock/socket rooms on the
real User id they were already consistent with. Added a Prisma
migration making Message.receiverId nullable for group-only messages.
Verified against a live Postgres test database: registered 3 users,
created a group chat, sent and read 1:1 and group messages, reacted,
and marked conversations read -- all succeed now.

Cross-tenant IDOR (same bug class found on Scribase today): GET
/api/v1/messages/chats/:chatId had no membership check at all -- any
authenticated user could read any group chat's messages by chatId
alone (every sibling function in the same file -- getMessage,
reportMessage, assertMessageAccess -- already enforced membership, this
one endpoint was the outlier). Also hardened sendMessage so posting
into a chatId you don't belong to is rejected. Verified live: a
non-member now gets 403 on both reads and writes to a chat they're not
in; an actual member still gets 200.

Unrelated build blocker found while standing up the backend to test
this: gitgram/backend/tsconfig.json set `ignoreDeprecations: "6.0"`,
which the pinned typescript@^5.9.3 doesn't recognize -- `tsc`/`ts-node`
hard-error with TS5103 before compiling a single file. Backend could
not build or boot in dev mode at all. Fixed to "5.0".

SEO gap: gitgram/web (Next.js 14 app dir) had no robots.txt and no
sitemap anywhere, static or dynamic -- zero crawl directives, no
sitemap reference for search engines. Added app/robots.ts (disallows
authenticated-only surfaces, allows public ones) and app/sitemap.ts
(static public marketing/discovery routes).

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-10-24 22:20:32 +03:00

2356 lines
68 KiB
Plaintext

// NEW SCHEMA - Repository-as-Account Architecture
generator client {
provider = "prisma-client-js"
// "native" covers local dev; the debian/arm64 openssl-3 targets cover the
// node:20-bookworm-slim (glibc) Docker runtime on x64 and arm64 respectively.
binaryTargets = ["native", "debian-openssl-3.0.x", "linux-arm64-openssl-3.0.x"]
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
// ============================================
// CORE: Account System
// ============================================
enum AccountType {
USER
REPOSITORY
ORGANIZATION
}
enum UserRole {
USER
MODERATOR
ADMIN
SUPER_ADMIN
}
// Universal Account - can be User, Repository, or Organization
model Account {
id String @id @default(cuid())
type AccountType
username String @unique
displayName String?
avatar String?
bio String? @db.Text
verified Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
// Relations based on type
userId String? @unique
user User? @relation(fields: [userId], references: [id])
repositoryId String? @unique
repository Repository? @relation(fields: [repositoryId], references: [id])
organizationId String? @unique
organization Organization? @relation(fields: [organizationId], references: [id])
// Social features (available to all account types)
posts Post[]
stories Story[]
reels Reel[]
comments Comment[]
likes Like[]
followers Follow[] @relation("AccountFollowers")
following Follow[] @relation("AccountFollowing")
sentMessages Message[] @relation("MessageSender")
receivedMessages Message[] @relation("MessageReceiver")
messageReactions MessageReaction[]
@@index([type])
@@index([username])
}
// ============================================
// USER: Individual developers
// ============================================
model User {
id String @id @default(cuid())
email String @unique
password String?
username String? @unique
displayName String?
avatar String?
avatarUrl String?
bio String? @db.Text
role UserRole @default(USER)
githubId String? @unique
githubUsername String?
githubAccessToken String?
googleId String? @unique
emailVerified Boolean @default(false)
verified Boolean @default(false)
isPrivate Boolean @default(false)
// Viewer opt-in for author-self-labeled adult content. When false (default),
// posts an author marked as adult (sexual/nudity/porn) are hidden from this
// user's feed. See services/selfLabels.ts.
adultContentEnabled Boolean @default(false)
isBanned Boolean @default(false)
bannedAt DateTime?
bannedReason String?
isSuspended Boolean @default(false)
suspendedUntil DateTime?
suspendedReason String?
warningCount Int @default(0)
twoFactorEnabled Boolean @default(false)
twoFactorSecret String?
interests String[] @default([]) // User interests for recommendations (e.g., "typescript", "react", "ai")
location String?
latitude Float?
longitude Float?
lastLoginAt DateTime?
lastLoginIp String?
lastActiveAt DateTime? // Last time the user produced any activity (post/comment/like)
scheduledDeletion DateTime? // Date when account will be deleted (30-day grace period)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
// Link to Account
account Account?
// User can manage multiple repositories
managedRepos RepositoryManager[]
// User can be part of organizations
orgMemberships OrganizationMember[]
// Content relations
posts Post[]
comments Comment[]
likes Like[]
stories Story[]
reels Reel[]
snippets CodeSnippet[]
unifiedComments UnifiedComment[]
reelComments ReelComment[]
storyReplies StoryReply[]
storySettings StorySettings?
storyHighlights StoryHighlight[]
// Social
followers Follow[] @relation("UserFollowers")
following Follow[] @relation("UserFollowing")
sessions Session[]
subscription Subscription?
twoFactorAuth TwoFactorAuth?
// Phase 9 additions
linkedAccounts LinkedAccount[]
// Audit trail
auditLogs AuditLog[]
// Repository stars
stars Star[]
// Multi-account switching grants
switchGrantsGranted AccountSwitchGrant[] @relation("SwitchGrantOwner")
switchGrantsReceived AccountSwitchGrant[] @relation("SwitchGrantTarget")
@@index([email])
@@index([githubId])
@@index([username])
}
model Session {
id String @id @default(cuid())
userId String
refreshToken String @unique
expiresAt DateTime
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
}
// ============================================
// ACCOUNT SWITCH GRANT: explicit, revocable authorization for one user
// (ownerUser) to switch into / assume the session of another user
// (targetUser). Enables true multi-account switching without sharing
// credentials. A grant must exist and be active for switchAccount to
// produce a session for a *different* user.
// ============================================
model AccountSwitchGrant {
id String @id @default(cuid())
ownerUserId String // the user who is allowed to switch
targetUserId String // the account they may switch into
createdAt DateTime @default(now())
revokedAt DateTime?
ownerUser User @relation("SwitchGrantOwner", fields: [ownerUserId], references: [id], onDelete: Cascade)
targetUser User @relation("SwitchGrantTarget", fields: [targetUserId], references: [id], onDelete: Cascade)
@@unique([ownerUserId, targetUserId])
@@index([ownerUserId])
@@index([targetUserId])
}
// ============================================
// REPOSITORY: GitHub repos as social accounts
// ============================================
model Repository {
id String @id @default(cuid())
owner String // GitHub owner
name String // GitHub repo name
fullName String @unique // "owner/name"
// Link to Account (social profile)
account Account?
// GitHub data
description String? @db.Text
stars Int @default(0)
forks Int @default(0)
watchers Int @default(0)
language String?
topics String[]
htmlUrl String
isPrivate Boolean @default(false) // mirrors GitHub repo visibility
ownerAvatar String? // GitHub owner avatar URL (populated by sync)
// Additional GitHub data
openIssues Int @default(0)
lastFetched DateTime?
score Float @default(0)
trendingScore Float @default(0)
trending Boolean @default(false)
status String @default("active")
// Social stats
reactionsCount Int @default(0)
commentsCount Int @default(0)
postsCount Int @default(0)
followersCount Int @default(0)
viewsCount Int @default(0)
// Claiming & Management
claimedBy String? // User ID who claimed
claimedAt DateTime?
repositoryId String?
managers RepositoryManager[]
// Organization ownership (a repo may be transferred under an org)
organizationId String?
organization Organization? @relation(fields: [organizationId], references: [id], onDelete: SetNull)
// Content
posts Post[]
reels Reel[]
stories Story[]
snippets CodeSnippet[]
followers RepositoryFollow[]
// GitHub Webhooks & Activity
webhook GitHubWebhook?
activities RepositoryActivity[]
// AITM Change Story settings
aitmSettings RepositoryAitmSettings?
// Analytics
starredBy Star[]
referrers RepositoryReferrer[]
pathViews RepositoryPathView[]
clones RepositoryClone[]
// Metadata
lastSynced DateTime @default(now())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([owner, name])
@@index([owner])
@@index([claimedBy])
@@index([organizationId])
@@index([trending])
}
enum ManagerRole {
OWNER
ADMIN
EDITOR
VIEWER
}
model RepositoryManager {
id String @id @default(cuid())
repositoryId String
userId String
role ManagerRole @default(EDITOR)
createdAt DateTime @default(now())
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([repositoryId, userId])
@@index([userId])
}
// ============================================
// ORGANIZATION: Companies/Teams
// ============================================
model Organization {
id String @id @default(cuid())
name String
slug String @unique
// Link to Account
account Account?
// Organization data
description String? @db.Text
website String?
location String?
// Members
members OrganizationMember[]
// Repositories owned by this organization
repositories Repository[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([slug])
}
enum OrgRole {
OWNER
ADMIN
MEMBER
}
model OrganizationMember {
id String @id @default(cuid())
organizationId String
userId String
role OrgRole @default(MEMBER)
createdAt DateTime @default(now())
organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([organizationId, userId])
@@index([userId])
}
// ============================================
// SOCIAL: Posts, Stories, Reels
// ============================================
enum PostType {
POST
TEXT
IMAGE
VIDEO
REEL
STORY
REPOSITORY
CHANGE_STORY
}
model Post {
id String @id @default(cuid())
accountId String // Can be user, repo, or org account
userId String?
projectId String?
repositoryId String?
content String @db.Text
mediaUrls String[]
repoUrl String?
checkpointRef String? // AITM checkpoint ID for change story posts
aitmCheckpointId String? @map("aitm_checkpoint_id")
aitmProjectId String? @map("aitm_project_id")
aitmCheckpointRef Json? @map("aitm_checkpoint_ref") // stores { sha, message, files, createdAt }
type PostType @default(POST)
status String @default("PUBLISHED") // PUBLISHED, DRAFT, SCHEDULED
isArchived Boolean @default(false)
archivedAt DateTime?
// Author self-labeling / content warnings (ported from Bluesky SELF_LABELS).
// Voluntary, author-applied sensitivity tags. Each maps to a hide-or-warn
// behavior in the feed pipeline. Adult labels (sexual, nudity, porn) hide by
// default; graphic-media and spoiler warn (blur) by default.
selfLabels String[] @default([]) // e.g. ["sexual", "graphic-media", "spoiler"]
contentWarning String? // optional free-text warning shown alongside the label
// Detected spoken/natural language of the post body, as an ISO 639-1/639-2
// code (e.g. "en", "es", "pt"). Distinct from programming-language fields on
// Repository/Project. Used by the feed pipeline's preferredLangOnly tuner step
// to filter content to a viewer's natural-language preferences. Null when the
// language could not be detected; such posts are never filtered out.
contentLanguage String?
// Optional geotagging for map / nearby discovery
location String?
latitude Float?
longitude Float?
likesCount Int @default(0)
commentsCount Int @default(0)
sharesCount Int @default(0)
viewsCount Int @default(0)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
repository Repository? @relation(fields: [repositoryId], references: [id], onDelete: SetNull)
comments Comment[]
likes Like[]
hashtags PostHashtag[]
savedBy SavedPost[]
linkPreviews LinkPreview[]
views PostView[]
@@index([accountId])
@@index([userId])
@@index([repositoryId])
@@index([checkpointRef])
@@index([aitmCheckpointId])
@@index([aitmProjectId])
@@index([createdAt])
@@index([isArchived])
@@index([contentLanguage])
}
model Comment {
id String @id @default(cuid())
postId String
accountId String
userId String?
parentId String? // For nested replies
content String @db.Text
likesCount Int @default(0)
isPinned Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
parent Comment? @relation("CommentReplies", fields: [parentId], references: [id], onDelete: Cascade)
replies Comment[] @relation("CommentReplies")
likes CommentLike[]
@@index([postId])
@@index([parentId])
@@index([accountId])
@@index([userId])
}
model Like {
id String @id @default(cuid())
postId String
accountId String
userId String?
createdAt DateTime @default(now())
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
@@unique([postId, accountId])
@@unique([postId, userId])
@@index([postId])
@@index([accountId])
@@index([userId])
}
model Story {
id String @id @default(cuid())
accountId String
userId String?
repositoryId String?
mediaUrl String
mediaType String // image/video
caption String? @db.Text
viewsCount Int @default(0)
expiresAt DateTime
createdAt DateTime @default(now())
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
repository Repository? @relation(fields: [repositoryId], references: [id], onDelete: SetNull)
views StoryView[]
reactions StoryReaction[]
replies StoryReply[]
@@index([accountId])
@@index([userId])
@@index([repositoryId])
@@index([expiresAt])
}
model Reel {
id String @id @default(cuid())
accountId String
userId String?
repositoryId String?
title String
description String? @db.Text
videoUrl String
thumbnailUrl String
duration Int
musicTrackId String?
musicTitle String?
musicArtist String?
musicPreviewUrl String?
musicArtworkUrl String?
musicStartTime Int?
effectId String?
trimStart Float?
trimEnd Float?
thumbnailTime Float?
isArchived Boolean @default(false)
archivedAt DateTime?
viewsCount Int @default(0)
likesCount Int @default(0)
commentsCount Int @default(0)
createdAt DateTime @default(now())
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
repository Repository? @relation(fields: [repositoryId], references: [id], onDelete: SetNull)
likes ReelLike[]
comments ReelComment[]
views ReelView[]
@@index([accountId])
@@index([userId])
@@index([repositoryId])
@@index([createdAt])
@@index([isArchived])
}
// ============================================
// SOCIAL: Follow System
// ============================================
model Follow {
id String @id @default(cuid())
followerId String // Account following
followingId String // Account being followed
followerUserId String?
followingUserId String?
createdAt DateTime @default(now())
follower Account @relation("AccountFollowers", fields: [followerId], references: [id], onDelete: Cascade)
following Account @relation("AccountFollowing", fields: [followingId], references: [id], onDelete: Cascade)
followerUser User? @relation("UserFollowers", fields: [followerUserId], references: [id], onDelete: Cascade)
followingUser User? @relation("UserFollowing", fields: [followingUserId], references: [id], onDelete: Cascade)
@@unique([followerId, followingId])
@@unique([followerUserId, followingUserId])
@@index([followerId])
@@index([followingId])
@@index([followerUserId])
@@index([followingUserId])
}
// ============================================
// MESSAGING
// ============================================
model Message {
id String @id @default(cuid())
senderId String
// Nullable: group-chat messages (chatId set) have no single receiver. Only
// 1:1 direct messages populate this.
receiverId String?
chatId String?
content String @db.Text
mediaUrl String?
read Boolean @default(false)
readAt DateTime? // Timestamp when message was read
deliveredAt DateTime? // Timestamp when message was delivered to recipient's client
editedAt DateTime?
deletedForSender Boolean @default(false)
createdAt DateTime @default(now())
sender Account @relation("MessageSender", fields: [senderId], references: [id], onDelete: Cascade)
receiver Account? @relation("MessageReceiver", fields: [receiverId], references: [id], onDelete: Cascade)
chat Chat? @relation(fields: [chatId], references: [id], onDelete: Cascade)
reactions MessageReaction[]
@@index([senderId])
@@index([receiverId])
@@index([chatId])
@@index([createdAt])
@@index([read])
}
// Emoji reactions on a direct/group message. A user may add at most one of each
// distinct emoji to a given message (enforced by the unique constraint), and the
// total number of distinct reactions per user per message is capped in the
// controller (mirroring Bluesky's per-message reaction limit).
model MessageReaction {
id String @id @default(cuid())
messageId String
userId String
emoji String
createdAt DateTime @default(now())
message Message @relation(fields: [messageId], references: [id], onDelete: Cascade)
user Account @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([messageId, userId, emoji])
@@index([messageId])
@@index([userId])
}
// ============================================
// NOTIFICATIONS
// ============================================
enum NotificationType {
LIKE
COMMENT
FOLLOW
MENTION
MESSAGE
REPO_UPDATE
STORY_REPLY
}
model Notification {
id String @id @default(cuid())
accountId String?
userId String?
type NotificationType
actorId String? // Account that triggered notification
postId String?
content String
read Boolean @default(false)
createdAt DateTime @default(now())
@@unique([userId, id])
@@index([accountId])
@@index([userId])
@@index([read])
@@index([createdAt])
}
// ============================================
// ADDITIONAL MODELS FOR CONTROLLERS
// ============================================
model Subscription {
id String @id @default(cuid())
userId String @unique
tier String @default("free")
plan String?
status String @default("active")
polarCustomerId String? @unique
polarSubscriptionId String? @unique
currentPeriodEnd DateTime?
expiresAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
@@index([polarCustomerId])
}
model TwoFactorAuth {
id String @id @default(cuid())
userId String @unique
secret String
enabled Boolean @default(false)
backupCodes String[]
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}
model CodeSnippet {
id String @id @default(cuid())
accountId String?
userId String?
repositoryId String?
title String
description String? @db.Text
code String @db.Text
language String
likesCount Int @default(0)
viewsCount Int @default(0)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
repository Repository? @relation(fields: [repositoryId], references: [id], onDelete: SetNull)
@@index([accountId])
@@index([userId])
@@index([repositoryId])
@@index([language])
}
model Hashtag {
id String @id @default(cuid())
name String @unique
count Int @default(0)
createdAt DateTime @default(now())
posts PostHashtag[]
@@index([count])
}
model PostHashtag {
id String @id @default(cuid())
postId String
hashtagId String
createdAt DateTime @default(now())
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
hashtag Hashtag @relation(fields: [hashtagId], references: [id], onDelete: Cascade)
@@unique([postId, hashtagId])
@@index([postId])
}
model SavedCollection {
id String @id @default(cuid())
accountId String
userId String?
name String
description String? @db.Text
coverImage String?
isPrivate Boolean @default(false)
isDefault Boolean @default(false) // For "All Saved" default collection
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
posts SavedPost[]
savedPosts SavedPost[] @relation("CollectionPosts")
savedPostLinks SavedPostCollection[] // Many-to-many relation
@@unique([userId, name]) // Prevent duplicate collection names per user
@@index([accountId])
@@index([userId])
@@index([isDefault])
}
model SavedPost {
id String @id @default(cuid())
accountId String?
userId String?
postId String
collectionId String? // Primary collection (backwards compatibility)
savedAt DateTime @default(now())
createdAt DateTime @default(now())
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
collection SavedCollection? @relation(fields: [collectionId], references: [id], onDelete: SetNull)
savedCollection SavedCollection? @relation("CollectionPosts", fields: [collectionId], references: [id], onDelete: SetNull, map: "SavedPost_savedCollection_fkey")
collections SavedPostCollection[] // Many-to-many relation
@@unique([accountId, postId])
@@unique([userId, postId])
@@index([accountId])
@@index([userId])
@@index([postId])
@@index([savedAt])
}
// Junction table for many-to-many: SavedPost <-> SavedCollection
model SavedPostCollection {
id String @id @default(cuid())
savedPostId String
collectionId String
addedAt DateTime @default(now())
savedPost SavedPost @relation(fields: [savedPostId], references: [id], onDelete: Cascade)
collection SavedCollection @relation(fields: [collectionId], references: [id], onDelete: Cascade)
@@unique([savedPostId, collectionId])
@@index([savedPostId])
@@index([collectionId])
}
enum RecurrenceType {
NONE
DAILY
WEEKLY
MONTHLY
}
model ScheduledPost {
id String @id @default(cuid())
accountId String?
userId String?
content String @db.Text
mediaUrls String[]
scheduledFor DateTime
published Boolean @default(false)
publishedAt DateTime?
status String @default("pending")
createdAt DateTime @default(now())
// Timezone support
timezone String @default("UTC") // IANA timezone (e.g., "America/New_York")
// Recurring post support
recurrenceType RecurrenceType @default(NONE)
recurrenceEndDate DateTime? // When to stop recurring (null = forever)
parentPostId String? // Links recurring instances to parent
// Track the published post
publishedPostId String? // ID of the created Post after publishing
@@index([accountId])
@@index([userId])
@@index([scheduledFor])
@@index([status])
@@index([parentPostId])
}
model Advertisement {
id String @id @default(cuid())
advertiserId String
campaignId String?
title String
content String @db.Text
mediaUrl String?
targetUrl String
callToAction String?
placement String[] @default([])
priority Int @default(0)
targetAudience String?
budget Float @default(0)
spent Float @default(0)
impressions Int @default(0)
clicks Int @default(0)
conversions Int @default(0)
status String @default("draft")
type String @default("banner")
startDate DateTime?
endDate DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([advertiserId])
@@index([campaignId])
@@index([status])
}
model ModerationLog {
id String @id @default(cuid())
moderatorId String
action String
targetType String
targetId String
reason String?
metadata String? @db.Text // JSON string with extra details (duration, scores, etc.)
automated Boolean @default(false) // Whether this was an automated action
appealable Boolean @default(true) // Whether the user can appeal this action
createdAt DateTime @default(now())
@@index([moderatorId])
@@index([targetType, targetId])
@@index([action])
@@index([createdAt])
}
model UserBlock {
id String @id @default(cuid())
blockerId String
blockedId String
createdAt DateTime @default(now())
@@unique([blockerId, blockedId])
@@index([blockerId])
}
model RepositoryFollow {
id String @id @default(cuid())
accountId String?
userId String?
repositoryId String
createdAt DateTime @default(now())
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@unique([accountId, repositoryId])
@@unique([userId, repositoryId])
@@index([accountId])
@@index([userId])
@@index([repositoryId])
}
enum ContentType {
POST
REPOSITORY
REEL
STORY
SNIPPET
ACTIVITY
}
// ============================================
// GITHUB WEBHOOKS & ACTIVITY
// ============================================
enum GitHubEventType {
PUSH
PULL_REQUEST
ISSUES
RELEASE
STAR
FORK
WATCH
CREATE
DELETE
}
model GitHubWebhook {
id String @id @default(cuid())
repositoryId String @unique
webhookId Int? // GitHub's webhook ID
secret String // HMAC-SHA256 secret
events GitHubEventType[]
active Boolean @default(true)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@index([repositoryId])
}
model RepositoryActivity {
id String @id @default(cuid())
repositoryId String
eventType GitHubEventType
eventId String @unique // GitHub delivery ID (for idempotency)
action String? // opened, closed, merged, etc.
// Actor info (from GitHub)
actorLogin String
actorAvatar String?
actorUrl String?
// Event data
title String?
body String? @db.Text
url String?
ref String? // Branch name
sha String? // Commit SHA
metadata Json? // Event-specific data
// Engagement (social interactions on Gitgram)
likesCount Int @default(0)
commentsCount Int @default(0)
occurredAt DateTime
createdAt DateTime @default(now())
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@index([repositoryId])
@@index([eventType])
@@index([createdAt])
@@index([occurredAt])
}
model Interaction {
id String @id @default(cuid())
accountId String?
userId String?
contentType ContentType
contentId String
type String
createdAt DateTime @default(now())
@@unique([accountId, contentType, contentId, type])
@@unique([userId, contentType, contentId, type])
@@index([contentType, contentId])
@@index([userId])
}
model UnifiedComment {
id String @id @default(cuid())
accountId String?
userId String?
contentType ContentType
contentId String
content String @db.Text
parentId String?
likesCount Int @default(0)
createdAt DateTime @default(now())
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
parent UnifiedComment? @relation("CommentReplies", fields: [parentId], references: [id])
replies UnifiedComment[] @relation("CommentReplies")
@@index([contentType, contentId])
@@index([parentId])
@@index([userId])
}
model Project {
id String @id @default(cuid())
accountId String
userId String?
githubId String? @unique
owner String?
name String
fullName String?
url String?
description String? @db.Text
repoUrl String?
demoUrl String?
imageUrl String?
language String?
tags String[]
stars Int @default(0)
forks Int @default(0)
likesCount Int @default(0)
viewsCount Int @default(0)
location String?
latitude Float?
longitude Float?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([accountId])
@@index([userId])
@@index([owner])
}
enum TalentOpportunityStatus {
OPEN
MATCHING
PILOT
CLOSED
}
enum TalentPilotStatus {
PLANNED
ACTIVE
REVIEW
COMPLETED
CANCELLED
}
enum TalentReferralStatus {
CONTACTED
ACCEPTED
DECLINED
}
/// A structured institution problem that can be matched against public,
/// repository-backed talent evidence. User ids stay scalar so this feature can
/// be extracted into the Zemin360 open-source service without coupling its
/// lifecycle to Gitgram accounts.
model TalentOpportunity {
id String @id @default(cuid())
organizationName String
title String
problem String @db.Text
requiredSkills String[]
successMetric String
durationWeeks Int @default(4)
sourceChannel String @default("direct")
communityReferralConsent Boolean @default(false)
createdById String
status TalentOpportunityStatus @default(OPEN)
revision Int @default(1)
pilots TalentPilot[]
referrals TalentReferral[]
placements TalentPlacement[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([createdById])
@@index([status, createdAt])
}
/// Recruiter placement/unlock entitlement + receipt. The recruiter (opportunity
/// owner) pays a placement/access fee to unlock a matched candidate's contact
/// and full evidence. The fee is charged through the Creem adapter (Creem is a
/// merchant-of-record that supports Turkey-based sellers) and settled by the
/// signed `checkout.completed` webhook, which flips status to `paid` and stamps
/// the receipt (paidAt + providerOrderId). The compound unique key makes the
/// unlock idempotent: one entitlement per (opportunity, candidate, recruiter),
/// so a repeated unlock request never opens a second charge.
model TalentPlacement {
id String @id @default(cuid())
opportunityId String
candidateId String
recruiterId String
feeCents Int
currency String @default("usd")
feeModel String @default("unlock") // unlock | placement
status String @default("pending") // pending | paid | failed | refunded
provider String @default("creem")
checkoutId String?
providerOrderId String? @unique
paidAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
opportunity TalentOpportunity @relation(fields: [opportunityId], references: [id], onDelete: Cascade)
@@unique([opportunityId, candidateId, recruiterId])
@@index([recruiterId, status])
@@index([candidateId])
@@index([status])
}
/// Consent-gated community introduction. The participant controls the outcome;
/// public opportunity responses expose aggregate counts rather than identities.
model TalentReferral {
id String @id @default(cuid())
opportunityId String
participantId String
referredById String
status TalentReferralStatus @default(CONTACTED)
revision Int @default(1)
respondedAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
opportunity TalentOpportunity @relation(fields: [opportunityId], references: [id], onDelete: Cascade)
pilot TalentPilot?
@@unique([opportunityId, participantId])
@@index([participantId, status])
@@index([opportunityId, status])
}
model TalentPilot {
id String @id @default(cuid())
opportunityId String
referralId String? @unique
participantId String
status TalentPilotStatus @default(PLANNED)
milestones Json @default("[]")
deliverableUrl String?
feedback String? @db.Text
publicEvidenceConsent Boolean @default(false)
revision Int @default(1)
startedAt DateTime?
completedAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
opportunity TalentOpportunity @relation(fields: [opportunityId], references: [id], onDelete: Cascade)
referral TalentReferral? @relation(fields: [referralId], references: [id], onDelete: Restrict)
statusTransitions TalentPilotStatusTransition[]
publicProof TalentPublicProof?
@@unique([opportunityId, participantId])
@@index([participantId, status])
}
/// Append-only provenance for every persisted pilot status change. Actor ids
/// remain scalar to preserve the Talent Graph service extraction boundary.
model TalentPilotStatusTransition {
id String @id @default(cuid())
pilotId String
actorId String
previousStatus TalentPilotStatus
nextStatus TalentPilotStatus
revision Int
createdAt DateTime @default(now())
pilot TalentPilot @relation(fields: [pilotId], references: [id], onDelete: Cascade)
@@index([pilotId, createdAt])
@@index([actorId, createdAt])
@@unique([pilotId, revision])
}
/// Privacy-safe projection consumed by public Talent Graph and matching reads.
/// Institution-authored free text never enters this table.
model TalentPublicProof {
pilotId String @id
publicId String @unique @default(cuid())
participantId String
deliverableUrl String
evidenceSkills String[]
completedAt DateTime
schemaVersion Int @default(1)
publishedAt DateTime @default(now())
updatedAt DateTime @updatedAt
pilot TalentPilot @relation(fields: [pilotId], references: [id], onDelete: Cascade)
@@index([participantId, completedAt])
@@index([evidenceSkills], type: Gin)
}
/// Durable idempotency receipt for every Talent Graph mutation. The unique
/// fingerprint scopes a client key to actor + operation; requestHash rejects
/// key reuse with a different body and response provides exact replay.
model TalentMutationReceipt {
id String @id @default(cuid())
requestFingerprint String @unique
requestHash String
actorId String
operation String
resourceType String
resourceId String
requestId String
response Json
createdAt DateTime @default(now())
@@index([actorId, createdAt])
@@index([resourceType, resourceId, createdAt])
}
model Analytics {
id String @id @default(cuid())
accountId String?
userId String?
date DateTime @default(now())
views Int @default(0)
likes Int @default(0)
comments Int @default(0)
shares Int @default(0)
followers Int @default(0)
reach Int @default(0)
createdAt DateTime @default(now())
@@unique([accountId, date])
@@unique([userId, date])
@@index([accountId])
@@index([userId])
}
model Chat {
id String @id @default(cuid())
name String?
isGroup Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
members ChatMember[]
messages Message[]
}
model ChatMember {
id String @id @default(cuid())
chatId String
accountId String?
userId String?
role String @default("member")
joinedAt DateTime @default(now())
chat Chat @relation(fields: [chatId], references: [id], onDelete: Cascade)
@@unique([chatId, accountId])
@@unique([chatId, userId])
@@index([userId])
@@index([chatId])
}
model NotificationPreferences {
id String @id @default(cuid())
accountId String? @unique
userId String? @unique
likes Boolean @default(true)
comments Boolean @default(true)
follows Boolean @default(true)
mentions Boolean @default(true)
messages Boolean @default(true)
posts Boolean @default(true)
emailDigest Boolean @default(false)
pushEnabled Boolean @default(true)
}
// ============================================
// PUSH DEVICES
// ============================================
enum DevicePlatform {
IOS
ANDROID
WEB
}
model PushDevice {
id String @id @default(cuid())
userId String
pushToken String @unique
platform DevicePlatform
deviceName String?
// Full Web Push subscription (endpoint + p256dh/auth keys) serialized as JSON.
// Only populated for WEB platform devices.
webPushSubscription String? @db.Text
active Boolean @default(true)
lastUsed DateTime @default(now())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
@@index([active])
}
model PostReport {
id String @id @default(cuid())
postId String
reporterId String?
userId String?
reason String
description String? @db.Text
status String @default("pending")
createdAt DateTime @default(now())
@@index([postId])
@@index([userId])
@@index([status])
}
model PostShare {
id String @id @default(cuid())
postId String
accountId String?
userId String?
createdAt DateTime @default(now())
@@index([postId])
@@index([userId])
}
model ReelComment {
id String @id @default(cuid())
reelId String
accountId String?
userId String?
content String @db.Text
createdAt DateTime @default(now())
reel Reel @relation(fields: [reelId], references: [id], onDelete: Cascade)
user User? @relation(fields: [userId], references: [id], onDelete: SetNull)
@@index([reelId])
@@index([userId])
}
model ReelLike {
id String @id @default(cuid())
reelId String
accountId String?
userId String?
createdAt DateTime @default(now())
reel Reel @relation(fields: [reelId], references: [id], onDelete: Cascade)
@@unique([reelId, accountId])
@@unique([reelId, userId])
@@index([reelId])
}
model ReelView {
id String @id @default(cuid())
reelId String
accountId String?
userId String?
viewedAt DateTime @default(now())
reel Reel @relation(fields: [reelId], references: [id], onDelete: Cascade)
@@index([reelId])
}
model RepositoryBookmark {
id String @id @default(cuid())
accountId String?
userId String?
repositoryId String
createdAt DateTime @default(now())
@@unique([accountId, repositoryId])
@@unique([userId, repositoryId])
@@index([userId])
}
model StoryView {
id String @id @default(cuid())
storyId String
accountId String?
userId String?
viewedAt DateTime @default(now())
duration Int? // View duration in milliseconds (if tracked)
completed Boolean @default(false) // Whether viewer watched the entire story
source String? // Where they came from: 'feed', 'profile', 'direct', etc.
deviceType String? // 'mobile', 'web', 'tablet'
story Story @relation(fields: [storyId], references: [id], onDelete: Cascade)
@@unique([storyId, accountId])
@@unique([storyId, userId])
@@index([storyId])
@@index([viewedAt])
}
model StoryReaction {
id String @id @default(cuid())
storyId String
userId String
type String
createdAt DateTime @default(now())
story Story @relation(fields: [storyId], references: [id], onDelete: Cascade)
@@unique([storyId, userId])
@@index([storyId])
}
model StoryReply {
id String @id @default(cuid())
storyId String
userId String
content String @db.Text
createdAt DateTime @default(now())
story Story @relation(fields: [storyId], references: [id], onDelete: Cascade)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([storyId])
@@index([userId])
}
model UserLanguagePreference {
id String @id @default(cuid())
userId String
language String
weight Float @default(1.0)
score Float @default(0)
@@unique([userId, language])
@@index([userId])
}
model UserTopicInterest {
id String @id @default(cuid())
userId String
topic String
weight Float @default(1.0)
score Float @default(0)
@@unique([userId, topic])
@@index([userId])
}
// ============================================
// PHASE 9: NEW MODELS
// ============================================
model LinkedAccount {
id String @id @default(cuid())
userId String
provider String // github, google, twitter
providerId String
email String?
username String?
avatar String?
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([provider, providerId])
@@index([userId])
}
model CommentLike {
id String @id @default(cuid())
commentId String
userId String
createdAt DateTime @default(now())
comment Comment @relation(fields: [commentId], references: [id], onDelete: Cascade)
@@unique([commentId, userId])
@@index([commentId])
@@index([userId])
}
model FollowRequest {
id String @id @default(cuid())
requesterId String
targetId String
status String @default("pending") // pending, accepted, rejected
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([requesterId, targetId])
@@index([requesterId])
@@index([targetId])
@@index([status])
}
model PasswordResetToken {
id String @id @default(cuid())
userId String
token String @unique
expiresAt DateTime
used Boolean @default(false)
createdAt DateTime @default(now())
@@index([userId])
@@index([token])
}
model EmailVerificationToken {
id String @id @default(cuid())
userId String
token String @unique
expiresAt DateTime
used Boolean @default(false)
createdAt DateTime @default(now())
@@index([userId])
@@index([token])
}
model StoryArchive {
id String @id @default(cuid())
storyId String @unique
userId String
mediaUrl String
mediaType String
caption String? @db.Text
createdAt DateTime @default(now())
@@index([userId])
}
model StorySettings {
id String @id @default(cuid())
userId String @unique
allowReplies Boolean @default(true)
hideFrom String[] @default([])
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
}
model StoryHighlight {
id String @id @default(cuid())
userId String
name String
coverImage String?
archiveIds String[] @default([])
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
}
model PostDraft {
id String @id @default(cuid())
userId String
content String? @db.Text
mediaUrls String[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
}
// ============================================
// USER WEBHOOKS
// ============================================
model UserWebhook {
id String @id @default(cuid())
userId String
name String
url String
secret String?
events String[] // Array of event types
active Boolean @default(true)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
deliveries WebhookDelivery[]
@@index([userId])
@@index([active])
}
model WebhookDelivery {
id String @id @default(cuid())
webhookId String
event String
payload Json
statusCode Int?
response String? @db.Text
success Boolean @default(false)
error String?
duration Int? // milliseconds
createdAt DateTime @default(now())
webhook UserWebhook @relation(fields: [webhookId], references: [id], onDelete: Cascade)
@@index([webhookId])
@@index([createdAt])
}
// ============================================
// A/B TESTING
// ============================================
model ABTestConversion {
id String @id @default(cuid())
experimentId String
userId String
variant String
metric String
value Float @default(1)
createdAt DateTime @default(now())
@@index([experimentId])
@@index([userId])
@@index([variant])
@@index([createdAt])
}
// ============================================
// CONTENT REPORTING SYSTEM
// ============================================
enum ReportTargetType {
POST
COMMENT
USER
REEL
STORY
}
enum ReportReason {
SPAM
HARASSMENT
INAPPROPRIATE
MISINFORMATION
OTHER
}
enum ReportStatus {
PENDING
REVIEWING
RESOLVED
DISMISSED
}
model Report {
id String @id @default(cuid())
reporterId String // User who submitted the report
targetType ReportTargetType // What type of content is being reported
targetId String // ID of the content being reported
reason ReportReason // Primary reason for the report
description String? @db.Text // Optional additional details
status ReportStatus @default(PENDING)
priority Int @default(0) // Higher = more urgent (based on report count, severity)
escalated Boolean @default(false) // Auto-escalated when 3+ reports on same target
autoFlagged Boolean @default(false) // Flagged by auto-moderation pipeline
resolvedAt DateTime?
resolvedBy String? // Moderator who resolved the report
resolution String? // Notes on how the report was resolved
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([reporterId])
@@index([targetType, targetId])
@@index([status])
@@index([createdAt])
@@index([priority])
@@index([escalated])
}
// ============================================
// MODERATION APPEALS
// ============================================
model ModerationAppeal {
id String @id @default(cuid())
userId String // User who is appealing
moderationLogId String // The moderation action being appealed
appealText String @db.Text
status String @default("PENDING") // PENDING, APPROVED, DENIED
reviewedBy String? // Moderator who reviewed the appeal
reviewedAt DateTime?
reviewNotes String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
@@index([moderationLogId])
@@index([status])
}
// ============================================
// EMAIL PREFERENCES
// ============================================
model EmailPreferences {
id String @id @default(cuid())
userId String @unique
marketingEmails Boolean @default(true)
newFollowerEmails Boolean @default(true)
commentEmails Boolean @default(true)
likeEmails Boolean @default(false) // Off by default to reduce email volume
mentionEmails Boolean @default(true)
weeklyDigest Boolean @default(true)
securityAlerts Boolean @default(true) // Always true, can't be disabled via API
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
}
// ============================================
// LINK PREVIEWS
// ============================================
model LinkPreview {
id String @id @default(cuid())
postId String
url String
title String?
description String? @db.Text
image String?
siteName String?
favicon String?
domain String
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
@@unique([postId, url])
@@index([postId])
@@index([domain])
}
// ============================================
// PROFILE VISIT TRACKING
// ============================================
enum ProfileVisitSource {
SEARCH
POST
COMMENT
MENTION
SUGGESTION
DIRECT
FOLLOWERS
FOLLOWING
REPOSITORY
}
model ProfileVisit {
id String @id @default(cuid())
visitorId String? // Nullable for anonymous visitors
visitedUserId String // The user whose profile was visited
visitedAt DateTime @default(now())
source ProfileVisitSource @default(DIRECT)
@@index([visitedUserId])
@@index([visitorId])
@@index([visitedAt])
@@index([visitedUserId, visitedAt])
@@index([visitedUserId, visitorId]) // For deduplication lookups
}
model ProfilePrivacySettings {
id String @id @default(cuid())
userId String @unique
profileVisitsEnabled Boolean @default(true) // Allow tracking visits to their profile
showProfileVisitors Boolean @default(true) // Show who visited their profile
@@index([userId])
}
// ============================================
// POST ANALYTICS - Detailed View Tracking
// ============================================
model PostView {
id String @id @default(cuid())
postId String
viewerId String? // User ID if logged in
sessionId String? // Anonymous session identifier
ipHash String? // Hashed IP for unique viewer counting (not stored raw for privacy)
country String? // Viewer's country (from IP geolocation)
city String? // Viewer's city
deviceType String? // mobile, desktop, tablet
source String? // feed, profile, explore, direct, search
referrer String? // Where they came from
isFollower Boolean @default(false) // Was the viewer following the post author?
duration Int? // View duration in milliseconds
profileVisit Boolean @default(false) // Did the viewer visit the author's profile after?
viewedAt DateTime @default(now())
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
@@index([postId])
@@index([viewerId])
@@index([viewedAt])
@@index([postId, viewedAt])
@@index([postId, isFollower])
@@index([postId, country])
}
// ============================================
// TRENDING RANKING SYSTEM
// ============================================
enum TrendingTier {
HOT_NOW
TRENDING_TODAY
THIS_WEEK
RISING_STARS
}
enum TrendingEntityType {
POST
REPOSITORY
USER
}
model TrendingEntry {
id String @id @default(cuid())
entityType TrendingEntityType
entityId String
tier TrendingTier
score Float @default(0)
rawScore Float @default(0) // Score before anti-gaming adjustments
gamingPenalty Float @default(0) // Penalty applied for suspicious activity
language String? // For per-language trending
topic String? // For per-topic trending
rank Int @default(0) // Position within tier
metadata Json? // Signal breakdown, debug info
periodStart DateTime // Start of the scoring window
periodEnd DateTime // End of the scoring window
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([entityType, entityId, tier, periodStart])
@@index([tier, score])
@@index([tier, language])
@@index([tier, topic])
@@index([entityType, tier])
@@index([createdAt])
@@index([rank])
}
model TrendingHistory {
id String @id @default(cuid())
entityType TrendingEntityType
entityId String
tier TrendingTier
score Float
rank Int
snapshotAt DateTime @default(now())
@@index([entityType, entityId])
@@index([tier, snapshotAt])
@@index([snapshotAt])
}
model EngagementAnomaly {
id String @id @default(cuid())
entityType String // post, repository, user
entityId String
anomalyType String // burst_likes, coordinated_follows, velocity_spike, etc.
severity Float @default(0) // 0-1 severity score
details Json? // Detailed anomaly info
actorIds String[] // Users involved in the anomaly
resolved Boolean @default(false)
resolvedAt DateTime?
resolvedBy String?
detectedAt DateTime @default(now())
createdAt DateTime @default(now())
@@index([entityType, entityId])
@@index([anomalyType])
@@index([resolved])
@@index([detectedAt])
}
model TrendingSignalWeight {
id String @id @default(cuid())
signalName String @unique // e.g. "github_stars", "post_likes", etc.
weight Float @default(1.0)
category String // github, social, engagement_quality, freshness, creator
description String?
active Boolean @default(true)
updatedAt DateTime @updatedAt
createdAt DateTime @default(now())
@@index([category])
@@index([active])
}
// ============================================
// MEDIA PIPELINE: Tracking & Lifecycle
// ============================================
enum MediaType {
IMAGE
VIDEO
}
enum MediaStatus {
PENDING // Uploaded but not yet processed
PROCESSING // Currently being transcoded/optimized
READY // Processed and available
FAILED // Processing failed
SOFT_DELETED // Marked for deletion (retention period)
EXPIRED // Past retention, awaiting cleanup
}
enum TranscodeJobStatus {
QUEUED
PROCESSING
COMPLETED
FAILED
RETRYING
}
model Media {
id String @id @default(cuid())
userId String
type MediaType
status MediaStatus @default(PENDING)
originalUrl String
processedUrl String?
thumbnailUrl String?
webpUrl String?
// File metadata
originalFilename String
mimeType String
fileSize Int // bytes
fileHash String // SHA-256 hash for dedup
width Int?
height Int?
duration Int? // seconds, for video
// Association
postId String?
reelId String?
storyId String?
contentType String? // 'post', 'reel', 'story', 'avatar'
// NSFW / moderation
nsfwScore Float?
nsfwChecked Boolean @default(false)
flagged Boolean @default(false)
flagReason String?
// Lifecycle
isPublic Boolean @default(false)
softDeletedAt DateTime?
retentionDays Int @default(30)
expiresAt DateTime?
// Multi-resolution URLs (JSON stored as string)
resolutions Json? // { "150": "url", "480": "url", "720": "url", "1080": "url" }
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
transcodeJobs TranscodeJob[]
@@index([userId])
@@index([fileHash])
@@index([status])
@@index([postId])
@@index([reelId])
@@index([storyId])
@@index([softDeletedAt])
@@index([expiresAt])
@@index([createdAt])
@@index([userId, type, createdAt])
}
model TranscodeJob {
id String @id @default(cuid())
mediaId String
status TranscodeJobStatus @default(QUEUED)
resolution String // e.g. '720p', '1080p', '150x150'
format String // e.g. 'mp4', 'webp'
inputUrl String
outputUrl String?
outputSize Int?
errorMessage String?
attempts Int @default(0)
maxAttempts Int @default(3)
startedAt DateTime?
completedAt DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
media Media @relation(fields: [mediaId], references: [id], onDelete: Cascade)
@@index([mediaId])
@@index([status])
@@index([createdAt])
}
model MediaUploadQuota {
id String @id @default(cuid())
userId String
date DateTime @db.Date
imageCount Int @default(0)
videoCount Int @default(0)
totalBytes BigInt @default(0)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([userId, date])
@@index([userId])
@@index([date])
}
model MediaFingerprint {
id String @id @default(cuid())
hash String @unique // perceptual hash or SHA-256
hashType String @default("sha256") // 'sha256', 'phash', 'blocklist'
reason String? // Why it's blocked (if blocklist)
isBlocked Boolean @default(false)
reportCount Int @default(0)
firstSeenAt DateTime @default(now())
lastSeenAt DateTime @default(now())
createdAt DateTime @default(now())
@@index([hash])
@@index([isBlocked])
}
// ============================================
// UNFOLLOW LOG - Track unfollows for analytics
// ============================================
model UnfollowLog {
id String @id @default(cuid())
unfollowerId String // The user who unfollowed
unfollowedId String // The user who was unfollowed
followedAt DateTime? // When the follow originally happened
unfollowedAt DateTime @default(now())
followDuration Int? // Duration of follow in seconds
@@index([unfollowedId])
@@index([unfollowerId])
@@index([unfollowedAt])
@@index([unfollowedId, unfollowedAt])
}
// ============================================
// AITM: Change Story Settings per Repository
// ============================================
model RepositoryAitmSettings {
id String @id @default(cuid())
repositoryId String @unique
aitmProjectId String
encryptedApiKey String @db.Text
autoGenerateStories Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@index([aitmProjectId])
}
// ============================================
// REPOSITORY STARS
// ============================================
model Star {
id String @id @default(cuid())
userId String
repositoryId String
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@unique([userId, repositoryId])
@@index([repositoryId])
@@map("stars")
}
// ============================================
// REPOSITORY ANALYTICS: Referrers
// ============================================
model RepositoryReferrer {
id String @id @default(cuid())
repositoryId String
source String
count Int @default(0)
uniqueCount Int @default(0)
date DateTime @default(now())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@unique([repositoryId, source], name: "repoId_source")
@@index([repositoryId, date])
@@map("repository_referrers")
}
// ============================================
// REPOSITORY ANALYTICS: Path Views
// ============================================
model RepositoryPathView {
id String @id @default(cuid())
repositoryId String
path String
views Int @default(0)
date DateTime @default(now())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@index([repositoryId])
@@index([repositoryId, date])
@@map("repository_path_views")
}
// ============================================
// REPOSITORY ANALYTICS: Clones
// ============================================
model RepositoryClone {
id String @id @default(cuid())
repositoryId String
count Int @default(0)
uniqueCount Int @default(0)
date DateTime @default(now())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
repository Repository @relation(fields: [repositoryId], references: [id], onDelete: Cascade)
@@unique([repositoryId, date], name: "repoId_date")
@@index([repositoryId, date])
@@map("repository_clones")
}
// ============================================
// AUDIT LOG: Security & activity audit trail
// ============================================
model AuditLog {
id String @id @default(cuid())
userId String
action String
metadata Json?
ipAddress String?
userAgent String?
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId, createdAt])
@@index([action])
@@map("audit_logs")
}
// ============================================
// STORE: Creator marketplace items & purchases
// ============================================
model StoreItem {
id String @id @default(cuid())
sellerId String
title String
description String? @db.Text
price Float @default(0)
category String @default("other")
images String[] @default([])
status String @default("active") // active, sold, archived
polarProductId String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
purchases StorePurchase[]
@@index([sellerId])
@@index([status])
@@index([category])
@@index([createdAt])
}
model StorePurchase {
id String @id @default(cuid())
itemId String
buyerId String
sellerId String
amount Float @default(0)
status String @default("pending") // pending, completed, failed, refunded
provider String @default("internal") // internal, polar
checkoutId String?
createdAt DateTime @default(now())
completedAt DateTime?
item StoreItem @relation(fields: [itemId], references: [id], onDelete: Cascade)
@@index([itemId])
@@index([buyerId])
@@index([sellerId])
@@index([status])
}
// ============================================
// MOMENTS: BeReal-style screenshot + selfie posts
// ============================================
model Moment {
id String @id @default(cuid())
userId String
screenshotUrl String
selfieUrl String
caption String? @db.Text
location String?
likesCount Int @default(0)
commentsCount Int @default(0)
createdAt DateTime @default(now())
expiresAt DateTime?
likes MomentLike[]
@@index([userId])
@@index([createdAt])
}
model MomentLike {
id String @id @default(cuid())
momentId String
userId String
createdAt DateTime @default(now())
moment Moment @relation(fields: [momentId], references: [id], onDelete: Cascade)
@@unique([momentId, userId])
@@index([momentId])
@@index([userId])
}
// ============================================
// FEEDBACK: User-submitted bug reports & feature requests
// ============================================
model Feedback {
id String @id @default(cuid())
userId String
type String @default("other") // bug, feature, other
title String
content String @db.Text
screenshotUrl String?
status String @default("open") // open, in_review, resolved, closed
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
@@index([status])
@@index([type])
@@index([createdAt])
}
// ============================================
// AD CAMPAIGNS: Container for advertisements
// ============================================
model AdCampaign {
id String @id @default(cuid())
advertiserId String
name String
description String? @db.Text
type String @default("post") // post, reel, story, banner, video
budget Float @default(0)
dailyBudget Float?
spent Float @default(0)
billingType String @default("cpc") // cpc, cpm, cpa
status String @default("active") // active, paused, completed, draft
targetAudience String? @db.Text // JSON string
startDate DateTime?
endDate DateTime?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([advertiserId])
@@index([status])
}
// ============================================
// AD PREFERENCES: Per-user ad personalization settings
// ============================================
model AdPreferences {
id String @id @default(cuid())
userId String @unique
personalizedAds Boolean @default(true)
interestCategories String[] @default([])
optOut Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([userId])
}
// ============================================
// MUTED WORDS: per-user keyword / hashtag muting.
//
// Ported from Bluesky's MutedWord moderation primitive (AppBskyActorDefs.MutedWord
// + hasMutedWord). A user adds a word, phrase, or hashtag; matching posts and
// notifications are hidden from their feed by services/mutedWordsService.ts.
//
// - value: the muted token. A leading "#" marks it as a hashtag (matched
// against post tags only) regardless of `targets`.
// - targets: which surfaces the word applies to: "content" (post text + tags)
// and/or "tag" (tags only). Mirrors Bluesky's MutedWord.targets.
// - actorTarget: "all" applies to everyone; "exclude-following" skips authors the
// viewer follows (so you still see muted words from friends).
// - expiresAt: optional expiry; an expired entry is ignored by the matcher and
// surfaced to the client so it can be renewed.
// ============================================
model MutedWord {
id String @id @default(cuid())
userId String
value String // normalized muted token (lowercased, "#" stripped for tags)
targets String[] @default(["content"]) // subset of: "content", "tag"
actorTarget String @default("all") // "all" | "exclude-following"
expiresAt DateTime? // null = never expires
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([userId, value])
@@index([userId])
@@index([expiresAt])
}