dbo.WorkDesk
Workdesks
TableType TUsage USERDATARows 0SizeMB 0
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_WorkDesk | varchar(38) | no | Workdesk | PKUID |
UID_OS | varchar(38) | yes | Operating system | FKUID |
UID_PersonExamResponsible | varchar(38) | yes | Checked by | FKUID |
UID_ProfitCenter | varchar(38) | yes | Primary cost center | FKUID |
UID_Department | varchar(38) | yes | Primary department | FKUID |
UID_PersonWorkDeskResponsible | varchar(38) | yes | Workdesk supervisor | FKUID |
Description | nvarchar(-1) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
Floor | nvarchar(64) | yes | Floor | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
UID_Locality | varchar(38) | yes | Primary location | FKUID |
Room | nvarchar(128) | yes | Room | |
RoomRemarks | nvarchar(-1) | yes | Remarks (room) | |
Phone | nvarchar(-1) | yes | Phone | |
Commentary | nvarchar(512) | yes | Comment | |
ExaminationDate | datetime(8) | yes | Date checked | |
ExaminationComment | nvarchar(-1) | yes | Check remarks | |
DiskDriveNeeded | bit(1) | yes | Floppy disk drive required | |
CDDriveNeeded | bit(1) | yes | CD-ROM drive required | |
FaxDescription | nvarchar(64) | yes | Remarks (Fax) | |
Fax | nvarchar(-1) | yes | Fax | |
InstallDate | datetime(8) | yes | Installation date | |
Ident_WorkDesk | nvarchar(128) | yes | Workdesk | |
InternalName | nvarchar(128) | yes | Internal name | |
DisplayName | nvarchar(128) | yes | Display name | |
CustomProperty01 | nvarchar(128) | yes | Spare field no. 01 | |
CustomProperty02 | nvarchar(128) | yes | Spare field no. 02 | |
CustomProperty03 | nvarchar(128) | yes | Spare field no. 03 | |
CustomProperty04 | nvarchar(128) | yes | Spare field no. 04 | |
CustomProperty05 | nvarchar(128) | yes | Spare field no. 05 | |
CustomProperty06 | nvarchar(128) | yes | Spare field no. 06 | |
CustomProperty07 | nvarchar(128) | yes | Spare field no. 07 | |
CustomProperty08 | nvarchar(128) | yes | Spare field no. 08 | |
CustomProperty09 | nvarchar(128) | yes | Spare field no. 09 | |
CustomProperty10 | nvarchar(128) | yes | Spare field no. 10 | |
RentCharge | int(4) | yes | Leasing fee | |
EstablishDate | datetime(8) | yes | Setup date | |
EndOfUse | datetime(8) | yes | Withdrawal date | |
Building | nvarchar(64) | yes | Building | |
ServiceType | nvarchar(64) | yes | §§Service type | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
IsNoInherite | bit(1) | yes | No inheritance | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
UID_WorkDeskType | varchar(38) | yes | Workdesk type | FKUID |
UID_WorkDeskState | varchar(38) | yes | §§Status | FKUID |
UID_Org | varchar(38) | yes | Primary business role | FKUID |
Relations
| FK | From | To |
|---|---|---|
| QER_RFRL1005 | WorkDesk.UID_WorkDeskType | WorkDeskType.UID_WorkDeskType |
| QER_RFRL1435 | HelperWorkDeskOrg.UID_WorkDesk | WorkDesk.UID_WorkDesk |
| QER_RFRL1733 | PersonWantsOrg.UID_WorkDeskOrdered | WorkDesk.UID_WorkDesk |
| QER_RFRL3367 | WorkDesk.UID_Locality | BaseTree.UID_Org |
| QER_RFRL3380 | WorkDesk.UID_Department | BaseTree.UID_Org |
| QER_RFRL3385 | WorkDesk.UID_ProfitCenter | BaseTree.UID_Org |
| QER_RFRL4204 | ShoppingCartItem.UID_WorkDeskOrdered | WorkDesk.UID_WorkDesk |
| QER_RFRL558 | WorkDesk.UID_OS | OS.UID_OS |
| QER_RFRL859 | WorkDesk.UID_WorkDeskState | WorkDeskState.UID_WorkDeskState |
| RMB_RFRL1229 | WorkDesk.UID_Org | BaseTree.UID_Org |
Triggers
GEN_T12036A1EDA64B06F1EB32C2AA SQL_TRIGGER
GEN_T2E1E85D27524C0010866FEEB5 SQL_TRIGGER
GEN_T3957254A4C49A61112990E2F9 SQL_TRIGGER
QER_TIWorkDesk SQL_TRIGGER
QER_TUWorkDesk SQL_TRIGGER
RMB_TUWorkDesk 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 |
|---|---|---|
| dbo.ADS_ZADSMachineInADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZHelperWorkDeskOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMB_ZHelperWorkDeskOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_RWorkDeskHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_ZWorkDeskHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T10DDEB8F8C0DA1E8C82D8396B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1371BF39B49FB897801265714 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1DE7F6295B3C428FC0E964E67 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T27B05EC761EFF8DD7BC5DC73A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T29B87B0110ADDEBD505856828 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2CF35A7BD96FF1E58C35AFA20 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5CE48BEBE31BE8229C1D065A1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E12A5227FF2FD6AECD548694 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUWorkDesk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMB_TUWorkDesk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VLicenseIdentites | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_VLicenseIdentites | SQL expression dependency | dbo · UID_WorkDesk · OBJECT_OR_COLUMN |
| dbo.QER_VLicenseIdentites | SQL expression dependency | dbo · EndOfUse · OBJECT_OR_COLUMN |
| dbo.QERVFirstUnicodeChar | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QERVPersonAndAERoles | SQL expression dependency | OBJECT_OR_COLUMN |
| WorkDeskType | referenced by foreign key from table | QER_RFRL1005: WorkDesk.UID_WorkDeskType -> WorkDeskType.UID_WorkDeskType |
| HelperWorkDeskOrg | foreign key references table | QER_RFRL1435: HelperWorkDeskOrg.UID_WorkDesk -> WorkDesk.UID_WorkDesk |
| PersonWantsOrg | foreign key references table | QER_RFRL1733: PersonWantsOrg.UID_WorkDeskOrdered -> WorkDesk.UID_WorkDesk |
| BaseTree | referenced by foreign key from table | QER_RFRL3367: WorkDesk.UID_Locality -> BaseTree.UID_Org |
| BaseTree | referenced by foreign key from table | QER_RFRL3380: WorkDesk.UID_Department -> BaseTree.UID_Org |
| BaseTree | referenced by foreign key from table | QER_RFRL3385: WorkDesk.UID_ProfitCenter -> BaseTree.UID_Org |
| ShoppingCartItem | foreign key references table | QER_RFRL4204: ShoppingCartItem.UID_WorkDeskOrdered -> WorkDesk.UID_WorkDesk |
| OS | referenced by foreign key from table | QER_RFRL558: WorkDesk.UID_OS -> OS.UID_OS |
| WorkDeskState | referenced by foreign key from table | QER_RFRL859: WorkDesk.UID_WorkDeskState -> WorkDeskState.UID_WorkDeskState |
| BaseTree | referenced by foreign key from table | RMB_RFRL1229: WorkDesk.UID_Org -> BaseTree.UID_Org |
| dbo.ADS_ZADSMachineInADSGroup | source text reference | has TRY/CATCH error handling |
| dbo.LDP_ZLDPMachineInLDAPGroup | source text reference | has TRY/CATCH error handling |
| dbo.QER_ZHelperWorkDeskOrg | source text reference | has TRY/CATCH error handling |
| dbo.RMB_ZHelperWorkDeskOrg | source text reference | has TRY/CATCH error handling |
| dbo.RMS_RWorkDeskHasESet | source text reference | has TRY/CATCH error handling |
| dbo.RMS_ZWorkDeskHasESet | source text reference | has TRY/CATCH error handling |
| dbo.QER_TUWorkDesk | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMB_TUWorkDesk | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-qer-customizer-qer-customizer-assignmentitshoporderentitylogic.cs | decompiled C# reference | classes AssignmentITShopOrderEntityLogic; methods MoveNext, SetStateMachine, CreateITShopOrder, CreateITShopOrderWorkdesk, CreateITShopOrder_OnSaving; references Person, WorkDesk; markers references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-itshophelperasync.cs | decompiled C# reference | classes ITShopHelperAsync, _003C_003Ec__DisplayClass14_0, _003C_003Ec__DisplayClass2_0, _003C_003Ec__DisplayClass4_0; methods _003C_CheckIsGroupAccount_003Eb__0, _003CHandlePersonHasAccountDef_003Eb__0, _003CGetValidAccountDef_003Eb__0, MoveNext, SetStateMachine, CreateAccountITShopOrder; references AccProduct, BasetreeAssign, BaseTreeHasObject, Delegation, DialogTable, ITShopOrg; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-forms-qer-forms-formdynamicgroupmasterdata.cs | decompiled C# reference | classes FormDynamicGroupMasterData; methods OnInit, OnDispose, OnDesignChanged, OnResetForm, OnFormSizeChanged, OnFormLoad; references BasetreeAssign, DialogColumn, DialogSchedule, DialogTable, DynamicGroup, DynamicGroupHasImmediateColumn; markers reads entity values, references DB/Dialog objects |
| cs-qer-forms-qer-forms-formitshopdecideorder.cs | decompiled C# reference | classes FormITShopDecideOrder; methods OnInit, Proxy_NodeDoubleClick, OnDesignChanged, OnResetForm, _LoadComplianceExceptions, InitializeComponent; references AccProduct, ComplianceArea, ComplianceRule, Delegation, ESet, HelperPWOCompliance; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshoppersonprolongateorder.cs | decompiled C# reference | classes FormITShopPersonProlongateOrder; methods OnInit, OnResetForm, InitializeComponent, MainActivator_OnActivating, _HandleAssignmentOrderMode, OnFormLoad; references AccProduct, Department, ESet, Person, ProfitCenter, WorkDesk; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-qer-forms-qer-forms-formitshopunsubscribeorder.cs | decompiled C# reference | classes FormITShopUnsubscribeOrder; methods OnInit, OnResetForm, OnFormLoad, FormTaskUnSubscribe, InitializeComponent, MainActivator_OnActivating; references AccProduct, Department, ESet, Person, ProfitCenter, WorkDesk; markers reads entity values, references DB/Dialog objects, IT Shop related markers |
| cs-rms-customizer-rms-customizer-workdeskhaseset.cs | decompiled C# reference | classes WorkdeskHasESet; methods CreateITShopWorkdeskOrder; references AccProduct, ESet, Person, WorkDesk, WorkDeskHasESet; markers references DB/Dialog objects, IT Shop related markers |