model Contract {
id String @id @default(cuid())
dueDay Int? @map("due_date") @db.TinyInt()
initialDate DateTime @map("initial_date")
endingDate DateTime? @map("ending_date")
rent Decimal @db.Decimal(7, 2)
bail Decimal @db.Decimal(7, 2)
duration Int @default(12) @db.TinyInt()
interest Decimal @default(1.00) @db.Decimal(4, 2)
arrears Decimal @default(10.00) @db.Decimal(4, 2)
witnesses Witness[]
tenant Tenant @relation(fields: [tenantId], references: [id])
tenantId String @map("tenant_id")
house House @relation(fields: [houseId], references: [id])
houseId String @map("house_id")
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([houseId, tenantId, initialDate])
@@index([houseId])
@@index([tenantId])
}
model Contract {
id String @id @default(cuid())
dueDay Int? @map("due_date") @db.TinyInt()
initialDate DateTime @map("initial_date")
endingDate DateTime? @map("ending_date")
rent Decimal @db.Decimal(7, 2)
bail Decimal @db.Decimal(7, 2)
duration Int @default(12) @db.TinyInt()
interest Decimal @default(1.00) @db.Decimal(4, 2)
arrears Decimal @default(10.00) @db.Decimal(4, 2)
witnesses Witness[]
tenant Tenant @relation(fields: [tenantId], references: [id])
tenantId String @map("tenant_id")
house House @relation(fields: [houseId], references: [id])
houseId String @map("house_id")
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@unique([houseId, tenantId, initialDate])
@@index([houseId])
@@index([tenantId])
}