SalesTerritory
PK
TerritoryID
int
NN
Name
Name
NN
FK
CountryRegionCode
nvarchar(3)
NN
Group
nvarchar(50)
NN
SalesYTD
money
NN
SalesLastYear
money
NN
CostYTD
money
NN
CostLastYear
money
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesTerritory_TerritoryID
IX
AK_SalesTerritory_Name
IX
AK_SalesTerritory_rowguid
ScrapReason
PK
ScrapReasonID
smallint
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_ScrapReason_ScrapReasonID
IX
AK_ScrapReason_Name
DatabaseLog
PK
DatabaseLogID
int
NN
PostTime
datetime
NN
DatabaseUser
int
NN
Event
int
NN
Schema
int
Object
int
TSQL
nvarchar(max)
NN
XmlEvent
xml
NN
KEY
PK_DatabaseLog_DatabaseLogID
Product
PK
ProductID
int
NN
Name
Name
NN
ProductNumber
nvarchar(25)
NN
MakeFlag
Flag
NN
FinishedGoodsFlag
Flag
NN
Color
nvarchar(15)
SafetyStockLevel
smallint
NN
ReorderPoint
smallint
NN
StandardCost
money
NN
ListPrice
money
NN
Size
nvarchar(5)
FK
SizeUnitMeasureCode
nchar(3)
FK
WeightUnitMeasureCode
nchar(3)
Weight
decimal(8,2)
DaysToManufacture
int
NN
ProductLine
nchar(2)
Class
nchar(2)
Style
nchar(2)
FK
ProductSubcategoryID
int
FK
ProductModelID
int
SellStartDate
datetime
NN
SellEndDate
datetime
DiscontinuedDate
datetime
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Product_ProductID
IX
AK_Product_ProductNumber
IX
AK_Product_Name
IX
AK_Product_rowguid
AWBuildVersion
PK
SystemInformationID
tinyint
NN
Database Version
nvarchar(25)
NN
VersionDate
datetime
NN
ModifiedDate
datetime
NN
KEY
PK_AWBuildVersion_SystemInformationID
PersonCreditCard
PFK
BusinessEntityID
int
NN
PFK
CreditCardID
int
NN
ModifiedDate
datetime
NN
KEY
PK_PersonCreditCard_BusinessEntityID_CreditCardID
JobCandidate
PK
JobCandidateID
int
NN
FK
BusinessEntityID
int
Resume
xml
ModifiedDate
datetime
NN
KEY
PK_JobCandidate_JobCandidateID
IX
IX_JobCandidate_BusinessEntityID
ProductModelProductDescriptionCulture
PFK
ProductModelID
int
NN
PFK
ProductDescriptionID
int
NN
PFK
CultureID
nchar(6)
NN
ModifiedDate
datetime
NN
KEY
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductSubcategory
PK
ProductSubcategoryID
int
NN
FK
ProductCategoryID
int
NN
Name
Name
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ProductSubcategory_ProductSubcategoryID
IX
AK_ProductSubcategory_Name
IX
AK_ProductSubcategory_rowguid
ProductCategory
PK
ProductCategoryID
int
NN
Name
Name
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ProductCategory_ProductCategoryID
IX
AK_ProductCategory_Name
IX
AK_ProductCategory_rowguid
UnitMeasure
PK
UnitMeasureCode
nchar(3)
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_UnitMeasure_UnitMeasureCode
IX
AK_UnitMeasure_Name
SalesReason
PK
SalesReasonID
int
NN
Name
Name
NN
ReasonType
Name
NN
ModifiedDate
datetime
NN
KEY
PK_SalesReason_SalesReasonID
ProductReview
PK
ProductReviewID
int
NN
FK
ProductID
int
NN
ReviewerName
Name
NN
ReviewDate
datetime
NN
EmailAddress
nvarchar(50)
NN
Rating
int
NN
Comments
nvarchar(3850)
ModifiedDate
datetime
NN
KEY
PK_ProductReview_ProductReviewID
IX
IX_ProductReview_ProductID_Name
Currency
PK
CurrencyCode
nchar(3)
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_Currency_CurrencyCode
IX
AK_Currency_Name
ProductDocument
PFK
ProductID
int
NN
PFK
DocumentNode
hierarchyid
NN
ModifiedDate
datetime
NN
KEY
PK_ProductDocument_ProductID_DocumentNode
ProductVendor
PFK
ProductID
int
NN
PFK
BusinessEntityID
int
NN
AverageLeadTime
int
NN
StandardPrice
money
NN
LastReceiptCost
money
LastReceiptDate
datetime
MinOrderQty
int
NN
MaxOrderQty
int
NN
OnOrderQty
int
FK
UnitMeasureCode
nchar(3)
NN
ModifiedDate
datetime
NN
KEY
PK_ProductVendor_ProductID_BusinessEntityID
IX
IX_ProductVendor_UnitMeasureCode
IX
IX_ProductVendor_BusinessEntityID
Culture
PK
CultureID
nchar(6)
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_Culture_CultureID
IX
AK_Culture_Name
PersonPhone
PFK
BusinessEntityID
int
NN
PK
PhoneNumber
Phone
NN
PFK
PhoneNumberTypeID
int
NN
ModifiedDate
datetime
NN
KEY
PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID
IX
IX_PersonPhone_PhoneNumber
SpecialOfferProduct
PFK
SpecialOfferID
int
NN
PFK
ProductID
int
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SpecialOfferProduct_SpecialOfferID_ProductID
IX
AK_SpecialOfferProduct_rowguid
IX
IX_SpecialOfferProduct_ProductID
Document
PK
DocumentNode
hierarchyid
NN
DocumentLevel
smallint
Title
nvarchar(50)
NN
FK
Owner
int
NN
FolderFlag
bit
NN
FileName
nvarchar(400)
NN
FileExtension
nvarchar(8)
NN
Revision
nchar(5)
NN
ChangeNumber
int
NN
Status
tinyint
NN
DocumentSummary
nvarchar(max)
Document
varbinary(max)
AK
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Document_DocumentNode
KEY
UQ__Document__F73921F7C5112C2E
IX
AK_Document_DocumentLevel_DocumentNode
IX
AK_Document_rowguid
IX
IX_Document_FileName_Revision
SalesOrderDetail
PFK
SalesOrderID
int
NN
PK
SalesOrderDetailID
int
NN
CarrierTrackingNumber
nvarchar(25)
OrderQty
smallint
NN
FK
ProductID
int
NN
FK
SpecialOfferID
int
NN
UnitPrice
money
NN
UnitPriceDiscount
money
NN
LineTotal
numeric(38,6)
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
IX
AK_SalesOrderDetail_rowguid
IX
IX_SalesOrderDetail_ProductID
TR
iduSalesOrderDetail
SalesTerritoryHistory
PFK
BusinessEntityID
int
NN
PFK
TerritoryID
int
NN
PK
StartDate
datetime
NN
EndDate
datetime
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID
IX
AK_SalesTerritoryHistory_rowguid
Illustration
PK
IllustrationID
int
NN
Diagram
xml
ModifiedDate
datetime
NN
KEY
PK_Illustration_IllustrationID
ProductModel
PK
ProductModelID
int
NN
Name
Name
NN
CatalogDescription
xml
Instructions
xml
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ProductModel_ProductModelID
IX
AK_ProductModel_Name
IX
AK_ProductModel_rowguid
IX
PXML_ProductModel_CatalogDescription
IX
PXML_ProductModel_Instructions
BusinessEntity
PK
BusinessEntityID
int
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_BusinessEntity_BusinessEntityID
IX
AK_BusinessEntity_rowguid
Password
PFK
BusinessEntityID
int
NN
PasswordHash
varchar(128)
NN
PasswordSalt
varchar(10)
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Password_BusinessEntityID
EmployeePayHistory
PFK
BusinessEntityID
int
NN
PK
RateChangeDate
datetime
NN
Rate
money
NN
PayFrequency
tinyint
NN
ModifiedDate
datetime
NN
KEY
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate
ContactType
PK
ContactTypeID
int
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_ContactType_ContactTypeID
IX
AK_ContactType_Name
Department
PK
DepartmentID
smallint
NN
Name
Name
NN
GroupName
Name
NN
ModifiedDate
datetime
NN
KEY
PK_Department_DepartmentID
IX
AK_Department_Name
WorkOrder
PK
WorkOrderID
int
NN
FK
ProductID
int
NN
OrderQty
int
NN
StockedQty
int
NN
ScrappedQty
smallint
NN
StartDate
datetime
NN
EndDate
datetime
DueDate
datetime
NN
FK
ScrapReasonID
smallint
ModifiedDate
datetime
NN
KEY
PK_WorkOrder_WorkOrderID
IX
IX_WorkOrder_ScrapReasonID
IX
IX_WorkOrder_ProductID
TR
iWorkOrder
TR
uWorkOrder
CountryRegionCurrency
PFK
CountryRegionCode
nvarchar(3)
NN
PFK
CurrencyCode
nchar(3)
NN
ModifiedDate
datetime
NN
KEY
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
IX
IX_CountryRegionCurrency_CurrencyCode
ShoppingCartItem
PK
ShoppingCartItemID
int
NN
ShoppingCartID
nvarchar(50)
NN
Quantity
int
NN
FK
ProductID
int
NN
DateCreated
datetime
NN
ModifiedDate
datetime
NN
KEY
PK_ShoppingCartItem_ShoppingCartItemID
IX
IX_ShoppingCartItem_ShoppingCartID_ProductID
SalesTaxRate
PK
SalesTaxRateID
int
NN
FK
StateProvinceID
int
NN
TaxType
tinyint
NN
TaxRate
smallmoney
NN
Name
Name
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesTaxRate_SalesTaxRateID
IX
AK_SalesTaxRate_StateProvinceID_TaxType
IX
AK_SalesTaxRate_rowguid
ShipMethod
PK
ShipMethodID
int
NN
Name
Name
NN
ShipBase
money
NN
ShipRate
money
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ShipMethod_ShipMethodID
IX
AK_ShipMethod_Name
IX
AK_ShipMethod_rowguid
ErrorLog
PK
ErrorLogID
int
NN
ErrorTime
datetime
NN
UserName
int
NN
ErrorNumber
int
NN
ErrorSeverity
int
ErrorState
int
ErrorProcedure
nvarchar(126)
ErrorLine
int
ErrorMessage
nvarchar(4000)
NN
KEY
PK_ErrorLog_ErrorLogID
PurchaseOrderDetail
PFK
PurchaseOrderID
int
NN
PK
PurchaseOrderDetailID
int
NN
DueDate
datetime
NN
OrderQty
smallint
NN
FK
ProductID
int
NN
UnitPrice
money
NN
LineTotal
money
NN
ReceivedQty
decimal(8,2)
NN
RejectedQty
decimal(8,2)
NN
StockedQty
decimal(9,2)
NN
ModifiedDate
datetime
NN
KEY
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
IX
IX_PurchaseOrderDetail_ProductID
TR
iPurchaseOrderDetail
TR
uPurchaseOrderDetail
CountryRegion
PK
CountryRegionCode
nvarchar(3)
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_CountryRegion_CountryRegionCode
IX
AK_CountryRegion_Name
Vendor
PFK
BusinessEntityID
int
NN
AccountNumber
AccountNumber
NN
Name
Name
NN
CreditRating
tinyint
NN
PreferredVendorStatus
Flag
NN
ActiveFlag
Flag
NN
PurchasingWebServiceURL
nvarchar(1024)
ModifiedDate
datetime
NN
KEY
PK_Vendor_BusinessEntityID
IX
AK_Vendor_AccountNumber
TR
dVendor
StateProvince
PK
StateProvinceID
int
NN
StateProvinceCode
nchar(3)
NN
FK
CountryRegionCode
nvarchar(3)
NN
IsOnlyStateProvinceFlag
Flag
NN
Name
Name
NN
FK
TerritoryID
int
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_StateProvince_StateProvinceID
IX
AK_StateProvince_Name
IX
AK_StateProvince_StateProvinceCode_CountryRegionCode
IX
AK_StateProvince_rowguid
CreditCard
PK
CreditCardID
int
NN
CardType
nvarchar(50)
NN
CardNumber
nvarchar(25)
NN
ExpMonth
tinyint
NN
ExpYear
smallint
NN
ModifiedDate
datetime
NN
KEY
PK_CreditCard_CreditCardID
IX
AK_CreditCard_CardNumber
ProductInventory
PFK
ProductID
int
NN
PFK
LocationID
smallint
NN
Shelf
nvarchar(10)
NN
Bin
tinyint
NN
Quantity
smallint
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ProductInventory_ProductID_LocationID
ProductDescription
PK
ProductDescriptionID
int
NN
Description
nvarchar(400)
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_ProductDescription_ProductDescriptionID
IX
AK_ProductDescription_rowguid
EmailAddress
PFK
BusinessEntityID
int
NN
PK
EmailAddressID
int
NN
EmailAddress
nvarchar(50)
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_EmailAddress_BusinessEntityID_EmailAddressID
IX
IX_EmailAddress_EmailAddress
CurrencyRate
PK
CurrencyRateID
int
NN
CurrencyRateDate
datetime
NN
FK
FromCurrencyCode
nchar(3)
NN
FK
ToCurrencyCode
nchar(3)
NN
AverageRate
money
NN
EndOfDayRate
money
NN
ModifiedDate
datetime
NN
KEY
PK_CurrencyRate_CurrencyRateID
IX
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
EmployeeDepartmentHistory
PFK
BusinessEntityID
int
NN
PFK
DepartmentID
smallint
NN
PFK
ShiftID
tinyint
NN
PK
StartDate
date
NN
EndDate
date
ModifiedDate
datetime
NN
KEY
PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID
IX
IX_EmployeeDepartmentHistory_DepartmentID
IX
IX_EmployeeDepartmentHistory_ShiftID
SalesPerson
PFK
BusinessEntityID
int
NN
FK
TerritoryID
int
SalesQuota
money
Bonus
money
NN
CommissionPct
smallmoney
NN
SalesYTD
money
NN
SalesLastYear
money
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesPerson_BusinessEntityID
IX
AK_SalesPerson_rowguid
SpecialOffer
PK
SpecialOfferID
int
NN
Description
nvarchar(255)
NN
DiscountPct
smallmoney
NN
Type
nvarchar(50)
NN
Category
nvarchar(50)
NN
StartDate
datetime
NN
EndDate
datetime
NN
MinQty
int
NN
MaxQty
int
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SpecialOffer_SpecialOfferID
IX
AK_SpecialOffer_rowguid
PhoneNumberType
PK
PhoneNumberTypeID
int
NN
Name
Name
NN
ModifiedDate
datetime
NN
KEY
PK_PhoneNumberType_PhoneNumberTypeID
SalesPersonQuotaHistory
PFK
BusinessEntityID
int
NN
PK
QuotaDate
datetime
NN
SalesQuota
money
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate
IX
AK_SalesPersonQuotaHistory_rowguid
BillOfMaterials
PK
BillOfMaterialsID
int
NN
FK
ProductAssemblyID
int
FK
ComponentID
int
NN
StartDate
datetime
NN
EndDate
datetime
FK
UnitMeasureCode
nchar(3)
NN
BOMLevel
smallint
NN
PerAssemblyQty
decimal(8,2)
NN
ModifiedDate
datetime
NN
KEY
PK_BillOfMaterials_BillOfMaterialsID
IX
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
IX
IX_BillOfMaterials_UnitMeasureCode
Address
PK
AddressID
int
NN
AddressLine1
nvarchar(60)
NN
AddressLine2
nvarchar(60)
City
nvarchar(30)
NN
FK
StateProvinceID
int
NN
PostalCode
nvarchar(15)
NN
SpatialLocation
geography
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Address_AddressID
IX
AK_Address_rowguid
IX
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
IX
IX_Address_StateProvinceID
SalesOrderHeader
PK
SalesOrderID
int
NN
RevisionNumber
tinyint
NN
OrderDate
datetime
NN
DueDate
datetime
NN
ShipDate
datetime
Status
tinyint
NN
OnlineOrderFlag
Flag
NN
SalesOrderNumber
nvarchar(25)
NN
PurchaseOrderNumber
OrderNumber
AccountNumber
AccountNumber
FK
CustomerID
int
NN
FK
SalesPersonID
int
FK
TerritoryID
int
FK
BillToAddressID
int
NN
FK
ShipToAddressID
int
NN
FK
ShipMethodID
int
NN
FK
CreditCardID
int
CreditCardApprovalCode
varchar(15)
FK
CurrencyRateID
int
SubTotal
money
NN
TaxAmt
money
NN
Freight
money
NN
TotalDue
money
NN
Comment
nvarchar(128)
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_SalesOrderHeader_SalesOrderID
IX
AK_SalesOrderHeader_rowguid
IX
AK_SalesOrderHeader_SalesOrderNumber
IX
IX_SalesOrderHeader_CustomerID
IX
IX_SalesOrderHeader_SalesPersonID
TR
uSalesOrderHeader
Person
PFK
BusinessEntityID
int
NN
PersonType
nchar(2)
NN
NameStyle
NameStyle
NN
Title
nvarchar(8)
FirstName
Name
NN
MiddleName
Name
LastName
Name
NN
Suffix
nvarchar(10)
EmailPromotion
int
NN
AdditionalContactInfo
xml
Demographics
xml
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Person_BusinessEntityID
IX
IX_Person_LastName_FirstName_MiddleName
IX
AK_Person_rowguid
IX
PXML_Person_AddContact
IX
PXML_Person_Demographics
IX
XMLPATH_Person_Demographics
IX
XMLPROPERTY_Person_Demographics
IX
XMLVALUE_Person_Demographics
TR
iuPerson
ProductPhoto
PK
ProductPhotoID
int
NN
ThumbNailPhoto
varbinary(max)
ThumbnailPhotoFileName
nvarchar(50)
LargePhoto
varbinary(max)
LargePhotoFileName
nvarchar(50)
ModifiedDate
datetime
NN
KEY
PK_ProductPhoto_ProductPhotoID
ProductModelIllustration
PFK
ProductModelID
int
NN
PFK
IllustrationID
int
NN
ModifiedDate
datetime
NN
KEY
PK_ProductModelIllustration_ProductModelID_IllustrationID
Customer
PK
CustomerID
int
NN
FK
PersonID
int
FK
StoreID
int
FK
TerritoryID
int
AccountNumber
varchar(10)
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Customer_CustomerID
IX
AK_Customer_rowguid
IX
AK_Customer_AccountNumber
IX
IX_Customer_TerritoryID
Employee
PFK
BusinessEntityID
int
NN
NationalIDNumber
nvarchar(15)
NN
LoginID
nvarchar(256)
NN
OrganizationNode
hierarchyid
OrganizationLevel
smallint
JobTitle
nvarchar(50)
NN
BirthDate
date
NN
MaritalStatus
nchar(1)
NN
Gender
nchar(1)
NN
HireDate
date
NN
SalariedFlag
Flag
NN
VacationHours
smallint
NN
SickLeaveHours
smallint
NN
CurrentFlag
Flag
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Employee_BusinessEntityID
IX
IX_Employee_OrganizationNode
IX
IX_Employee_OrganizationLevel_OrganizationNode
IX
AK_Employee_LoginID
IX
AK_Employee_NationalIDNumber
IX
AK_Employee_rowguid
TR
dEmployee
ProductProductPhoto
PFK
ProductID
int
NN
PFK
ProductPhotoID
int
NN
Primary
Flag
NN
ModifiedDate
datetime
NN
KEY
PK_ProductProductPhoto_ProductID_ProductPhotoID
Store
PFK
BusinessEntityID
int
NN
Name
Name
NN
FK
SalesPersonID
int
Demographics
xml
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_Store_BusinessEntityID
IX
AK_Store_rowguid
IX
IX_Store_SalesPersonID
IX
PXML_Store_Demographics
Shift
PK
ShiftID
tinyint
NN
Name
Name
NN
StartTime
time(7)
NN
EndTime
time(7)
NN
ModifiedDate
datetime
NN
KEY
PK_Shift_ShiftID
IX
AK_Shift_Name
IX
AK_Shift_StartTime_EndTime
BusinessEntityAddress
PFK
BusinessEntityID
int
NN
PFK
AddressID
int
NN
PFK
AddressTypeID
int
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID
IX
AK_BusinessEntityAddress_rowguid
IX
IX_BusinessEntityAddress_AddressID
IX
IX_BusinessEntityAddress_AddressTypeID
TransactionHistory
PK
TransactionID
int
NN
FK
ProductID
int
NN
ReferenceOrderID
int
NN
ReferenceOrderLineID
int
NN
TransactionDate
datetime
NN
TransactionType
nchar(1)
NN
Quantity
int
NN
ActualCost
money
NN
ModifiedDate
datetime
NN
KEY
PK_TransactionHistory_TransactionID
IX
IX_TransactionHistory_ProductID
IX
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
Location
PK
LocationID
smallint
NN
Name
Name
NN
CostRate
smallmoney
NN
Availability
decimal(8,2)
NN
ModifiedDate
datetime
NN
KEY
PK_Location_LocationID
IX
AK_Location_Name
ProductCostHistory
PFK
ProductID
int
NN
PK
StartDate
datetime
NN
EndDate
datetime
StandardCost
money
NN
ModifiedDate
datetime
NN
KEY
PK_ProductCostHistory_ProductID_StartDate
PurchaseOrderHeader
PK
PurchaseOrderID
int
NN
RevisionNumber
tinyint
NN
Status
tinyint
NN
FK
EmployeeID
int
NN
FK
VendorID
int
NN
FK
ShipMethodID
int
NN
OrderDate
datetime
NN
ShipDate
datetime
SubTotal
money
NN
TaxAmt
money
NN
Freight
money
NN
TotalDue
money
NN
ModifiedDate
datetime
NN
KEY
PK_PurchaseOrderHeader_PurchaseOrderID
IX
IX_PurchaseOrderHeader_VendorID
IX
IX_PurchaseOrderHeader_EmployeeID
TR
uPurchaseOrderHeader
WorkOrderRouting
PFK
WorkOrderID
int
NN
PK
ProductID
int
NN
PK
OperationSequence
smallint
NN
FK
LocationID
smallint
NN
ScheduledStartDate
datetime
NN
ScheduledEndDate
datetime
NN
ActualStartDate
datetime
ActualEndDate
datetime
ActualResourceHrs
decimal(9,4)
PlannedCost
money
NN
ActualCost
money
ModifiedDate
datetime
NN
KEY
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
IX
IX_WorkOrderRouting_ProductID
AddressType
PK
AddressTypeID
int
NN
Name
Name
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_AddressType_AddressTypeID
IX
AK_AddressType_rowguid
IX
AK_AddressType_Name
SalesOrderHeaderSalesReason
PFK
SalesOrderID
int
NN
PFK
SalesReasonID
int
NN
ModifiedDate
datetime
NN
KEY
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
ProductListPriceHistory
PFK
ProductID
int
NN
PK
StartDate
datetime
NN
EndDate
datetime
ListPrice
money
NN
ModifiedDate
datetime
NN
KEY
PK_ProductListPriceHistory_ProductID_StartDate
BusinessEntityContact
PFK
BusinessEntityID
int
NN
PFK
PersonID
int
NN
PFK
ContactTypeID
int
NN
rowguid
uniqueidentifier
NN
ModifiedDate
datetime
NN
KEY
PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID
IX
AK_BusinessEntityContact_rowguid
IX
IX_BusinessEntityContact_PersonID
IX
IX_BusinessEntityContact_ContactTypeID
TransactionHistoryArchive
PK
TransactionID
int
NN
ProductID
int
NN
ReferenceOrderID
int
NN
ReferenceOrderLineID
int
NN
TransactionDate
datetime
NN
TransactionType
nchar(1)
NN
Quantity
int
NN
ActualCost
money
NN
ModifiedDate
datetime
NN
KEY
PK_TransactionHistoryArchive_TransactionID
IX
IX_TransactionHistoryArchive_ProductID
IX
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
MS SQL Server - Sample
Adventure Works - ER Diagram with subject areas
Human Resources
Luna Modeler
WWW.DATENSEN.COM
Dbo
Production
Person
Sales
Purchasing
View
vEmployeeDepartment
Function
ufnGetDocumentStatusText
Function
ufnGetProductDealerPrice
View
vStoreWithContacts
Procedure
uspUpdateEmployeeHireInfo
User defined type
Name
Trigger
uPurchaseOrderDetail
Function
ufnGetAccountingStartDate
Trigger
dVendor
View
vJobCandidate
Function
ufnGetProductListPrice
Procedure
uspGetEmployeeManagers
View
vSalesPersonSalesByFiscalYears
Function
ufnLeadingZeros
Function
ufnGetContactInformation
Trigger
uPurchaseOrderHeader
Procedure
uspLogError
User defined type
OrderNumber
View
vEmployeeDepartmentHistory
View
vVendorWithAddresses
Procedure
uspPrintError
Trigger
iPurchaseOrderDetail
Trigger
uWorkOrder
User defined type
Phone
Procedure
uspUpdateEmployeeLogin
User defined type
NameStyle
Trigger
dEmployee
Procedure
uspGetBillOfMaterials
Procedure
uspSearchCandidateResumes
Function
ufnGetStock
Function
ufnGetSalesOrderStatusText
Trigger
uSalesOrderHeader
Procedure
uspGetManagerEmployees
View
vProductAndDescription
View
vPersonDemographics
View
vIndividualCustomer
Trigger
iWorkOrder
View
vStoreWithDemographics
Function
ufnGetPurchaseOrderStatusText
View
vStoreWithAddresses
User defined type
AccountNumber
View
vVendorWithContacts
Trigger
iuPerson
View
vJobCandidateEducation
Function
ufnGetAccountingEndDate
View
vProductModelInstructions
Function
ufnGetProductStandardCost
Procedure
uspUpdateEmployeePersonalInfo
View
vStateProvinceCountryRegion
View
vJobCandidateEmployment
Trigger
iduSalesOrderDetail
Procedure
uspGetWhereUsedProductID
User defined type
Flag
View
vProductModelCatalogDescription
View
vAdditionalContactInfo
View
vSalesPerson
View
vEmployee