| [dbo].[DateOfInsertion] | this is a default supplying the current date.
do we really need it though?
| 0 |
| [dbo].[DF_AWBuildVersion_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [dbo].[DF_ErrorLog_ErrorTime] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_Department_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_Employee_CurrentFlag] | Default constraint value of 1
| 1 |
| [HumanResources].[DF_Employee_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_Employee_rowguid] | Default constraint value of NEWID()
| 1 |
| [HumanResources].[DF_Employee_SalariedFlag] | Default constraint value of 1 (TRUE)
| 1 |
| [HumanResources].[DF_Employee_SickLeaveHours] | Default constraint value of 0
| 1 |
| [HumanResources].[DF_Employee_VacationHours] | Default constraint value of 0
| 1 |
| [HumanResources].[DF_EmployeeAddress_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_EmployeeAddress_rowguid] | Default constraint value of NEWID()
| 1 |
| [HumanResources].[DF_EmployeeDepartmentHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_EmployeePayHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_JobCandidate_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [HumanResources].[DF_Shift_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_Address_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_Address_rowguid] | Default constraint value of NEWID()
| 1 |
| [Person].[DF_AddressType_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_AddressType_rowguid] | Default constraint value of NEWID()
| 1 |
| [Person].[DF_Contact_EmailPromotion] | Default constraint value of 0
| 1 |
| [Person].[DF_Contact_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_Contact_NameStyle] | Default constraint value of 0
| 1 |
| [Person].[DF_Contact_rowguid] | Default constraint value of NEWID()
| 1 |
| [Person].[DF_ContactType_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_CountryRegion_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_StateProvince_IsOnlyStateProvinceFlag] | Default constraint value of 1 (TRUE)
| 1 |
| [Person].[DF_StateProvince_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Person].[DF_StateProvince_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_BillOfMaterials_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_BillOfMaterials_PerAssemblyQty] | Default constraint value of 1.0
| 1 |
| [Production].[DF_BillOfMaterials_StartDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Culture_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Document_ChangeNumber] | Default constraint value of 0
| 1 |
| [Production].[DF_Document_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Illustration_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Location_Availability] | Default constraint value of 0.00
| 1 |
| [Production].[DF_Location_CostRate] | Default constraint value of 0.0
| 1 |
| [Production].[DF_Location_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Product_FinishedGoodsFlag] | Default constraint value of 1
| 1 |
| [Production].[DF_Product_MakeFlag] | Default constraint value of 1
| 1 |
| [Production].[DF_Product_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_Product_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_ProductCategory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductCategory_rowguid] | Default constraint value of NEWID()()
| 1 |
| [Production].[DF_ProductCostHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductDescription_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductDescription_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_ProductDocument_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductInventory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductInventory_Quantity] | Default constraint value of 0
| 1 |
| [Production].[DF_ProductInventory_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_ProductListPriceHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductModel_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductModel_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_ProductModelIllustration_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductModelProductDescriptionCulture_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductPhoto_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductProductPhoto_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductProductPhoto_Primary] | Default constraint value of 0 (FALSE)
| 1 |
| [Production].[DF_ProductReview_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductReview_ReviewDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductSubcategory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_ProductSubcategory_rowguid] | Default constraint value of NEWID()
| 1 |
| [Production].[DF_ScrapReason_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_TransactionHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_TransactionHistory_ReferenceOrderLineID] | Default constraint value of 0
| 1 |
| [Production].[DF_TransactionHistory_TransactionDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_TransactionHistoryArchive_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_TransactionHistoryArchive_ReferenceOrderLineID] | Default constraint value of 0
| 1 |
| [Production].[DF_TransactionHistoryArchive_TransactionDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_UnitMeasure_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_WorkOrder_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Production].[DF_WorkOrderRouting_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_ProductVendor_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_PurchaseOrderDetail_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_Freight] | Default constraint value of 0.0
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_OrderDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_RevisionNumber] | Default constraint value of 0
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_Status] | Default constraint value of 1
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_SubTotal] | Default constraint value of 0.0
| 1 |
| [Purchasing].[DF_PurchaseOrderHeader_TaxAmt] | Default constraint value of 0.0
| 1 |
| [Purchasing].[DF_ShipMethod_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_ShipMethod_rowguid] | Default constraint value of NEWID()
| 1 |
| [Purchasing].[DF_ShipMethod_ShipBase] | Default constraint value of 0.0
| 1 |
| [Purchasing].[DF_ShipMethod_ShipRate] | Default constraint value of 0.0
| 1 |
| [Purchasing].[DF_Vendor_ActiveFlag] | Default constraint value of 1 (TRUE)
| 1 |
| [Purchasing].[DF_Vendor_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_Vendor_PreferredVendorStatus] | Default constraint value of 1 (TRUE)
| 1 |
| [Purchasing].[DF_VendorAddress_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Purchasing].[DF_VendorContact_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_ContactCreditCard_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_CountryRegionCurrency_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_CreditCard_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_Currency_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_CurrencyRate_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_Customer_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_Customer_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_CustomerAddress_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_CustomerAddress_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_Individual_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesOrderDetail_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesOrderDetail_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesOrderDetail_UnitPriceDiscount] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesOrderHeader_Freight] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesOrderHeader_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesOrderHeader_OnlineOrderFlag] | Default constraint value of 1 (TRUE)
| 1 |
| [Sales].[DF_SalesOrderHeader_OrderDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesOrderHeader_RevisionNumber] | Default constraint value of 0
| 1 |
| [Sales].[DF_SalesOrderHeader_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesOrderHeader_Status] | Default constraint value of 1
| 1 |
| [Sales].[DF_SalesOrderHeader_SubTotal] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesOrderHeader_TaxAmt] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesOrderHeaderSalesReason_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesPerson_Bonus] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesPerson_CommissionPct] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesPerson_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesPerson_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesPerson_SalesLastYear] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesPerson_SalesYTD] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesPersonQuotaHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesPersonQuotaHistory_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesReason_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesTaxRate_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesTaxRate_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesTaxRate_TaxRate] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesTerritory_CostLastYear] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesTerritory_CostYTD] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesTerritory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesTerritory_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SalesTerritory_SalesLastYear] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesTerritory_SalesYTD] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SalesTerritoryHistory_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SalesTerritoryHistory_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_ShoppingCartItem_DateCreated] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_ShoppingCartItem_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_ShoppingCartItem_Quantity] | Default constraint value of 1
| 1 |
| [Sales].[DF_SpecialOffer_DiscountPct] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SpecialOffer_MinQty] | Default constraint value of 0.0
| 1 |
| [Sales].[DF_SpecialOffer_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SpecialOffer_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_SpecialOfferProduct_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_SpecialOfferProduct_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_Store_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_Store_rowguid] | Default constraint value of NEWID()
| 1 |
| [Sales].[DF_StoreContact_ModifiedDate] | Default constraint value of GETDATE()
| 1 |
| [Sales].[DF_StoreContact_rowguid] | Default constraint value of NEWID()
| 1 |