Bewerken: ShiftLogLine

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `ShllId` | nvarchar(13) | Nee | — | — |
| `ShllContext` | bigint | Nee | ((0)) | — |
| `ShllRecStatus` | int | Nee | ((0)) | — |
| `ShllCompId` | nvarchar(6) | Nee | — | — |
| `ShllCreatedFromMeettId` | nvarchar(13) | Ja | — | — |
| `ShllCreatedInCurrentShiftLog` | smallint | Nee | ((1)) | — |
| `ShllCreatedMeettId` | nvarchar(13) | Ja | — | — |
| `ShllDepId` | nvarchar(11) | Ja | — | — |
| `ShllEqmId` | nvarchar(24) | Ja | — | — |
| `ShllExported` | smallint | Nee | ((0)) | — |
| `ShllJobId` | nvarchar(12) | Ja | — | — |
| `ShllObjDwtId` | nvarchar(6) | Ja | — | — |
| `ShllOriginShllId` | nvarchar(13) | Ja | — | — |
| `ShllPattern` | nvarchar(max) | Ja | — | — |
| `ShllPatternDuration` | int | Nee | ((0)) | — |
| `ShllPatternOccurText` | nvarchar(max) | Ja | — | — |
| `ShllPatternText` | nvarchar(max) | Ja | — | — |
| `ShllPrfId` | nvarchar(50) | Ja | — | — |
| `ShllRecChangeDate` | datetimeoffset(7) | Ja | — | — |
| `ShllRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `ShllReportEmpId` | nvarchar(9) | Ja | — | — |
| `ShllReportObjectDowntime` | smallint | Nee | ((0)) | — |
| `ShllSafiId` | nvarchar(6) | Ja | — | — |
| `ShllScheduledEndDate` | datetimeoffset(7) | Ja | — | — |
| `ShllScheduledEndWpId` | nvarchar(9) | Ja | — | — |
| `ShllScheduledStartDate` | datetimeoffset(7) | Ja | — | — |
| `ShllScheduledStartWpId` | nvarchar(9) | Ja | — | — |
| `ShllShlbId` | nvarchar(6) | Ja | — | — |
| `ShllShlId` | nvarchar(6) | Ja | — | — |
| `ShllShlltId` | nvarchar(5) | Ja | — | — |
| `ShllText` | nvarchar(max) | Ja | — | — |
| `ShllFinishedDate` | datetimeoffset(7) | Ja | — | — |
| `ShllFinishedEmpId` | nvarchar(9) | Ja | — | — |
| `ShllEqmmspEqmId` | nvarchar(24) | Ja | — | — |
| `ShllEqmmspMspId` | nvarchar(70) | Ja | — | — |
| `ShllPrfmspPrfId` | nvarchar(50) | Ja | — | — |
| `ShllPrfmspMspId` | nvarchar(70) | Ja | — | — |
| `ShllMeterReading` | decimal(21,2) | Nee | ((0)) | — |
| `ShllMeterReadingDate` | datetimeoffset(7) | Ja | — | — |
| `ShllImageFile1` | nvarchar(max) | Ja | — | — |
| `ShllImageFile2` | nvarchar(max) | Ja | — | — |
| `ShllImageFile3` | nvarchar(max) | Ja | — | — |
| `ShllImageFile4` | nvarchar(max) | Ja | — | — |
| `ShllDescr` | nvarchar(200) | Ja | — | — |
| `ShllInstruction` | nvarchar(max) | Ja | — | — |
| `ShllQualityOk` | smallint | Nee | ((0)) | — |
| `ShllQualityNotOk` | smallint | Nee | ((0)) | — |
| `ShllInspectionImageFile1` | nvarchar(max) | Ja | — | — |
| `ShllInspectionImageFile2` | nvarchar(max) | Ja | — | — |
| `ShllInspectionImageFile3` | nvarchar(max) | Ja | — | — |
| `ShllInspectionImageFile4` | nvarchar(max) | Ja | — | — |
| `ShllSkippedDate` | datetimeoffset(7) | Ja | — | — |
| `ShllSkippedEmpId` | nvarchar(9) | Ja | — | — |
| `ShllSrId` | nvarchar(4) | Ja | — | — |
| `ShllEndDateOfRecurrencePattern` | datetimeoffset(7) | Ja | — | — |
| `ShllDataProvider` | nvarchar(50) | Ja | — | — |
| `ShllProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `ShllTransferNextTime` | smallint | Nee | ((0)) | — |
| `ShllExternalId` | nvarchar(50) | Ja | — | — |
| `ShllExternalStatus` | nvarchar(50) | Ja | — | — |
| `ShllFrqId` | nvarchar(3) | Ja | — | — |
| `ShllFrequencyInterval` | int | Nee | ((0)) | — |