Bewerken: Competence

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `CmpId` | nvarchar(6) | Nee | — | — |
| `CmpDescr` | nvarchar(200) | Ja | — | — |
| `CmpContext` | bigint | Nee | ((0)) | — |
| `CmpRecStatus` | int | Nee | ((0)) | — |
| `CmpApprovedDate` | datetimeoffset(7) | Ja | — | — |
| `CmpApprovedEmpId` | nvarchar(9) | Ja | — | — |
| `CmpCompId` | nvarchar(6) | Nee | — | — |
| `CmpCreatedDate` | datetimeoffset(7) | Ja | — | — |
| `CmpCreatedEmpId` | nvarchar(9) | Ja | — | — |
| `CmpDataProvider` | nvarchar(50) | Ja | — | — |
| `CmpExpiredDate` | datetimeoffset(7) | Ja | — | — |
| `CmpExpiredEmpId` | nvarchar(9) | Ja | — | — |
| `CmpExported` | smallint | Nee | ((0)) | — |
| `CmpExternalId` | nvarchar(50) | Ja | — | — |
| `CmpExternalStatus` | nvarchar(50) | Ja | — | — |
| `CmpProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `CmpRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `CmpRemarkText` | nvarchar(max) | Ja | — | — |
| `CmpTransferNextTime` | smallint | Nee | ((0)) | — |