title: "KnowledgeTopic (table)" category: reference tags: [table, knowledgetopic, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.KnowledgeTopic
Schema: dba
Aantal kolommen: 52
Zie ook de entity-pagina: ../entities/KnowledgeTopic
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
KntId |
nvarchar(11) | Nee | — | — |
KntDescr |
nvarchar(200) | Ja | — | — |
KntContext |
bigint | Nee | ((1)) | — |
KntRecStatus |
int | Nee | ((0)) | — |
KntAcceptDescr |
smallint | Nee | ((0)) | — |
KntAcceptDiagnosis |
smallint | Nee | ((0)) | — |
KntAcceptKnd |
smallint | Nee | ((0)) | — |
KntAcceptShowInFAQ |
smallint | Nee | ((1)) | — |
KntAcceptSkillCat |
smallint | Nee | ((0)) | — |
KntAcceptTags |
smallint | Nee | ((0)) | — |
KntAcceptTemplateText |
smallint | Nee | ((0)) | — |
KntAcceptText |
smallint | Nee | ((0)) | — |
KntActiveDate |
datetimeoffset(7) | Ja | — | — |
KntActiveEmpId |
nvarchar(9) | Ja | — | — |
KntActiveInTree |
smallint | Nee | ((0)) | — |
KntApprovedDate |
datetimeoffset(7) | Ja | — | — |
KntApprovedEmpId |
nvarchar(9) | Ja | — | — |
KntBackgroundInfo |
nvarchar(max) | Ja | — | — |
KntCompId |
nvarchar(6) | Nee | — | — |
KntCreateDate |
datetimeoffset(7) | Ja | — | — |
KntCreateEmpId |
nvarchar(9) | Ja | — | — |
KntDataProvider |
nvarchar(50) | Ja | — | — |
KntDiagnosis |
nvarchar(max) | Ja | — | — |
KntExported |
smallint | Nee | ((0)) | — |
KntExternalId |
nvarchar(50) | Ja | — | — |
KntExternalStatus |
nvarchar(50) | Ja | — | — |
KntImage |
nvarchar(max) | Ja | — | — |
KntInactiveDate |
datetimeoffset(7) | Ja | — | — |
KntInactiveEmpId |
nvarchar(9) | Ja | — | — |
KntInputSupport |
nvarchar(max) | Ja | — | — |
KntJobId |
nvarchar(12) | Ja | — | — |
KntKndId |
nvarchar(11) | Ja | — | — |
KntOpenDate |
datetimeoffset(7) | Ja | — | — |
KntOpenEmpId |
nvarchar(9) | Ja | — | — |
KntParentKntId |
nvarchar(11) | Ja | — | — |
KntProviderMutDate |
datetimeoffset(7) | Ja | — | — |
KntRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
KntRejectedDate |
datetimeoffset(7) | Ja | — | — |
KntRejectedEmpId |
nvarchar(9) | Ja | — | — |
KntRejectionReason |
nvarchar(max) | Ja | — | — |
KntRemarks |
nvarchar(max) | Ja | — | — |
KntSdrtId |
nvarchar(4) | Ja | — | — |
KntShowInFAQ |
smallint | Nee | ((1)) | — |
KntSkcId |
nvarchar(9) | Ja | — | — |
KntSubmittedDate |
datetimeoffset(7) | Ja | — | — |
KntSubmittedEmpId |
nvarchar(9) | Ja | — | — |
KntTags |
nvarchar(200) | Ja | — | — |
KntTemplateText |
nvarchar(max) | Ja | — | — |
KntText |
nvarchar(max) | Ja | — | — |
KntTransferNextTime |
smallint | Nee | ((0)) | — |
KntFileExtension |
nvarchar(5) | Nee | — | — |
KntText_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
KntFileExtension—(N'.html')KntText_FT—(case when [KntText] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([KntText],(5))=N'<html' then [KntText] else N'<html lang="nl">'+[KntText] end) end)
Brondatabewerken
- DB-schema —
lookup_table_schema("KnowledgeTopic")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("KnowledgeTopic")· ../entities/KnowledgeTopic Properties, contexts, statussen. Bron:Entities.xml.