schema.prisma

generator client {
  provider = "dart run orm"
  output = "lib/orm"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model License {
    license_key String @id
    customer Customer @relation(fields: [customer_id], references:[id], onUpdate: Cascade, onDelete: Cascade)
    customer_id Int
    user_id String?
    product Product @relation(fields: [product_id], references:[id], onUpdate: Cascade, onDelete: Cascade)
    product_id Int
    payments Payment[]
    created_at DateTime @default(now())
}

model Product{
    id Int @id @default(autoincrement())
    name String
    description String?
    License License[]
    features Feature[]
    client_keys ClientKey[]
}

model Customer {
    id Int @id @default(autoincrement())
    name String
    email String
    licenses License[]
    client_keys ClientKey[]
}

model Feature {
    id Int @id @default(autoincrement())
    name String
    description String
    type FeatureType 
    product Product @relation(fields: [product_id], references:[id], onUpdate: Cascade, onDelete: Cascade)
    product_id Int
    trial_period Int?
    payments Payment[]
}

enum FeatureType {
    FREE
    PAID
}

model Payment {
    id Int @id @default(autoincrement())
    license License @relation(fields: [license_key], references: [license_key], onUpdate: Cascade, onDelete: Cascade)
    license_key String
    activation_date DateTime @default(now())
    expiration_date DateTime
    payment_reference String?
    features Feature[]
    revoked Boolean @default(false)
    revocation_reasoning String?
}

model ClientKey {
    id Int @id @default(autoincrement())
    key String @unique 
    product Product @relation(fields: [product_id], references:[id], onUpdate: Cascade, onDelete: Cascade)
    product_id Int
    customer Customer @relation(fields: [customer_id], references:[id], onUpdate: Cascade, onDelete: Cascade)
    customer_id Int
    revoked Boolean @default(false)
}