title: "Notes (table)" category: reference tags: [table, notes, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Notes
Schema: dba
Aantal kolommen: 28
Zie ook de entity-pagina: ../entities/Notes
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
NotId |
nvarchar(9) | Nee | — | — |
NotDescr |
nvarchar(200) | Ja | — | — |
NotContext |
bigint | Nee | ((0)) | — |
NotRecStatus |
int | Nee | ((0)) | — |
NotBldfId |
nvarchar(23) | Ja | — | — |
NotBldId |
nvarchar(11) | Ja | — | — |
NotBldpId |
nvarchar(11) | Ja | — | — |
NotCompId |
nvarchar(6) | Nee | — | — |
NotContactEmpId |
nvarchar(9) | Ja | — | — |
NotDate |
datetimeoffset(7) | Ja | — | — |
NotEmpId |
nvarchar(9) | Ja | — | — |
NotEqmId |
nvarchar(24) | Ja | — | — |
NotExported |
smallint | Nee | ((0)) | — |
NotIncId |
nvarchar(10) | Ja | — | — |
NotNotsId |
nvarchar(9) | Ja | — | — |
NotPrfId |
nvarchar(50) | Ja | — | — |
NotRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
NotSpcId |
nvarchar(40) | Ja | — | — |
NotSvcId |
nvarchar(9) | Ja | — | — |
NotText |
nvarchar(max) | Ja | — | — |
NotVdrId |
nvarchar(6) | Ja | — | — |
NotFileExtension |
nvarchar(5) | Nee | — | — |
NotText_FT |
varbinary(max) | Ja | — | — |
NotDataProvider |
nvarchar(50) | Ja | — | — |
NotProviderMutDate |
datetimeoffset(7) | Ja | — | — |
NotTransferNextTime |
smallint | Nee | ((0)) | — |
NotExternalId |
nvarchar(50) | Ja | — | — |
NotExternalStatus |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
NotFileExtension—(N'.html')NotText_FT—(case when [NotText] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([NotText],(5))=N'<html' then [NotText] else N'<html lang="nl">'+[NotText] end) end)
Brondatabewerken
- DB-schema —
lookup_table_schema("Notes")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Notes")· ../entities/Notes Properties, contexts, statussen. Bron:Entities.xml.