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

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

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

datasource db {
	provider = "mysql"
	url      = env("DB_CONNECTION")
	shadowDatabaseUrl = env("SHADOW_DB_CONNECTION")
}

model Payer {
	payer_id     Int      @id @default(autoincrement())
	payer_name   String   @db.VarChar(100)
	payer_address String  @db.VarChar(255)
	payer_abn    String?  @db.VarChar(15)
	payer_email  String   @db.VarChar(100)
	invoices     Invoice[]
}

model Invoice {
	payer_id                  Int      
	invoice_suffix_code       Int
	invoice_payer_name        String   @db.VarChar(100)
	invoice_payer_address     String   @db.VarChar(255)
	invoice_payer_abn         String?  @db.VarChar(15)
	invoice_billing_period_start DateTime
	invoice_billing_period_end DateTime
	invoice_due_date          DateTime
	invoice_date              DateTime
	invoice_total_amount      Decimal  @db.Decimal(10, 2)
	invoice_note              String?  @db.Text
	payer                     Payer    @relation(fields: [payer_id], references: [payer_id])
	invoice_items             InvoiceItem[]

	@@id([invoice_date, invoice_suffix_code])
}

model InvoiceItem {
	item_id            Int
	invoice_date       DateTime @map("invoice_date")
	invoice_suffix_code Int     @map("invoice_suffix_code")
	item_description   String   @db.VarChar(255)
	item_quantity      Int
	item_unit_price    Decimal  @db.Decimal(10, 2)
	item_unit          String   @db.VarChar(50)
	invoice            Invoice  @relation(fields: [invoice_date, invoice_suffix_code], references: [invoice_date, invoice_suffix_code])

	@@id([item_id, invoice_date, invoice_suffix_code])
}