DB column index
Generated from read-only sandbox DB metadata. This page groups recurring column names across OIM tables and shows data types, nullability, and FK evidence when present. It does not infer behavior beyond the metadata shown.
7,720Total table columns
2,483Distinct column names
629Foreign-key rows
473Tables
Provenance: data/db/tables.json, data/db/foreign_keys.json, generated DB inventory table links.
Most common columns
Description 153 tables0 FK out0 referenced by
Types: nvarchar(max) × 58, nvarchar(1024) × 57, nvarchar(512) × 14, nvarchar(255) × 11
Types: nvarchar(max) × 58, nvarchar(1024) × 57, nvarchar(512) × 14, nvarchar(255) × 11
DisplayName 74 tables0 FK out0 referenced by
Types: nvarchar(256) × 38, nvarchar(255) × 18, nvarchar(64) × 7, nvarchar(128) × 6
Types: nvarchar(256) × 38, nvarchar(255) × 18, nvarchar(64) × 7, nvarchar(128) × 6
Name 35 tables0 FK out0 referenced by
Types: nvarchar(256) × 24, nvarchar(255) × 6, nvarchar(128) × 3, nvarchar(512) × 1
Types: nvarchar(256) × 24, nvarchar(255) × 6, nvarchar(128) × 3, nvarchar(512) × 1
SortOrder 35 tables0 FK out0 referenced by
Types: int × 21, float × 3, nvarchar(16) × 3, nvarchar(8) × 2
Types: int × 21, float × 3, nvarchar(16) × 3, nvarchar(8) × 2
ObjectGUID 19 tables0 FK out0 referenced by
Types: varchar(36) × 9, varchar(256) × 6, varchar(40) × 4
Types: varchar(36) × 9, varchar(256) × 6, varchar(40) × 4
cn 17 tables0 FK out0 referenced by
Types: nvarchar(110) × 7, nvarchar(400) × 5, nvarchar(255) × 3, nvarchar(64) × 2
Types: nvarchar(110) × 7, nvarchar(400) × 5, nvarchar(255) × 3, nvarchar(64) × 2
PreProcessorCondition 16 tables0 FK out0 referenced by
Types: nvarchar(255) × 12, nvarchar(1024) × 3, nvarchar(256) × 1
Types: nvarchar(255) × 12, nvarchar(1024) × 3, nvarchar(256) × 1
ObjectClass 13 tables0 FK out0 referenced by
Types: nvarchar(1024) × 5, nvarchar(256) × 5, nvarchar(255) × 2, nvarchar(16) × 1
Types: nvarchar(1024) × 5, nvarchar(256) × 5, nvarchar(255) × 2, nvarchar(16) × 1
Caption 7 tables0 FK out0 referenced by
Types: nvarchar(256) × 3, nvarchar(128) × 2, nvarchar(255) × 1, nvarchar(64) × 1
Types: nvarchar(256) × 3, nvarchar(128) × 2, nvarchar(255) × 1, nvarchar(64) × 1
XTouched
422 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 40 table examples; full list is in the JSON asset.
XObjectKey
418 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccountNames | varchar(138) | required | |
| dbo.AccProduct | varchar(138) | required | |
| dbo.AccProductDependencies | varchar(138) | required | |
| dbo.AccProductGroup | varchar(138) | required | |
| dbo.AccProductGroupCollection | varchar(138) | required | |
| dbo.AccProductInAccProduct | varchar(138) | required | |
| dbo.AccProductInBaseTree | varchar(138) | required | |
| dbo.AccProductInFunctionalArea | varchar(138) | required | |
| dbo.AccProductParamCategory | varchar(138) | required | |
| dbo.AccProductParameter | varchar(138) | required | |
| dbo.ADSAccount | varchar(138) | required | |
| dbo.ADSAccountInADSGroup | varchar(138) | required | |
| dbo.ADSAccountSecretary | varchar(138) | required | |
| dbo.ADSContact | varchar(138) | required | |
| dbo.ADSContactInADSGroup | varchar(138) | required | |
| dbo.ADSContactSecretary | varchar(138) | required | |
| dbo.ADSContainer | varchar(138) | required | |
| dbo.ADSDomain | varchar(138) | required | |
| dbo.ADSDomainSubType | varchar(138) | required | |
| dbo.ADSForest | varchar(138) | required | |
| dbo.ADSGroup | varchar(138) | required | |
| dbo.ADSGroupCollection | varchar(138) | required | |
| dbo.ADSGroupExclusion | varchar(138) | required | |
| dbo.ADSGroupInADSGroup | varchar(138) | required | |
| dbo.ADSGroupSecretary | varchar(138) | required | |
| dbo.ADSMachine | varchar(138) | required | |
| dbo.ADSMachineInADSGroup | varchar(138) | required | |
| dbo.ADSMachineInADSSite | varchar(138) | required | |
| dbo.ADSOtherSID | varchar(138) | required | |
| dbo.ADSOtherSIDInADSGroup | varchar(138) | required |
Showing 30 of 40 table examples; full list is in the JSON asset.
XDateInserted
403 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 40 table examples; full list is in the JSON asset.
XDateUpdated
403 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 40 table examples; full list is in the JSON asset.
XUserInserted
403 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccountNames | nvarchar(64) | nullable | |
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductDependencies | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.AccProductInAccProduct | nvarchar(64) | nullable | |
| dbo.AccProductInBaseTree | nvarchar(64) | nullable | |
| dbo.AccProductInFunctionalArea | nvarchar(64) | nullable | |
| dbo.AccProductParamCategory | nvarchar(64) | nullable | |
| dbo.AccProductParameter | nvarchar(64) | nullable | |
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSAccountInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSAccountSecretary | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.ADSContactInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSContactSecretary | nvarchar(64) | nullable | |
| dbo.ADSContainer | nvarchar(64) | nullable | |
| dbo.ADSDomain | nvarchar(64) | nullable | |
| dbo.ADSDomainSubType | nvarchar(64) | nullable | |
| dbo.ADSForest | nvarchar(64) | nullable | |
| dbo.ADSGroup | nvarchar(64) | nullable | |
| dbo.ADSGroupExclusion | nvarchar(64) | nullable | |
| dbo.ADSGroupInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSGroupSecretary | nvarchar(64) | nullable | |
| dbo.ADSMachine | nvarchar(64) | nullable | |
| dbo.ADSMachineInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSMachineInADSSite | nvarchar(64) | nullable | |
| dbo.ADSOtherSID | nvarchar(64) | nullable | |
| dbo.ADSOtherSIDInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSPolicy | nvarchar(64) | nullable | |
| dbo.ADSPolicyAppliesTo | nvarchar(64) | nullable |
Showing 30 of 40 table examples; full list is in the JSON asset.
XUserUpdated
403 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccountNames | nvarchar(64) | nullable | |
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductDependencies | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.AccProductInAccProduct | nvarchar(64) | nullable | |
| dbo.AccProductInBaseTree | nvarchar(64) | nullable | |
| dbo.AccProductInFunctionalArea | nvarchar(64) | nullable | |
| dbo.AccProductParamCategory | nvarchar(64) | nullable | |
| dbo.AccProductParameter | nvarchar(64) | nullable | |
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSAccountInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSAccountSecretary | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.ADSContactInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSContactSecretary | nvarchar(64) | nullable | |
| dbo.ADSContainer | nvarchar(64) | nullable | |
| dbo.ADSDomain | nvarchar(64) | nullable | |
| dbo.ADSDomainSubType | nvarchar(64) | nullable | |
| dbo.ADSForest | nvarchar(64) | nullable | |
| dbo.ADSGroup | nvarchar(64) | nullable | |
| dbo.ADSGroupExclusion | nvarchar(64) | nullable | |
| dbo.ADSGroupInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSGroupSecretary | nvarchar(64) | nullable | |
| dbo.ADSMachine | nvarchar(64) | nullable | |
| dbo.ADSMachineInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSMachineInADSSite | nvarchar(64) | nullable | |
| dbo.ADSOtherSID | nvarchar(64) | nullable | |
| dbo.ADSOtherSIDInADSGroup | nvarchar(64) | nullable | |
| dbo.ADSPolicy | nvarchar(64) | nullable | |
| dbo.ADSPolicyAppliesTo | nvarchar(64) | nullable |
Showing 30 of 40 table examples; full list is in the JSON asset.
XMarkedForDeletion
334 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccountNames | int | nullable | |
| dbo.AccProduct | int | nullable | |
| dbo.AccProductDependencies | int | nullable | |
| dbo.AccProductGroup | int | nullable | |
| dbo.AccProductInAccProduct | int | nullable | |
| dbo.AccProductInBaseTree | int | nullable | |
| dbo.AccProductInFunctionalArea | int | nullable | |
| dbo.AccProductParamCategory | int | nullable | |
| dbo.AccProductParameter | int | nullable | |
| dbo.ADSAccount | int | nullable | |
| dbo.ADSAccountInADSGroup | int | nullable | |
| dbo.ADSAccountSecretary | int | nullable | |
| dbo.ADSContact | int | nullable | |
| dbo.ADSContactInADSGroup | int | nullable | |
| dbo.ADSContactSecretary | int | nullable | |
| dbo.ADSContainer | int | nullable | |
| dbo.ADSDomain | int | nullable | |
| dbo.ADSDomainSubType | int | nullable | |
| dbo.ADSForest | int | nullable | |
| dbo.ADSGroup | int | nullable | |
| dbo.ADSGroupCollection | int | nullable | |
| dbo.ADSGroupExclusion | int | nullable | |
| dbo.ADSGroupInADSGroup | int | nullable | |
| dbo.ADSGroupSecretary | int | nullable | |
| dbo.ADSMachine | int | nullable | |
| dbo.ADSMachineInADSGroup | int | nullable | |
| dbo.ADSMachineInADSSite | int | nullable | |
| dbo.ADSOtherSID | int | nullable | |
| dbo.ADSOtherSIDInADSGroup | int | nullable | |
| dbo.ADSPolicy | int | nullable |
Showing 30 of 40 table examples; full list is in the JSON asset.
Description
153 occurrences9 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(max) | nullable | |
| dbo.AccProductGroup | nvarchar(max) | nullable | |
| dbo.AccProductParamCategory | nvarchar(256) | nullable | |
| dbo.ADSAccount | nvarchar(1024) | nullable | |
| dbo.ADSContact | nvarchar(1024) | nullable | |
| dbo.ADSContainer | nvarchar(1024) | nullable | |
| dbo.ADSDomain | nvarchar(1024) | nullable | |
| dbo.ADSDomainSubType | nvarchar(1024) | nullable | |
| dbo.ADSGroup | nvarchar(1024) | nullable | |
| dbo.ADSPolicy | nvarchar(1024) | nullable | |
| dbo.ADSPrinter | nvarchar(1024) | nullable | |
| dbo.ADSSite | nvarchar(1024) | nullable | |
| dbo.AssetClass | nvarchar(max) | nullable | |
| dbo.AssetType | nvarchar(max) | nullable | |
| dbo.AttestationObject | nvarchar(512) | nullable | |
| dbo.AttestationPolicy | nvarchar(max) | nullable | |
| dbo.AttestationPolicyGroup | nvarchar(max) | nullable | |
| dbo.AttestationType | nvarchar(512) | nullable | |
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.ComplianceArea | nvarchar(512) | nullable | |
| dbo.ComplianceGroup | nvarchar(max) | nullable | |
| dbo.ComplianceRule | nvarchar(512) | nullable | |
| dbo.ComplianceSubRule | nvarchar(max) | nullable | |
| dbo.DialogAEDS | nvarchar(1024) | nullable | |
| dbo.DialogConfigParm | nvarchar(1024) | nullable | |
| dbo.DialogConfigParmOption | nvarchar(255) | nullable | |
| dbo.DialogCountry | nvarchar(64) | nullable | |
| dbo.DialogCustomizer | nvarchar(512) | nullable | |
| dbo.DialogDashBoardDef | nvarchar(1024) | nullable | |
| dbo.DialogDatabase | nvarchar(255) | required |
Showing 30 of 40 table examples; full list is in the JSON asset.
DisplayName
74 occurrences6 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(255) | nullable | |
| dbo.ADSContact | nvarchar(255) | nullable | |
| dbo.ADSDomain | nvarchar(128) | nullable | |
| dbo.ADSGroup | nvarchar(255) | nullable | |
| dbo.ADSPolicy | nvarchar(255) | nullable | |
| dbo.AssetClass | nvarchar(255) | nullable | |
| dbo.AttestationCase | nvarchar(255) | nullable | |
| dbo.DialogConfigParm | nvarchar(256) | nullable | |
| dbo.DialogDashBoardDef | nvarchar(255) | nullable | |
| dbo.DialogHistoryDB | nvarchar(255) | nullable | |
| dbo.DialogObject | nvarchar(128) | nullable | |
| dbo.DialogParameter | nvarchar(256) | nullable | |
| dbo.DialogParameterSet | nvarchar(256) | nullable | |
| dbo.DialogProcess | nvarchar(1024) | nullable | |
| dbo.DialogProcessChain | nvarchar(1024) | nullable | |
| dbo.DialogProcessStep | nvarchar(1024) | nullable | |
| dbo.DialogReport | nvarchar(255) | nullable | |
| dbo.DialogTable | nvarchar(64) | nullable | |
| dbo.DPRNameSpace | nvarchar(1024) | nullable | |
| dbo.DPRObjectOperation | nvarchar(128) | nullable | |
| dbo.DPRProjectionConfig | nvarchar(256) | nullable | |
| dbo.DPRProjectionConfigStep | nvarchar(256) | nullable | |
| dbo.DPRProjectionDependency | nvarchar(256) | nullable | |
| dbo.DPRProjectionStartInfo | nvarchar(256) | nullable | |
| dbo.DPRProjectionStepQuota | nvarchar(256) | nullable | |
| dbo.DPRSchema | nvarchar(256) | nullable | |
| dbo.DPRSchemaClass | nvarchar(256) | nullable | |
| dbo.DPRSchemaMethod | nvarchar(256) | nullable | |
| dbo.DPRSchemaProperty | nvarchar(256) | nullable | |
| dbo.DPRSchemaPropertyReference | nvarchar(256) | nullable |
Showing 30 of 40 table examples; full list is in the JSON asset.
XOrigin
42 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 40 table examples; full list is in the JSON asset.
RiskIndexCalculated
39 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 39 table examples; full list is in the JSON asset.
XIsInEffect
37 occurrences1 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 37 table examples; full list is in the JSON asset.
Name
35 occurrences5 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSForest | nvarchar(512) | nullable | |
| dbo.DialogSchedule | nvarchar(255) | required | |
| dbo.DialogScriptAssembly | nvarchar(128) | nullable | |
| dbo.DPRObjectOperation | nvarchar(128) | required | |
| dbo.DPRProjectionConfig | nvarchar(256) | required | |
| dbo.DPRProjectionConfigStep | nvarchar(256) | required | |
| dbo.DPRProjectionDependency | nvarchar(256) | required | |
| dbo.DPRProjectionStartInfo | nvarchar(256) | nullable | |
| dbo.DPRProjectionStepQuota | nvarchar(256) | required | |
| dbo.DPRSchema | nvarchar(256) | required | |
| dbo.DPRSchemaClass | nvarchar(256) | required | |
| dbo.DPRSchemaMethod | nvarchar(256) | required | |
| dbo.DPRSchemaProperty | nvarchar(256) | required | |
| dbo.DPRSchemaPropertyReference | nvarchar(256) | required | |
| dbo.DPRSchemaType | nvarchar(256) | required | |
| dbo.DPRScript | nvarchar(256) | required | |
| dbo.DPRShell | nvarchar(256) | required | |
| dbo.DPRSystemConnection | nvarchar(256) | required | |
| dbo.DPRSystemMap | nvarchar(256) | required | |
| dbo.DPRSystemMappingRule | nvarchar(256) | required | |
| dbo.DPRSystemObjectMatchSet | nvarchar(256) | required | |
| dbo.DPRSystemObjectMatchSetMAsgn | nvarchar(256) | required | |
| dbo.DPRSystemObjectMatchSets | nvarchar(256) | required | |
| dbo.DPRSystemScope | nvarchar(256) | required | |
| dbo.DPRSystemScopeFilter | nvarchar(256) | required | |
| dbo.DPRSystemSyncDependency | nvarchar(256) | required | |
| dbo.DPRSystemVariable | nvarchar(256) | nullable | |
| dbo.DPRSystemVariableSet | nvarchar(256) | nullable | |
| dbo.Job | nvarchar(255) | nullable | |
| dbo.JobAutoStart | nvarchar(255) | required |
Showing 30 of 35 table examples; full list is in the JSON asset.
SortOrder
35 occurrences10 data types0 outgoing FK refs0 incoming FK refs
Showing 30 of 35 table examples; full list is in the JSON asset.
UID_Org
33 occurrences1 data types13 outgoing FK refs43 incoming FK refs
Showing 30 of 33 table examples; full list is in the JSON asset.
UID_Person
30 occurrences1 data types19 outgoing FK refs38 incoming FK refs
IsInActive
27 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | bit | nullable | |
| dbo.AttestationPolicy | bit | nullable | |
| dbo.AttestationPolicyGroup | bit | nullable | |
| dbo.BaseTree | bit | nullable | |
| dbo.ComplianceRule | bit | nullable | |
| dbo.DialogDashBoardDef | bit | nullable | |
| dbo.DialogHistoryDB | bit | nullable | |
| dbo.DialogProductHasAuthentifier | bit | nullable | |
| dbo.DialogRichMail | bit | nullable | |
| dbo.DPRSchemaType | bit | nullable | |
| dbo.DynamicGroupHasImmediateColumn | bit | nullable | |
| dbo.ESet | bit | nullable | |
| dbo.HardwareType | bit | nullable | |
| dbo.Person | bit | nullable | |
| dbo.PersonInNCHasMControl | bit | nullable | |
| dbo.POLPlaybook | bit | nullable | |
| dbo.POLPlaybookAction | bit | nullable | |
| dbo.QBMAdaptiveCard | bit | nullable | |
| dbo.QBMCEFDefinition | bit | nullable | |
| dbo.QBMColumnBitMaskConfig | bit | nullable | |
| dbo.QBMColumnLimitedValue | bit | nullable | |
| dbo.QBMHtmlApp | bit | nullable | |
| dbo.QERExternalRiskScore | bit | nullable | |
| dbo.QERPolicy | bit | nullable | |
| dbo.QERRiskIndex | bit | nullable | |
| dbo.RelatedApplication | bit | nullable | |
| dbo.RPSReport | bit | nullable |
UID_QBMClrType
26 occurrences1 data types25 outgoing FK refs41 incoming FK refs
CanonicalName
25 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(1000) | nullable | |
| dbo.ADSContact | nvarchar(1000) | nullable | |
| dbo.ADSContainer | nvarchar(1000) | nullable | |
| dbo.ADSDomain | nvarchar(400) | nullable | |
| dbo.ADSForest | nvarchar(400) | nullable | |
| dbo.ADSGroup | nvarchar(1000) | nullable | |
| dbo.ADSMachine | nvarchar(1000) | nullable | |
| dbo.ADSOtherSID | nvarchar(1000) | nullable | |
| dbo.ADSPolicy | nvarchar(400) | nullable | |
| dbo.ADSPrinter | nvarchar(1000) | nullable | |
| dbo.ADSSite | nvarchar(400) | nullable | |
| dbo.BaseTree | nvarchar(400) | nullable | |
| dbo.LDAPAccount | nvarchar(1000) | nullable | |
| dbo.LDAPContainer | nvarchar(1000) | nullable | |
| dbo.LDAPGroup | nvarchar(1000) | nullable | |
| dbo.LDPDomain | nvarchar(400) | nullable | |
| dbo.LDPMachine | nvarchar(1000) | nullable | |
| dbo.Person | nvarchar(1000) | nullable | |
| dbo.UNSAccountB | nvarchar(400) | nullable | |
| dbo.UNSContainerB | nvarchar(400) | nullable | |
| dbo.UNSGroupB | nvarchar(400) | nullable | |
| dbo.UNSGroupB1 | nvarchar(400) | nullable | |
| dbo.UNSGroupB2 | nvarchar(400) | nullable | |
| dbo.UNSGroupB3 | nvarchar(400) | nullable | |
| dbo.UNSRootB | nvarchar(400) | nullable |
DistinguishedName
25 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(1000) | nullable | |
| dbo.ADSContact | nvarchar(1000) | nullable | |
| dbo.ADSContainer | nvarchar(1000) | nullable | |
| dbo.ADSDomain | nvarchar(400) | nullable | |
| dbo.ADSForest | nvarchar(400) | nullable | |
| dbo.ADSGroup | nvarchar(1000) | nullable | |
| dbo.ADSMachine | nvarchar(1000) | nullable | |
| dbo.ADSOtherSID | nvarchar(1000) | nullable | |
| dbo.ADSPolicy | nvarchar(400) | required | |
| dbo.ADSPrinter | nvarchar(1000) | nullable | |
| dbo.ADSSite | nvarchar(400) | nullable | |
| dbo.BaseTree | nvarchar(400) | nullable | |
| dbo.LDAPAccount | nvarchar(1000) | nullable | |
| dbo.LDAPContainer | nvarchar(1000) | nullable | |
| dbo.LDAPGroup | nvarchar(1000) | nullable | |
| dbo.LDPDomain | nvarchar(400) | nullable | |
| dbo.LDPMachine | nvarchar(1000) | nullable | |
| dbo.Person | nvarchar(1000) | nullable | |
| dbo.UNSAccountB | nvarchar(400) | nullable | |
| dbo.UNSContainerB | nvarchar(400) | nullable | |
| dbo.UNSGroupB | nvarchar(400) | nullable | |
| dbo.UNSGroupB1 | nvarchar(400) | nullable | |
| dbo.UNSGroupB2 | nvarchar(400) | nullable | |
| dbo.UNSGroupB3 | nvarchar(400) | nullable | |
| dbo.UNSRootB | nvarchar(400) | nullable |
NameFormat
23 occurrences1 data types0 outgoing FK refs0 incoming FK refs
CustomProperty01
21 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogCalendar | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty02
21 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogCalendar | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty03
21 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogCalendar | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty04
21 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogCalendar | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty05
21 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogCalendar | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
UID_AccProduct
21 occurrences1 data types19 outgoing FK refs21 incoming FK refs
UID_DialogColumn
21 occurrences1 data types0 outgoing FK refs1 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogColumn | varchar(38) | required | ← dbo.QBMIdentityProvider.UID_SearchColumn |
| dbo.DialogColumnBulkDependencies | varchar(38) | required | |
| dbo.DialogColumnGroupRight | varchar(38) | required | |
| dbo.DialogColumnHasSemaphor | varchar(38) | required | |
| dbo.DialogDeferredOperationColumn | varchar(38) | required | |
| dbo.DialogMultiLanguage | varchar(38) | required | |
| dbo.DialogValidDynamicRef | varchar(38) | required | |
| dbo.DialogWatchProperty | varchar(38) | nullable | |
| dbo.QBMCEFDefinition | varchar(38) | nullable | |
| dbo.QBMColumnBitMaskConfig | varchar(38) | required | |
| dbo.QBMColumnLimitedValue | varchar(38) | required | |
| dbo.QBMConfigLibrary | varchar(38) | nullable | |
| dbo.QBMLock | varchar(38) | required | |
| dbo.QBMMissingDisplayRight | varchar(38) | required | |
| dbo.QBMObjectHasPwdPolicy | varchar(38) | nullable | |
| dbo.QBMPwdHistory | varchar(38) | nullable | |
| dbo.QBMSplittedLookup | varchar(38) | required | |
| dbo.QBMTreeHasColumn | varchar(38) | nullable | |
| dbo.QBMTreeResultHasColumn | varchar(38) | nullable | |
| dbo.QERRiskIndex | varchar(38) | nullable | |
| dbo.TSBITDataMapping | varchar(38) | required |
UID_DialogTable
21 occurrences1 data types20 outgoing FK refs31 incoming FK refs
CustomProperty06
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty07
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty08
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty09
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
CustomProperty10
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.AccProductGroup | nvarchar(64) | nullable | |
| dbo.ADSPrinter | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogReport | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(64) | nullable | |
| dbo.ExtendedAttribute | nvarchar(64) | nullable | |
| dbo.ExtendedAttributeGroup | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.QERAssign | nvarchar(64) | nullable | |
| dbo.QERResource | nvarchar(64) | nullable | |
| dbo.QERReuse | nvarchar(64) | nullable | |
| dbo.QERReuseUS | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.TSBAccountDef | nvarchar(64) | nullable | |
| dbo.UNSItemB | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
SerializationBag
20 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRProjectionConfig | nvarchar(max) | nullable | |
| dbo.DPRProjectionConfigStep | nvarchar(max) | nullable | |
| dbo.DPRProjectionDependency | nvarchar(max) | nullable | |
| dbo.DPRProjectionStartInfo | nvarchar(max) | nullable | |
| dbo.DPRProjectionStepQuota | nvarchar(max) | nullable | |
| dbo.DPRSchema | nvarchar(max) | nullable | |
| dbo.DPRSchemaClass | nvarchar(max) | nullable | |
| dbo.DPRSchemaMethod | nvarchar(max) | nullable | |
| dbo.DPRSchemaProperty | nvarchar(max) | nullable | |
| dbo.DPRSchemaPropertyReference | nvarchar(max) | nullable | |
| dbo.DPRSchemaType | nvarchar(max) | nullable | |
| dbo.DPRScript | nvarchar(max) | nullable | |
| dbo.DPRShell | nvarchar(max) | nullable | |
| dbo.DPRSystemConnection | nvarchar(max) | nullable | |
| dbo.DPRSystemMap | nvarchar(max) | nullable | |
| dbo.DPRSystemMappingRule | nvarchar(max) | nullable | |
| dbo.DPRSystemObjectMatchSet | nvarchar(max) | nullable | |
| dbo.DPRSystemObjectMatchSetMAsgn | nvarchar(max) | nullable | |
| dbo.DPRSystemScope | nvarchar(max) | nullable | |
| dbo.DPRSystemScopeFilter | nvarchar(max) | nullable |
ObjectGUID
19 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(36) | nullable | |
| dbo.ADSContact | varchar(36) | nullable | |
| dbo.ADSContainer | varchar(36) | nullable | |
| dbo.ADSDomain | varchar(36) | nullable | |
| dbo.ADSGroup | varchar(36) | nullable | |
| dbo.ADSMachine | varchar(36) | nullable | |
| dbo.ADSPolicy | varchar(36) | nullable | |
| dbo.ADSPrinter | varchar(36) | nullable | |
| dbo.ADSSite | varchar(36) | nullable | |
| dbo.LDAPAccount | varchar(40) | nullable | |
| dbo.LDAPContainer | varchar(40) | nullable | |
| dbo.LDAPGroup | varchar(40) | nullable | |
| dbo.LDPDomain | varchar(40) | nullable | |
| dbo.UNSAccountB | varchar(256) | nullable | |
| dbo.UNSContainerB | varchar(256) | nullable | |
| dbo.UNSGroupB | varchar(256) | nullable | |
| dbo.UNSGroupB1 | varchar(256) | nullable | |
| dbo.UNSGroupB2 | varchar(256) | nullable | |
| dbo.UNSGroupB3 | varchar(256) | nullable |
RiskIndex
18 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSGroup | float | nullable | |
| dbo.AttestationCase | float | nullable | |
| dbo.AttestationPolicy | float | nullable | |
| dbo.BaseTree | float | nullable | |
| dbo.ComplianceRule | float | nullable | |
| dbo.LDAPGroup | float | nullable | |
| dbo.QERAssign | float | nullable | |
| dbo.QERExternalRiskScore | float | nullable | |
| dbo.QERPolicy | float | nullable | |
| dbo.QERResource | float | nullable | |
| dbo.QERReuse | float | nullable | |
| dbo.QERReuseUS | float | nullable | |
| dbo.RPSReport | float | nullable | |
| dbo.TSBAccountDef | float | nullable | |
| dbo.UNSGroupB | float | nullable | |
| dbo.UNSGroupB1 | float | nullable | |
| dbo.UNSGroupB2 | float | nullable | |
| dbo.UNSGroupB3 | float | nullable |
cn
17 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(110) | required | |
| dbo.ADSContact | nvarchar(110) | required | |
| dbo.ADSContainer | nvarchar(110) | required | |
| dbo.ADSGroup | nvarchar(110) | required | |
| dbo.ADSMachine | nvarchar(110) | required | |
| dbo.ADSPolicy | nvarchar(110) | required | |
| dbo.ADSSite | nvarchar(110) | nullable | |
| dbo.LDAPAccount | nvarchar(255) | nullable | |
| dbo.LDAPContainer | nvarchar(255) | nullable | |
| dbo.LDAPGroup | nvarchar(255) | nullable | |
| dbo.LDPMachine | nvarchar(64) | nullable | |
| dbo.UNSAccountB | nvarchar(400) | nullable | |
| dbo.UNSContainerB | nvarchar(64) | nullable | |
| dbo.UNSGroupB | nvarchar(400) | nullable | |
| dbo.UNSGroupB1 | nvarchar(400) | nullable | |
| dbo.UNSGroupB2 | nvarchar(400) | nullable | |
| dbo.UNSGroupB3 | nvarchar(400) | nullable |
PreProcessorCondition
16 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationObject | nvarchar(1024) | nullable | |
| dbo.AttestationWizardParm | nvarchar(1024) | nullable | |
| dbo.DialogColumn | nvarchar(255) | nullable | |
| dbo.DialogCustomizer | nvarchar(256) | nullable | |
| dbo.DialogDashBoardDef | nvarchar(255) | nullable | |
| dbo.DialogGroup | nvarchar(255) | nullable | |
| dbo.DialogObject | nvarchar(255) | nullable | |
| dbo.DialogReport | nvarchar(255) | nullable | |
| dbo.DialogReportQueryModule | nvarchar(255) | nullable | |
| dbo.DialogSheet | nvarchar(255) | nullable | |
| dbo.DialogTable | nvarchar(255) | nullable | |
| dbo.Job | nvarchar(255) | nullable | |
| dbo.JobChain | nvarchar(255) | nullable | |
| dbo.QBMTree | nvarchar(255) | nullable | |
| dbo.QBMTreeResult | nvarchar(255) | nullable | |
| dbo.RPSReport | nvarchar(1024) | nullable |
WhereClause
16 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | nvarchar(max) | nullable | |
| dbo.AttestationWizardParm | nvarchar(max) | nullable | |
| dbo.ComplianceRule | nvarchar(max) | nullable | |
| dbo.ComplianceSubRule | nvarchar(max) | nullable | |
| dbo.DialogNotification | nvarchar(max) | nullable | |
| dbo.DialogObject | nvarchar(1024) | nullable | |
| dbo.DPRNameSpaceHasDialogTable | nvarchar(max) | nullable | |
| dbo.DynamicGroup | nvarchar(max) | nullable | |
| dbo.JobAutoStart | nvarchar(max) | nullable | |
| dbo.PWODecisionStep | nvarchar(max) | nullable | |
| dbo.QBMCEFDefinition | nvarchar(max) | nullable | |
| dbo.QBMTree | nvarchar(max) | nullable | |
| dbo.QBMTreeResult | nvarchar(max) | nullable | |
| dbo.QERPolicy | nvarchar(max) | nullable | |
| dbo.QERWorkingStep | nvarchar(max) | nullable | |
| dbo.RelatedApplication | nvarchar(max) | nullable |
IsDeactivatedByPreProcessor
15 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationObject | bit | nullable | |
| dbo.AttestationWizardParm | bit | nullable | |
| dbo.DialogColumn | bit | nullable | |
| dbo.DialogCustomizer | bit | nullable | |
| dbo.DialogDashBoardDef | bit | nullable | |
| dbo.DialogGroup | bit | nullable | |
| dbo.DialogObject | bit | nullable | |
| dbo.DialogReport | bit | nullable | |
| dbo.DialogSheet | bit | nullable | |
| dbo.DialogTable | bit | nullable | |
| dbo.Job | bit | nullable | |
| dbo.JobChain | bit | nullable | |
| dbo.QBMTree | bit | nullable | |
| dbo.QBMTreeResult | bit | nullable | |
| dbo.RPSReport | bit | nullable |
UID_DialogGroup
14 occurrences1 data types12 outgoing FK refs14 incoming FK refs
IsForITShop
13 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSGroup | bit | nullable | |
| dbo.ESet | bit | nullable | |
| dbo.LDAPGroup | bit | nullable | |
| dbo.QERAssign | bit | nullable | |
| dbo.QERResource | bit | nullable | |
| dbo.QERReuse | bit | nullable | |
| dbo.QERReuseUS | bit | nullable | |
| dbo.RPSReport | bit | nullable | |
| dbo.TSBAccountDef | bit | nullable | |
| dbo.UNSGroupB | bit | nullable | |
| dbo.UNSGroupB1 | bit | nullable | |
| dbo.UNSGroupB2 | bit | nullable | |
| dbo.UNSGroupB3 | bit | nullable |
IsITShopOnly
13 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSGroup | bit | nullable | |
| dbo.ESet | bit | nullable | |
| dbo.LDAPGroup | bit | nullable | |
| dbo.QERAssign | bit | nullable | |
| dbo.QERResource | bit | nullable | |
| dbo.QERReuse | bit | nullable | |
| dbo.QERReuseUS | bit | nullable | |
| dbo.RPSReport | bit | nullable | |
| dbo.TSBAccountDef | bit | nullable | |
| dbo.UNSGroupB | bit | nullable | |
| dbo.UNSGroupB1 | bit | nullable | |
| dbo.UNSGroupB2 | bit | nullable | |
| dbo.UNSGroupB3 | bit | nullable |
ObjectClass
13 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(256) | nullable | |
| dbo.ADSContact | nvarchar(256) | nullable | |
| dbo.ADSContainer | nvarchar(256) | nullable | |
| dbo.ADSDomain | nvarchar(255) | nullable | |
| dbo.ADSGroup | nvarchar(256) | nullable | |
| dbo.ADSMachine | nvarchar(255) | nullable | |
| dbo.ADSSite | nvarchar(256) | nullable | |
| dbo.LDAPAccount | nvarchar(1024) | nullable | |
| dbo.LDAPContainer | nvarchar(1024) | nullable | |
| dbo.LDAPGroup | nvarchar(1024) | nullable | |
| dbo.LDPDomain | nvarchar(1024) | nullable | |
| dbo.LDPMachine | nvarchar(1024) | nullable | |
| dbo.QBMDBRightsAddOn | nvarchar(16) | nullable |
GenProcID
12 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDBQueue | varchar(38) | required | |
| dbo.DialogDeferredOperation | varchar(38) | nullable | |
| dbo.DialogProcess | varchar(38) | required | |
| dbo.DialogProcessChain | varchar(38) | required | |
| dbo.DialogWatchOperation | varchar(38) | required | |
| dbo.JobHistory | varchar(38) | required | |
| dbo.JobQueue | varchar(38) | required | |
| dbo.PersonWantsOrg | varchar(38) | nullable | |
| dbo.POLPlaybookRun | varchar(38) | nullable | |
| dbo.QBMDBQueueCurrent | varchar(38) | nullable | |
| dbo.QBMDBQueuePond | varchar(38) | required | |
| dbo.QERBufferRecalcDecisionMaker | varchar(38) | nullable |
ObjectKey
12 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasObject | varchar(138) | required | |
| dbo.BaseTreeOwnsObject | varchar(138) | required | |
| dbo.DialogDeferredOperation | varchar(138) | nullable | |
| dbo.DialogProcess | varchar(138) | nullable | |
| dbo.DialogProcessChain | varchar(138) | nullable | |
| dbo.DialogTaggedItem | varchar(138) | required | |
| dbo.DPRProjectionObjectState | nvarchar(256) | required | |
| dbo.HelperPWOPersonHasObject | varchar(138) | nullable | |
| dbo.PersonHasObject | varchar(138) | required | |
| dbo.QBMTaggedChange | varchar(138) | required | |
| dbo.QERBufferRecalcDecisionMaker | varchar(138) | required | |
| dbo.QERPolicyHasObject | varchar(138) | required |
UID_PersonHead
12 occurrences1 data types3 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(38) | nullable | → dbo.Person.UID_Person |
| dbo.AttestationHelper | varchar(38) | nullable | |
| dbo.AttestationHistory | varchar(38) | nullable | |
| dbo.BaseTree | varchar(38) | nullable | |
| dbo.HelperHeadOrg | varchar(38) | required | |
| dbo.HelperHeadPerson | varchar(38) | required | |
| dbo.Person | varchar(38) | nullable | |
| dbo.PersonWantsOrg | varchar(38) | nullable | → dbo.Person.UID_Person |
| dbo.PWODecisionHistory | varchar(38) | nullable | |
| dbo.PWOHelperDecisionMaker | varchar(38) | required | |
| dbo.PWOHelperPWO | varchar(38) | nullable | |
| dbo.QERCloudAssistantMessage | varchar(38) | required | → dbo.Person.UID_Person |
UID_TSBAccountDef
12 occurrences1 data types10 outgoing FK refs11 incoming FK refs
LevelNumber
11 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductGroupCollection | int | nullable | |
| dbo.ADSGroupCollection | int | nullable | |
| dbo.AttestationHelper | int | required | |
| dbo.LDAPGroupCollection | int | nullable | |
| dbo.PWODecisionStep | int | nullable | |
| dbo.PWOHelperPWO | int | required | |
| dbo.QERWorkingStep | int | nullable | |
| dbo.UNSGroupB1Collection | int | nullable | |
| dbo.UNSGroupB2Collection | int | nullable | |
| dbo.UNSGroupB3Collection | int | nullable | |
| dbo.UNSGroupBCollection | int | nullable |
StructuralObjectClass
11 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(256) | nullable | |
| dbo.ADSContact | nvarchar(256) | nullable | |
| dbo.ADSContainer | nvarchar(256) | nullable | |
| dbo.ADSDomain | nvarchar(256) | nullable | |
| dbo.ADSGroup | nvarchar(256) | nullable | |
| dbo.ADSMachine | nvarchar(256) | nullable | |
| dbo.LDAPAccount | nvarchar(256) | nullable | |
| dbo.LDAPContainer | nvarchar(256) | nullable | |
| dbo.LDAPGroup | nvarchar(256) | nullable | |
| dbo.LDPDomain | nvarchar(256) | nullable | |
| dbo.LDPMachine | nvarchar(256) | nullable |
UID_DialogCulture
11 occurrences1 data types10 outgoing FK refs12 incoming FK refs
XDateSubItem
11 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | datetime | nullable | |
| dbo.ADSContact | datetime | nullable | |
| dbo.ADSGroup | datetime | nullable | |
| dbo.ADSPolicy | datetime | nullable | |
| dbo.LDAPGroup | datetime | nullable | |
| dbo.UNSAccountB | datetime | nullable | |
| dbo.UNSGroupB | datetime | nullable | |
| dbo.UNSGroupB1 | datetime | nullable | |
| dbo.UNSGroupB2 | datetime | nullable | |
| dbo.UNSGroupB3 | datetime | nullable | |
| dbo.UNSItemB | datetime | nullable |
DisplayValue
10 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductParameter | nvarchar(256) | nullable | |
| dbo.AttestationWizardParm | nvarchar(256) | nullable | |
| dbo.AttestationWizardParmOpt | nvarchar(256) | nullable | |
| dbo.DialogDeferredOperation | nvarchar(255) | nullable | |
| dbo.DialogReportQueryModule | nvarchar(256) | required | |
| dbo.DialogWatchOperation | nvarchar(255) | nullable | |
| dbo.QBMDeployTarget | nvarchar(256) | nullable | |
| dbo.QBMModuleDef | nvarchar(256) | nullable | |
| dbo.QERRiskIndex | nvarchar(256) | nullable | |
| dbo.TSBITData | nvarchar(256) | nullable |
MatchPatternForMembership
10 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bigint | nullable | |
| dbo.ADSContact | bigint | nullable | |
| dbo.ADSGroup | bigint | nullable | |
| dbo.LDAPAccount | bigint | nullable | |
| dbo.LDAPGroup | bigint | nullable | |
| dbo.UNSAccountB | bigint | nullable | |
| dbo.UNSGroupB | bigint | nullable | |
| dbo.UNSGroupB1 | bigint | nullable | |
| dbo.UNSGroupB2 | bigint | nullable | |
| dbo.UNSGroupB3 | bigint | nullable |
UID_DPRShell
10 occurrences1 data types9 outgoing FK refs9 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRProjectionConfig | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRProjectionDependency | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRProjectionStartInfo | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRSchema | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRScript | varchar(38) | nullable | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRShell | varchar(38) | required | ← dbo.DPRScript.UID_DPRShell ← dbo.DPRSystemVariableSet.UID_DPRShell ← dbo.DPRProjectionStartInfo.UID_DPRShell ← dbo.DPRProjectionConfig.UID_DPRShell ← dbo.DPRSchema.UID_DPRShell ← dbo.DPRSystemConnection.UID_DPRShell ← dbo.DPRSystemMap.UID_DPRShell ← dbo.DPRSystemScope.UID_DPRShell ← dbo.DPRProjectionDependency.UID_DPRShell |
| dbo.DPRSystemConnection | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRSystemMap | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRSystemScope | varchar(38) | required | → dbo.DPRShell.UID_DPRShell |
| dbo.DPRSystemVariableSet | varchar(38) | nullable | → dbo.DPRShell.UID_DPRShell |
UID_PWODecisionRule
10 occurrences1 data types9 outgoing FK refs9 incoming FK refs
UID_UNSAccountB
10 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.UNSAccountB | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB1 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB2 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB3 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSItemB | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB1 | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB2 | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB3 | varchar(38) | required |
IsLocked
9 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogScript | bit | nullable | |
| dbo.DialogWebService | bit | nullable | |
| dbo.DPRSchema | bit | nullable | |
| dbo.DPRSchemaClass | bit | nullable | |
| dbo.DPRSchemaMethod | bit | nullable | |
| dbo.DPRSchemaProperty | bit | nullable | |
| dbo.DPRSchemaPropertyReference | bit | nullable | |
| dbo.DPRSchemaType | bit | nullable | |
| dbo.QERPasswordQueryAndAnswer | bit | nullable |
Remarks
9 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductGroup | nvarchar(max) | nullable | |
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.ESet | nvarchar(max) | nullable | |
| dbo.FirmPartner | nvarchar(max) | nullable | |
| dbo.Hardware | nvarchar(max) | nullable | |
| dbo.Investment | nvarchar(max) | nullable | |
| dbo.Person | nvarchar(max) | nullable | |
| dbo.PWODecisionRule | nvarchar(max) | nullable | |
| dbo.QBMCustomSQL | nvarchar(1024) | nullable |
UID_DialogProduct
9 occurrences1 data types8 outgoing FK refs8 incoming FK refs
UID_PersonWantsOrg
9 occurrences1 data types6 outgoing FK refs8 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Delegation | varchar(38) | required | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.HelperPWOCompliance | varchar(38) | nullable | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.HelperPWOPersonHasObject | varchar(38) | nullable | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.PersonInNCHasMControl | varchar(38) | nullable | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.PersonWantsOrg | varchar(38) | required | ← dbo.AttestationHelper.UID_PWORulerOrigin ← dbo.PersonInNCHasMControl.UID_PersonWantsOrg ← dbo.QERUniversalSubstitute.UID_PersonWantsOrg ← dbo.PWODecisionHistory.UID_PersonWantsOrg ← dbo.Delegation.UID_PersonWantsOrg ← dbo.HelperPWOPersonHasObject.UID_PersonWantsOrg ← dbo.HelperPWOCompliance.UID_PersonWantsOrg ← dbo.PWOHelperPWO.UID_PWORulerOrigin |
| dbo.PWODecisionHistory | varchar(38) | nullable | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.PWOHelperPWO | varchar(38) | required | |
| dbo.QERUniversalSubstitute | varchar(38) | required | → dbo.PersonWantsOrg.UID_PersonWantsOrg |
| dbo.ShoppingCartItem | varchar(38) | nullable |
UID_AERoleOwner
8 occurrences1 data types8 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSContainer | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.ADSDomain | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.AttestationPolicyGroup | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.LDAPContainer | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.LDPDomain | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.QBMPwdPolicy | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.UNSRootB | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
UID_ComplianceRule
8 occurrences1 data types7 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ComplianceRule | varchar(38) | required | ← dbo.ComplianceRuleInArea.UID_ComplianceRule ← dbo.ComplianceSubRule.UID_ComplianceRule ← dbo.ComplianceSubRulePerson.UID_ComplianceRule ← dbo.ComplianceRuleHasMControl.UID_ComplianceRule ← dbo.HelperPWOCompliance.UID_ComplianceRule ← dbo.PWOHelperPWO.UID_ComplianceRule ← dbo.PWODecisionHistory.UID_ComplianceRule |
| dbo.ComplianceRuleHasMControl | varchar(38) | required | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.ComplianceRuleInArea | varchar(38) | required | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.ComplianceSubRule | varchar(38) | nullable | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.ComplianceSubRulePerson | varchar(38) | required | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.HelperPWOCompliance | varchar(38) | nullable | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.PWODecisionHistory | varchar(38) | nullable | → dbo.ComplianceRule.UID_ComplianceRule |
| dbo.PWOHelperPWO | varchar(38) | nullable | → dbo.ComplianceRule.UID_ComplianceRule |
UID_DialogCountry
8 occurrences1 data types7 outgoing FK refs13 incoming FK refs
UID_DialogSchedule
8 occurrences1 data types5 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.DialogSchedule.UID_DialogSchedule |
| dbo.AttestationPolicyGroup | varchar(38) | nullable | → dbo.DialogSchedule.UID_DialogSchedule |
| dbo.DialogDashBoardDef | varchar(38) | nullable | → dbo.DialogSchedule.UID_DialogSchedule |
| dbo.DialogSchedule | varchar(38) | required | ← dbo.AttestationPolicyGroup.UID_DialogSchedule ← dbo.AttestationPolicy.UID_DialogSchedule ← dbo.ComplianceRule.UID_DialogScheduleFill ← dbo.ComplianceRule.UID_DialogScheduleCheck ← dbo.JobAutoStart.UID_DialogSchedule ← dbo.DialogDashBoardDef.UID_DialogSchedule ← dbo.DynamicGroup.UID_DialogSchedule |
| dbo.DynamicGroup | varchar(38) | nullable | → dbo.DialogSchedule.UID_DialogSchedule |
| dbo.JobAutoStart | varchar(38) | nullable | → dbo.DialogSchedule.UID_DialogSchedule |
| dbo.QBMDBQueueTaskHasSchedule | varchar(38) | required | |
| dbo.RPSSubscription | varchar(38) | nullable |
UID_DPRProjectionConfig
8 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRJournal | varchar(38) | nullable | |
| dbo.DPRObjectOperation | varchar(38) | required | |
| dbo.DPRProjectionConfig | varchar(38) | required | |
| dbo.DPRProjectionConfigHasConnect | varchar(38) | required | |
| dbo.DPRProjectionConfigStep | varchar(38) | required | |
| dbo.DPRProjectionObjectState | varchar(38) | required | |
| dbo.DPRProjectionStartInfo | varchar(38) | nullable | |
| dbo.DPRRevisionStore | varchar(38) | required |
UID_PWODecisionMethod
8 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.AccProductGroup | varchar(38) | nullable | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.AttestationObjectHasPWODM | varchar(38) | required | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.BaseTree | varchar(38) | nullable | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.BaseTreeHasPWODecisionMethod | varchar(38) | required | → dbo.PWODecisionMethod.UID_PWODecisionMethod |
| dbo.PWODecisionMethod | varchar(38) | required | ← dbo.AttestationPolicy.UID_PWODecisionMethod ← dbo.AttestationObjectHasPWODM.UID_PWODecisionMethod ← dbo.BaseTree.UID_PWODecisionMethod ← dbo.AccProduct.UID_PWODecisionMethod ← dbo.AccProductGroup.UID_PWODecisionMethod ← dbo.BaseTreeHasPWODecisionMethod.UID_PWODecisionMethod |
| dbo.PWOHelperBoardMethod | varchar(38) | required |
UID_QBMTree
8 occurrences1 data types7 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QBMGroupHasTree | varchar(38) | required | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMProduct | varchar(38) | nullable | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMProductHasTree | varchar(38) | required | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMTree | varchar(38) | required | ← dbo.QBMTreeHasTreeResult.UID_QBMTree ← dbo.QBMGroupHasTree.UID_QBMTree ← dbo.QBMProductHasTree.UID_QBMTree ← dbo.QBMTreeHasSheet.UID_QBMTree ← dbo.QBMProduct.UID_QBMTree ← dbo.QBMTreeHasUIDashBoard.UID_QBMTree ← dbo.QBMTreeHasColumn.UID_QBMTree |
| dbo.QBMTreeHasColumn | varchar(38) | nullable | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMTreeHasSheet | varchar(38) | required | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMTreeHasTreeResult | varchar(38) | required | → dbo.QBMTree.UID_QBMTree |
| dbo.QBMTreeHasUIDashBoard | varchar(38) | required | → dbo.QBMTree.UID_QBMTree |
UID_Task
8 occurrences1 data types3 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDBQueue | varchar(38) | nullable | |
| dbo.PWODecisionRule | varchar(38) | nullable | → dbo.QBMDBQueueTask.UID_Task |
| dbo.QBMConfigParmHasTask | varchar(38) | required | → dbo.QBMDBQueueTask.UID_Task |
| dbo.QBMDBQueueCurrent | varchar(38) | nullable | |
| dbo.QBMDBQueuePond | varchar(38) | nullable | |
| dbo.QBMDBQueueTask | varchar(38) | required | ← dbo.QBMDBQueueTaskDepend.UID_TaskPredecessor ← dbo.QBMConfigParmHasTask.UID_Task ← dbo.QBMDBQueueTaskHasSchedule.UID_Task ← dbo.PWODecisionRule.UID_Task ← dbo.BaseTreeAssign.UID_TaskHardware |
| dbo.QBMDBQueueTaskHasSchedule | varchar(38) | required | → dbo.QBMDBQueueTask.UID_Task |
| dbo.QBMDBQueueTaskMetric | varchar(38) | required |
UID_UNSRootB
8 occurrences1 data types7 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.UNSAccountB | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSContainerB | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSGroupB | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSGroupB1 | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSGroupB2 | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSGroupB3 | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSItemB | varchar(38) | required | → dbo.UNSRootB.UID_UNSRootB |
| dbo.UNSRootB | varchar(38) | required | ← dbo.UNSGroupB.UID_UNSRootB ← dbo.UNSAccountB.UID_UNSRootB ← dbo.UNSContainerB.UID_UNSRootB ← dbo.UNSItemB.UID_UNSRootB ← dbo.UNSGroupB1.UID_UNSRootB ← dbo.UNSGroupB2.UID_UNSRootB ← dbo.UNSGroupB3.UID_UNSRootB |
Caption
7 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogAuthentifier | nvarchar(64) | nullable | |
| dbo.DialogColumn | nvarchar(256) | nullable | |
| dbo.DialogMethod | nvarchar(256) | nullable | |
| dbo.DialogSheet | nvarchar(128) | required | |
| dbo.QBMRelation | nvarchar(256) | nullable | |
| dbo.QBMTree | nvarchar(255) | nullable | |
| dbo.QBMTreeResult | nvarchar(128) | nullable |
CustomRemarks
7 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogGroup | nvarchar(255) | nullable | |
| dbo.DialogObject | nvarchar(255) | nullable | |
| dbo.DialogTable | nvarchar(255) | nullable | |
| dbo.DialogUser | nvarchar(255) | nullable | |
| dbo.JobChain | nvarchar(255) | nullable | |
| dbo.JobComponent | nvarchar(255) | nullable | |
| dbo.QBMProduct | nvarchar(255) | nullable |
UID_ADSDomain
7 occurrences1 data types6 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
| dbo.ADSContact | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
| dbo.ADSContainer | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
| dbo.ADSDomain | varchar(38) | required | ← dbo.DomainTrustsDomain.UID_ADSDomainTrusts ← dbo.ADSPolicy.UID_ADSDomain ← dbo.ADSContact.UID_ADSDomain ← dbo.ADSAccount.UID_ADSDomain ← dbo.ADSGroup.UID_ADSDomain ← dbo.ADSMachine.UID_ADSDomain ← dbo.ADSContainer.UID_ADSDomain |
| dbo.ADSGroup | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
| dbo.ADSMachine | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
| dbo.ADSPolicy | varchar(38) | required | → dbo.ADSDomain.UID_ADSDomain |
UID_ADSGroup
7 occurrences1 data types2 outgoing FK refs7 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccountInADSGroup | varchar(38) | required | |
| dbo.ADSContactInADSGroup | varchar(38) | required | |
| dbo.ADSGroup | varchar(38) | required | ← dbo.ADSGroupExclusion.UID_ADSGroupLower ← dbo.ADSGroupSecretary.UID_ADSGroup ← dbo.ADSGroupCollection.UID_ADSGroupParent ← dbo.ADSOtherSIDInADSGroup.UID_ADSGroup ← dbo.ADSGroupInADSGroup.UID_ADSGroupParent ← dbo.ADSAccount.UID_ADSGroupPrimary ← dbo.ADSMachine.UID_ADSGroupPrimary |
| dbo.ADSGroupSecretary | varchar(38) | required | → dbo.ADSGroup.UID_ADSGroup |
| dbo.ADSMachineInADSGroup | varchar(38) | required | |
| dbo.ADSOtherSIDInADSGroup | varchar(38) | required | → dbo.ADSGroup.UID_ADSGroup |
| dbo.BaseTreeHasADSGroup | varchar(38) | required |
UID_AttestationPolicy
7 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(38) | required | → dbo.AttestationPolicy.UID_AttestationPolicy |
| dbo.AttestationPolicy | varchar(38) | required | ← dbo.AttestationCase.UID_AttestationPolicy ← dbo.AttestationRun.UID_AttestationPolicy ← dbo.HelperAttestationPolicy.UID_AttestationPolicy ← dbo.AttestationPolicyInArea.UID_AttestationPolicy ← dbo.AttestationPolicyHasApprover.UID_AttestationPolicy ← dbo.AttestationPolicyHasMControl.UID_AttestationPolicy |
| dbo.AttestationPolicyHasApprover | varchar(38) | required | → dbo.AttestationPolicy.UID_AttestationPolicy |
| dbo.AttestationPolicyHasMControl | varchar(38) | required | → dbo.AttestationPolicy.UID_AttestationPolicy |
| dbo.AttestationPolicyInArea | varchar(38) | required | → dbo.AttestationPolicy.UID_AttestationPolicy |
| dbo.AttestationRun | varchar(38) | nullable | → dbo.AttestationPolicy.UID_AttestationPolicy |
| dbo.HelperAttestationPolicy | varchar(38) | required | → dbo.AttestationPolicy.UID_AttestationPolicy |
UID_Department
7 occurrences1 data types4 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ComplianceRule | varchar(38) | nullable | |
| dbo.Hardware | varchar(38) | nullable | |
| dbo.MitigatingControl | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.Person | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.PersonWantsOrg | varchar(38) | nullable | |
| dbo.ShoppingCartItem | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.WorkDesk | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
UID_DialogImage
7 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogImage | varchar(38) | required | ← dbo.DialogObject.UID_DialogImage ← dbo.DialogMethod.UID_DialogImage ← dbo.DialogSheet.UID_DialogImage ← dbo.DialogTable.UID_DialogImage ← dbo.QBMTree.UID_DialogImage ← dbo.QBMTreeResult.UID_DialogImage |
| dbo.DialogMethod | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
| dbo.DialogObject | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
| dbo.DialogSheet | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
| dbo.DialogTable | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
| dbo.QBMTree | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
| dbo.QBMTreeResult | varchar(38) | nullable | → dbo.DialogImage.UID_DialogImage |
UID_DialogState
7 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | varchar(38) | nullable | → dbo.DialogState.UID_DialogState |
| dbo.DialogState | varchar(38) | required | ← dbo.DialogStateHasTimeZone.UID_DialogState ← dbo.DialogStateHoliday.UID_DialogState ← dbo.DialogStateHasCulture.UID_DialogState ← dbo.Person.UID_DialogState ← dbo.BaseTree.UID_DialogState ← dbo.FirmPartner.UID_DialogState |
| dbo.DialogStateHasCulture | varchar(38) | required | → dbo.DialogState.UID_DialogState |
| dbo.DialogStateHasTimeZone | varchar(38) | required | → dbo.DialogState.UID_DialogState |
| dbo.DialogStateHoliday | varchar(38) | required | → dbo.DialogState.UID_DialogState |
| dbo.FirmPartner | varchar(38) | nullable | → dbo.DialogState.UID_DialogState |
| dbo.Person | varchar(38) | nullable | → dbo.DialogState.UID_DialogState |
UID_DPRSchemaType
7 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRProjectionDependency | varchar(38) | required | |
| dbo.DPRSchemaClass | varchar(38) | required | |
| dbo.DPRSchemaMethod | varchar(38) | required | |
| dbo.DPRSchemaProperty | varchar(38) | required | |
| dbo.DPRSchemaType | varchar(38) | required | |
| dbo.DPRScript | varchar(38) | nullable | |
| dbo.DPRSystemScopeFilter | varchar(38) | required |
UID_DPRSystemVariableSet
7 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRJournal | varchar(38) | nullable | |
| dbo.DPRProjectionObjectState | varchar(38) | nullable | |
| dbo.DPRProjectionStartInfo | varchar(38) | nullable | |
| dbo.DPRRevisionStore | varchar(38) | nullable | |
| dbo.DPRRootObjConnectionInfo | varchar(38) | required | |
| dbo.DPRSystemVariable | varchar(38) | required | |
| dbo.DPRSystemVariableSet | varchar(38) | required |
UID_ESet
7 occurrences1 data types3 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasESet | varchar(38) | required | |
| dbo.ESet | varchar(38) | required | ← dbo.ESetHasEntitlement.UID_ESet ← dbo.PersonHasESet.UID_ESet ← dbo.ESetCollection.UID_ESetChild ← dbo.ESetExcludesESet.UID_ESet |
| dbo.ESetCollection | varchar(38) | required | |
| dbo.ESetExcludesESet | varchar(38) | required | → dbo.ESet.UID_ESet |
| dbo.ESetHasEntitlement | varchar(38) | required | → dbo.ESet.UID_ESet |
| dbo.PersonHasESet | varchar(38) | required | → dbo.ESet.UID_ESet |
| dbo.WorkDeskHasESet | varchar(38) | required |
UID_Job
7 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogProcessStep | varchar(38) | required | |
| dbo.Job | varchar(38) | required | |
| dbo.JobChain | varchar(38) | nullable | |
| dbo.JobHistory | varchar(38) | required | |
| dbo.JobQueue | varchar(38) | required | |
| dbo.JobRunParameter | varchar(38) | required | |
| dbo.QBMElementAffectedByJob | varchar(38) | required |
UID_MitigatingControl
7 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCaseHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
| dbo.AttestationPolicyHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
| dbo.ComplianceRuleHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
| dbo.MitigatingControl | varchar(38) | required | ← dbo.AttestationCaseHasMControl.UID_MitigatingControl ← dbo.AttestationPolicyHasMControl.UID_MitigatingControl ← dbo.ComplianceRuleHasMControl.UID_MitigatingControl ← dbo.PersonInNCHasMControl.UID_MitigatingControl ← dbo.PolicyObjectHasMControl.UID_MitigatingControl ← dbo.QERPolicyHasMControl.UID_MitigatingControl |
| dbo.PersonInNCHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
| dbo.PolicyObjectHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
| dbo.QERPolicyHasMControl | varchar(38) | required | → dbo.MitigatingControl.UID_MitigatingControl |
UID_QERJustification
7 occurrences1 data types6 outgoing FK refs8 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
| dbo.AttestationHistory | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
| dbo.PersonInBaseTree | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
| dbo.PersonWantsOrg | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
| dbo.PWODecisionHistory | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
| dbo.QERJustification | varchar(38) | required | ← dbo.AttestationCase.UID_QERJustification ← dbo.AttestationHistory.UID_QERJustification ← dbo.PersonInBaseTree.UID_QERJustification ← dbo.QERPolicyHasObject.UID_QERJustification ← dbo.PersonWantsOrg.UID_QERJustificationOrder ← dbo.ShoppingCartItem.UID_QERJustificationOrder ← dbo.PersonWantsOrg.UID_QERJustification ← dbo.PWODecisionHistory.UID_QERJustification |
| dbo.QERPolicyHasObject | varchar(38) | nullable | → dbo.QERJustification.UID_QERJustification |
UID_QERResourceType
7 occurrences1 data types6 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
| dbo.QERAssign | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
| dbo.QERResource | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
| dbo.QERResourceType | varchar(38) | required | ← dbo.PersonWantsOrg.UID_QERResourceType ← dbo.QERResource.UID_QERResourceType ← dbo.QERAssign.UID_QERResourceType ← dbo.QERReuse.UID_QERResourceType ← dbo.QERReuseUS.UID_QERResourceType ← dbo.TSBAccountDef.UID_QERResourceType |
| dbo.QERReuse | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
| dbo.QERReuseUS | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
| dbo.TSBAccountDef | varchar(38) | nullable | → dbo.QERResourceType.UID_QERResourceType |
Commentary
6 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(256) | nullable | |
| dbo.DialogColumn | nvarchar(1024) | nullable | |
| dbo.DialogTag | nvarchar(max) | nullable | |
| dbo.DialogTimeZone | nvarchar(64) | nullable | |
| dbo.ESet | nvarchar(256) | nullable | |
| dbo.WorkDesk | nvarchar(256) | nullable |
Fax
6 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.FirmPartner | nvarchar(max) | nullable | |
| dbo.Person | nvarchar(max) | nullable | |
| dbo.WorkDesk | nvarchar(max) | nullable |
IsCircular
6 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSGroupCollection | bit | nullable | |
| dbo.LDAPGroupCollection | bit | nullable | |
| dbo.UNSGroupB1Collection | bit | nullable | |
| dbo.UNSGroupB2Collection | bit | nullable | |
| dbo.UNSGroupB3Collection | bit | nullable | |
| dbo.UNSGroupBCollection | bit | nullable |
ObjectKeyManager
6 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(138) | nullable | |
| dbo.ADSContact | varchar(138) | nullable | |
| dbo.ADSContainer | varchar(138) | nullable | |
| dbo.ADSDomain | varchar(138) | nullable | |
| dbo.ADSGroup | varchar(138) | nullable | |
| dbo.ADSMachine | varchar(138) | nullable |
ObjectSID
6 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(255) | nullable | |
| dbo.ADSDomain | nvarchar(255) | nullable | |
| dbo.ADSGroup | nvarchar(255) | nullable | |
| dbo.ADSMachine | nvarchar(255) | nullable | |
| dbo.ADSOtherSID | nvarchar(255) | nullable | |
| dbo.LDAPAccount | nvarchar(256) | nullable |
Operation
6 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDeferredOperation | nvarchar(32) | nullable | |
| dbo.DialogUserDisplayConfig | nvarchar(32) | nullable | |
| dbo.DPRMemberShipAction | varchar(3) | required | |
| dbo.QBMCEFMessage | varchar(1) | nullable | |
| dbo.QBMPendingChange | varchar(1) | required | |
| dbo.QBMPendingChangeDetail | varchar(1) | required |
ReasonHead
6 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | nvarchar(max) | nullable | |
| dbo.AttestationHelper | nvarchar(max) | nullable | |
| dbo.AttestationHistory | nvarchar(max) | nullable | |
| dbo.PersonWantsOrg | nvarchar(max) | nullable | |
| dbo.PWODecisionHistory | nvarchar(max) | nullable | |
| dbo.PWOHelperPWO | nvarchar(max) | nullable |
Street
6 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSContainer | nvarchar(max) | nullable | |
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.FirmPartner | nvarchar(max) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable | |
| dbo.Person | nvarchar(max) | nullable |
UID_DialogFeature
6 occurrences1 data types5 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogGroupHasFeature | varchar(38) | required | → dbo.QBMFeature.UID_DialogFeature |
| dbo.QBMEventHasFeature | varchar(38) | required | → dbo.QBMFeature.UID_DialogFeature |
| dbo.QBMFeature | varchar(38) | required | ← dbo.QBMLaunchActionHasFeature.UID_DialogFeature ← dbo.DialogGroupHasFeature.UID_DialogFeature ← dbo.QBMScriptHasFeature.UID_DialogFeature ← dbo.QBMMethodHasFeature.UID_DialogFeature ← dbo.QBMEventHasFeature.UID_DialogFeature |
| dbo.QBMLaunchActionHasFeature | varchar(38) | required | → dbo.QBMFeature.UID_DialogFeature |
| dbo.QBMMethodHasFeature | varchar(38) | required | → dbo.QBMFeature.UID_DialogFeature |
| dbo.QBMScriptHasFeature | varchar(38) | required | → dbo.QBMFeature.UID_DialogFeature |
UID_DialogSheet
6 occurrences1 data types5 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogGroupHasSheet | varchar(38) | required | → dbo.DialogSheet.UID_DialogSheet |
| dbo.DialogObjectHasSheet | varchar(38) | required | → dbo.DialogSheet.UID_DialogSheet |
| dbo.DialogProductHasSheet | varchar(38) | required | → dbo.DialogSheet.UID_DialogSheet |
| dbo.DialogSheet | varchar(38) | required | ← dbo.DialogObjectHasSheet.UID_DialogSheet ← dbo.DialogGroupHasSheet.UID_DialogSheet ← dbo.DialogProductHasSheet.UID_DialogSheet ← dbo.QBMTreeHasSheet.UID_DialogSheet ← dbo.QBMTreeResultHasSheet.UID_DialogSheet |
| dbo.QBMTreeHasSheet | varchar(38) | required | → dbo.DialogSheet.UID_DialogSheet |
| dbo.QBMTreeResultHasSheet | varchar(38) | required | → dbo.DialogSheet.UID_DialogSheet |
UID_FunctionalArea
6 occurrences1 data types5 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.FunctionalArea.UID_FunctionalArea |
| dbo.AccProductInFunctionalArea | varchar(38) | required | → dbo.FunctionalArea.UID_FunctionalArea |
| dbo.BaseTree | varchar(38) | nullable | → dbo.FunctionalArea.UID_FunctionalArea |
| dbo.ComplianceRule | varchar(38) | nullable | → dbo.FunctionalArea.UID_FunctionalArea |
| dbo.FunctionalArea | varchar(38) | required | ← dbo.MitigatingControl.UID_FunctionalArea ← dbo.ComplianceRule.UID_FunctionalArea ← dbo.BaseTree.UID_FunctionalArea ← dbo.AccProduct.UID_FunctionalArea ← dbo.AccProductInFunctionalArea.UID_FunctionalArea |
| dbo.MitigatingControl | varchar(38) | nullable | → dbo.FunctionalArea.UID_FunctionalArea |
UID_ProfitCenter
6 occurrences1 data types2 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | |
| dbo.Hardware | varchar(38) | nullable | |
| dbo.Person | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.PersonWantsOrg | varchar(38) | nullable | |
| dbo.ShoppingCartItem | varchar(38) | nullable | |
| dbo.WorkDesk | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
UID_TSBBehavior
6 occurrences1 data types5 outgoing FK refs6 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(38) | nullable | → dbo.TSBBehavior.UID_TSBBehavior |
| dbo.ADSContact | varchar(38) | nullable | → dbo.TSBBehavior.UID_TSBBehavior |
| dbo.LDAPAccount | varchar(38) | nullable | → dbo.TSBBehavior.UID_TSBBehavior |
| dbo.TSBAccountDefHasBehavior | varchar(38) | required | → dbo.TSBBehavior.UID_TSBBehavior |
| dbo.TSBBehavior | varchar(38) | required | ← dbo.ADSAccount.UID_TSBBehavior ← dbo.ADSContact.UID_TSBBehavior ← dbo.LDAPAccount.UID_TSBBehavior ← dbo.TSBAccountDef.UID_TSBBehaviorDefault ← dbo.TSBAccountDefHasBehavior.UID_TSBBehavior ← dbo.UNSAccountB.UID_TSBBehavior |
| dbo.UNSAccountB | varchar(38) | nullable | → dbo.TSBBehavior.UID_TSBBehavior |
UID_UNSContainerB
6 occurrences1 data types5 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.UNSAccountB | varchar(38) | nullable | → dbo.UNSContainerB.UID_UNSContainerB |
| dbo.UNSContainerB | varchar(38) | required | ← dbo.UNSGroupB.UID_UNSContainerB ← dbo.UNSAccountB.UID_UNSContainerB ← dbo.UNSGroupB1.UID_UNSContainerB ← dbo.UNSGroupB2.UID_UNSContainerB ← dbo.UNSGroupB3.UID_UNSContainerB |
| dbo.UNSGroupB | varchar(38) | nullable | → dbo.UNSContainerB.UID_UNSContainerB |
| dbo.UNSGroupB1 | varchar(38) | nullable | → dbo.UNSContainerB.UID_UNSContainerB |
| dbo.UNSGroupB2 | varchar(38) | nullable | → dbo.UNSContainerB.UID_UNSContainerB |
| dbo.UNSGroupB3 | varchar(38) | nullable | → dbo.UNSContainerB.UID_UNSContainerB |
UID_WorkDesk
6 occurrences1 data types1 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Hardware | varchar(38) | nullable | |
| dbo.HelperWorkDeskOrg | varchar(38) | required | → dbo.WorkDesk.UID_WorkDesk |
| dbo.Person | varchar(38) | nullable | |
| dbo.WorkDesk | varchar(38) | required | ← dbo.HelperWorkDeskOrg.UID_WorkDesk ← dbo.PersonWantsOrg.UID_WorkDeskOrdered ← dbo.ShoppingCartItem.UID_WorkDeskOrdered |
| dbo.WorkDeskHasESet | varchar(38) | required | |
| dbo.WorkDeskInBaseTree | varchar(38) | required |
ApproveReasonType
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | int | nullable | |
| dbo.AccProductGroup | int | nullable | |
| dbo.AttestationPolicy | int | nullable | |
| dbo.PWODecisionStep | int | nullable | |
| dbo.QERWorkingStep | int | nullable |
DenyReasonType
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | int | nullable | |
| dbo.AccProductGroup | int | nullable | |
| dbo.AttestationPolicy | int | nullable | |
| dbo.PWODecisionStep | int | nullable | |
| dbo.QERWorkingStep | int | nullable |
FullPath
5 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductGroup | nvarchar(256) | nullable | |
| dbo.BaseTree | nvarchar(400) | nullable | |
| dbo.DialogConfigParm | nvarchar(256) | required | |
| dbo.QBMConsistencyCheck | nvarchar(256) | nullable | |
| dbo.QBMDeployTarget | nvarchar(256) | nullable |
HasReadOnlyMemberships
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSGroup | bit | nullable | |
| dbo.UNSGroupB | bit | nullable | |
| dbo.UNSGroupB1 | bit | nullable | |
| dbo.UNSGroupB2 | bit | nullable | |
| dbo.UNSGroupB3 | bit | nullable |
IdentityType
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(32) | nullable | |
| dbo.ADSContact | varchar(32) | nullable | |
| dbo.LDAPAccount | varchar(32) | nullable | |
| dbo.Person | varchar(32) | nullable | |
| dbo.UNSAccountB | varchar(32) | nullable |
IsAutoAssignToPerson
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QERAssign | bit | nullable | |
| dbo.QERResource | bit | nullable | |
| dbo.QERReuse | bit | nullable | |
| dbo.QERReuseUS | bit | nullable | |
| dbo.TSBAccountDef | bit | nullable |
IsCrypted
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogColumn | bit | nullable | |
| dbo.DialogConfigParm | bit | nullable | |
| dbo.JobParameter | bit | nullable | |
| dbo.JobRunParameter | bit | nullable | |
| dbo.JobTreeParamColl | bit | nullable |
IsDeactivated
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogMethod | bit | nullable | |
| dbo.DialogSheet | bit | nullable | |
| dbo.DPRProjectionConfigStep | bit | nullable | |
| dbo.QBMTree | bit | nullable | |
| dbo.QBMTreeResult | bit | nullable |
IsProtectedFromAccidentalDel
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bit | nullable | |
| dbo.ADSContact | bit | nullable | |
| dbo.ADSContainer | bit | nullable | |
| dbo.ADSGroup | bit | nullable | |
| dbo.ADSMachine | bit | nullable |
IsReadOnly
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductParameter | bit | nullable | |
| dbo.DialogUser | bit | nullable | |
| dbo.DPRSchemaMethod | bit | nullable | |
| dbo.DPRSchemaType | bit | nullable | |
| dbo.DPRSystemConnection | bit | nullable |
JPegPhoto
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varbinary(max) | nullable | |
| dbo.AccProductGroup | varbinary(max) | nullable | |
| dbo.LDAPAccount | varbinary(max) | nullable | |
| dbo.Person | varbinary(max) | nullable | |
| dbo.RelatedApplication | varbinary(max) | nullable |
PostalCode
5 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(40) | nullable | |
| dbo.ADSContact | nvarchar(40) | nullable | |
| dbo.ADSContainer | nvarchar(16) | nullable | |
| dbo.LDAPAccount | nvarchar(30) | nullable | |
| dbo.LDAPContainer | nvarchar(40) | nullable |
ReadyForDeleteOrExport
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogProcess | int | nullable | |
| dbo.DialogProcessChain | int | nullable | |
| dbo.DialogProcessSubstitute | int | nullable | |
| dbo.DialogWatchOperation | int | nullable | |
| dbo.JobHistory | int | nullable |
ShortName
5 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.DialogState | nvarchar(16) | nullable | |
| dbo.DialogTimeZone | nvarchar(8) | nullable | |
| dbo.FirmPartner | nvarchar(32) | nullable | |
| dbo.ShoppingCartPattern | nvarchar(64) | nullable |
TaskName
5 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobHistory | nvarchar(64) | nullable | |
| dbo.JobPerformance | nvarchar(64) | required | |
| dbo.JobQueue | nvarchar(64) | required | |
| dbo.JobTask | nvarchar(64) | nullable | |
| dbo.QBMLaunchAction | nvarchar(512) | nullable |
UID_ADSContainer
5 occurrences1 data types4 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(38) | nullable | → dbo.ADSContainer.UID_ADSContainer |
| dbo.ADSContact | varchar(38) | nullable | → dbo.ADSContainer.UID_ADSContainer |
| dbo.ADSContainer | varchar(38) | required | ← dbo.ADSContact.UID_ADSContainer ← dbo.ADSAccount.UID_ADSContainer ← dbo.ADSMachine.UID_ADSContainer ← dbo.ADSGroup.UID_ADSContainer ← dbo.ADSAccount.UID_ADSContainerDisabled |
| dbo.ADSGroup | varchar(38) | nullable | → dbo.ADSContainer.UID_ADSContainer |
| dbo.ADSMachine | varchar(38) | nullable | → dbo.ADSContainer.UID_ADSContainer |
UID_DialogDashBoardDef
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDashBoardContent | varchar(38) | nullable | → dbo.DialogDashBoardDef.UID_DialogDashBoardDef |
| dbo.DialogDashBoardDef | varchar(38) | required | ← dbo.QERPolicy.UID_DialogDashBoardDef ← dbo.DialogDashBoardContent.UID_DialogDashBoardDef ← dbo.QBMUIDashBoard.UID_DialogDashBoardDef ← dbo.QBMTree.UID_DialogDashBoardDef |
| dbo.QBMTree | varchar(38) | nullable | → dbo.DialogDashBoardDef.UID_DialogDashBoardDef |
| dbo.QBMUIDashBoard | varchar(38) | required | → dbo.DialogDashBoardDef.UID_DialogDashBoardDef |
| dbo.QERPolicy | varchar(38) | nullable | → dbo.DialogDashBoardDef.UID_DialogDashBoardDef |
UID_DialogObject
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogObject | varchar(38) | required | ← dbo.DialogObjectHasMethod.UID_DialogObject ← dbo.DialogObjectHasSheet.UID_DialogObject ← dbo.QBMXUserFilter.UID_DialogObject ← dbo.QBMTreeResult.UID_DialogObject |
| dbo.DialogObjectHasMethod | varchar(38) | required | → dbo.DialogObject.UID_DialogObject |
| dbo.DialogObjectHasSheet | varchar(38) | required | → dbo.DialogObject.UID_DialogObject |
| dbo.QBMTreeResult | varchar(38) | nullable | → dbo.DialogObject.UID_DialogObject |
| dbo.QBMXUserFilter | varchar(38) | nullable | → dbo.DialogObject.UID_DialogObject |
UID_DPRJournal
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRJournal | varchar(38) | required | |
| dbo.DPRJournalFailure | varchar(38) | required | |
| dbo.DPRJournalMessage | varchar(38) | nullable | |
| dbo.DPRJournalObject | varchar(38) | required | |
| dbo.DPRJournalSetup | varchar(38) | required |
UID_DPRSchema
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchema | varchar(38) | required | |
| dbo.DPRSchemaPropertyReference | varchar(38) | required | |
| dbo.DPRSchemaType | varchar(38) | required | |
| dbo.DPRSystemConnection | varchar(38) | required | |
| dbo.DPRSystemScope | varchar(38) | required |
UID_Hardware
5 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSMachine | varchar(38) | nullable | → dbo.Hardware.UID_Hardware |
| dbo.Hardware | varchar(38) | required | ← dbo.ADSMachine.UID_Hardware ← dbo.LDPMachine.UID_Hardware ← dbo.HelperHardwareOrg.UID_Hardware |
| dbo.HardwareInBaseTree | varchar(38) | required | |
| dbo.HelperHardwareOrg | varchar(38) | required | → dbo.Hardware.UID_Hardware |
| dbo.LDPMachine | varchar(38) | nullable | → dbo.Hardware.UID_Hardware |
UID_LDPDomain
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.LDAPAccount | varchar(38) | required | → dbo.LDPDomain.UID_LDPDomain |
| dbo.LDAPContainer | varchar(38) | required | → dbo.LDPDomain.UID_LDPDomain |
| dbo.LDAPGroup | varchar(38) | required | → dbo.LDPDomain.UID_LDPDomain |
| dbo.LDPDomain | varchar(38) | required | ← dbo.LDAPContainer.UID_LDPDomain ← dbo.LDAPAccount.UID_LDPDomain ← dbo.LDAPGroup.UID_LDPDomain ← dbo.LDPMachine.UID_LDPDomain |
| dbo.LDPMachine | varchar(38) | required | → dbo.LDPDomain.UID_LDPDomain |
UID_OrgAttestator
5 occurrences1 data types4 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.AccProductGroup | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.BaseTree | varchar(38) | nullable | |
| dbo.ComplianceRule | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
| dbo.OrgRoot | varchar(38) | nullable | → dbo.BaseTree.UID_Org |
UID_OrgRoot
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | varchar(38) | required | → dbo.OrgRoot.UID_OrgRoot |
| dbo.OrgRoot | varchar(38) | required | ← dbo.QERUniversalSubstituteInRoot.UID_OrgRoot ← dbo.BaseTree.UID_OrgRoot ← dbo.OrgRootAssign.UID_OrgRoot ← dbo.QEROrgRootHasOrgType.UID_OrgRoot |
| dbo.OrgRootAssign | varchar(38) | required | → dbo.OrgRoot.UID_OrgRoot |
| dbo.QEROrgRootHasOrgType | varchar(38) | required | → dbo.OrgRoot.UID_OrgRoot |
| dbo.QERUniversalSubstituteInRoot | varchar(38) | required | → dbo.OrgRoot.UID_OrgRoot |
UID_OrgType
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | varchar(38) | nullable | → dbo.OrgType.UID_OrgType |
| dbo.OrgRoot | varchar(38) | nullable | → dbo.OrgType.UID_OrgType |
| dbo.OrgType | varchar(38) | required | ← dbo.BaseTree.UID_OrgType ← dbo.OrgRoot.UID_OrgType ← dbo.QEROrgRootHasOrgType.UID_OrgType ← dbo.PWODecisionMethod.UID_OrgType |
| dbo.PWODecisionMethod | varchar(38) | nullable | → dbo.OrgType.UID_OrgType |
| dbo.QEROrgRootHasOrgType | varchar(38) | required | → dbo.OrgType.UID_OrgType |
UID_QBMEvent
5 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobAutoStart | varchar(38) | nullable | → dbo.QBMEvent.UID_QBMEvent |
| dbo.JobEventGen | varchar(38) | nullable | → dbo.QBMEvent.UID_QBMEvent |
| dbo.POLPlaybookAction | varchar(38) | required | → dbo.QBMEvent.UID_QBMEvent |
| dbo.QBMEvent | varchar(38) | required | ← dbo.POLPlaybookAction.UID_QBMEvent ← dbo.JobEventGen.UID_QBMEvent ← dbo.JobAutoStart.UID_QBMEvent |
| dbo.QBMEventHasFeature | varchar(38) | required |
UID_QBMIdentityProvider
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QBMIdentityClient | varchar(38) | required | → dbo.QBMIdentityProvider.UID_QBMIdentityProvider |
| dbo.QBMIdentityProvDisabledCol | varchar(38) | required | → dbo.QBMIdentityProvider.UID_QBMIdentityProvider |
| dbo.QBMIdentityProvEnabledCol | varchar(38) | required | → dbo.QBMIdentityProvider.UID_QBMIdentityProvider |
| dbo.QBMIdentityProvider | varchar(38) | required | ← dbo.QBMIdentityClient.UID_QBMIdentityProvider ← dbo.QBMIdentityProvEnabledCol.UID_QBMIdentityProvider ← dbo.QBMIdentityProvDisabledCol.UID_QBMIdentityProvider ← dbo.QERWebAuthnKey.UID_QBMIdentityProvider |
| dbo.QERWebAuthnKey | varchar(38) | required | → dbo.QBMIdentityProvider.UID_QBMIdentityProvider |
UID_QBMServer
5 occurrences1 data types4 outgoing FK refs8 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRRootObjConnectionInfo | varchar(38) | nullable | → dbo.QBMServer.UID_QBMServer |
| dbo.DPRServiceGate | varchar(38) | required | → dbo.QBMServer.UID_QBMServer |
| dbo.QBMServer | varchar(38) | required | ← dbo.BaseTree.UID_DefaultPrintServer ← dbo.ADSAccount.UID_TerminalProfileServer ← dbo.DPRServiceGate.UID_QBMServer ← dbo.DPRRootObjConnectionInfo.UID_QBMServer ← dbo.QBMServerHasServerTag.UID_QBMServer ← dbo.QBMServerHasDeployTarget.UID_QBMServer ← dbo.ServerHasShares.UID_Server ← dbo.UNSRootB.UID_SyncServer |
| dbo.QBMServerHasDeployTarget | varchar(38) | required | → dbo.QBMServer.UID_QBMServer |
| dbo.QBMServerHasServerTag | varchar(38) | required | → dbo.QBMServer.UID_QBMServer |
UID_QBMServerTag
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRRootObjConnectionInfo | varchar(38) | nullable | → dbo.QBMServerTag.UID_QBMServerTag |
| dbo.Job | varchar(38) | nullable | → dbo.QBMServerTag.UID_QBMServerTag |
| dbo.QBMDeployTargetHasServerTag | varchar(38) | required | → dbo.QBMServerTag.UID_QBMServerTag |
| dbo.QBMServerHasServerTag | varchar(38) | required | → dbo.QBMServerTag.UID_QBMServerTag |
| dbo.QBMServerTag | varchar(38) | required | ← dbo.DPRRootObjConnectionInfo.UID_QBMServerTag ← dbo.QBMServerHasServerTag.UID_QBMServerTag ← dbo.Job.UID_QBMServerTag ← dbo.QBMDeployTargetHasServerTag.UID_QBMServerTag |
UID_QBMXUser
5 occurrences1 data types4 outgoing FK refs4 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogUserConfiguration | varchar(38) | required | → dbo.QBMXUser.UID_QBMXUser |
| dbo.DialogUserDisplayConfig | varchar(38) | nullable | → dbo.QBMXUser.UID_QBMXUser |
| dbo.QBMUserConfig | varchar(38) | required | → dbo.QBMXUser.UID_QBMXUser |
| dbo.QBMXUser | varchar(38) | required | ← dbo.DialogUserConfiguration.UID_QBMXUser ← dbo.DialogUserDisplayConfig.UID_QBMXUser ← dbo.QBMXUserFilter.UID_QBMXUser ← dbo.QBMUserConfig.UID_QBMXUser |
| dbo.QBMXUserFilter | varchar(38) | nullable | → dbo.QBMXUser.UID_QBMXUser |
UID_Tree
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogProcessChain | varchar(38) | required | |
| dbo.DialogProcessStep | varchar(38) | nullable | |
| dbo.JobHistory | varchar(38) | required | |
| dbo.JobQueue | varchar(38) | required | |
| dbo.JobTreeParamColl | varchar(38) | required |
UID_UNSGroupB
5 occurrences1 data types0 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasUNSGroupB | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB | varchar(38) | required | |
| dbo.UNSGroupB | varchar(38) | required | ← dbo.UNSGroupBExclusion.UID_UNSGroupBLower ← dbo.UNSGroupBInUNSGroupB.UID_UNSGroupBParent ← dbo.UNSGroupBCollection.UID_UNSGroupBChild |
| dbo.UNSGroupBHasUnsItemB | varchar(38) | required |
UsageArea
5 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PWODecisionMethod | char(1) | nullable | |
| dbo.PWODecisionRule | char(1) | required | |
| dbo.PWODecisionStep | char(1) | nullable | |
| dbo.PWODecisionSubMethod | char(1) | nullable | |
| dbo.QERBufferRecalcDecisionMaker | varchar(1) | required |
WhereClauseAddOn
5 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | nvarchar(max) | nullable | |
| dbo.ComplianceRule | nvarchar(max) | nullable | |
| dbo.ComplianceSubRule | nvarchar(max) | nullable | |
| dbo.DynamicGroup | nvarchar(max) | nullable | |
| dbo.QERPolicy | nvarchar(max) | nullable |
Building
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.FirmPartner | nvarchar(32) | nullable | |
| dbo.Person | nvarchar(64) | nullable | |
| dbo.WorkDesk | nvarchar(32) | nullable |
ColumnName
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductParameter | nvarchar(32) | nullable | |
| dbo.DialogColumn | varchar(30) | required | |
| dbo.QBMBufferConfig | varchar(30) | nullable | |
| dbo.QBMBufferTransfer | varchar(30) | required |
ComponentClass
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobComponent | nvarchar(200) | nullable | |
| dbo.JobHistory | nvarchar(200) | nullable | |
| dbo.JobPerformance | nvarchar(200) | required | |
| dbo.JobQueue | nvarchar(200) | nullable |
DataType
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogColumn | int | nullable | |
| dbo.DialogParameter | int | nullable | |
| dbo.DPRSchemaProperty | nvarchar(16) | nullable | |
| dbo.QBMConfigLibrary | int | nullable |
DateHead
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | datetime | nullable | |
| dbo.AttestationHistory | datetime | nullable | |
| dbo.PersonWantsOrg | datetime | nullable | |
| dbo.PWODecisionHistory | datetime | nullable |
DecisionLevel
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | int | nullable | |
| dbo.AttestationHistory | int | nullable | |
| dbo.PersonWantsOrg | int | required | |
| dbo.PWODecisionHistory | int | nullable |
DisplayPattern
4 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogObject | nvarchar(255) | nullable | |
| dbo.DialogTable | nvarchar(255) | nullable | |
| dbo.DPRSchemaType | nvarchar(256) | nullable | |
| dbo.QBMXUserFilter | nvarchar(max) | nullable |
DisplayPersonHead
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | nvarchar(255) | nullable | |
| dbo.AttestationHistory | nvarchar(255) | nullable | |
| dbo.PersonWantsOrg | nvarchar(128) | nullable | |
| dbo.PWODecisionHistory | nvarchar(128) | nullable |
ElementColor
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDatabase | nvarchar(16) | nullable | |
| dbo.DialogObject | nvarchar(16) | nullable | |
| dbo.DialogTable | nvarchar(16) | nullable | |
| dbo.QBMTree | nvarchar(16) | nullable |
EmployeeType
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(256) | nullable | |
| dbo.ADSContact | nvarchar(256) | nullable | |
| dbo.LDAPAccount | nvarchar(256) | nullable | |
| dbo.Person | varchar(32) | nullable |
FileName
4 occurrences4 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogAEDS | nvarchar(512) | nullable | |
| dbo.DialogPhysicalForm | nvarchar(255) | nullable | |
| dbo.QBMFileRevision | nvarchar(400) | nullable | |
| dbo.QERTermsOfUseHasFile | nvarchar(1024) | nullable |
GroupType
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.UNSGroupB | nvarchar(64) | nullable | |
| dbo.UNSGroupB1 | nvarchar(64) | nullable | |
| dbo.UNSGroupB2 | nvarchar(64) | nullable | |
| dbo.UNSGroupB3 | nvarchar(64) | nullable |
Ident_PWODecisionStep
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHistory | nvarchar(64) | nullable | |
| dbo.PWODecisionHistory | nvarchar(64) | nullable | |
| dbo.PWODecisionStep | nvarchar(64) | nullable | |
| dbo.QERWorkingStep | nvarchar(64) | nullable |
Initials
4 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(8) | nullable | |
| dbo.ADSContact | nvarchar(8) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.Person | nvarchar(10) | nullable |
IsGroupAccount
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bit | nullable | |
| dbo.ADSContact | bit | nullable | |
| dbo.LDAPAccount | bit | nullable | |
| dbo.UNSAccountB | bit | nullable |
IsManual
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDashBoardDef | bit | nullable | |
| dbo.QBMNonLinearDepend | bit | nullable | |
| dbo.QBMTrustedSQL | bit | nullable | |
| dbo.QERPickCategory | bit | nullable |
IsNeverConnectManual
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bit | nullable | |
| dbo.ADSContact | bit | nullable | |
| dbo.LDAPAccount | bit | nullable | |
| dbo.UNSAccountB | bit | nullable |
IsNoInheriteToSecurityIncident
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QERAssign | bit | nullable | |
| dbo.QERResource | bit | nullable | |
| dbo.QERReuse | bit | nullable | |
| dbo.QERReuseUS | bit | nullable |
IsObsolete
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchemaClass | bit | nullable | |
| dbo.DPRSchemaMethod | bit | nullable | |
| dbo.DPRSchemaProperty | bit | nullable | |
| dbo.DPRSchemaType | bit | nullable |
IsPrivilegedAccount
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bit | nullable | |
| dbo.ADSOtherSID | bit | nullable | |
| dbo.LDAPAccount | bit | nullable | |
| dbo.UNSAccountB | bit | nullable |
IsProcessed
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QBMCEFMessage | bit | nullable | |
| dbo.QBMGuidReplace | bit | nullable | |
| dbo.QBMPendingChange | int | nullable | |
| dbo.QBMPendingChangeDetail | int | nullable |
IsToHideInHistory
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHistory | bit | nullable | |
| dbo.PWODecisionHistory | bit | nullable | |
| dbo.PWODecisionStep | bit | nullable | |
| dbo.QERWorkingStep | bit | nullable |
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(255) | nullable | |
| dbo.ADSContact | nvarchar(255) | nullable | |
| dbo.ADSGroup | nvarchar(255) | nullable | |
| dbo.LDAPAccount | nvarchar(400) | nullable |
MaxInstance
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobComponent | int | nullable | |
| dbo.JobQueue | int | nullable | |
| dbo.JobTask | int | nullable | |
| dbo.QBMDBQueueTask | int | nullable |
MessageString
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogJournal | nvarchar(max) | nullable | |
| dbo.DPRJournalMessage | nvarchar(max) | nullable | |
| dbo.QBMCEFDefinition | nvarchar(max) | nullable | |
| dbo.QERExternalRiskScore | nvarchar(512) | nullable |
MetaData
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchemaMethod | nvarchar(1024) | nullable | |
| dbo.DPRSchemaProperty | nvarchar(1024) | nullable | |
| dbo.DPRSchemaPropertyReference | nvarchar(1024) | nullable | |
| dbo.DPRSchemaType | nvarchar(1024) | nullable |
MSDsConsistencyGuid
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(256) | nullable | |
| dbo.ADSContact | nvarchar(256) | nullable | |
| dbo.ADSGroup | nvarchar(256) | nullable | |
| dbo.ADSMachine | nvarchar(256) | nullable |
NeverConnectToPerson
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | int | nullable | |
| dbo.ADSContact | int | nullable | |
| dbo.LDAPAccount | int | nullable | |
| dbo.UNSAccountB | int | nullable |
ObjectKeyBase
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(138) | nullable | |
| dbo.DPRMemberShipAction | varchar(138) | required | |
| dbo.HelperAttestationPolicy | varchar(138) | required | |
| dbo.QERCloudAssistantMessage | varchar(138) | nullable |
ObjectKeyDialogColumn
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DynamicGroupHasImmediateColumn | varchar(138) | required | |
| dbo.QBMIdentityProvDisabledCol | varchar(138) | required | |
| dbo.QBMIdentityProvEnabledCol | varchar(138) | required | |
| dbo.QBMUniqueGroupHasColumn | varchar(138) | required |
ObjectKeyOfRow
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogWatchOperation | varchar(138) | required | |
| dbo.QBMBufferConfig | varchar(138) | required | |
| dbo.QBMBufferTransfer | varchar(138) | required | |
| dbo.QBMLock | varchar(138) | required |
ObjectState
4 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDeferredOperation | nvarchar(max) | nullable | |
| dbo.DPRJournalFailure | nvarchar(64) | nullable | |
| dbo.DPRJournalObject | nvarchar(64) | nullable | |
| dbo.DPRProjectionObjectState | int | nullable |
OrderNumber
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(64) | nullable | |
| dbo.DialogObject | int | nullable | |
| dbo.PWOState | int | nullable | |
| dbo.QBMColumnLimitedValue | int | nullable |
OrderState
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Delegation | nvarchar(16) | nullable | |
| dbo.PersonWantsOrg | nvarchar(16) | required | |
| dbo.PWODecisionHistory | nvarchar(16) | nullable | |
| dbo.QERUniversalSubstitute | nvarchar(16) | nullable |
PersonalTitle
4 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.LDAPAccount | nvarchar(72) | nullable | |
| dbo.Person | nvarchar(128) | nullable |
Phone
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.FirmPartner | nvarchar(max) | nullable | |
| dbo.Hardware | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(max) | nullable | |
| dbo.WorkDesk | nvarchar(max) | nullable |
PhysicalDeliveryOfficeName
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(128) | nullable | |
| dbo.ADSContact | nvarchar(128) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable |
PostOfficeBox
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(40) | nullable | |
| dbo.ADSContact | nvarchar(40) | nullable | |
| dbo.LDAPAccount | nvarchar(64) | nullable | |
| dbo.LDAPContainer | nvarchar(64) | nullable |
Priority
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Job | int | nullable | |
| dbo.JobHistory | int | nullable | |
| dbo.JobQueue | int | nullable | |
| dbo.PWODecisionMethod | int | nullable |
ProcessState
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogProcess | nchar(1) | nullable | |
| dbo.DialogProcessChain | nchar(1) | nullable | |
| dbo.DialogProcessStep | nchar(1) | nullable | |
| dbo.QERBufferRecalcDecisionMaker | int | nullable |
Queue
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobHistory | nvarchar(128) | nullable | |
| dbo.JobPerformance | nvarchar(128) | required | |
| dbo.JobQueue | nvarchar(128) | required | |
| dbo.JobQueueStats | nvarchar(128) | nullable |
RiskIndexReduced
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | float | nullable | |
| dbo.ComplianceRule | float | nullable | |
| dbo.PersonInBaseTree | float | nullable | |
| dbo.QERPolicy | float | nullable |
RulerLevel
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHelper | int | nullable | |
| dbo.AttestationHistory | int | nullable | |
| dbo.PWODecisionHistory | int | nullable | |
| dbo.PWOHelperPWO | int | nullable |
RuleViolationThreshold
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | int | nullable | |
| dbo.ComplianceRule | int | nullable | |
| dbo.FunctionalArea | int | nullable | |
| dbo.QERPolicy | int | nullable |
ScriptCode
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogScript | nvarchar(max) | nullable | |
| dbo.DPRScript | nvarchar(max) | nullable | |
| dbo.DPRTemplate | nvarchar(max) | nullable | |
| dbo.QBMCustomSQL | nvarchar(max) | nullable |
ScriptLanguage
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRShell | nvarchar(16) | nullable | |
| dbo.DPRShellPatch | nvarchar(16) | required | |
| dbo.DPRSystemVariable | nvarchar(16) | nullable | |
| dbo.DPRTemplate | nvarchar(16) | required |
SeeAlso
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable | |
| dbo.LDAPGroup | nvarchar(max) | nullable |
SelectScript
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogObject | nvarchar(max) | nullable | |
| dbo.DialogTable | nvarchar(max) | nullable | |
| dbo.DPRShellPatch | nvarchar(max) | nullable | |
| dbo.QBMAttribute | nvarchar(max) | nullable |
SubLevelNumber
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHelper | int | required | |
| dbo.PWODecisionStep | int | nullable | |
| dbo.PWOHelperPWO | int | required | |
| dbo.QERWorkingStep | int | nullable |
TableName
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogTable | varchar(30) | required | |
| dbo.QBMBufferConfig | varchar(30) | nullable | |
| dbo.QBMBufferTransfer | varchar(30) | required | |
| dbo.QBMTableRevision | varchar(30) | required |
TelephoneNumber
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable |
Title
4 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(128) | nullable | |
| dbo.ADSContact | nvarchar(128) | nullable | |
| dbo.LDAPAccount | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(64) | nullable |
UID_AccProductParamCategory
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.AccProductParamCategory.UID_AccProductParamCategory |
| dbo.AccProductGroup | varchar(38) | nullable | → dbo.AccProductParamCategory.UID_AccProductParamCategory |
| dbo.AccProductParamCategory | varchar(38) | required | ← dbo.AccProductGroup.UID_AccProductParamCategory ← dbo.AccProduct.UID_AccProductParamCategory ← dbo.AccProductParameter.UID_AccProductParamCategory |
| dbo.AccProductParameter | varchar(38) | nullable | → dbo.AccProductParamCategory.UID_AccProductParamCategory |
UID_ADSCountryCode
4 occurrences1 data types4 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(38) | nullable | → dbo.DialogCountry.UID_DialogCountry |
| dbo.ADSContact | varchar(38) | nullable | → dbo.DialogCountry.UID_DialogCountry |
| dbo.ADSContainer | varchar(38) | nullable | → dbo.DialogCountry.UID_DialogCountry |
| dbo.Hardware | varchar(38) | nullable | → dbo.DialogCountry.UID_DialogCountry |
UID_ADSMachine
4 occurrences1 data types2 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSMachine | varchar(38) | required | ← dbo.ADSMachineInADSSite.UID_ADSMachine ← dbo.ADSDomain.UID_ADSMachineRIDMaster ← dbo.ADSPrinter.UID_ADSMachine |
| dbo.ADSMachineInADSGroup | varchar(38) | required | |
| dbo.ADSMachineInADSSite | varchar(38) | required | → dbo.ADSMachine.UID_ADSMachine |
| dbo.ADSPrinter | varchar(38) | required | → dbo.ADSMachine.UID_ADSMachine |
UID_AttestationCase
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(38) | required | ← dbo.AttestationHistory.UID_AttestationCase ← dbo.AttestationHelper.UID_AttestationCase ← dbo.AttestationCaseHasMControl.UID_AttestationCase |
| dbo.AttestationCaseHasMControl | varchar(38) | required | → dbo.AttestationCase.UID_AttestationCase |
| dbo.AttestationHelper | varchar(38) | required | → dbo.AttestationCase.UID_AttestationCase |
| dbo.AttestationHistory | varchar(38) | nullable | → dbo.AttestationCase.UID_AttestationCase |
UID_AttestationObject
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationObject | varchar(38) | required | ← dbo.AttestationPolicy.UID_AttestationObject ← dbo.AttestationWizardParm.UID_AttestationObject ← dbo.AttestationObjectHasPWODM.UID_AttestationObject |
| dbo.AttestationObjectHasPWODM | varchar(38) | required | → dbo.AttestationObject.UID_AttestationObject |
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.AttestationObject.UID_AttestationObject |
| dbo.AttestationWizardParm | varchar(38) | required | → dbo.AttestationObject.UID_AttestationObject |
UID_ComplianceArea
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicyInArea | varchar(38) | required | → dbo.ComplianceArea.UID_ComplianceArea |
| dbo.ComplianceArea | varchar(38) | required | ← dbo.AttestationPolicyInArea.UID_ComplianceArea ← dbo.ComplianceRuleInArea.UID_ComplianceArea ← dbo.QERPolicyInArea.UID_ComplianceArea |
| dbo.ComplianceRuleInArea | varchar(38) | required | → dbo.ComplianceArea.UID_ComplianceArea |
| dbo.QERPolicyInArea | varchar(38) | required | → dbo.ComplianceArea.UID_ComplianceArea |
UID_DialogAuthentifier
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogAuthentifier | varchar(38) | required | ← dbo.DialogDatabase.UID_DialogAuthentifier ← dbo.DialogProductHasAuthentifier.UID_DialogAuthentifier ← dbo.QBMLoginAudit.UID_DialogAuthentifier |
| dbo.DialogDatabase | varchar(38) | nullable | → dbo.DialogAuthentifier.UID_DialogAuthentifier |
| dbo.DialogProductHasAuthentifier | varchar(38) | required | → dbo.DialogAuthentifier.UID_DialogAuthentifier |
| dbo.QBMLoginAudit | varchar(38) | nullable | → dbo.DialogAuthentifier.UID_DialogAuthentifier |
UID_DialogMethod
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogGroupHasMethod | varchar(38) | required | → dbo.DialogMethod.UID_DialogMethod |
| dbo.DialogMethod | varchar(38) | required | ← dbo.DialogGroupHasMethod.UID_DialogMethod ← dbo.DialogObjectHasMethod.UID_DialogMethod ← dbo.QBMMethodHasFeature.UID_DialogMethod |
| dbo.DialogObjectHasMethod | varchar(38) | required | → dbo.DialogMethod.UID_DialogMethod |
| dbo.QBMMethodHasFeature | varchar(38) | required | → dbo.DialogMethod.UID_DialogMethod |
UID_DialogReport
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogReport | varchar(38) | required | ← dbo.QERPolicy.UID_DialogReport ← dbo.DialogReportQuery.UID_DialogReport ← dbo.RPSReport.UID_DialogReport |
| dbo.DialogReportQuery | varchar(38) | required | → dbo.DialogReport.UID_DialogReport |
| dbo.QERPolicy | varchar(38) | nullable | → dbo.DialogReport.UID_DialogReport |
| dbo.RPSReport | varchar(38) | required | → dbo.DialogReport.UID_DialogReport |
UID_DialogTimeZone
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogCountryHasTimeZone | varchar(38) | required | → dbo.DialogTimeZone.UID_DialogTimeZone |
| dbo.DialogSchedule | varchar(38) | required | → dbo.DialogTimeZone.UID_DialogTimeZone |
| dbo.DialogStateHasTimeZone | varchar(38) | required | → dbo.DialogTimeZone.UID_DialogTimeZone |
| dbo.DialogTimeZone | varchar(38) | required | ← dbo.DialogCountryHasTimeZone.UID_DialogTimeZone ← dbo.DialogStateHasTimeZone.UID_DialogTimeZone ← dbo.DialogSchedule.UID_DialogTimeZone |
UID_DPRNameSpace
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRMemberShipAction | varchar(38) | required | → dbo.DPRNameSpace.UID_DPRNameSpace |
| dbo.DPRNameSpace | varchar(38) | required | ← dbo.DPRNameSpaceHasDialogTable.UID_DPRNameSpace ← dbo.DPRMemberShipAction.UID_DPRNameSpace ← dbo.UNSRootB.UID_DPRNameSpace |
| dbo.DPRNameSpaceHasDialogTable | varchar(38) | required | → dbo.DPRNameSpace.UID_DPRNameSpace |
| dbo.UNSRootB | varchar(38) | nullable | → dbo.DPRNameSpace.UID_DPRNameSpace |
UID_DPRSystemConnection
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRObjectOperation | varchar(38) | required | |
| dbo.DPRProjectionConfigHasConnect | varchar(38) | required | |
| dbo.DPRRootObjConnectionInfo | varchar(38) | required | |
| dbo.DPRSystemConnection | varchar(38) | required |
UID_FirmPartner
4 occurrences1 data types3 outgoing FK refs5 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.FirmPartner.UID_FirmPartner |
| dbo.FirmPartner | varchar(38) | required | ← dbo.AccProduct.UID_FirmPartner ← dbo.Person.UID_FirmPartner ← dbo.HardwareType.UID_FirmPartnerDefaultVendor ← dbo.Hardware.UID_FirmPartnerManufacturer ← dbo.HardwareType.UID_FirmPartner |
| dbo.HardwareType | varchar(38) | nullable | → dbo.FirmPartner.UID_FirmPartner |
| dbo.Person | varchar(38) | nullable | → dbo.FirmPartner.UID_FirmPartner |
UID_LDAPContainer
4 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.LDAPAccount | varchar(38) | nullable | → dbo.LDAPContainer.UID_LDAPContainer |
| dbo.LDAPContainer | varchar(38) | required | ← dbo.LDAPAccount.UID_LDAPContainer ← dbo.LDAPGroup.UID_LDAPContainer |
| dbo.LDAPGroup | varchar(38) | nullable | → dbo.LDAPContainer.UID_LDAPContainer |
| dbo.LDPMachine | varchar(38) | nullable |
UID_LDAPGroup
4 occurrences1 data types0 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasLDAPGroup | varchar(38) | required | |
| dbo.LDAPAccountInLDAPGroup | varchar(38) | required | |
| dbo.LDAPGroup | varchar(38) | required | ← dbo.LDAPGroupInLDAPGroup.UID_LDAPGroupParent ← dbo.LDAPGroupExclusion.UID_LDAPGroupLower ← dbo.LDAPGroupCollection.UID_LDAPGroupChild |
| dbo.LDPMachineInLDAPGroup | varchar(38) | required |
UID_PersonOwner
4 occurrences1 data types4 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.Person.UID_Person |
| dbo.AttestationPolicyGroup | varchar(38) | nullable | → dbo.Person.UID_Person |
| dbo.Hardware | varchar(38) | nullable | → dbo.Person.UID_Person |
| dbo.RPSReport | varchar(38) | nullable | → dbo.Person.UID_Person |
UID_QBMTreeResult
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QBMTreeHasTreeResult | varchar(38) | required | → dbo.QBMTreeResult.UID_QBMTreeResult |
| dbo.QBMTreeResult | varchar(38) | required | ← dbo.QBMTreeHasTreeResult.UID_QBMTreeResult ← dbo.QBMTreeResultHasSheet.UID_QBMTreeResult ← dbo.QBMTreeResultHasColumn.UID_QBMTreeResult |
| dbo.QBMTreeResultHasColumn | varchar(38) | nullable | → dbo.QBMTreeResult.UID_QBMTreeResult |
| dbo.QBMTreeResultHasSheet | varchar(38) | required | → dbo.QBMTreeResult.UID_QBMTreeResult |
UID_QERPickCategory
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.QERPickCategory.UID_QERPickCategory |
| dbo.AttestationPolicyGroup | varchar(38) | nullable | → dbo.QERPickCategory.UID_QERPickCategory |
| dbo.QERPickCategory | varchar(38) | required | ← dbo.AttestationPolicyGroup.UID_QERPickCategory ← dbo.AttestationPolicy.UID_QERPickCategory ← dbo.QERPickedItem.UID_QERPickCategory |
| dbo.QERPickedItem | varchar(38) | required | → dbo.QERPickCategory.UID_QERPickCategory |
UID_QERPolicy
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QERPolicy | varchar(38) | required | ← dbo.QERPolicyHasMControl.UID_QERPolicy ← dbo.QERPolicyHasObject.UID_QERPolicy ← dbo.QERPolicyInArea.UID_QERPolicy |
| dbo.QERPolicyHasMControl | varchar(38) | required | → dbo.QERPolicy.UID_QERPolicy |
| dbo.QERPolicyHasObject | varchar(38) | required | → dbo.QERPolicy.UID_QERPolicy |
| dbo.QERPolicyInArea | varchar(38) | required | → dbo.QERPolicy.UID_QERPolicy |
UID_QERTermsOfUse
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | varchar(38) | nullable | → dbo.QERTermsOfUse.UID_QERTermsOfUse |
| dbo.AttestationPolicy | varchar(38) | nullable | → dbo.QERTermsOfUse.UID_QERTermsOfUse |
| dbo.QERTermsOfUse | varchar(38) | required | ← dbo.AttestationPolicy.UID_QERTermsOfUse ← dbo.QERTermsOfUseHasFile.UID_QERTermsOfUse ← dbo.AccProduct.UID_QERTermsOfUse |
| dbo.QERTermsOfUseHasFile | varchar(38) | required | → dbo.QERTermsOfUse.UID_QERTermsOfUse |
UID_QERWorkingMethod
4 occurrences1 data types3 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationCase | varchar(38) | nullable | → dbo.QERWorkingMethod.UID_QERWorkingMethod |
| dbo.PersonWantsOrg | varchar(38) | nullable | → dbo.QERWorkingMethod.UID_QERWorkingMethod |
| dbo.QERWorkingMethod | varchar(38) | required | ← dbo.AttestationCase.UID_QERWorkingMethod ← dbo.QERWorkingStep.UID_QERWorkingMethod ← dbo.PersonWantsOrg.UID_QERWorkingMethod |
| dbo.QERWorkingStep | varchar(38) | required | → dbo.QERWorkingMethod.UID_QERWorkingMethod |
UID_RPSReport
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasRPSReport | varchar(38) | required | |
| dbo.PersonHasRPSReport | varchar(38) | required | |
| dbo.RPSReport | varchar(38) | required | |
| dbo.RPSSubscription | varchar(38) | required |
UID_ShoppingCartOrder
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | varchar(38) | nullable | |
| dbo.PWODecisionHistory | varchar(38) | nullable | |
| dbo.ShoppingCartItem | varchar(38) | nullable | |
| dbo.ShoppingCartOrder | varchar(38) | required |
UID_UNSGroupB1
4 occurrences1 data types0 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasUNSGroupB1 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB1 | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB1 | varchar(38) | required | |
| dbo.UNSGroupB1 | varchar(38) | required | ← dbo.UNSGroupB1Collection.UID_UNSGroupB1Child ← dbo.UNSGroupB1Exclusion.UID_UNSGroupB1Lower ← dbo.UNSGroupB1InUNSGroupB1.UID_UNSGroupB1Parent |
UID_UNSGroupB2
4 occurrences1 data types0 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasUNSGroupB2 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB2 | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB2 | varchar(38) | required | |
| dbo.UNSGroupB2 | varchar(38) | required | ← dbo.UNSGroupB2Collection.UID_UNSGroupB2Child ← dbo.UNSGroupB2Exclusion.UID_UNSGroupB2Lower ← dbo.UNSGroupB2InUNSGroupB2.UID_UNSGroupB2Parent |
UID_UNSGroupB3
4 occurrences1 data types0 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTreeHasUNSGroupB3 | varchar(38) | required | |
| dbo.UNSAccountBHasUNSGroupB3 | varchar(38) | required | |
| dbo.UNSAccountBInUNSGroupB3 | varchar(38) | required | |
| dbo.UNSGroupB3 | varchar(38) | required | ← dbo.UNSGroupB3Collection.UID_UNSGroupB3Child ← dbo.UNSGroupB3Exclusion.UID_UNSGroupB3Lower ← dbo.UNSGroupB3InUNSGroupB3.UID_UNSGroupB3Parent |
UserPassword
4 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(990) | nullable | |
| dbo.DialogWebService | varchar(990) | nullable | |
| dbo.LDAPAccount | varchar(990) | nullable | |
| dbo.LDAPContainer | varchar(990) | nullable |
AccountDisabled
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | bit | nullable | |
| dbo.LDAPAccount | bit | nullable | |
| dbo.UNSAccountB | bit | nullable |
AccountExpires
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | datetime | nullable | |
| dbo.LDAPAccount | datetime | nullable | |
| dbo.UNSAccountB | datetime | nullable |
AccountToPersonMatchingRule
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSDomain | nvarchar(max) | nullable | |
| dbo.LDPDomain | nvarchar(max) | nullable | |
| dbo.UNSRootB | nvarchar(max) | nullable |
AdditionalData
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | nvarchar(max) | nullable | |
| dbo.POLPlaybookRun | nvarchar(max) | nullable | |
| dbo.ShoppingCartItem | nvarchar(max) | nullable |
ApplicationName
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogJournal | nvarchar(64) | nullable | |
| dbo.QBMLoginAudit | nvarchar(1024) | nullable | |
| dbo.QBMUserConfig | nvarchar(64) | nullable |
ApprovalState
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | int | nullable | |
| dbo.ESet | int | nullable | |
| dbo.Person | int | nullable |
BusinessCategory
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable | |
| dbo.LDAPGroup | nvarchar(max) | nullable |
CanInsert
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogColumnGroupRight | bit | nullable | |
| dbo.DialogTableGroupRight | bit | nullable | |
| dbo.QBMTreeResult | bit | nullable |
Category
3 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogParameterSet | nvarchar(64) | nullable | |
| dbo.Hardware | nvarchar(max) | nullable | |
| dbo.QBMConsistencyCheck | varchar(16) | nullable |
City
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(64) | nullable | |
| dbo.FirmPartner | nvarchar(64) | nullable | |
| dbo.Person | nvarchar(max) | nullable |
ComponentAssembly
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.JobComponent | nvarchar(128) | nullable | |
| dbo.JobHistory | nvarchar(255) | nullable | |
| dbo.JobQueue | nvarchar(255) | nullable |
ConnectionString
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogDatabase | nvarchar(max) | nullable | |
| dbo.DialogHistoryDB | varchar(990) | nullable | |
| dbo.QBMConnectionInfo | nvarchar(max) | nullable |
ContentFull
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogWatchProperty | nvarchar(max) | nullable | |
| dbo.QBMBufferConfig | nvarchar(max) | nullable | |
| dbo.QBMBufferTransfer | nvarchar(max) | nullable |
ContentShort
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogWatchProperty | nvarchar(400) | nullable | |
| dbo.QBMBufferConfig | nvarchar(400) | nullable | |
| dbo.QBMBufferTransfer | nvarchar(400) | nullable |
Currency
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | nvarchar(32) | nullable | |
| dbo.AccProductGroup | nvarchar(32) | nullable | |
| dbo.Hardware | nvarchar(32) | nullable |
DomainDisplayName
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSContainer | nvarchar(128) | nullable | |
| dbo.LDAPContainer | nvarchar(128) | nullable | |
| dbo.UNSContainerB | nvarchar(128) | nullable |
EmployeeNumber
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(512) | nullable | |
| dbo.ADSContact | nvarchar(512) | nullable | |
| dbo.LDAPAccount | nvarchar(20) | nullable |
ExceptionValidUntil
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonInBaseTree | datetime | nullable | |
| dbo.PersonWantsOrg | datetime | nullable | |
| dbo.PWODecisionHistory | datetime | nullable |
ExtensionAttribute1
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute10
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute11
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute12
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute13
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute14
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute15
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute2
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute3
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute4
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute5
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute6
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute7
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute8
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
ExtensionAttribute9
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable |
FileContent
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogRichMailImage | varbinary(max) | nullable | |
| dbo.QBMFileRevision | varbinary(max) | nullable | |
| dbo.QERTermsOfUseHasFile | varbinary(max) | required |
GidNumber
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | int | nullable | |
| dbo.ADSContact | int | nullable | |
| dbo.ADSGroup | int | nullable |
GivenName
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.LDAPAccount | nvarchar(64) | nullable |
HasContentFull
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogWatchProperty | bit | nullable | |
| dbo.QBMBufferConfig | bit | nullable | |
| dbo.QBMBufferTransfer | bit | nullable |
HashValue
3 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogRichMailImage | nvarchar(40) | nullable | |
| dbo.QBMFileRevision | varbinary(64) | nullable | |
| dbo.QBMPwdHistory | varchar(218) | required |
HomePhone
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(64) | nullable | |
| dbo.ADSContact | nvarchar(64) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable |
ImportSource
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(32) | nullable | |
| dbo.Hardware | varchar(32) | nullable | |
| dbo.Person | nvarchar(32) | nullable |
Info
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(1024) | nullable |
InsertValues
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogObject | nvarchar(max) | nullable | |
| dbo.DialogSheet | nvarchar(max) | nullable | |
| dbo.DialogTable | nvarchar(max) | nullable |
InternalName
3 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.Person | nvarchar(128) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
InternalPrice
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | float | nullable | |
| dbo.AccProductGroup | float | nullable | |
| dbo.Hardware | float | nullable |
IsDayLightSaving
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogCountry | bit | nullable | |
| dbo.DialogState | bit | nullable | |
| dbo.DialogTimeZone | bit | nullable |
IsDecisionBySystem
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHistory | bit | nullable | |
| dbo.PWODecisionHistory | bit | nullable | |
| dbo.QERJustification | bit | nullable |
IsFromDelegation
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationHelper | bit | nullable | |
| dbo.PWODecisionHistory | bit | nullable | |
| dbo.PWOHelperPWO | bit | nullable |
IsMandatory
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProductDependencies | bit | nullable | |
| dbo.AccProductParameter | bit | nullable | |
| dbo.DialogParameter | int | nullable |
IsNoDBQueueDefer
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Job | bit | nullable | |
| dbo.JobQueue | bit | nullable | |
| dbo.JobTask | bit | nullable |
IsNoInherite
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Hardware | bit | nullable | |
| dbo.Person | bit | nullable | |
| dbo.WorkDesk | bit | nullable |
IsoDate
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogCalendar | nvarchar(10) | nullable | |
| dbo.DialogCountryHoliday | nvarchar(10) | required | |
| dbo.DialogStateHoliday | nvarchar(10) | nullable |
isSPML
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogColumn | bit | nullable | |
| dbo.DialogTable | bit | nullable | |
| dbo.QBMRelation | bit | nullable |
JobChainName
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogProcessChain | nvarchar(255) | nullable | |
| dbo.JobHistory | nvarchar(255) | nullable | |
| dbo.JobQueue | nvarchar(255) | required |
LayoutInformation
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogTable | nvarchar(max) | nullable | |
| dbo.PWODecisionSubMethod | nvarchar(max) | nullable | |
| dbo.QERWorkingMethod | nvarchar(max) | nullable |
Locality
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(128) | nullable | |
| dbo.ADSContact | nvarchar(128) | nullable | |
| dbo.ADSContainer | nvarchar(64) | nullable |
LogMode
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Job | varchar(8) | nullable | |
| dbo.JobHistory | varchar(8) | nullable | |
| dbo.JobQueue | varchar(8) | nullable |
LogonUser
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogJournal | nvarchar(64) | nullable | |
| dbo.QBMCEFMessage | nvarchar(64) | nullable | |
| dbo.QBMLoginAudit | nvarchar(256) | nullable |
MatchPatternDisplay
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSDomain | nvarchar(max) | nullable | |
| dbo.LDPDomain | nvarchar(max) | nullable | |
| dbo.UNSRootB | nvarchar(max) | nullable |
ModifyTimeStamp
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.LDAPAccount | nvarchar(30) | nullable | |
| dbo.LDAPContainer | nvarchar(30) | nullable | |
| dbo.LDAPGroup | nvarchar(30) | nullable |
NamespaceManagedBy
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSDomain | nvarchar(16) | nullable | |
| dbo.LDPDomain | nvarchar(16) | nullable | |
| dbo.UNSRootB | nvarchar(16) | nullable |
ObjectIdentifier
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRJournalFailure | nvarchar(400) | required | |
| dbo.DPRJournalObject | nvarchar(400) | required | |
| dbo.QERExternalRiskScore | nvarchar(256) | required |
ObjectKeyAppliesTo
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSPolicyAppliesTo | varchar(138) | required | |
| dbo.POLPlaybook | varchar(138) | nullable | |
| dbo.TSBITData | varchar(138) | required |
ObjectKeyElement
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ComplianceSubRuleObject | varchar(138) | nullable | |
| dbo.QBMObjectHasPwdPolicy | varchar(138) | required | |
| dbo.QBMPendingChange | varchar(138) | nullable |
ObjectKeyOrgUsedInAssign
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | varchar(138) | nullable | |
| dbo.ShoppingCartItem | varchar(138) | nullable | |
| dbo.ShoppingCartPatternItem | varchar(138) | nullable |
ObjectKeySecretary
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccountSecretary | varchar(138) | required | |
| dbo.ADSContactSecretary | varchar(138) | required | |
| dbo.ADSGroupSecretary | varchar(138) | required |
OperationType
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogWatchOperation | nchar(1) | nullable | |
| dbo.QBMBufferTransfer | varchar(1) | nullable | |
| dbo.QBMCEFDefinition | nchar(1) | required |
OrderDetail1
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | nvarchar(max) | nullable | |
| dbo.ShoppingCartItem | nvarchar(max) | nullable | |
| dbo.ShoppingCartPatternItem | nvarchar(max) | nullable |
OrderDetail2
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | nvarchar(64) | nullable | |
| dbo.ShoppingCartItem | nvarchar(64) | nullable | |
| dbo.ShoppingCartPatternItem | nvarchar(16) | nullable |
OtherMailBox
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSContact | nvarchar(max) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable |
ParentRestriction
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogValidDynamicRef | nchar(2) | required | |
| dbo.QBMForeignKeyWrongReport | nchar(2) | nullable | |
| dbo.QBMRelation | nchar(2) | required |
PostalAddress
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(max) | nullable | |
| dbo.LDAPAccount | nvarchar(max) | nullable | |
| dbo.LDAPContainer | nvarchar(max) | nullable |
ProcessDisplay
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Job | nvarchar(max) | nullable | |
| dbo.JobChain | nvarchar(max) | nullable | |
| dbo.JobEventGen | nvarchar(1024) | nullable |
ProcessTracking
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Job | int | nullable | |
| dbo.JobChain | int | nullable | |
| dbo.JobQueue | bit | nullable |
ProjectionDirection
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRProjectionConfig | nvarchar(32) | nullable | |
| dbo.DPRProjectionConfigStep | nvarchar(32) | nullable | |
| dbo.DPRProjectionStartInfo | nvarchar(32) | nullable |
PurchasePrice
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | float | nullable | |
| dbo.AccProductGroup | float | nullable | |
| dbo.Hardware | float | nullable |
PWOPriority
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | int | nullable | |
| dbo.PWODecisionHistory | int | nullable | |
| dbo.ShoppingCartItem | int | nullable |
Quantity
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PersonWantsOrg | float | nullable | |
| dbo.ShoppingCartItem | float | nullable | |
| dbo.ShoppingCartPatternItem | float | nullable |
RentCharge
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.Hardware | int | nullable | |
| dbo.WorkDesk | int | nullable | |
| dbo.WorkDeskType | int | nullable |
Room
3 occurrences3 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | nvarchar(32) | nullable | |
| dbo.Person | nvarchar(max) | nullable | |
| dbo.WorkDesk | nvarchar(64) | nullable |
SalesPrice
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AccProduct | float | nullable | |
| dbo.AccProductGroup | float | nullable | |
| dbo.Hardware | float | nullable |
SAMAccountName
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(20) | nullable | |
| dbo.ADSGroup | nvarchar(256) | nullable | |
| dbo.ADSMachine | nvarchar(20) | nullable |
Severity
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.POLPlaybook | int | nullable | |
| dbo.POLPlaybookRun | int | nullable | |
| dbo.QBMConsistencyCheck | varchar(1) | nullable |
ShortDescription
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.HardwareState | nvarchar(64) | nullable | |
| dbo.WorkDeskState | nvarchar(64) | nullable | |
| dbo.WorkDeskType | nvarchar(max) | nullable |
SIDHistory
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(max) | nullable | |
| dbo.ADSGroup | nvarchar(max) | nullable | |
| dbo.ADSMachine | nvarchar(max) | nullable |
SourceType
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogMultiLanguage | nvarchar(16) | nullable | |
| dbo.QBMFileRevision | int | nullable | |
| dbo.QBMTranslationAddOnSource | nvarchar(16) | nullable |
State
3 occurrences2 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | nvarchar(128) | nullable | |
| dbo.ADSContact | nvarchar(128) | nullable | |
| dbo.ADSContainer | nvarchar(32) | nullable |
TransparencyIndex
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.BaseTree | float | nullable | |
| dbo.ComplianceRule | float | nullable | |
| dbo.QERPolicy | float | nullable |
UID_ADSAccount
3 occurrences1 data types1 outgoing FK refs1 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSAccount | varchar(38) | required | ← dbo.ADSAccountSecretary.UID_ADSAccount |
| dbo.ADSAccountInADSGroup | varchar(38) | required | |
| dbo.ADSAccountSecretary | varchar(38) | required | → dbo.ADSAccount.UID_ADSAccount |
UID_ADSContact
3 occurrences1 data types1 outgoing FK refs1 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSContact | varchar(38) | required | ← dbo.ADSContactSecretary.UID_ADSContact |
| dbo.ADSContactInADSGroup | varchar(38) | required | |
| dbo.ADSContactSecretary | varchar(38) | required | → dbo.ADSContact.UID_ADSContact |
UID_ADSForest
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.ADSDomain | varchar(38) | required | → dbo.ADSForest.UID_ADSForest |
| dbo.ADSForest | varchar(38) | required | ← dbo.ADSSite.UID_ADSForest ← dbo.ADSDomain.UID_ADSForest |
| dbo.ADSSite | varchar(38) | required | → dbo.ADSForest.UID_ADSForest |
UID_AttestationPolicyGroup
3 occurrences1 data types1 outgoing FK refs1 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.AttestationPolicy | varchar(38) | nullable | |
| dbo.AttestationPolicyGroup | varchar(38) | required | ← dbo.AttestationRun.UID_AttestationPolicyGroup |
| dbo.AttestationRun | varchar(38) | nullable | → dbo.AttestationPolicyGroup.UID_AttestationPolicyGroup |
UID_ConfigParm
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogConfigParm | varchar(38) | required | ← dbo.QBMConfigParmHasTask.UID_ConfigParm ← dbo.DialogConfigParmOption.UID_ConfigParm |
| dbo.DialogConfigParmOption | varchar(38) | required | → dbo.DialogConfigParm.UID_ConfigParm |
| dbo.QBMConfigParmHasTask | varchar(38) | required | → dbo.DialogConfigParm.UID_ConfigParm |
UID_DialogColumnTarget
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.QBMColumnTranslation | varchar(38) | required | |
| dbo.QERRiskIndexColumnDepend | varchar(38) | required | |
| dbo.TSBITData | varchar(38) | nullable |
UID_DialogLogicalForm
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogLogicalForm | varchar(38) | required | ← dbo.DialogLogicalFormHasTable.UID_DialogLogicalForm ← dbo.DialogSheet.UID_DialogLogicalForm |
| dbo.DialogLogicalFormHasTable | varchar(38) | required | → dbo.DialogLogicalForm.UID_DialogLogicalForm |
| dbo.DialogSheet | varchar(38) | nullable | → dbo.DialogLogicalForm.UID_DialogLogicalForm |
UID_DialogParameterSet
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogParameter | varchar(38) | required | → dbo.DialogParameterSet.UID_DialogParameterSet |
| dbo.DialogParameterSet | varchar(38) | required | ← dbo.DialogParameter.UID_DialogParameterSet ← dbo.DialogRichMail.UID_DialogParameterSet |
| dbo.DialogRichMail | varchar(38) | nullable | → dbo.DialogParameterSet.UID_DialogParameterSet |
UID_DialogRichMail
3 occurrences1 data types2 outgoing FK refs23 incoming FK refs
UID_DialogRichMailGrant
3 occurrences1 data types3 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PWODecisionMethod | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
| dbo.PWODecisionStep | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
| dbo.QERWorkingStep | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
UID_DialogRichMailNoGrant
3 occurrences1 data types3 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.PWODecisionMethod | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
| dbo.PWODecisionStep | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
| dbo.QERWorkingStep | varchar(38) | nullable | → dbo.DialogRichMail.UID_DialogRichMail |
UID_DialogTag
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogTag | varchar(38) | required | ← dbo.DialogTaggedItem.UID_DialogTag ← dbo.QBMTaggedChange.UID_DialogTag |
| dbo.DialogTaggedItem | varchar(38) | required | → dbo.DialogTag.UID_DialogTag |
| dbo.QBMTaggedChange | varchar(38) | required | → dbo.DialogTag.UID_DialogTag |
UID_DialogUser
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DialogUser | varchar(38) | required | ← dbo.DialogUserInGroup.UID_DialogUser ← dbo.Person.UID_DialogUser |
| dbo.DialogUserInGroup | varchar(38) | required | → dbo.DialogUser.UID_DialogUser |
| dbo.Person | varchar(38) | nullable | → dbo.DialogUser.UID_DialogUser |
UID_DPRProjectionStartInfo
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRJournal | varchar(38) | nullable | |
| dbo.DPRProjectionStartInfo | varchar(38) | required | |
| dbo.DPRStartSequenceHasProjection | varchar(38) | required |
UID_DPRSchemaMethod
3 occurrences1 data types2 outgoing FK refs2 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchemaMethHasProperty | varchar(38) | required | → dbo.DPRSchemaMethod.UID_DPRSchemaMethod |
| dbo.DPRSchemaMethod | varchar(38) | required | ← dbo.DPRSchemaMethHasProperty.UID_DPRSchemaMethod ← dbo.DPRSystemObjectMatchSetMAsgn.UID_DPRSchemaMethod |
| dbo.DPRSystemObjectMatchSetMAsgn | varchar(38) | required | → dbo.DPRSchemaMethod.UID_DPRSchemaMethod |
UID_DPRSchemaProperty
3 occurrences1 data types2 outgoing FK refs3 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchemaMethHasProperty | varchar(38) | required | → dbo.DPRSchemaProperty.UID_DPRSchemaProperty |
| dbo.DPRSchemaProperty | varchar(38) | required | ← dbo.DPRSchemaMethHasProperty.UID_DPRSchemaProperty ← dbo.DPRSchemaPropertyRefHasTarget.UID_DPRSchemaProperty ← dbo.DPRSchemaAccess.UID_DPRSchemaPropertyTrg |
| dbo.DPRSchemaPropertyRefHasTarget | varchar(38) | required | → dbo.DPRSchemaProperty.UID_DPRSchemaProperty |
UID_DPRSchemaPropertyReference
3 occurrences1 data types0 outgoing FK refs0 incoming FK refs
| Table | Type | Nullability | FK evidence |
|---|---|---|---|
| dbo.DPRSchemaProperty | varchar(38) | nullable | |
| dbo.DPRSchemaPropertyReference | varchar(38) | required | |
| dbo.DPRSchemaPropertyRefHasTarget | varchar(38) | required |