Convert gitgram/ and aitimemachine/ from embedded git repos (which showed as opaque submodule gitlinks on GitHub) into fully-tracked first-party content. AITM now merges its 7 vendored repos as first-party engines: - memory: beads (Go task DAG) + context7 (docs SDK), unified into saved_contexts - git: vendored C git (bundled binary) + gitnexus (in-process code intelligence) - agentic: a2a (@a2a-js/sdk) + pal (AITM-managed Python subprocess) Includes the full session's product build: Gitgram web/mobile/backend features, AITM website/CLI/MCP, the unified memory layer, engine build tooling (scripts/build-engines.sh, Dockerfile, CI), docs (README, ENGINES.md, ARCHITECTURE.md), and extensive test suites. Build artifacts, node_modules, external/, and gemini-cli are gitignored. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
366 lines
9.2 KiB
Plaintext
366 lines
9.2 KiB
Plaintext
// NEW SCHEMA - Repository-as-Account Architecture
|
|
|
|
generator client {
|
|
provider = "prisma-client-js"
|
|
}
|
|
|
|
datasource db {
|
|
provider = "postgresql"
|
|
url = env("DATABASE_URL")
|
|
}
|
|
|
|
// ============================================
|
|
// CORE: Account System
|
|
// ============================================
|
|
|
|
enum AccountType {
|
|
USER
|
|
REPOSITORY
|
|
ORGANIZATION
|
|
}
|
|
|
|
// 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")
|
|
|
|
@@index([type])
|
|
@@index([username])
|
|
}
|
|
|
|
// ============================================
|
|
// USER: Individual developers
|
|
// ============================================
|
|
|
|
model User {
|
|
id String @id @default(cuid())
|
|
email String @unique
|
|
password String?
|
|
githubId String? @unique
|
|
githubUsername String?
|
|
githubAccessToken String?
|
|
googleId String? @unique
|
|
emailVerified Boolean @default(false)
|
|
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[]
|
|
|
|
sessions Session[]
|
|
|
|
@@index([email])
|
|
@@index([githubId])
|
|
}
|
|
|
|
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])
|
|
}
|
|
|
|
// ============================================
|
|
// 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
|
|
|
|
// Claiming & Management
|
|
claimedBy String? // User ID who claimed
|
|
claimedAt DateTime?
|
|
managers RepositoryManager[]
|
|
|
|
// Metadata
|
|
lastSynced DateTime @default(now())
|
|
createdAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
|
|
@@unique([owner, name])
|
|
@@index([owner])
|
|
@@index([claimedBy])
|
|
}
|
|
|
|
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
|
|
website String?
|
|
location String?
|
|
|
|
// Members
|
|
members OrganizationMember[]
|
|
|
|
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
|
|
REEL
|
|
STORY
|
|
}
|
|
|
|
model Post {
|
|
id String @id @default(cuid())
|
|
accountId String // Can be user, repo, or org account
|
|
content String @db.Text
|
|
mediaUrls String[]
|
|
type PostType @default(POST)
|
|
|
|
likesCount Int @default(0)
|
|
commentsCount Int @default(0)
|
|
sharesCount Int @default(0)
|
|
|
|
createdAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
|
|
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
|
|
comments Comment[]
|
|
likes Like[]
|
|
|
|
@@index([accountId])
|
|
@@index([createdAt])
|
|
}
|
|
|
|
model Comment {
|
|
id String @id @default(cuid())
|
|
postId String
|
|
accountId String
|
|
content String @db.Text
|
|
createdAt DateTime @default(now())
|
|
|
|
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
|
|
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
|
|
|
|
@@index([postId])
|
|
@@index([accountId])
|
|
}
|
|
|
|
model Like {
|
|
id String @id @default(cuid())
|
|
postId String
|
|
accountId String
|
|
createdAt DateTime @default(now())
|
|
|
|
post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
|
|
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
|
|
|
|
@@unique([postId, accountId])
|
|
@@index([postId])
|
|
@@index([accountId])
|
|
}
|
|
|
|
model Story {
|
|
id String @id @default(cuid())
|
|
accountId 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)
|
|
|
|
@@index([accountId])
|
|
@@index([expiresAt])
|
|
}
|
|
|
|
model Reel {
|
|
id String @id @default(cuid())
|
|
accountId String
|
|
title String
|
|
videoUrl String
|
|
thumbnailUrl String
|
|
duration Int
|
|
viewsCount Int @default(0)
|
|
likesCount Int @default(0)
|
|
createdAt DateTime @default(now())
|
|
|
|
account Account @relation(fields: [accountId], references: [id], onDelete: Cascade)
|
|
|
|
@@index([accountId])
|
|
@@index([createdAt])
|
|
}
|
|
|
|
// ============================================
|
|
// SOCIAL: Follow System
|
|
// ============================================
|
|
|
|
model Follow {
|
|
id String @id @default(cuid())
|
|
followerId String // Account following
|
|
followingId String // Account being followed
|
|
createdAt DateTime @default(now())
|
|
|
|
follower Account @relation("AccountFollowers", fields: [followerId], references: [id], onDelete: Cascade)
|
|
following Account @relation("AccountFollowing", fields: [followingId], references: [id], onDelete: Cascade)
|
|
|
|
@@unique([followerId, followingId])
|
|
@@index([followerId])
|
|
@@index([followingId])
|
|
}
|
|
|
|
// ============================================
|
|
// MESSAGING
|
|
// ============================================
|
|
|
|
model Message {
|
|
id String @id @default(cuid())
|
|
senderId String
|
|
receiverId String
|
|
content String @db.Text
|
|
mediaUrl String?
|
|
read 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)
|
|
|
|
@@index([senderId])
|
|
@@index([receiverId])
|
|
@@index([createdAt])
|
|
}
|
|
|
|
// ============================================
|
|
// NOTIFICATIONS
|
|
// ============================================
|
|
|
|
enum NotificationType {
|
|
LIKE
|
|
COMMENT
|
|
FOLLOW
|
|
MENTION
|
|
MESSAGE
|
|
REPO_UPDATE
|
|
}
|
|
|
|
model Notification {
|
|
id String @id @default(cuid())
|
|
accountId String
|
|
type NotificationType
|
|
actorId String? // Account that triggered notification
|
|
postId String?
|
|
content String
|
|
read Boolean @default(false)
|
|
createdAt DateTime @default(now())
|
|
|
|
@@index([accountId])
|
|
@@index([read])
|
|
@@index([createdAt])
|
|
}
|