title: "Course (table)" category: reference tags: [table, course, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Course
Schema: dba
Aantal kolommen: 21
Zie ook de entity-pagina: ../entities/Course
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
CrsId |
nvarchar(6) | Nee | — | — |
CrsDescr |
nvarchar(200) | Ja | — | — |
CrsContext |
bigint | Nee | ((0)) | — |
CrsRecStatus |
int | Nee | ((0)) | — |
CrsApprovedDate |
datetimeoffset(7) | Ja | — | — |
CrsApprovedEmpId |
nvarchar(9) | Ja | — | — |
CrsCreatedDate |
datetimeoffset(7) | Ja | — | — |
CrsCreatedEmpId |
nvarchar(9) | Ja | — | — |
CrsCrstId |
nvarchar(6) | Ja | — | — |
CrsDataProvider |
nvarchar(50) | Ja | — | — |
CrsExpiredDate |
datetimeoffset(7) | Ja | — | — |
CrsExpiredEmpId |
nvarchar(9) | Ja | — | — |
CrsExported |
smallint | Nee | ((0)) | — |
CrsExternalId |
nvarchar(50) | Ja | — | — |
CrsExternalStatus |
nvarchar(50) | Ja | — | — |
CrsFrqCode |
int | Nee | ((0)) | — |
CrsFrqId |
nvarchar(3) | Ja | — | — |
CrsProviderMutDate |
datetimeoffset(7) | Ja | — | — |
CrsRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
CrsTransferNextTime |
smallint | Nee | ((0)) | — |
CrsRecCreateEmpId |
nvarchar(9) | Ja | — | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("Course")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Course")· ../entities/Course Properties, contexts, statussen. Bron:Entities.xml.