// 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"
  previewFeatures = ["relationJoins"]
}

datasource db {
  provider = "sqlite"
  url      = "file:database/dev.sqlite"
}

model Session {
  id           String    @id
  shop         String
  state        String
  isOnline     Boolean   @default(false)
  scope        String?
  expires      DateTime?
  accessToken  String
  userId       BigInt?
}

model Country {
  id           Int      @id @default(autoincrement())
  code         String   @unique
  name         String
  addresses    SupplierAddress[]
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

model Supplier {
  id           Int      @id @default(autoincrement())
  shop         String
  name         String
  businessName String
  code         String
  published    Boolean  @default(true)
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
  addresses    SupplierAddress[]
  contacts     SupplierContact[]
  notes        SupplierNote[]
}

model SupplierAddress {
  id           Int      @id @default(autoincrement())
  supplierId   Int
  supplier     Supplier @relation(fields: [supplierId], references: [id])
  title        String
  company      String
  address      String
  postalCode   String
  city         String
  countryId    Int
  country      Country  @relation(fields: [countryId], references: [id])
  published    Boolean  @default(true)
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

model SupplierContact {
  id           Int      @id @default(autoincrement())
  supplierId   Int
  supplier     Supplier @relation(fields: [supplierId], references: [id])
  title        String
  firstname    String?
  lastname     String?
  email        String
  phone        String?
  published    Boolean  @default(true)
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

model SupplierNote {
  id           Int      @id @default(autoincrement())
  supplierId   Int
  supplier     Supplier @relation(fields: [supplierId], references: [id])
  userId       BigInt
  note         String
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}