title: "SafetyDossierReview (table)" category: reference tags: [table, safetydossierreview, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.SafetyDossierReview
Schema: dba
Aantal kolommen: 23
Zie ook de entity-pagina: ../entities/SafetyDossierReview
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
SafdrvSafdId |
nvarchar(6) | Nee | — | — |
SafdrvLineId |
nvarchar(6) | Nee | — | — |
SafdrvContext |
bigint | Nee | ((0)) | — |
SafdrvRecStatus |
int | Nee | ((0)) | — |
SafdrvCompId |
nvarchar(6) | Nee | — | — |
SafdrvCreatedDate |
datetimeoffset(7) | Ja | — | — |
SafdrvCreatedEmpId |
nvarchar(9) | Ja | — | — |
SafdrvDecision |
smallint | Nee | ((0)) | — |
SafdrvEmpId |
nvarchar(9) | Ja | — | — |
SafdrvExpiredDate |
datetimeoffset(7) | Ja | — | — |
SafdrvExpiredEmpId |
nvarchar(9) | Ja | — | — |
SafdrvExported |
smallint | Nee | ((0)) | — |
SafdrvNotificationDate |
datetimeoffset(7) | Ja | — | — |
SafdrvRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
SafdrvRemarkText |
nvarchar(max) | Ja | — | — |
SafdrvReminderDate |
datetimeoffset(7) | Ja | — | — |
SafdrvReviewStartedDate |
datetimeoffset(7) | Ja | — | — |
SafdrvReviewStartedEmpId |
nvarchar(9) | Ja | — | — |
SafdrvSafdcId |
nvarchar(2) | Ja | — | — |
SafdrvStatusChangeDate |
datetimeoffset(7) | Ja | — | — |
SafdrvStatusChangeEmpId |
nvarchar(9) | Ja | — | — |
SafdrvSubmittedDate |
datetimeoffset(7) | Ja | — | — |
SafdrvSubmittedEmpId |
nvarchar(9) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("SafetyDossierReview")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("SafetyDossierReview")· ../entities/SafetyDossierReview Properties, contexts, statussen. Bron:Entities.xml.