Prisma Models

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 = "sqlite"
  url      = env("DATABASE_URL")
}

model Category {
  id        Int      @default(autoincrement()) @id
  name      String
  sites     Site[]
}

model Site {
  id         Int       @default(autoincrement()) @id
  title      String
  desc       String?
  image      String?
  date       String?
  content    SiteContent[]
  category   Category? @relation(fields: [categoryId], references: [id])
  categoryId Int?
}

model SiteContent {
  id         Int      @default(autoincrement()) @id
  content    String?
  site       Site?    @relation(fields: [siteId], references: [id])
  siteId     Int?
}

model Service {
  id         Int      @default(autoincrement()) @id
  name       String?
  tags       String?
  image      String?
}

model Education {
  id              Int      @default(autoincrement()) @id
  title           String?
  specialization  String?
  startdate       String?
  enddate         String?
  description     String?
}

model Experience {
  id              Int      @default(autoincrement()) @id
  role            String?
  title           String?
  specialization  String?
  startdate       String?
  enddate         String?
  description     String?
}