Novell ZENWORKS 10 Schematics
3
LC_ComplianceInstCountDemog
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
InstalledQty int
IgnoredQty int
UndiscoveredQty int
LC_ComplianceLicCountDemog
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
Source smallint
LicenseQty int
AllocatedQty int
LC_ComplianceDemographics
PK ZUID binary(16 )
FK1,I1 LicenseOID binary(1 6)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
Source smallint
LicenseQty int
AllocatedQty int
InstalledQty int
QtyConsumed int
OverLicensedQty int
UnderLicensedQty int
LC_AllocationsVsInstallat ions
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
TotalInstQty int
DemographicInstQty int
WorkstationInstQty int
UnallocatedInstQty int
TotalOverAllocQty int
TotalUnderAllocQty int
DemoOverAllocQty int
DemoUnderAllocQty int
WkstnOverAllocQty int
LC_DemographicAllocation
PK AllocationOID binary(16)
FK1,I1 LicenseOID binary(16)
Type smallint
Unit nvarchar(32)
Qty int
WorkstationQty int
InstalledQty int
VarianceQty int
LC_ComplianceEngineLog
PK ZUID binary(16)
StartTime datetime
FinishTime datetime
LastModifiedTime datetime
Status smallint
Source smallint
StartedBy nvarchar(64)
LicensesToDo int
LicensesDone int
FK1,I1 LicenseOID binary(16)
Comments nvarchar(256)
PK,FK1 ZUID binary(16)
U2,U1 Manufacturer nvarchar(64)
U2,U1 Version nvarchar(32)
U2,U1 LicenseName nvarchar(2 55)
LC_WorkstationAllocation
PK AllocationOID binary(16)
FK1,I1 LicenseOID binary(16)
Qty in t
DuplicateAllocation tinyint
InstalledQty int
LC_License
Notes nvarchar(256)
AllocateBy smallint
AllocateImports smallint
Compliance smallint
CalculatedIndex float
ManualIndex float
TotalLicenses int
TotalInstalled int
HasManualSource tinyint
CalculatedLicenseQty int
ManualLicenseQty int
CalculatedConsumption int
ManualConsumption int
CalculatedOverLicensedQty int
ManualOverLicensedQty int
CalculatedUnderLicense dQty int
ManualUnderLicensedQty int
CalculationDate datetime
Adf0 nvarchar(256)
Adf1 nvarchar(256)
Adf2 nvarchar(64)
Adf3 nvarchar(64)
Adf4 nvarchar(64)
Adf5 nvarchar(64)
Adf6 nvarchar(64)
Adf7 nvarchar(64)
Adf8 nvarchar(64)
Adf9 nvarchar(64)
Adf10 nvarchar(64)
Adf11 nvarchar(64)
Adf12 nvarchar(64)
Adf13 nvarchar(64)
Adf14 nvarchar(64)
Adf15 nvarchar(64)
Adf16 nvarchar(64)
Adf17 nvarchar(64)
Adf18 nvarchar(64)
Adf19 nvarchar(64)
AllocatedQty int
LC_CalculatedCompliance
PK ZUID binary(16)
FK1,I1 LicenseOID binary(16)
CalculationType smallint
VersionsCovered nvarchar(1024)
LicenseQty int
QtyConsumed int
FK2,I2 Entitlem entUID binary(16)
LC_LicenseToTPMap
PK MapOID binary(16)
FK2,I1 TallyProductOID binary(16)
FK1,I2 LicenseOID binary(16)
LC_ChangeLogSPMap
PK ZUID binary(16)
FK2,I1 SummaryPurchaseUID binary(16)
FK1,I2 ChangeLogUID binary(16)
LC_ChangeLog
PK ZUID binary(16)
DateChanged datetime
ChangedBy nvarchar(64)
QuantityBefore int
QuantityAfter int
DescriptionBefore nvarchar(256)
DescriptionAfter nvarchar(256)
LC_EntitlementToPPMap
PK MapOID binary(16)
FK2,U1,U5,U3,U4,U2 PurchasedProductOI D binary(16)
FK1,I1 Entitle mentUID binary(16)
LC_PurchasedProduct
PK,FK1 ZUID binary(16)
ProductDesc nvarchar(128)
ResellerSKU nvarchar(32)
MfgPartNum nvarchar(32 )
U2,U1 Manufacturer nvarchar(64)
U2,U1 Version nvarchar(32)
U2,U1 Type nvarchar(32)
U2,U1 LicenseQty int
Upgrade int
Excluded int
Matched int
Associated int
Notes nvarchar(255)
U2,U1 Product nvarchar(25 6)
PK MapOID binary(16)
FK2,U2,U3,U5,U1,U4 PurchasedProductOID bi nary(16)
FK1,I1 LicenseOID binary(16)
LC_LicenseToPPMap
PK ZUID binary(16)
FK1,I1 EntitlementUID binary(16)
LC_ChangeLogEntMap
PK ZUID binary(16)
FK2,I1 EntitlementUID binary(1 6)
FK1,I2 ChangeLogUID binary(16)
LC_PurchaseRecDetail
PK DetailOID binary(16)
FK2,I2 PurchaseRecOID binary(16)
FK1,I1 PurchasedProdOID binary(16)
Quantity int
SerialNumber nvarchar(40)
Comments nvarchar(128)
CostCenter nvarchar(32)
Department nvarchar(32)
Site nvarchar(32)
InvoiceNumber nvarchar(32)
UnitMSRP numeric(19,2)
UnitPrice numeric(19,2)
TotalPrice numeric(19,2)
ExpDate datetime
LC_PurchaseRec
PK,FK1 ZUID binary(16)
OrderDate datetime
PONumber nv archar(32)
Reseller nvarchar(64)
Company nvarchar(32)
ShipAddress1 nvarchar(64)
ShipAddress2 nvarchar(64)
ShipAddress3 nvarchar(64)
ShipCity nvarchar(32)
ShipState nvarchar(32)
ShipZip nvarchar(16)
ShipCountry nvarchar(32)
Recipient nvarchar(32)
Notes nvarchar(256)
LC_SummaryPurchase
Description nvarchar(256)
LicenseQty int
DateEntered datetime
EnteredBy nvarchar(64)
Notes nvarchar(256)
TotalCost numeric(1 9,2)
LC_Entitlement
PK ZUID binary(16)
FK2,I1 LicenseOID binary(16)
FK1,I2 UpgradeFrom binary(16)
LicenseModel smallint
LicenseModelName nvarchar(64)
LicenseQty int
Description nvarchar(256)
Platform nvarchar(64)
Type smallint
LicensePeriod smallint
StartDate datetime
EndDate datetime
Notes nvarchar(256)
QtyUpgraded int
QtyAvailable int
QtyConsumed int
Status smallint
VMUseRights nvarchar(256)
LC_SummaryPurchaseDocumentMap
PK ZUID binary(16)
FK2,I1 SummaryPurchaseUID binary(16 )
FK1,I2 DocumentOID binary(16)
attachedBy nva rchar(64)
dateAttached datetime
LC_EntitlementDocumentMap
PK ZUID binary(16)
FK2,I2 EntitlementUID binary(16)
FK1,I1 DocumentOID binary(16)
attachedBy nvarchar(64)
dateAttached datetime
PK ZUID binary(16)
FK1,I1 EntitlementUID binary(16)
WorkstationOID binary(16)
MachineName nvarchar(32)
SerialNumber nvarchar(38)
IsDeleted tinyint
IsInstalled tinyint
IsLicenseConsumed tinyint
IsRetired tinyint
LC_EntitlementToTPMap
PK MapOID binary(16)
FK1,I2 EntitlementUID binary(16)
FK2,I1 TallyProductOID binary(16)
LC_MachinesCovered
LC_Document
PK,FK1 ZUID binary(16)
UserDocID nvarchar(64)
FName nvarchar(256)
FileExt nvarchar(8)
FilePath nvarchar(1024)
FileLength numeric(19,0)
ServerName nvarchar(128)
FileDate datetime
UploadDate datetime
UploadedBy nvarchar(64)
Description nvarchar(255)
FileBlob image
LC_RenewalHistory
PK RenewalOID binary(16)
FK1,I1 ContractOID binary(16)
DateOfChange datetime
SourceOfChange nvarchar(64)
BeforeEndDate datetime
AfterEndDate datetime
EffectiveDate datetime
Notes nvarchar(512)
LC_ContractEntitlementMap
PK ZUID binary(16)
FK1,I2 ContractOID binary(16)
FK2,I1 EntitlementUID binary(16)
LC_Vendor
PK VendorOID binary(16)
VendorName nvarchar(64)
AdminVendorID nvarchar(64)
AccountNumber nvarchar(64)
PriContactName nva rchar(64)
PriContactPhone nvarcha r(32)
PriContactEmail nvarchar(32)
SecContactName nvarchar(64)
SecContactPhone nvarchar(32)
SecContactEmail nvarchar(32)
LC_ContractNetworkDeviceMap
PK ZUID binary(16)
FK1,U2,U3,U1,I2,U5,U4 ContractOID binary(16)
U2,U3,U1,I1,U5,U4 NetworkDeviceOID binary(16)
PK ZUID binary(16)
FK1,U3,U2,I1,U1,U5,U4 ContractOID binary(16)
U3,U2,U1,U5,U4 OUType smallin t
U3,U2,U1,U5,U4 OUValue nvarcha r(32)
PK ZUID binary(16)
FK1,U3,U2,U1,I1,U5,U4 ContractOID bina ry(16)
FK2,U3,U2,U1,I2,U5,U4 DocumentOID binary(16)
PK,FK7 ZUID binary(16)
FK1,I2 ParentContractOID binary(16)
U4,U5,U1,U2,U7,U3,U6 AdminContractID nvarchar(64)
FK6,I6 VendorOID binary(16)
FK3,I3 StartDateNotifOID binary (16)
FK4,I4 EndDateNotifOID binary( 16)
FK5,I1 NoticeDateNotifOID binary(16)
FK2,I5 LeaseOID binary(16)
LC_ContractOrgUnitAssoc
LC_ContractDocumentMap
AttachedBy nvarchar(64)
DateAttached datetime
LC_Contract
ContractName nvarchar(64)
Description nvarchar(255)
ContractType nvarchar(32)
ContractStatus nvarchar(32)
ProgramName nvarchar(255 )
TotalCost numeric(19,2)
InternalContactName nvarchar(64)
InternalContactPhone nvarchar(16)
InternalContactEmail nvarchar(64)
StartDate datetime
EndDate datetime
Evergreen tinyint
NoticeDescription nvarchar(255)
NoticeDate datetime
TimeRemaining numeric(19,0)
RenewalOption tinyint
RenewalProvision nvarchar(255)
KeyTerms nvarchar(255)
VendorContractID nvarchar(32)
Adf0 nvarchar(256)
Adf1 nvarchar(256)
Adf2 nvarchar(64)
Adf3 nvarchar(64)
Adf4 nvarchar(64)
Adf5 nvarchar(64)
Adf6 nvarchar(64)
Adf7 nvarchar(64)
Adf8 nvarchar(64)
Adf9 nvarchar(64)
Adf10 nvarchar(64)
Adf11 nvarchar(64)
Adf12 nvarchar(64)
Adf13 nvarchar(64)
Adf14 nvarchar(64)
Adf15 nvarchar(64)
Adf16 nvarchar(64)
Adf17 nvarchar(64)
Adf18 nvarchar(64)
Adf19 nvarchar(64)
LC_ContractWkstnMap
PK ZUID binary(16)
FK1,U3,U2,U1,I2,U5,U4 ContractOID binary(16)
U3,U2,U1,I1,U5,U4 WorkstationOID binary(16)
LC_ContractUserMap
PK ZUID binary(16)
FK1,U2,U1,I1,U4,U3 ContractOID binary(16)
U2,U1,I2,U4,U3 UserOID binary(16)
PK LeaseOID binary(16)
FK1,I4 DateOrderedNotifOID binary(16)
FK2,I5 DateShippedNotifOID binary(16)
FK3,I1 DateDeliveredNotifOID binary(16)
FK4,I6 DateSignedNotifOID binary(16)
FK5,I2 DateInspectedNotifOID binary(16)
FK6,I3 DateAcceptedNotifOID bin ary(16)
PK,FK4 ZUID binary(16)
FK1,I2 ContractOID binary(16)
FK2,I3 LeaseOID binary(16)
FK3,I1 ServiceLevelAgre ementOID binary(16)
PK ServiceLevelAgreementOI D binary(16)
FK1,I3 ContractOID binary(1 6)
FK2,I1 StartDateNotifOID binary(16)
FK3,I2 EndDateNotif OID binary(16)
LC_Lease
DateOrdered datetime
DateShipped datetime
DateDelivered datetime
DateSignedFor datetime
DateInspected datetime
DateAccepted datetime
DeliveryProcedures nvarchar(255)
ReturnObligations nvarchar(255)
RightsToRelocate nvarchar(255)
DefaultsAndRemedies nvarchar(255)
InsuranceProvisions nvarchar(255)
InsuranceAmount numeric(19,2)
ModificationProvisions nvarchar(255)
PurchaseOption nvarchar(255)
EndOfLeaseProvisions nvarchar(255)
PrevailingLaw nvarchar(255)
LC_Notifications
NotificationType smallint
DocumentType smallint
ContractType smallint
NotificationName nvarch ar(150)
FieldName nvarchar(65)
FieldLabel nvarchar(64)
DaysPrior int
Status smallint
Recipients ntext
RepeatCount int
Frequency smallint
NotificationsSent int
NotificationFailures int
LastSentDate datetime
NextScheduledDate datetime
AutoDelete smallint
Subject nvarchar(256)
CreateDate datetime
MessageText nvarchar(2048)
Sender nvarchar(128)
Locale nvarchar(10)
LC_ServiceLevelAgreement
DefinedServiceLevel nvarchar(128)
ActualServiceLevel nvarchar(128)
ServiceStartDate datetime
ServiceEndDate datetime
PercentMet int
®
LC_TallyProductExtension
PK DpExtensionUID binary(16)
FK2,U2,U1,U5,U4,U3 TallyProductOID binary(16)
I2 ExcludedByUser tinyint
FK1,I1 DpStandards UID binary(16 )
UndiscoveredQty int
Notes nvarchar(255)
LC_TallyProductMap
PK MapOID bi nary(16)
FK1,I1 TallyProdOID binary(16)
I2 Source int
LC_ProductStandards
PK StandardsOID binary(16)
FK1,I1 ProductOID binary(16)
GroupName nvarchar(30)
StandardName nva rchar(30)
LC_TallyProductSuiteMap
PK MapOID binary(16)
FK2,I2,U1 SuiteOID binary(16)
FK1,I1,U1 ComponentProductOID binary(16)
PK,FK2 ZUID binary(16)
I2 Source int
FK1,I1 DpExtensionUID binary(16)
LC_TallyProductSuite
PK ZUID binary(16)
FK1,I1 ProductOID binary(16)
SuiteName nvarchar(64)
LC_TallyProduct
Version nvarchar(32)
Manufacturer nvarchar(64)
Excluded int
Platform int
Product nvarchar(256)
CurrentManufacturer nv archar(64)
DistributionModel smallint
LicenseType smallin t
QtyIgnored int
QtyInstalled int
LC_TallyProductColl
PK,FK2 ZUID binary(16)
FK1,U2,U3,U5,U4,U1 ProductOID binary(16)
PK ZUID binary(16)
FK1,U2,U3,I1,U1,U5,U4 MemberComponentOID binary(16)
FK4,I3 MemberProductOID binary(16)
FK2,U2,U3,I2,U1,U5,U4 ParentComponentOID binary(16)
FK3,I4 ParentProductOID binary(16)
LC_CollComponent
Platform int
Source int
IsTracked int
DateLastModified datet ime
PK ComponentOID binary(16)
FK3,I2 TallyProductOID binary(16)
FK1,I1 SuiteComponentOID binary(16)
FK2,I3 SuiteProductOID binary(16)
LC_SuiteComponent
PK MapOID binary(16)
FK2,I2,U3,U1,U4,U5,U2,U7,U6 ParentProductOID binary(16)
FK1,I1,U3,U1,U4,U5,U2,U7,U6 MemberProductOID binary(16)
PK ComponentOID binary(16)
I3 WorkstationOID binary(16)
FK1,I2 TallyProductOID binary(16)
I4 Excluded smallint
I1 ReferencedComponentOID binary(16)
LC_TallyProductCollMap
IsRequired smallint
LC_Component
ExcludedNonColl smallint
Ignored tinyint
LC_PurchaseRecordImportMap
PK MapName nv archar(64)
MapResellerName nvarchar(32)
MapDelim nvarchar(8)
MapDateFormat nvarcha r(16)
MapIgnoredCols nvarchar(512)
PONum nvarchar(32)
OrderDate n varchar(32)
InvoiceNum nvarchar(32)
Reseller nvarchar(32)
Recipient nvarchar(32)
CompanyName nvarchar(32)
ShippingAddress1 nvarchar(32)
ShippingAddress2 nvarchar(32)
ShippingAddress3 nvarchar(32)
City nvarchar(32)
State n varchar(32)
Zip nvarchar(32)
Country nvarchar(32)
Notes nvarchar(32)
Manufacturer nvarchar(32)
ProductName nvarchar(32)
Version nvarcha r(32)
ProductType nvarchar(32)
LicensesPerPackage nvarchar(32)
ResellerSKU nvarchar(32)
MfrPartNum nvarchar(32)
Upgrade nvarchar(32)
PurchaseQty nvarchar(32)
SerialNum nvarchar(32)
Site nvarchar(32)
Department nvarchar(32)
CostCenter nvarchar(32)
Comments nvarchar(32)
UnitMSRP nvarchar(32)
UnitPrice nvarchar(32)
ExtendedPrice nvarchar(32)
ExpDate nvarchar(32)
LC_ImportHistory
PK JobOID binary(16)
NumRecordsCreated int
NumDetailsCreated int
NumProductsCreated int
ImportStartTime datetime
ImportEndTime datetime
Duration numeric(19,2)
NumErrors int
FileName nvarchar(64)
FileLength numeric(19,2)
NumRows int
Success int
Progress numeric(19,2)
LC_ImportError
PK ErrorOID binary(16)
FK1,I1 JobOID binary(16)
FileName nvarchar(64)
LineNum int
ErrorMsg nvarchar(64)
StackTrace nvarchar(256)
CreateDate datetime
LC_NotificationDefaults
PK NotificationDefaultOID binary(16)
DaysPrior int
Recipients ntext
RepeatCount int
Frequency small int
AutoDelete smallint
EmailFrom nvarchar(64)
ZENworks 10 Configuration Manageme nt SP2
Software / Contract Management – 05/2 009
Notice: Details about the ZENworks database
schema are provided for reference p urposes. The
schema generally changes in each release of th e
product and any integration done at the database
level may be impacted by these changes. We
suggest you contact Novell to discuss your import
or export integration plans with the ZENworks
database.
Copyright © 2009 Novell, Inc. All rights reserved.
No part of this publication may be reproduced,
photocopied, stored on a retrieval system, or
transmitted without the express written con sent
of the publisher.
Loading...