| Check Constraints | ||||||||
|---|---|---|---|---|---|---|---|---|
| Fact | GeneralSchema | GeneralObject | SQLServerName | create_date | modify_date | is_disabled | is_not_trusted | SQLServerCode |
| 14 | HumanResources | Employee | CK_Employee_BirthDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate())) |
| 14 | HumanResources | Employee | CK_Employee_Gender | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([Gender])='F' OR upper([Gender])='M') |
| 14 | HumanResources | Employee | CK_Employee_HireDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate())) |
| 14 | HumanResources | Employee | CK_Employee_MaritalStatus | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([MaritalStatus])='S' OR upper([MaritalStatus])='M') |
| 14 | HumanResources | Employee | CK_Employee_SickLeaveHours | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120)) |
| 14 | HumanResources | Employee | CK_Employee_VacationHours | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([VacationHours]>=(-40) AND [VacationHours]<=(240)) |
| 14 | HumanResources | EmployeeDepartmentHistory | CK_EmployeeDepartmentHistory_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| 14 | HumanResources | EmployeePayHistory | CK_EmployeePayHistory_PayFrequency | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([PayFrequency]=(2) OR [PayFrequency]=(1)) |
| 14 | HumanResources | EmployeePayHistory | CK_EmployeePayHistory_Rate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Rate]>=(6.50) AND [Rate]<=(200.00)) |
| 14 | Person | Person | CK_Person_EmailPromotion | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) |
| 14 | Person | Person | CK_Person_PersonType | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([PersonType] IS NULL OR (upper([PersonType])='GC' OR upper([PersonType])='SP' OR upper([PersonType])='EM' OR upper([PersonType])='IN' OR upper([PersonType])='VC' OR upper([PersonType])='SC')) |
| 14 | Production | BillOfMaterials | CK_BillOfMaterials_BOMLevel | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ProductAssemblyID] IS NULL AND [BOMLevel]=(0) AND [PerAssemblyQty]=(1.00) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel]>=(1)) |
| 14 | Production | BillOfMaterials | CK_BillOfMaterials_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>[StartDate] OR [EndDate] IS NULL) |
| 14 | Production | BillOfMaterials | CK_BillOfMaterials_PerAssemblyQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([PerAssemblyQty]>=(1.00)) |
| 14 | Production | BillOfMaterials | CK_BillOfMaterials_ProductAssemblyID | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ProductAssemblyID]<>[ComponentID]) |
| 14 | Production | Document | CK_Document_Status | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Status]>=(1) AND [Status]<=(3)) |
| 14 | Production | Location | CK_Location_Availability | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Availability]>=(0.00)) |
| 14 | Production | Location | CK_Location_CostRate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([CostRate]>=(0.00)) |
| 14 | Production | Product | CK_Product_Class | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL) |
| 14 | Production | Product | CK_Product_DaysToManufacture | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([DaysToManufacture]>=(0)) |
| 14 | Production | Product | CK_Product_ListPrice | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ListPrice]>=(0.00)) |
| 14 | Production | Product | CK_Product_ProductLine | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL) |
| 14 | Production | Product | CK_Product_ReorderPoint | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ReorderPoint]>(0)) |
| 14 | Production | Product | CK_Product_SafetyStockLevel | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SafetyStockLevel]>(0)) |
| 14 | Production | Product | CK_Product_SellEndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL) |
| 14 | Production | Product | CK_Product_StandardCost | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([StandardCost]>=(0.00)) |
| 14 | Production | Product | CK_Product_Style | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL) |
| 14 | Production | Product | CK_Product_Weight | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Weight]>(0.00)) |
| 14 | Production | ProductCostHistory | CK_ProductCostHistory_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| 14 | Production | ProductCostHistory | CK_ProductCostHistory_StandardCost | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([StandardCost]>=(0.00)) |
| 14 | Production | ProductInventory | CK_ProductInventory_Bin | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Bin]>=(0) AND [Bin]<=(100)) |
| 14 | Production | ProductInventory | CK_ProductInventory_Shelf | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Shelf] like '[A-Za-z]' OR [Shelf]='N/A') |
| 14 | Production | ProductListPriceHistory | CK_ProductListPriceHistory_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| 14 | Production | ProductListPriceHistory | CK_ProductListPriceHistory_ListPrice | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ListPrice]>(0.00)) |
| 14 | Production | ProductReview | CK_ProductReview_Rating | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Rating]>=(1) AND [Rating]<=(5)) |
| 14 | Production | TransactionHistory | CK_TransactionHistory_TransactionType | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') |
| 14 | Production | TransactionHistoryArchive | CK_TransactionHistoryArchive_TransactionType | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') |
| 14 | Production | WorkOrder | CK_WorkOrder_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| 14 | Production | WorkOrder | CK_WorkOrder_OrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([OrderQty]>(0)) |
| 14 | Production | WorkOrder | CK_WorkOrder_ScrappedQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ScrappedQty]>=(0)) |
| 14 | Production | WorkOrderRouting | CK_WorkOrderRouting_ActualCost | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ActualCost]>(0.00)) |
| 14 | Production | WorkOrderRouting | CK_WorkOrderRouting_ActualEndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL) |
| 14 | Production | WorkOrderRouting | CK_WorkOrderRouting_ActualResourceHrs | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ActualResourceHrs]>=(0.0000)) |
| 14 | Production | WorkOrderRouting | CK_WorkOrderRouting_PlannedCost | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([PlannedCost]>(0.00)) |
| 14 | Production | WorkOrderRouting | CK_WorkOrderRouting_ScheduledEndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ScheduledEndDate]>=[ScheduledStartDate]) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_AverageLeadTime | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([AverageLeadTime]>=(1)) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_LastReceiptCost | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([LastReceiptCost]>(0.00)) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_MaxOrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([MaxOrderQty]>=(1)) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_MinOrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([MinOrderQty]>=(1)) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_OnOrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([OnOrderQty]>=(0)) |
| 14 | Purchasing | ProductVendor | CK_ProductVendor_StandardPrice | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([StandardPrice]>(0.00)) |
| 14 | Purchasing | PurchaseOrderDetail | CK_PurchaseOrderDetail_OrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([OrderQty]>(0)) |
| 14 | Purchasing | PurchaseOrderDetail | CK_PurchaseOrderDetail_ReceivedQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ReceivedQty]>=(0.00)) |
| 14 | Purchasing | PurchaseOrderDetail | CK_PurchaseOrderDetail_RejectedQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([RejectedQty]>=(0.00)) |
| 14 | Purchasing | PurchaseOrderDetail | CK_PurchaseOrderDetail_UnitPrice | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([UnitPrice]>=(0.00)) |
| 14 | Purchasing | PurchaseOrderHeader | CK_PurchaseOrderHeader_Freight | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Freight]>=(0.00)) |
| 14 | Purchasing | PurchaseOrderHeader | CK_PurchaseOrderHeader_ShipDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL) |
| 14 | Purchasing | PurchaseOrderHeader | CK_PurchaseOrderHeader_Status | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Status]>=(1) AND [Status]<=(4)) |
| 14 | Purchasing | PurchaseOrderHeader | CK_PurchaseOrderHeader_SubTotal | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SubTotal]>=(0.00)) |
| 14 | Purchasing | PurchaseOrderHeader | CK_PurchaseOrderHeader_TaxAmt | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([TaxAmt]>=(0.00)) |
| 14 | Purchasing | ShipMethod | CK_ShipMethod_ShipBase | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ShipBase]>(0.00)) |
| 14 | Purchasing | ShipMethod | CK_ShipMethod_ShipRate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ShipRate]>(0.00)) |
| 14 | Purchasing | Vendor | CK_Vendor_CreditRating | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([CreditRating]>=(1) AND [CreditRating]<=(5)) |
| 14 | Sales | SalesOrderDetail | CK_SalesOrderDetail_OrderQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([OrderQty]>(0)) |
| 14 | Sales | SalesOrderDetail | CK_SalesOrderDetail_UnitPrice | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([UnitPrice]>=(0.00)) |
| 14 | Sales | SalesOrderDetail | CK_SalesOrderDetail_UnitPriceDiscount | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([UnitPriceDiscount]>=(0.00)) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_DueDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([DueDate]>=[OrderDate]) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_Freight | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Freight]>=(0.00)) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_ShipDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_Status | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Status]>=(0) AND [Status]<=(8)) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_SubTotal | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SubTotal]>=(0.00)) |
| 14 | Sales | SalesOrderHeader | CK_SalesOrderHeader_TaxAmt | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([TaxAmt]>=(0.00)) |
| 14 | Sales | SalesPerson | CK_SalesPerson_Bonus | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Bonus]>=(0.00)) |
| 14 | Sales | SalesPerson | CK_SalesPerson_CommissionPct | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([CommissionPct]>=(0.00)) |
| 14 | Sales | SalesPerson | CK_SalesPerson_SalesLastYear | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesLastYear]>=(0.00)) |
| 14 | Sales | SalesPerson | CK_SalesPerson_SalesQuota | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesQuota]>(0.00)) |
| 14 | Sales | SalesPerson | CK_SalesPerson_SalesYTD | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesYTD]>=(0.00)) |
| 14 | Sales | SalesPersonQuotaHistory | CK_SalesPersonQuotaHistory_SalesQuota | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesQuota]>(0.00)) |
| 14 | Sales | SalesTaxRate | CK_SalesTaxRate_TaxType | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([TaxType]>=(1) AND [TaxType]<=(3)) |
| 14 | Sales | SalesTerritory | CK_SalesTerritory_CostLastYear | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([CostLastYear]>=(0.00)) |
| 14 | Sales | SalesTerritory | CK_SalesTerritory_CostYTD | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([CostYTD]>=(0.00)) |
| 14 | Sales | SalesTerritory | CK_SalesTerritory_SalesLastYear | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesLastYear]>=(0.00)) |
| 14 | Sales | SalesTerritory | CK_SalesTerritory_SalesYTD | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([SalesYTD]>=(0.00)) |
| 14 | Sales | SalesTerritoryHistory | CK_SalesTerritoryHistory_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |
| 14 | Sales | ShoppingCartItem | CK_ShoppingCartItem_Quantity | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([Quantity]>=(1)) |
| 14 | Sales | SpecialOffer | CK_SpecialOffer_DiscountPct | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([DiscountPct]>=(0.00)) |
| 14 | Sales | SpecialOffer | CK_SpecialOffer_EndDate | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([EndDate]>=[StartDate]) |
| 14 | Sales | SpecialOffer | CK_SpecialOffer_MaxQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([MaxQty]>=(0)) |
| 14 | Sales | SpecialOffer | CK_SpecialOffer_MinQty | 2017-10-27 14:33:01 | 2017-10-27 14:33:01 | False | False | ([MinQty]>=(0)) |