Generated from read-only sandbox DB table/column metadata and default-constraint metadata. It only states schema facts: NOT NULL, identity, PK/FK, and whether a SQL default constraint was collected. It does not infer object-layer templates or generated values.
Provenance: data/db/all-objects/tables.json collected from read-only sandbox DB metadata; site/assets/oim-default-constraints.json from sys.default_constraints metadata.
| Table | Req. | No default | Non-PK no default | PK | FK | Column sample |
|---|---|---|---|---|---|---|
| dbo.DPRProjectionConfigStep Synchronization steps | 9 | 9 | 8 | 1 | 6 | UID_DPRProjectionConfigStep [PK], UID_LeftDPRSystemConnection [FK], UID_RightDPRSystemConnection [FK], XObjectKey, Name, UID_QBMClrType [FK], UID_DPRProjectionConfig [FK], UID_DPRSystemObjectMatchSets [FK], UID_DPRSystemMap [FK] |
| dbo.DPRShellPatch Synchronization project patches | 8 | 8 | 7 | 1 | 0 | UID_DPRShellPatch [PK], DisplayName, PatchNumber, PatchType, PatchContext, PatchContextVersion, XObjectKey, ScriptLanguage |
| dbo.DPRMemberShipAction MN table changes | 7 | 7 | 6 | 1 | 1 | UID_DPRMemberShipAction [PK], ObjectKeyMN, Operation, ObjectKeyBase, ObjectKeyMember, XObjectKey, UID_DPRNameSpace [FK] |
| dbo.DPRProjectionDependency Schema type dependencies for synchronization | 7 | 7 | 6 | 1 | 4 | UID_DPRProjectionDependency [PK], UID_DPRShell [FK], UID_DPRSchemaTypePrior [FK], UID_DPRSchemaType [FK], Name, XObjectKey, UID_QBMClrType [FK] |
| dbo.DPRServiceGate Service gates | 7 | 7 | 6 | 1 | 1 | UID_DPRServiceGate [PK], Receiver, RequestTime, RequestType, ResponseState, XObjectKey, UID_QBMServer [FK] |
| dbo.DPRSystemMap Mappings | 7 | 7 | 6 | 1 | 4 | UID_DPRSystemMap [PK], UID_LeftDPRSchemaClass [FK], XObjectKey, Name, UID_QBMClrType [FK], UID_RightDPRSchemaClass [FK], UID_DPRShell [FK] |
| dbo.DPRSystemObjectMatchSetMAsgn Synchronization object match set method assignments | 7 | 7 | 6 | 1 | 3 | UID_DPRSystemObjectMatchSetMA [PK], XObjectKey, Name, UID_DPRSchemaMethod [FK], UID_QBMClrType [FK], UID_DPRSystemObjectMatchSet [FK], Side |
| dbo.DPRTemplate Project templates | 7 | 7 | 6 | 1 | 0 | UID_DPRTemplate [PK], ScriptLanguage, ConnectedSystem, ConnectedSystemVersion, TemplateType, XObjectKey, SupportedScriptLanguages |
| dbo.JobQueue Job queue | 7 | 7 | 6 | 1 | 1 | UID_Job [PK], UID_Tree, Queue, TaskName, Ready2EXE, JobChainName, GenProcID [FK] |
| dbo.QBMRelation Table relations | 7 | 7 | 6 | 1 | 2 | UID_QBMRelation [PK], RelationID, ParentRestriction, ChildRestriction, UID_ChildColumn [FK], UID_ParentColumn [FK], XObjectKey |
| dbo.Delegation Delegations | 6 | 6 | 5 | 1 | 3 | UID_Delegation [PK], UID_PersonReceiver [FK], UID_PersonSender [FK], UID_PersonWantsOrg [FK], ObjectKeyDelegated, XObjectKey |
| dbo.DialogReportQueryModule Report query modules | 6 | 6 | 5 | 1 | 0 | UID_DialogReportQueryModule [PK], Ident_DialogReportQueryModule, ModuleAssembly, ModuleClass, DisplayValue, XObjectKey |
| dbo.DPRObjectOperation Provisioning process operations | 6 | 6 | 5 | 1 | 3 | UID_DPRObjectOperation [PK], UID_DialogTable [FK], UID_DPRSystemConnection [FK], UID_DPRProjectionConfig [FK], Name, XObjectKey |
| dbo.DPRProjectionObjectState Synchronization object state | 6 | 6 | 5 | 1 | 2 | UID_DPRProjectionObjectState [PK], UID_DPRProjectionConfig [FK], UID_ObjectKeyQBMClrType [FK], ObjectKey, SchemaTypeKey, XObjectKey |
| dbo.DPRRevisionStore Synchronization data revisions | 6 | 6 | 5 | 1 | 2 | UID_DPRRevisionStore [PK], XObjectKey, SchemaTypeKey, UID_ValueQBMClrType [FK], RevisionDate, UID_DPRProjectionConfig [FK] |
| dbo.DPRSchema Schemas | 6 | 6 | 5 | 1 | 2 | UID_DPRSchema [PK], UID_DPRShell [FK], XObjectKey, Name, SystemId, UID_QBMClrType [FK] |
| dbo.DPRSchemaAccess Schema accesses | 6 | 6 | 5 | 1 | 2 | UID_DPRSchemaAccess [PK], UID_DPRSchemaPropertyTrg [FK], UID_DPRSchemaPropertySrc [FK], AccessMode, AccessType, ObjectKeyAccessor |
| dbo.DPRSystemConnection System connections | 6 | 6 | 5 | 1 | 3 | UID_DPRSystemConnection [PK], XObjectKey, Name, UID_DPRSchema [FK], UID_QBMClrType [FK], UID_DPRShell [FK] |
| dbo.DPRSystemScope System scopes | 6 | 6 | 5 | 1 | 3 | UID_DPRSystemScope [PK], UID_DPRShell [FK], XObjectKey, Name, UID_DPRSchema [FK], UID_QBMClrType [FK] |
| dbo.DPRSystemScopeFilter System scope filters | 6 | 6 | 5 | 1 | 3 | UID_DPRSystemScopeFilter [PK], UID_DPRSystemScope [FK], XObjectKey, Name, UID_DPRSchemaType [FK], UID_QBMClrType [FK] |
| dbo.QBMCEFDefinition SIEM message definitions | 7 | 6 | 5 | 1 | 1 | UID_QBMCEFDefinition [PK], UID_DialogTable [FK], EventClassID, ActivityName, LogSeverity = default, OperationType, XObjectKey |
| dbo.ADSPolicy Active Directory account policies | 5 | 5 | 4 | 1 | 1 | UID_ADSPolicy [PK], cn, DistinguishedName, XObjectKey, UID_ADSDomain [FK] |
| dbo.DialogConfigParm Configuration parameters | 5 | 5 | 4 | 1 | 0 | UID_ConfigParm [PK], ConfigParm, Value, FullPath, XObjectKey |
| dbo.DialogMultiLanguage Translations | 5 | 5 | 4 | 1 | 2 | UID_DialogMultiLanguage [PK], EntryKey, UID_DialogColumn [FK], XObjectKey, UID_DialogCulture [FK] |
| dbo.DPRJournalFailure Incorrect synchronization objects | 5 | 5 | 4 | 1 | 1 | UID_DPRJournalFailure [PK], UID_DPRJournal [FK], SchemaTypeName, SchemaUid, ObjectIdentifier |
| dbo.DPRJournalObject Synchronization change actions | 5 | 5 | 4 | 1 | 1 | UID_DPRJournalObject [PK], UID_DPRJournal [FK], SchemaTypeName, SchemaUid, ObjectIdentifier |
| dbo.DPRProjectionConfig Synchronization workflows | 5 | 5 | 4 | 1 | 2 | UID_DPRProjectionConfig [PK], UID_DPRShell [FK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRRootObjConnectionInfo Connection infos of synchronized systems | 5 | 5 | 4 | 1 | 2 | UID_DPRRootObjConnectionInfo [PK], UID_DPRSystemConnection [FK], UID_DPRSystemVariableSet [FK], ObjectKeyRoot, XObjectKey |
| dbo.DPRSchemaClass Schema classes | 5 | 5 | 4 | 1 | 2 | UID_DPRSchemaClass [PK], XObjectKey, Name, UID_DPRSchemaType [FK], UID_QBMClrType [FK] |
| dbo.DPRSchemaMethod Schema methods | 5 | 5 | 4 | 1 | 2 | UID_DPRSchemaMethod [PK], XObjectKey, Name, UID_DPRSchemaType [FK], UID_QBMClrType [FK] |
| dbo.DPRSchemaProperty Schema properties | 5 | 5 | 4 | 1 | 2 | UID_DPRSchemaProperty [PK], XObjectKey, Name, UID_DPRSchemaType [FK], UID_QBMClrType [FK] |
| dbo.DPRSchemaPropertyReference Schema property references | 5 | 5 | 4 | 1 | 2 | UID_DPRSchemaPropertyReference [PK], XObjectKey, Name, UID_QBMClrType [FK], UID_DPRSchema [FK] |
| dbo.DPRSchemaType Schema types | 5 | 5 | 4 | 1 | 2 | UID_DPRSchemaType [PK], XObjectKey, Name, UID_QBMClrType [FK], UID_DPRSchema [FK] |
| dbo.DPRSystemMappingRule System mapping rules | 5 | 5 | 4 | 1 | 2 | UID_DPRSystemMappingRule [PK], UID_DPRSystemMap [FK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRSystemSyncDependency Dependencies if databases synchronized automatically | 5 | 5 | 4 | 1 | 2 | UID_DPRSystemSyncDependency [PK], UID_DialogTablePrior [FK], UID_DialogTable [FK], Name, XObjectKey |
| dbo.QBMMissingDisplayRight Viewing permissions for parent columns | 5 | 5 | 4 | 1 | 3 | UID_QBMMissingDisplayRight [PK], UID_DialogGroup [FK], UID_DialogColumn [FK], XObjectKey, UID_DialogTableChild [FK] |
| dbo.QBMPwdHistory Password history | 5 | 5 | 4 | 1 | 0 | UID_QBMPwdHistory [PK], ObjectKeyAccount, HashValue, DateInserted, XObjectKey |
| dbo.QBMSplittedLookup Table lookup support | 5 | 5 | 4 | 1 | 1 | UID_QBMSplittedLookup [PK], UID_DialogColumn [FK], ObjectKeyOwner, SplittedElement, SplittedElementType |
| dbo.QERUniversalSubstitute Identities' deputies | 5 | 5 | 4 | 1 | 3 | UID_QERUniversalSubstitute [PK], UID_PersonWantsOrg [FK], UID_PersonSender [FK], UID_PersonReceiver [FK], XObjectKey |
| dbo.RPSSubscription Report subscriptions | 5 | 5 | 4 | 1 | 2 | UID_RPSSubscription [PK], Ident_RPSSubscription, UID_Person [FK], UID_RPSReport [FK], XObjectKey |
| dbo.ShoppingCartItem Cart items | 5 | 5 | 4 | 1 | 3 | UID_ShoppingCartItem [PK], UID_PersonInserted [FK], UID_AccProduct [FK], UID_PersonOrdered [FK], XObjectKey |
| dbo.QBMBufferTransfer Transfer buffer | 4 | 4 | 4 | 0 | 0 | ModuleName, TableName, ColumnName, ObjectKeyOfRow |
| dbo.DialogValidDynamicRef Dynamically referenced tables | 5 | 5 | 3 | 2 | 2 | UID_DialogColumn [PK] [FK], UID_DialogTableReference [PK] [FK], XObjectKey, ParentRestriction, ChildRestriction |
| dbo.ADSAccount Active Directory user accounts | 4 | 4 | 3 | 1 | 1 | UID_ADSAccount [PK], cn, XObjectKey, UID_ADSDomain [FK] |
| dbo.ADSAccountSecretary Active Directory user accounts: secretary assignments | 4 | 4 | 3 | 1 | 1 | UID_ADSAccountSecretary [PK], UID_ADSAccount [FK], ObjectKeySecretary, XObjectKey |
| dbo.ADSContact Active Directory contacts | 4 | 4 | 3 | 1 | 1 | UID_ADSContact [PK], UID_ADSDomain [FK], cn, XObjectKey |
| dbo.ADSContactSecretary Active Directory contacts: secretary assignments | 4 | 4 | 3 | 1 | 1 | UID_ADSContactSecretary [PK], UID_ADSContact [FK], ObjectKeySecretary, XObjectKey |
| dbo.ADSContainer Active Directory containers | 4 | 4 | 3 | 1 | 1 | UID_ADSContainer [PK], cn, XObjectKey, UID_ADSDomain [FK] |
| dbo.ADSDomain Active Directory domains | 4 | 4 | 3 | 1 | 1 | UID_ADSDomain [PK], Ident_Domain, XObjectKey, UID_ADSForest [FK] |
| dbo.ADSGroup Active Directory groups | 4 | 4 | 3 | 1 | 1 | UID_ADSGroup [PK], cn, XObjectKey, UID_ADSDomain [FK] |
| dbo.ADSGroupSecretary Active Directory groups: secretary assignments | 4 | 4 | 3 | 1 | 1 | UID_ADSGroupSecretary [PK], UID_ADSGroup [FK], ObjectKeySecretary, XObjectKey |
| dbo.ADSMachine Active Directory computers | 4 | 4 | 3 | 1 | 1 | UID_ADSMachine [PK], cn, XObjectKey, UID_ADSDomain [FK] |
| dbo.ADSPolicyAppliesTo Active Directory account policies: assignments | 4 | 4 | 3 | 1 | 1 | UID_ADSPolicyAppliesTo [PK], UID_ADSPolicy [FK], ObjectKeyAppliesTo, XObjectKey |
| dbo.AttestationCase Attestation cases | 4 | 4 | 3 | 1 | 2 | UID_AttestationCase [PK], UID_AttestationPolicy [FK], XObjectKey, UID_AttestationRun [FK] |
| dbo.BaseTree Roles and organizations | 4 | 4 | 3 | 1 | 1 | UID_Org [PK], Ident_Org, UID_OrgRoot [FK], XObjectKey |
| dbo.BaseTreeHasObject Roles and organizations: company resource assignments | 4 | 4 | 3 | 1 | 1 | UID_BaseTreeHasObject [PK], ObjectKey, UID_Org [FK], XObjectKey |
| dbo.BaseTreeOwnsObject Target system managers | 4 | 4 | 3 | 1 | 1 | UID_BaseTreeOwnsObject [PK], ObjectKey, XObjectKey, UID_Org [FK] |
| dbo.DialogColumn Columns | 4 | 4 | 3 | 1 | 1 | UID_DialogColumn [PK], ColumnName, XObjectKey, UID_DialogTable [FK] |
| dbo.DialogColumnBulkDependencies Column dependencies for bulk filling | 4 | 4 | 3 | 1 | 1 | UID_DialogColumn [FK], UID_QBMColumnBulkDepend [PK], ObjectKeyDialogColumnPrior, XObjectKey |
| dbo.DialogCountryHoliday Public holidays | 4 | 4 | 3 | 1 | 1 | UID_DialogCountryHoliday [PK], UID_DialogCountry [FK], IsoDate, XObjectKey |
| dbo.DialogMailNoSubscription Mail subscription cancellations | 4 | 4 | 3 | 1 | 1 | UID_DialogMailNoSubscription [PK], UID_DialogRichMail [FK], SMTPAddress, XObjectKey |
| dbo.DialogObject Object definitions | 4 | 4 | 3 | 1 | 1 | UID_DialogObject [PK], ObjectName, XObjectKey, UID_DialogTable [FK] |
| dbo.DialogParameter Parameters | 4 | 4 | 3 | 1 | 1 | UID_DialogParameter [PK], UID_DialogParameterSet [FK], ParameterName, XObjectKey |
| dbo.DialogRichMail Mail templates | 4 | 4 | 3 | 1 | 0 | UID_DialogRichMail [PK], Ident_DialogRichMail, XObjectKey, TargetFormat |
| dbo.DialogRichMailBody Mail definitions | 4 | 4 | 3 | 1 | 2 | UID_DialogRichMailBody [PK], UID_DialogRichMail [FK], XObjectKey, UID_DialogCulture [FK] |
| dbo.DialogSchedule Schedules | 4 | 4 | 3 | 1 | 1 | UID_DialogSchedule [PK], Name, XObjectKey, UID_DialogTimeZone [FK] |
| dbo.DialogWebService Web services | 4 | 4 | 3 | 1 | 0 | UID_DialogWebService [PK], Ident_DialogWebService, Namespace, XObjectKey |
| dbo.DPRProjectionStartInfo Start configurations | 4 | 4 | 3 | 1 | 2 | UID_DPRProjectionStartInfo [PK], UID_DPRShell [FK], UID_QBMClrType [FK], XObjectKey |
| dbo.DPRProjectionStepQuota Quotas | 4 | 4 | 3 | 1 | 1 | UID_DPRProjectionStepQuota [PK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRShell Synchronization projects | 4 | 4 | 3 | 1 | 1 | UID_DPRShell [PK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRSystemObjectMatchSet Synchronization object match sets | 4 | 4 | 3 | 1 | 1 | UID_DPRSystemObjectMatchSet [PK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRSystemObjectMatchSets Synchronization object match set of workflow steps | 4 | 4 | 3 | 1 | 1 | UID_DPRSystemObjectMatchSets [PK], XObjectKey, Name, UID_QBMClrType [FK] |
| dbo.DPRSystemVariable System variables | 4 | 4 | 3 | 1 | 2 | UID_DPRSystemVariable [PK], XObjectKey, UID_DPRSystemVariableSet [FK], UID_QBMClrType [FK] |
| dbo.DynamicGroupHasImmediateColumn Dynamic roles: recalculation properties | 4 | 4 | 3 | 1 | 1 | UID_DynamicGroupHasImmediate [PK], UID_DynamicGroup [FK], ObjectKeyDialogColumn, XObjectKey |
| dbo.ESetHasEntitlement System roles: assignments | 4 | 4 | 3 | 1 | 1 | UID_ESetHasEntitlement [PK], UID_ESet [FK], Entitlement, XObjectKey |
| dbo.HardwareType Device models | 4 | 4 | 3 | 1 | 0 | UID_HardwareType [PK], Ident_HardwareType, Ident_HardwareBasicType, XObjectKey |
| dbo.HelperAttestationPolicy Attestation object auxiliary table | 4 | 4 | 3 | 1 | 1 | UID_HelperAttestationPolicy [PK], ObjectKeyBase, UID_AttestationPolicy [FK], XObjectKey |
| dbo.JobChain Processes | 4 | 4 | 3 | 1 | 1 | UID_JobChain [PK], Name, XObjectKey, UID_DialogTable [FK] |
| dbo.JobHistory Process history | 4 | 4 | 3 | 1 | 1 | UID_JobHistory [PK], UID_Job, UID_Tree, GenProcID [FK] |
| dbo.JobParameter Parameter templates | 4 | 4 | 3 | 1 | 1 | UID_JobParameter [PK], UID_JobTask [FK], Name, XObjectKey |
| dbo.JobPerformance Processing performances | 4 | 4 | 3 | 1 | 0 | UID_JobPerformance [PK], Queue, ComponentClass, TaskName |
| dbo.JobTask Process tasks | 4 | 4 | 3 | 1 | 0 | UID_JobTask [PK], ExecutionType, RunningOS, XObjectKey |
| dbo.ObjectHasExtendedAttribute Extended property assignments | 4 | 4 | 3 | 1 | 1 | UID_ObjectHasExtendedAttribute [PK], UID_ExtendedAttribute [FK], ObjectKeyOfObject, XObjectKey |
| dbo.PersonHasObject Identities: company resource assignments | 4 | 4 | 3 | 1 | 1 | UID_PersonHasObject [PK], ObjectKey, UID_Person [FK], XObjectKey |
| dbo.PersonInNCHasMControl Rule violations: mitigating control assignments | 4 | 4 | 3 | 1 | 1 | UID_PersonInNCHasMControl [PK], UID_MitigatingControl [FK], ObjectKeyPersonInNonCompliance, XObjectKey |
| dbo.QBMAdaptiveCardTemplate Adaptive Card templates | 4 | 4 | 3 | 1 | 2 | UID_QBMAdaptiveCardTemplate [PK], UID_QBMAdaptiveCard [FK], UID_DialogCulture [FK], XObjectKey |
| dbo.QBMAttribute Schema attributes | 4 | 4 | 3 | 1 | 0 | UID_QBMAttribute [PK], Ident_QBMAttribute, DisplayName, XObjectKey |
| dbo.QBMClrType CLR types | 4 | 4 | 3 | 1 | 0 | UID_QBMClrType [PK], XObjectKey, Assembly, FullTypeName |
| dbo.QBMColumnTranslation Translation sources | 4 | 4 | 3 | 1 | 1 | UID_DialogColumnTarget [FK], UID_QBMColumnTranslation [PK], ObjectKeyDialogColumnSource, XObjectKey |
| dbo.QBMEvent Object events | 4 | 4 | 3 | 1 | 1 | UID_QBMEvent [PK], EventName, UID_DialogTable [FK], XObjectKey |
| dbo.QBMExternalPackage NuGet packages | 4 | 4 | 3 | 1 | 0 | UID_QBMExternalPackage [PK], Name, Version, XObjectKey |
| dbo.QBMFileHasDeployTarget Software: assignments to machine roles | 4 | 4 | 3 | 1 | 1 | UID_QBMFileHasDeployTarget [PK], UID_QBMFileRevision [FK], ObjectKeyDeployTarget, XObjectKey |
| dbo.QBMIdentityClient OAuth 2.0/OpenID Connect applications | 4 | 4 | 3 | 1 | 1 | UID_QBMIdentityClient [PK], DisplayName, UID_QBMIdentityProvider [FK], XObjectKey |
| dbo.QBMIdentityProvDisabledCol OAuth 2.0/OpenID Connect provider: columns for disabling | 4 | 4 | 3 | 1 | 1 | UID_QBMIdentityProvDisabledCol [PK], ObjectKeyDialogColumn, UID_QBMIdentityProvider [FK], XObjectKey |
| dbo.QBMIdentityProvEnabledCol OAuth 2.0/OpenID Connect provider: columns for enabling | 4 | 4 | 3 | 1 | 1 | UID_QBMIdentityProvEnabledCol [PK], UID_QBMIdentityProvider [FK], ObjectKeyDialogColumn, XObjectKey |
| dbo.QBMLock Locked object properties | 4 | 4 | 3 | 1 | 1 | UID_QBMLock [PK], UID_DialogColumn [FK], ObjectKeyOfRow, XObjectKey |
| dbo.QBMPendingChangeDetail Details of pending changes | 4 | 4 | 3 | 1 | 1 | UID_QBMPendingChangeDetail [PK], UID_QBMPendingChange [FK], Operation, XObjectKey |
| dbo.QBMTaggedChange Labeled object attribute changes | 4 | 4 | 3 | 1 | 1 | UID_QBMTaggedChange [PK], UID_DialogTag [FK], ObjectKey, XObjectKey |
| dbo.QBMTree Menu items | 4 | 4 | 3 | 1 | 0 | UID_QBMTree [PK], Ident_QBMTree, NodeType, XObjectKey |
| dbo.QBMUniqueGroupHasColumn Columns: assignments to unique groups | 4 | 4 | 3 | 1 | 1 | UID_QBMUniqueGroupHasColumn [PK], UID_QBMUniqueGroup [FK], ObjectKeyDialogColumn, XObjectKey |
| dbo.QBMViewAddOn Additional view definitions | 4 | 4 | 3 | 1 | 1 | UID_QBMViewAddOn [PK], UID_DialogTable [FK], XObjectKey, Ident_QBMViewAddOn |
| dbo.QERPickedItem Selection elements | 4 | 4 | 3 | 1 | 1 | UID_QERPickedItem [PK], ObjectKeyItem, XObjectKey, UID_QERPickCategory [FK] |
| dbo.QERPolicyHasObject Policy violations | 4 | 4 | 3 | 1 | 1 | UID_QERPolicyHasObject [PK], UID_QERPolicy [FK], ObjectKey, XObjectKey |
| dbo.QERWebAuthnKey Webauthn security keys | 4 | 4 | 3 | 1 | 2 | UID_QERWebAuthnKey [PK], XObjectKey, UID_Person [FK], UID_QBMIdentityProvider [FK] |
| dbo.QERWorkingStep Running instances of approval steps | 4 | 4 | 3 | 1 | 2 | UID_QERWorkingStep [PK], XObjectKey, UID_QERWorkingMethod [FK], UID_PWODecisionRule [FK] |
| dbo.RPSReport Subscribable reports | 4 | 4 | 3 | 1 | 1 | UID_RPSReport [PK], Ident_RPSReport, UID_DialogReport [FK], XObjectKey |
| dbo.ShoppingCartPatternItem Cart items | 4 | 4 | 3 | 1 | 2 | UID_ShoppingCartPatternItem [PK], UID_AccProduct [FK], UID_ShoppingCartPattern [FK], XObjectKey |
| dbo.TSBPersonUsesAccount Authorization to use shared user accounts | 4 | 4 | 3 | 1 | 1 | UID_TSBPersonUsesAccount [PK], ObjectKeyAccount, UID_Person [FK], XObjectKey |
| dbo.QERBufferRecalcDecisionMaker | 3 | 3 | 3 | 0 | 1 | UID_PWODecisionRule [FK], ObjectKey, UsageArea |
| dbo.QERTermsOfUseHasFile Terms of use: file assignments | 4 | 4 | 2 | 2 | 2 | UID_QERTermsOfUse [PK] [FK], UID_DialogCulture [PK] [FK], FileContent, XObjectKey |
| dbo.AccountNames Security IDs | 3 | 3 | 2 | 1 | 0 | UID_AccountName [PK], Ident_account, XObjectKey |
| dbo.ADSDomainSubType Active Directory domain subtypes | 3 | 3 | 2 | 1 | 0 | UID_ADSDomainSubType [PK], Ident_ADSDomainSubType, XObjectKey |
| dbo.ADSPrinter Active Directory printers | 3 | 3 | 2 | 1 | 1 | UID_ADSPrinter [PK], XObjectKey, UID_ADSMachine [FK] |
| dbo.ADSSite Active Directory site | 3 | 3 | 2 | 1 | 1 | UID_ADSSite [PK], XObjectKey, UID_ADSForest [FK] |
| dbo.AssetClass Asset classes | 3 | 3 | 2 | 1 | 0 | UID_AssetClass [PK], Ident_AssetClass, XObjectKey |
| dbo.AssetType Asset types | 3 | 3 | 2 | 1 | 0 | UID_AssetType [PK], Ident_AssetType, XObjectKey |
| dbo.AttestationHelper Attestation cases auxiliary table | 5 | 3 | 2 | 1 | 1 | UID_AttestationHelper [PK], UID_AttestationCase [FK], LevelNumber = default, SubLevelNumber = default, XObjectKey |
| dbo.AttestationWizardParm Attestation conditions | 3 | 3 | 2 | 1 | 1 | UID_AttestationWizardParm [PK], UID_AttestationObject [FK], XObjectKey |
| dbo.AttestationWizardParmOpt Options for attestation conditions | 3 | 3 | 2 | 1 | 1 | UID_AttestationWizardParmOpt [PK], UID_AttestationWizardParm [FK], XObjectKey |
| dbo.DialogConfigParmOption Configuration parameter options | 3 | 3 | 2 | 1 | 1 | UID_DialogConfigParmOption [PK], UID_ConfigParm [FK], XObjectKey |
No default on 418 occurrences; PK 0, FK 0. Types: varchar(138) × 418
No default on 28 occurrences; PK 26, FK 27. Types: varchar(38) × 28
No default on 27 occurrences; PK 0, FK 0. Types: nvarchar(255) × 4, nvarchar(128) × 2, nvarchar(256) × 21
No default on 23 occurrences; PK 1, FK 22. Types: varchar(38) × 23
No default on 21 occurrences; PK 15, FK 20. Types: varchar(38) × 21
No default on 15 occurrences; PK 6, FK 14. Types: varchar(38) × 15
No default on 13 occurrences; PK 6, FK 12. Types: varchar(38) × 13
No default on 13 occurrences; PK 12, FK 12. Types: varchar(38) × 13
No default on 10 occurrences; PK 10, FK 9. Types: varchar(38) × 10
No default on 8 occurrences; PK 0, FK 0. Types: varchar(138) × 7, nvarchar(256) × 1
No default on 8 occurrences; PK 1, FK 7. Types: varchar(38) × 8
No default on 8 occurrences; PK 1, FK 7. Types: varchar(38) × 8
No default on 7 occurrences; PK 1, FK 5. Types: varchar(38) × 7
No default on 7 occurrences; PK 1, FK 6. Types: varchar(38) × 7
No default on 7 occurrences; PK 6, FK 6. Types: varchar(38) × 7
No default on 7 occurrences; PK 4, FK 6. Types: varchar(38) × 7
No default on 7 occurrences; PK 6, FK 6. Types: varchar(38) × 7
No default on 7 occurrences; PK 6, FK 6. Types: varchar(38) × 7
No default on 6 occurrences; PK 0, FK 0. Types: nvarchar(110) × 6
No default on 6 occurrences; PK 4, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 4, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 6, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 6, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 6, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 2, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 1, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 4, FK 2. Types: varchar(38) × 6
No default on 6 occurrences; PK 2, FK 5. Types: varchar(38) × 6
No default on 6 occurrences; PK 6, FK 5. Types: varchar(38) × 6
No default on 5 occurrences; PK 3, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 1, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 1, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 4, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 1, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 5, FK 4. Types: varchar(38) × 5
No default on 5 occurrences; PK 5, FK 4. Types: varchar(38) × 5
No default on 4 occurrences; PK 0, FK 0. Types: nvarchar(256) × 3, nvarchar(128) × 1
No default on 4 occurrences; PK 0, FK 0. Types: varchar(138) × 4
No default on 4 occurrences; PK 0, FK 0. Types: varchar(138) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 1, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 2, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 1, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 2. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 3, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 1, FK 0. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 4 occurrences; PK 4, FK 3. Types: varchar(38) × 4
No default on 3 occurrences; PK 0, FK 0. Types: nvarchar(400) × 2, nvarchar(256) × 1
No default on 3 occurrences; PK 0, FK 0. Types: varchar(138) × 3
No default on 3 occurrences; PK 0, FK 0. Types: varchar(3) × 1, varchar(1) × 2
No default on 3 occurrences; PK 0, FK 0. Types: varchar(30) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 3, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 3, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 1, FK 2. Types: varchar(38) × 3
No default on 3 occurrences; PK 2, FK 2. Types: varchar(38) × 3
