brand_book/apps/api/prisma/schema.prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
}

enum Role {
  viewer
  editor
}

enum ComponentStatus {
  draft
  review
  approved
}

model User {
  id           String    @id @default(uuid())
  email        String    @unique
  name         String
  passwordHash String
  role         Role      @default(viewer)
  createdAt    DateTime  @default(now())

  components   ExperimentalComponent[]
}

model ExperimentalComponent {
  id            String          @id @default(uuid())
  name          String
  baseComponent String
  attributes    Json
  status        ComponentStatus @default(draft)
  author        User            @relation(fields: [authorId], references: [id])
  authorId      String
  createdAt     DateTime        @default(now())
  updatedAt     DateTime        @updatedAt
}

model Block {
  id          String   @id @default(uuid())
  path        String   @unique
  name        String
  version     String
  isInPreview Boolean  @default(false)
  changelog   Json     @default("[]")
  updatedAt   DateTime @updatedAt
  createdAt   DateTime @default(now())
}

model BlockSnapshot {
  id        String   @id @default(uuid())
  blockPath String
  version   String
  changelog Json     @default("[]")
  html      String   @db.Text
  css       String   @db.Text
  createdAt DateTime @default(now())

  @@unique([blockPath, version])
  @@index([blockPath])
}