Files
2026-07-08 16:15:37 +02:00

189 lines
5.6 KiB
Plaintext

// AK-P16d (P16) Signature — hardened self-hosted SES default plus optional
// PandaDoc BYOK adapter.
//
// AD-25: v1 default is the self-hosted SES flow (`ses-selfhosted`), not a
// mandatory external provider. PandaDoc remains an opt-in BYOK adapter
// (`pandadoc-byok`) through the Apps-Engine DataConnection. AD-20: signature
// documents attach to the `Projekt` core via bare `projektId`, never to a Deal.
//
// AD-21: this module owns its schema file. Cross-module references to Projekt,
// DataConnection, File, Kontakt and User are intentionally bare String scalars
// so this slice does not edit neighboring schema files. Intra-module relations
// stay inside this file.
enum SignatureProvider {
ses_selfhosted
pandadoc_byok
}
enum SignatureDocumentStatus {
draft
sent
viewed
signed
declined
revoked
expired
}
enum SignatureSignerStatus {
draft
sent
viewed
otp_verified
signed
declined
revoked
expired
}
enum SignatureSignerRole {
kunde
bauherr
auftraggeber
rechnungsempfaenger
intern
}
enum SignatureRoutingMode {
parallel
sequential
}
enum SignatureEventType {
link_created
link_opened
otp_requested
otp_verified
document_sent
document_viewed
signer_signed
signer_declined
reminder_sent
document_revoked
provider_webhook
pdf_sealed
certificate_created
}
model SignatureProviderConnection {
id String @id @default(cuid())
tenantId String
provider SignatureProvider
dataConnectionId String?
label String
isDefault Boolean @default(false)
webhookSharedKeyId String?
healthMessageKey String?
isDemoData Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
archivedAt DateTime?
documents ProjektSignatureDocument[]
@@unique([tenantId, provider, dataConnectionId])
@@index([tenantId, provider, isDefault, archivedAt])
@@index([tenantId, dataConnectionId])
}
model ProjektSignatureDocument {
id String @id @default(cuid())
tenantId String
projektId String
providerConnectionId String?
provider SignatureProvider @default(ses_selfhosted)
providerDocumentId String?
sourcePdfFileId String
signedPdfFileId String?
completionCertFileId String?
status SignatureDocumentStatus @default(draft)
routingMode SignatureRoutingMode @default(parallel)
title String
subject String?
message String?
externalStatusPayload Json @default("{}")
documentHashSha256 String?
sealedPdfHashSha256 String?
completionCertHashSha256 String?
sentAt DateTime?
completedAt DateTime?
revokedAt DateTime?
declinedAt DateTime?
expiresAt DateTime?
createdByUserId String?
isDemoData Boolean @default(false)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
archivedAt DateTime?
providerConnection SignatureProviderConnection? @relation(fields: [providerConnectionId], references: [id], onDelete: SetNull)
signers ProjektSignatureSigner[]
events SignatureEvent[]
@@index([tenantId, projektId, archivedAt, createdAt])
@@index([tenantId, status])
@@index([tenantId, provider, providerDocumentId])
@@index([tenantId, sourcePdfFileId])
@@index([tenantId, signedPdfFileId])
@@index([tenantId, completionCertFileId])
}
model ProjektSignatureSigner {
id String @id @default(cuid())
tenantId String
documentId String
signerEmail String
signerName String
signerRole SignatureSignerRole @default(kunde)
linkedKontaktId String?
status SignatureSignerStatus @default(draft)
signingOrder Int @default(0)
accessTokenHash String? @unique
otpHash String?
otpExpiresAt DateTime?
lastLinkOpenedAt DateTime?
lastReminderAt DateTime?
viewedAt DateTime?
signedAt DateTime?
declinedAt DateTime?
revokedAt DateTime?
signerIpHash String?
signerUserAgent String?
intentText String?
signatureSvg String?
signatureImageFileId String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
document ProjektSignatureDocument @relation(fields: [documentId], references: [id], onDelete: Cascade)
events SignatureEvent[]
@@index([tenantId, documentId, signingOrder])
@@index([tenantId, signerEmail])
@@index([tenantId, linkedKontaktId])
@@index([tenantId, accessTokenHash])
}
model SignatureEvent {
id String @id @default(cuid())
tenantId String
documentId String
signerId String?
eventType SignatureEventType
actorUserId String?
providerEventId String?
ipHash String?
userAgent String?
metadata Json @default("{}")
createdAt DateTime @default(now())
document ProjektSignatureDocument @relation(fields: [documentId], references: [id], onDelete: Cascade)
signer ProjektSignatureSigner? @relation(fields: [signerId], references: [id], onDelete: SetNull)
@@unique([tenantId, providerEventId])
@@index([tenantId, documentId, createdAt])
@@index([tenantId, signerId, createdAt])
@@index([tenantId, eventType, createdAt])
}