dbo.WorkDeskType
Workdesk types
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_WorkDeskType | varchar(38) | no | Workdesk type | PKUID |
Ident_WorkDeskType | nvarchar(128) | no | Workdesk type | |
Description | nvarchar(-1) | yes | Description | |
DiskDriveNeeded | bit(1) | yes | Floppy disk drive required | |
CDDriveNeeded | bit(1) | yes | CD-ROM drive required | |
DisplayName | nvarchar(128) | yes | Display name | |
RentCharge | int(4) | yes | Leasing fee | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
ShortDescription | nvarchar(-1) | yes | Short description | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1005 | WorkDesk.UID_WorkDeskType | WorkDeskType.UID_WorkDeskType |
Triggers
GEN_T26402F01A6DA4D69BA3FC34AC SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| WorkDesk | foreign key references table | QER_RFRL1005: WorkDesk.UID_WorkDeskType -> WorkDeskType.UID_WorkDeskType |