title: "ReservableObject (table)" category: reference tags: [table, reservableobject, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.ReservableObject
Schema: dba
Aantal kolommen: 50
Zie ook de entity-pagina: ../entities/ReservableObject
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
ResoId |
nvarchar(11) | Nee | — | — |
ResoContext |
bigint | Nee | ((0)) | — |
ResoRecStatus |
int | Nee | ((0)) | — |
ResoArtId |
nvarchar(9) | Ja | — | — |
ResoAuthorizationRequired |
smallint | Nee | ((0)) | — |
ResoAutoAddIncludedObjects |
smallint | Nee | ((0)) | — |
ResoBldId |
nvarchar(11) | Ja | — | — |
ResoBlockCatering |
smallint | Nee | ((0)) | — |
ResoCanBePartOf |
smallint | Nee | ((0)) | — |
ResoCanHaveParts |
smallint | Nee | ((0)) | — |
ResoCcrId |
nvarchar(9) | Ja | — | — |
ResoCleanupTime |
int | Nee | ((0)) | — |
ResoCompId |
nvarchar(6) | Nee | — | — |
ResoDataProvider |
nvarchar(50) | Ja | — | — |
ResoDefaultArticle |
smallint | Nee | ((0)) | — |
ResoDepId |
nvarchar(11) | Ja | — | — |
ResoEmpId |
nvarchar(9) | Ja | — | — |
ResoEqmId |
nvarchar(24) | Ja | — | — |
ResoExported |
smallint | Nee | ((0)) | — |
ResoExternalId |
nvarchar(50) | Ja | — | — |
ResoExternalStatus |
nvarchar(50) | Ja | — | — |
ResoExtId |
nvarchar(5) | Ja | — | — |
ResoHourPrice |
decimal(21,5) | Nee | ((0)) | — |
ResoHoursAllowedChangeInAdv |
int | Nee | ((0)) | — |
ResoIgnoreEndTime |
smallint | Nee | ((0)) | — |
ResoInheritPrice |
smallint | Nee | ((0)) | — |
ResoIsDeliveryLocation |
smallint | Nee | ((0)) | — |
ResoIsPickupLocation |
smallint | Nee | ((0)) | — |
ResoIsScarce |
smallint | Nee | ((0)) | — |
ResoMaximumDuration |
int | Nee | ((0)) | — |
ResoNotAvailableFrom |
datetimeoffset(7) | Ja | — | — |
ResoNotAvailableTill |
datetimeoffset(7) | Ja | — | — |
ResoPreparationTime |
int | Nee | ((0)) | — |
ResoPrice |
decimal(21,5) | Nee | ((0)) | — |
ResoProviderMutDate |
datetimeoffset(7) | Ja | — | — |
ResoRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
ResoResotId |
nvarchar(4) | Ja | — | — |
ResoSitId |
nvarchar(8) | Ja | — | — |
ResoSkcId |
nvarchar(9) | Ja | — | — |
ResoSpcId |
nvarchar(40) | Ja | — | — |
ResoText |
nvarchar(max) | Ja | — | — |
ResoTimeAllowedChangeInAdv |
time(7) | Ja | — | — |
ResoTransferNextTime |
smallint | Nee | ((0)) | — |
ResoTskdId |
nvarchar(11) | Ja | — | — |
ResoType |
smallint | Nee | ((0)) | — |
ResoUnitPrice |
decimal(21,5) | Nee | ((0)) | — |
ResoVatId |
nvarchar(3) | Ja | — | — |
ResoVisId |
nvarchar(7) | Ja | — | — |
ResoWsId |
nvarchar(8) | Ja | — | — |
ResoDescr |
nvarchar(2000) | Ja | — | — |
Computed columnsbewerken
ResoDescr—(CONVERT([nvarchar](2000),NULL))
Trigger-gevulde kolommenbewerken
ResoArtId← TRGI_Article, TRGU_ArticleResoBldId← TRGI_Equipment, TRGI_Space, TRGU_Equipment, TRGU_SpaceResoCcrId← TRGI_Employee, TRGI_Equipment, TRGI_Space, TRGU_Employee, TRGU_Equipment, TRGU_SpaceResoDepId← TRGI_Employee, TRGI_Equipment, TRGI_Space, TRGU_Employee, TRGU_Equipment, TRGU_SpaceResoEmpId← TRGI_Employee, TRGU_EmployeeResoEqmId← TRGI_Equipment, TRGU_EquipmentResoExtId← TRGI_External, TRGU_ExternalResoSitId← TRGI_Article, TRGI_Employee, TRGI_Equipment, TRGI_Space, TRGU_Article, TRGU_Employee, TRGU_Equipment, TRGU_SpaceResoSpcId← TRGI_Space, TRGU_SpaceResoVisId← TRGD_Visitor, TRGI_Visitor, TRGU_Visitor
Brondatabewerken
- DB-schema —
lookup_table_schema("ReservableObject")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("ReservableObject")· ../entities/ReservableObject Properties, contexts, statussen. Bron:Entities.xml.