Database Schema for Content Storage

model MarkdownPage {
    pageId      String   @id @default(cuid())
    slug        String   // URL path like "/getting-started"
    githubPath  String   // File path in repo
    githubSha   String?  // Git blob SHA for deduplication
    branchId    String   // Which branch this belongs to
    frontmatter Json     // Parsed frontmatter metadata
    
    // Relations
    branch      SiteBranch      @relation(...)
    content     MarkdownBlob?   @relation(...)  // Actual content
    errors      MarkdownPageSyncError[]
    mediaAssets PageMediaAsset[]
    
    @@unique([branchId, slug])
    @@index([githubSha])
}

model MarkdownBlob {
    githubSha       String   @id  // Git SHA as primary key
    markdown        String   // Raw markdown content
    mdast           Json     // Parsed AST
    structuredData  Json     // Extracted headings, content
    
    // Relations
    pages           MarkdownPage[]  // Multiple pages can share content
}

model MediaAsset {
    assetId     String   @id @default(cuid())
    slug        String   // URL path for the asset
    githubPath  String   // Original file path
    githubSha   String   // Git blob SHA
    branchId    String   
    width       Int?     // Image dimensions
    height      Int?
    bytes       Int      // File size
    
    // Relations
    branch      SiteBranch       @relation(...)
    pageAssets  PageMediaAsset[]  // Pages using this asset
    
    @@unique([slug, branchId])
}

model MetaFile {
    metaId      String   @id @default(cuid())
    githubPath  String   // Path to meta.json
    githubSha   String   // Git blob SHA
    jsonData    Json     // Parsed JSON content
    branchId    String
    
    // Relations
    branch      SiteBranch  @relation(...)
    
    @@unique([githubPath, branchId])
}

model Site {
    siteId          String   @id @default(cuid())
    name            String   // Site display name
    githubFolder    String?  // Base path in repository
    defaultLocale   String   @default("en")
    createdAt       DateTime @default(now())
    
    // Relations
    org             Org             @relation(...)
    branches        SiteBranch[]    // Multiple branches
    locales         SiteLocale[]    // Supported languages
    installations   SiteInstallation[]
}

model SiteBranch {
    branchId         String   @id @default(cuid())
    siteId           String
    branch           String   // Git branch name
    docsJson         Json?    // holocron.jsonc content
    docsJsonComments Json?    // Preserved JSONC comments
    cssStyles        String?  // Custom CSS
    
    // Relations
    site            Site            @relation(...)
    pages           MarkdownPage[]
    mediaAssets     MediaAsset[]
    metaFiles       MetaFile[]
    domains         Domain[]        // Custom domains
    chats           Chat[]          // AI chat sessions
    
    @@unique([siteId, branch])
}

model Chat {
    chatId          String   @id
    userId          String
    branchId        String
    currentSlug     String   // Current page being edited
    filesInDraft    Json     // In-memory file changes
    lastPushedFiles Json     // Last synced state
    title           String?  // Generated chat title
    description     String?  // PR description
    prNumber        Int?     // GitHub PR number
    modelId         String?  // AI model used
    modelProvider   String?
    createdAt       DateTime @default(now())
    
    // Relations
    user            User            @relation(...)
    branch          SiteBranch      @relation(...)
    messages        ChatMessage[]   // Chat history
}

model ChatMessage {
    id          String   @id
    chatId      String
    role        String   // "user" or "assistant"
    index       Int      // Message order
    createdAt   DateTime @default(now())
    
    // Relations
    chat        Chat              @relation(...)
    textParts   ChatPartText[]    // Text content
    toolParts   ChatPartTool[]    // Tool invocations
    reasoning   ChatPartReasoning[] // AI reasoning
    files       ChatPartFile[]    // File attachments
}

model ChatPartText {
    partId      String   @id @default(cuid())
    messageId   String
    index       Int      // Order within message
    type        String   // "text"
    text        String   // Actual text content
}

model ChatPartTool {
    partId      String   @id @default(cuid())
    messageId   String
    index       Int
    type        String   // Tool type
    toolCallId  String   // Unique tool invocation ID
    state       String   // "output-available", "output-error"
    input       Json     // Tool parameters
    output      Json?    // Tool result
    errorText   String?  // Error message if failed
}

model MarkdownPageSyncError {
    errorId      String   @id @default(cuid())
    pageId       String
    line         Int      // Error line number
    errorMessage String   // Error description
    errorType    String   // "mdxParse", "mdParse", "render"
    
    // Relations
    page         MarkdownPage  @relation(...)
}

model PageMediaAsset {
    pageId      String
    assetSlug   String
    branchId    String
    
    // Relations
    page        MarkdownPage  @relation(...)
    mediaAsset  MediaAsset    @relation(...)
    
    @@id([pageId, assetSlug, branchId])
}