schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

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

model User {
    id           String     @db.VarChar(255) @id
    username     String     @db.VarChar(255)
    email        String     @db.VarChar(255)
    projects     Project[]
    Credentials  Credential[]
}

model Credential {
    id          Int         @default(autoincrement()) @id
    User        User        @relation(fields: [userId], references: [id], onDelete: Cascade)
    userId      String      @db.VarChar(255)
    config      Json        @db.Json
    apiService  String      @db.VarChar(20)
}

model Project {
    id           Int        @default(autoincrement()) @id
    user         User       @relation(fields: [userId], references: [id], onDelete: Cascade)
    userId       String     @db.VarChar(255)
    boardId      String     @db.VarChar(255)
    title        String     @db.VarChar(100)
    url          String     @db.VarChar(255)
    serviceName  String     @db.VarChar(20)
    cards        Card[]
}

model Card {
    id          Int         @default(autoincrement()) @id
    cardId      String      @db.VarChar(255)
    project     Project     @relation(fields: [projectId], references: [id], onDelete: Cascade)
    projectId   Int
    X           Int
    Y           Int
}