Bewerken: KnowledgeTopic

Sectie: Kolommen

Reden:

## Kolommen

| 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 | — | — |