Tracking text is used to annotate the Relationship shape.
10 = Tracking Text
DB Engineer /CMD=1003 PinX PinY User.OldPinX User.OldPinY
PinX guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
PinY guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
0 = IDEF1X; 2 = Relational
Overrides the relationship notation specifed by the IDEF1X or Relational notations.
Set to hide all relationships on the page
Set to hide relationship text.
Set to hide PK, FK, and Index annotations.
Set to hide the PK section of Entities.
Set to hide the Datatype section for Entities.
Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
Set to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Use the Relationship connector to define a foreign key between two tables.
IDEF1X Notation
Crow's Foot Notation
Relational Notation
Relationship (Foreign Key)
Unique identifier used by the add-on.
Set to indicate the relationship is an 'Identifying Relationship'.
25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
Set to indicate the relationship is optional.
Set to override Database | Document | Options locally for this relationship shape.
Set to allow free-form editing (manual edits are not maintained in the model.)
User.DBNotation This formula conditionally sets the DBNotation setting.
Calculates a reference point for Relationship text.
User.CrowsFoot This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
reference to associated text shape
Locate referencial integrity text here.
Locate cardinality text here.
Database Model master stores embedded model information.
&DocTitleLong
Arial
&PageDesc
&Date &Time
&PageNo
AccountNumber
Flag
NameStyle
UGRPInfo
MAPInfo
TSTAMPInfo
SourceDocs
is of
SalesOrderHeader
CreditCardID
Name
OrderNumber
Phone
ModifiedDate
datetime
rowguid
uniqueidentifier
Comment
nvarchar
TotalDue
money
Freight
TaxAmt
SubTotal
CurrencyRateID
CreditCardApprovalCode
varchar
ShipMethodID
ShipToAddressID
BillToAddressID
TerritoryID
SalesPersonID
ContactID
CustomerID
PurchaseOrderNumber
SalesOrderNumber
OnlineOrderFlag
Status
tinyint
ShipDate
DueDate
OrderDate
RevisionNumber
is identified by
SalesOrderID
identifies
Customer
CustomerType
nchar
Vendor
PurchasingWebServiceURL
ActiveFlag
PreferredVendorStatus
CreditRating
VendorName
VendorID
ActualCost
WorkOrderRouting
PlannedCost
ActualResourceHrs
decimal
ActualEndDate
ActualStartDate
ScheduledEndDate
ScheduledStartDate
LocationID
smallint
is partly identified by
OperationSequence
partly identifies
WorkOrderID
ProductID
TransactionHistoryArchive
ReferenceOrderLineID
Quantity
TransactionType
TransactionDate
ReferenceOrderID
TransactionID
TransactionHistory
AdditionalContactInfo
Contact
PasswordSalt
PasswordHash
EmailPromotion
EmailAddress
Suffix
LastName
MiddleName
FirstName
Title
Address
PostalCode
StateProvinceID
City
AddressLine2
AddressLine1
AddressID
EmployeeAddress
EmployeeID
CustomerAddress
AddressTypeID
VendorAddress
AddressType
AddressTypeName
Availability
Location
CostRate
smallmoney
LocationName
AverageLeadTime
ProductVendor
Modified
Date
UnitMeasureCode
OnOrderQty
MaxOrderQty
MinOrderQty
LastReceiptDate
LastReceiptCost
StandardPrice
AverageRate
CurrencyRate
EndOfDayRate
ToCurrencyCode
FromCurrencyCode
CurrencyRateDate
AWBuildVersion
VersionDate
Database Version
SystemInformationID
BillOfMaterials
PerAssemblyQty
BOMLevel
EndDate
StartDate
ComponentID
ProductAssemblyID
BillOfMaterialsID
tifies
ProductInventory
Shelf
BirthDate
Employee
ShiftID
CurrentFlag
SickLeaveHours
VacationHours
SalariedFlag
HireDate
Gender
MaritalStatus
ManagerID
LoginID
NationalIDNumber
Bonus
SalesPerson
SalesLastYear
SalesYTD
CommissionPct
SalesQuota
CardNumber
CreditCard
ExpYear
ExpMonth
CardType
CarrierTrackingNumber
SalesOrderDetail
SalesOrderDetailID
LineTotal
numeric
UnitPriceDiscount
UnitPrice
SpecialOfferID
OrderQty
CatalogDescription
ProductModel
Instructions
ProductModelName
ProductModelID
Category
SpecialOffer
MaxQty
MinQty
Type
DiscountPct
Description
ChangeNumber
Document
DocumentID1
image
DocumentSummary
ntext
Revision
FileExtension
FileName
DocumentID
Class
Product
DiscontinuedDate
SellEndDate
SellStartDate
ProductSubcategoryID
Style
ProductLine
DaysToManufacture
Weight
WeightUnitMeasureCode
SizeUnitMeasureCode
Size
ListPrice
StandardCost
ReorderPoint
SafetyStockLevel
Color
FinishedGoodsFlag
MakeFlag
ProductNumber
ProductName
Comments
ProductReview
Rating
ReviewDate
ReviewerName
ProductReviewID
ContactCreditCard
StoreContact
ContactTypeID
Individual
Demographics
VendorContact
ContactType
ContactTypeName
CostLastYear
SalesTerritory
CostYTD
Group
CountryRegionCode
SalesTerritoryName
CountryRegion
CountryRegionName
CountryRegionCurrency
CurrencyCode
StateProvince
StateProvinceName
IsOnlyStateProvinceFlag
StateProvinceCode
Culture
CultureName
CultureID
ProductModelProductDescriptionCulture
ProductDescriptionID
Currency
CurrencyName
Store
StoreName
DatabaseLog
DatabaseLogID
XmlEvent
TSQL
Object
sysname
Schema
Event
DatabaseUser
PostTime
DateCreated
ShoppingCartItem
ShoppingCartID
ShoppingCartItemID
Department
GroupName
DepartmentName
DepartmentID
EmployeeDepartmentHistory
ProductDescription
Diagram
Illustration
IllustrationID
ProductDocument
PurchaseOrderDetail
is partly
dentified by
PurchaseOrderID
PurchaseOrderDetailID
StockedQty
RejectedQty
ReceivedQty
WorkOrder
ScrapReasonID
ScrappedQty
PurchaseOrderHeader
PurchaseOrderHeaderCol1
JobCandidate
Resume
JobCandidateID
EmployeePayHistory
PayFrequency
Rate
RateChangeDate
SalesTerritoryHistory
ProductListPriceHistory
ProductCostHistory
EndTime
Shift
StartTime
ShiftName
ErrorLine
ErrorLog
ErrorMessage
ErrorProcedure
ErrorState
ErrorSeverity
ErrorNumber
UserName
ErrorTime
ErrorLogID
ProductModelIllustration
LargePhoto
ProductPhoto
LargePhotoFileName
ThumbnailPhotoFileName
ThumbNailPhoto
ProductPhotoID
SpecialOfferProduct
SalesTaxRate
SalesTaxRateName
TaxRate
TaxType
SalesTaxRateID
SalesReason
ReasonType
SalesReasonName
SalesReasonID
SalesPersonQuotaHistory
QuotaDate
SalesOrderHeaderSalesReason
ShipMethod
ShipRate
ShipBase
ShipMethodName
UnitMeasure
UnitMeasureName
ScrapReason
ScrapReasonName
ProductSubcategory
ProductSubcategoryName
ProductCategoryID
ProductProductPhoto
Primary
ProductCategory
ProductCategoryName
<Rgz
MObdw
Microsoft SQL Server (4.2+)
AdventureWorks
RUNAMUKX
PK_DatabaseLog_DatabaseLogID
Sales
)getdate()
Lookup table containing the ISO standard codes for countries and regions.
Person
)getdat
PK_ErrorLog_ErrorLogID
State and province lookup table.
)newid()
Sales territory lookup table.
Current customer information. Also see the Individual and Store tables.
Cross-reference table mapping customers to their address(es).
Street address information for customers, employees, and vendors.
FK_Address_StateProvince_StateProvinceID
hasFK_Address_StateProvince_StateProvinceID
Cross-reference mapping vendors and addresses.
Purchasing
Types of addresses stored in the Address table.
FK_CustomerAddress_AddressType_AddressTypeID
hasFK_CustomerAddress_AddressType_AddressTypeID
PK_AddressType_AddressTypeID
AK_AddressType_Name
AddressType_UC1
AK_AddressType_rowguid
AddressType_UC2
FK_VendorAddress_AddressType_AddressTypeID
hasFK_VendorAddress_AddressType_AddressTypeID
Companies from whom Adventure Works Cycles purchases parts or other goods.
itRating
Cross-reference table mapping vendors with the products they supply.
Products sold or used in the manfacturing of sold products.
Production
Product model classification.
Cross-reference table mapping product models and illustrations.
Bicycle assembly diagrams.
PK_Illustration_IllustrationID
FK_ProductModelIllustration_Illustration_IllustrationID
hasFK_ProductModelIllustration_Illustration_IllustrationID
PK_ProductModelIllustration_ProductModelID_IllustrationID
FK_ProductModelIllustration_ProductModel_ProductModelID
hasFK_ProductModelIllustration_ProductModel_ProductModelID
Cross-reference table mapping product descriptions and the language the description is written in.
Lookup table containing the languages in which some AdventureWorks data is stored.
PK_Culture_CultureID
AK_Culture_Name
Culture_UC1
FK_ProductModelProductDescriptionCulture_Culture_CultureID
hasFK_ProductModelProductDescriptionCulture_Culture_CultureID
Product descriptions in several languages.
PK_ProductDescription_ProductDescriptionID
AK_ProductDescription_rowguid
ProductDescription_UC1
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
hasFK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID
hasFK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID
PK_ProductModel_ProductModelID
AK_ProductModel_Name
ProductModel_UC1
AK_ProductModel_rowguid
ProductModel_UC2
FK_Product_ProductMo
del_ProductModelID
hasFK_Product_ProductModel_ProductModelID
Product subcategories. See ProductCategory table.
High-level product categorization.
PK_ProductCategory_ProductCategoryID
AK_ProductCategory_Name
ProductCategory_UC1
AK_ProductCategory_rowguid
ProductCategory_UC2
FK_ProductSubcategory_ProductCategory_ProductCategoryID
hasFK_ProductSubcategory_ProductCategory_ProductCategoryID
PK_ProductSubcategory_ProductSubcategoryID
AK_ProductSubcategory_Name
ProductSubcategory_UC1
AK_ProductSubcategory_rowguid
ProductSubcategory_UC2
FK_Product_ProductSubcategory_ProductSubcategoryID
hasFK_Product_ProductSubcategory_ProductSubcategoryID
Unit of measure lookup table.
Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
FK_BillOfMaterials_Product_ProductAssemblyID
hasFK_BillOfMaterials_Product_ProductAssemblyID
FK_BillOfMaterials_Product_ComponentID
hasFK_BillOfMaterials_Product_ComponentID
PK_BillOfMaterials_BillOfMaterialsID
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
BillOfMaterials_UC1
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode
hasFK_BillOfMaterials_UnitMeasure_UnitMeasureCode
FK_Product_UnitMeasure_WeightUnitMeasureCode
hasFK_Product_UnitMeasure_WeightUnitMeasureCode
FK_ProductVendor_UnitMeasure_UnitMeasureCode
hasFK_ProductVendor_UnitMeasure_UnitMeasureCode
PK_UnitMeasure_UnitMeasureCode
AK_UnitMeasure_Name
UnitMeasure_UC1
FK_Product_UnitMeasure_SizeUnitMeasureCode
hasFK_Product_UnitMeasure_SizeUnitMeasureCode
Changes in the cost of a produc
t over time.
PK_ProductCostHistory_ProductID_StartDate
FK_ProductCostHistory_Product_ProductID
hasFK_ProductCostHistory_Product_ProductID
Cross-reference table mapping products to related product documents.
Product maintenance documents.
PK_Document_DocumentID
AK_Document_FileName_Revision
Document_UC1
FK_ProductDocument_Document_DocumentID
hasFK_ProductDocument_Document_DocumentID
PK_ProductDocument_ProductID_DocumentID
FK_ProductDocument_Product_ProductID
hasFK_ProductDocument_Product_ProductID
Product inventory information.
Product inventory and manufacturing locations.
Work order details.
Manufacturing work orders.
FK_WorkOrder_Product_ProductID
hasFK_WorkOrder_Product_ProductID
Manufacturing failure reasons lookup table.
PK_ScrapReason_ScrapReasonID
AK_ScrapReason_Name
ScrapReason_UC1
FK_WorkOrder_ScrapReason_ScrapReasonID
hasFK_WorkOrder_ScrapReason_ScrapReasonID
PK_WorkOrder_WorkOrderID
FK_WorkOrderRouting_WorkOrder_WorkOrderID
hasFK_WorkOrderRouting_WorkOrder_WorkOrderID
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
FK_WorkOrderRouting_Location_LocationID
hasFK_WorkOrderRouting_Location_LocationID
PK_Location_LocationID
AK_Location_Name
Location_UC1
FK_ProductInventory_Location_LocationID
hasFK_ProductInventory_Location_LocationID
PK_ProductInventory_ProductID_LocationID
FK_ProductInventory_Product_ProductID
hasFK_ProductInventory_Product_ProductID
Changes in the list price of a product over time.
PK_ProductListPriceHistory_ProductID_StartDate
FK_ProductListPriceHistory_Product_Pro
uctID
hasFK_ProductListPriceHistory_Product_ProductID
Cross-reference table mapping products and product photos.
Product images.
PK_ProductPhoto_ProductPhotoID
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID
hasFK_ProductProductPhoto_ProductPhoto_ProductPhotoID
PK_ProductProductPhoto_ProductID_ProductPhotoID
FK_ProductProductPhoto_Product_ProductID
hasFK_ProductProductPhoto_Product_ProductID
Customer reviews of products they have purchased.
PK_ProductReview_ProductReviewID
FK_ProductReview_Product_ProductID
hasFK_ProductReview_Product_ProductID
Record of each purchase order, sales order, or work order transaction year to date.
PK_TransactionHistory_TransactionID
FK_TransactionHistory_Product_ProductID
hasFK_TransactionHistory_Product_ProductID
Individual products associated with a specific purchase order. See PurchaseOrderHeader.
General purchase order information. See PurchaseOrderDetail.
Employee information such as salary, department, and title.
HumanResources
FK_Employee_Employee_ManagerID
hasFK_Employee_Employee_ManagerID
Names of each employee, customer contact, and vendor contact.
Cross-reference table mapping vendors and their employees.
Lookup table containing the types of contacts stored in Contact.
Cross-reference table mapping stores and their employees.
FK_StoreContact_Contact_ContactID
hasFK_StoreContact_Contact_ContactID
Customers (resellers) of Adventure Works products.
FK_Store_Customer_CustomerID
hasFK_Store_Customer_CustomerID
Sales representative current information.
FK_SalesPerson_Employee_SalesPersonID
hasFK_SalesPerson_Employee_SalesPersonID
FK_SalesPerson_SalesTerritory_TerritoryID
hasFK_SalesPerson_SalesTerritory_TerritoryID
General sales order information.
FK_SalesOrderHeader_Address_BillToAddressID
hasFK_SalesOrderHeader_Address_BillToAddressID
FK_SalesOrderHeader_Address_ShipToAddressID
hasFK_SalesOrderHeader_Address_ShipToAddressID
FK_SalesOrderHeader_Contact_ContactID
hasFK_SalesOrderHeader_Contact_ContactID
Shipping company lookup table.
FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
hasFK_PurchaseOrderHeader_ShipMethod_ShipMethodID
PK_ShipMethod_ShipMethodID
AK_ShipMethod_Name
ShipMethod_UC1
AK_ShipMethod_rowguid
ShipMethod_UC2
FK_SalesOrderHeader_ShipMethod_ShipMethodID
hasFK_SalesOrderHeader_ShipMethod_ShipMethodID
Currency exchange rates.
Lookup table containing standard ISO currencies.
FK_CurrencyRate_Currency_ToCurrencyCode
hasFK_CurrencyRate_Currency_ToCurrencyCode
FK_CountryRegionCurrency_Currency_CurrencyCode
hasFK_CountryRegionCurrency_Currency_CurrencyCode
PK_Currency_CurrencyCode
AK_Currency_Name
Currency_UC1
FK_CurrencyRate_Currency_FromCurrencyCode
hasFK_CurrencyRate_Currency_FromCurrencyCode
PK_CurrencyRate_
urrencyRateID
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
CurrencyRate_UC1
FK_SalesOrderHeader_CurrencyRate_CurrencyRateID
hasFK_SalesOrderHeader_CurrencyRate_CurrencyRateID
FK_SalesOrderHeader_Customer_CustomerID
hasFK_SalesOrderHeader_Customer_CustomerID
FK_SalesOrderHeader_SalesTerritory_TerritoryID
hasFK_SalesOrderHeader_SalesTerritory_TerritoryID
Customer credit card information.
Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
FK_ContactCreditCard_Contact_ContactID
hasFK_ContactCreditCard_Contact_ContactID
PK_ContactCreditCard_ContactID_CreditCardID
FK_ContactCreditCard_CreditCard_CreditCardID
hasFK_ContactCreditCard_CreditCard_CreditCardID
PK_CreditCard_CreditCardID
AK_CreditCard_CardNumber
CreditCard_UC1
FK_SalesOrderHeader_CreditCard_CreditCardID
hasFK_SalesOrderHeader_CreditCard_CreditCardID
Individual products associated with a specific sales order. See SalesOrderHeader.
Cross-reference table mapping products to special offer discounts.
FK_SpecialOfferProduct_Product_ProductID
hasFK_SpecialOfferProduct_Product_ProductID
Sale discounts lookup table.
PK_SpecialOffer_SpecialOfferID
AK_SpecialOffer_rowguid
SpecialOffer_UC1
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
hasFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
PK_SpecialOfferProduct_SpecialOfferID_ProductID
AK_SpecialOfferProduct_rowguid
SpecialOfferProduct_UC1
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
hasFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
AK_SalesOrderDetail_rowguid
SalesOrderDetail_UC1
FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
hasFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
Cross-reference table mapping sales orders to sales reason codes.
Lookup table of customer purchase reas
ons.
PK_SalesReason_SalesReasonID
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID
hasFK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
hasFK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
PK_SalesOrderHeader_SalesOrderID
AK_SalesOrderHeader_rowguid
SalesOrderHeader_UC1
AK_SalesOrderHeader_SalesOrderNumber
SalesOrderHeader_UC2
FK_SalesOrderHeader_SalesPerson_SalesPersonID
hasFK_SalesOrderHeader_SalesPerson_SalesPersonID
Sales performance tracking.
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
AK_SalesPersonQuotaHistory_rowguid
SalesPersonQuotaHistory_UC1
FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID
hasFK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID
Sales representative transfers to other sales territories.
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID
hasFK_SalesTerritoryHistory_SalesTerritory_TerritoryID
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
AK_SalesTerritoryHistory_rowguid
SalesTerritoryHistory_UC1
FK_SalesTerritoryHistory_SalesPerson_SalesPersonID
hasFK_SalesTerritoryHistory_SalesPerson_SalesPersonID
PK_SalesPerson_SalesPersonID
AK_SalesPerson_rowguid
SalesPerson_UC1
FK_Store_SalesPerson_SalesPersonID
hasFK_Store_SalesPerson_SalesPersonID
PK_Store_CustomerID
AK_Store_rowguid
Store_UC1
FK_StoreContact_Store_CustomerID
hasFK_StoreContact_Store_CustomerID
PK_StoreContact_CustomerID_ContactID
AK_StoreContact_rowguid
StoreContact_UC1
FK_StoreContact_ContactType_ContactTypeID
hasFK_StoreContact_ContactType_ContactTypeID
PK_ContactType_ContactTypeID
AK_ContactType_Name
ContactType_UC1
FK_VendorContact_ContactType_ContactTypeID
hasFK_VendorContact_ContactType_ContactTypeID
FK_VendorContact_Vendor_VendorID
hasFK_VendorContact_Vendor_VendorID
PK_VendorContact_VendorID_ContactID
FK_VendorContact_Contact_ContactID
hasFK_VendorContact_Contact_ContactID
Demographic data about customers that purchase Adventure Works products online.
FK_Individual_Customer_CustomerID
hasFK_Individual_Customer_CustomerID
PK_Individual_CustomerID
FK_Individual_Contact_ContactID
asFK_Individual_Contact_ContactID
PK_Contact_ContactID
AK_Contact_rowguid
Contact_UC1
FK_Employee_Contact_ContactID
hasFK_Employee_Contact_ContactID
Employee department transfers.
Lookup table containing the departments within the Adventure Works Cycles company.
Dictionary
PK_Department_DepartmentID
AK_Department_Name
Department_UC1
FK_EmployeeDepartmentHistory_Department_DepartmentID
hasFK_EmployeeDepartmentHistory_Department_DepartmentID
Work shift lookup table.
PK_Shift_ShiftID
AK_Shift_Name
Shift_UC1
AK_Shift_StartTime_EndTime
Shift_UC2
FK_EmployeeDepartmentHistory_Shift_ShiftID
hasFK_EmployeeDepartmentHistory_Shift_ShiftID
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
FK_EmployeeDepartmentHistory_Employee_EmployeeID
hasFK_EmployeeDepartmentHistory_Employee_EmployeeID
Employee pay history.
PK_EmployeePayHistory_EmployeeID_RateChangeDate
FK_EmployeePayHistory_Employee_EmployeeID
hasFK_EmployeePayHistory_Employee_EmployeeID
s submitted to Human Resources by job applicants.
PK_JobCandidate_JobCandidateID
FK_JobCandidate_Employee_EmployeeID
hasFK_JobCandidate_Employee_EmployeeID
FK_EmployeeAddress_Address_AddressID
hasFK_EmployeeAddress_Address_AddressID
PK_EmployeeAddress_EmployeeID_AddressID
AK_EmployeeAddress_rowguid
EmployeeAddress_UC1
FK_EmployeeAddress_Employee_EmployeeID
hasFK_EmployeeAddress_Employee_EmployeeID
PK_Employee_EmployeeID
AK_Employee_LoginID
Employee_UC1
AK_Employee_NationalIDNumber
Employee_UC2
AK_Employee_rowguid
Employee_UC3
FK_PurchaseOrderHeader_Employee_EmployeeID
hasFK_PurchaseOrderHeader_Employee_EmployeeID
FK_PurchaseOrderHeader_Vendor_VendorID
hasFK_PurchaseOrderHeader_Vendor_VendorID
PK_PurchaseOrderHeader_PurchaseOrderID
FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID
hasFK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
FK_PurchaseOrderDetail_Product_ProductID
hasFK_PurchaseOrderDetail_Product_ProductID
Contains online customer orders until the order is submitted or cancelled.
PK_ShoppingCartItem_ShoppingCartItemID
FK_ShoppingCartItem_Product_ProductID
hasFK_ShoppingCartItem_
Product_ProductID
PK_Product_ProductID
AK_Product_Name
Product_UC1
AK_Product_ProductNumber
Product_UC2
AK_Product_rowguid
Product_UC3
FK_ProductVendor_Product_ProductID
hasFK_ProductVendor_Product_ProductID
PK_ProductVendor_ProductID_VendorID
FK_ProductVendor_Vendor_VendorID
hasFK_ProductVendor_Vendor_VendorID
PK_Vendor_VendorID
AK_Vendor_AccountNumber
Vendor_UC1
FK_VendorAddress_Vendor_VendorID
hasFK_VendorAddress_Vendor_VendorID
PK_VendorAddress_VendorID_AddressID
FK_VendorAddress_Address_AddressID
hasFK_VendorAddress_Address_AddressID
PK_Address_AddressID
AK_Address_rowguid
Address_UC1
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
Address_UC2
FK_CustomerAddress_Address_AddressID
hasFK_CustomerAddress_Address_AddressID
PK_CustomerAddress_CustomerID_AddressID
AK_CustomerAddress_rowguid
CustomerAddress_UC1
FK_CustomerAddress_Customer_CustomerID
hasFK_CustomerAddress_Customer_CustomerID
PK_Customer_CustomerID
AK_Customer_AccountNumber
Customer_UC1
AK_Customer_rowguid
Customer_UC2
FK_Customer_SalesTerritory_TerritoryID
hasFK_Customer_SalesTerritory_TerritoryID
PK_SalesTerritory_TerritoryID
AK_SalesTerritory_Name
SalesTerritory_UC1
AK_SalesTerritory_rowguid
SalesTerritory_UC2
FK_StateProvince_SalesTerritory_TerritoryID
hasFK_StateProvince_SalesTerritory_TerritoryID
Tax rate lookup table.
PK_SalesTaxRate_SalesTaxRateID
AK_SalesTaxRate_rowguid
SalesTaxRate_UC1
AK_SalesTaxRa
te_StateProvinceID_TaxType
SalesTaxRate_UC2
FK_SalesTaxRate_StateProvince_StateProvinceID
hasFK_SalesTaxRate_StateProvince_StateProvinceID
PK_StateProvince_StateProvinceID
AK_StateProvince_Name
StateProvince_UC1
AK_StateProvince_rowguid
StateProvince_UC2
AK_StateProvince_StateProvinceCode_CountryRegionCode
StateProvince_UC3
FK_StateProvince_CountryRegion_CountryRegionCode
hasFK_StateProvince_CountryRegion_CountryRegionCode
PK_CountryRegion_CountryRegionCode
AK_CountryRegion_Name
CountryRegion_UC1
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode
hasFK_CountryRegionCurrency_CountryRegion_CountryRegionCode
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
Transactions for previous years.
PK_TransactionHistoryArchive_TransactionID
PRIMARY
Current version number of the AdventureWorks sample database.
PK_AWBuildVersion_SystemInformationID
uAWBuildVersion
CREATE TRIGGER [dbo].[uAWBuildVersion] ON [dbo].[AWBuildVersion]
AFTER UPDATE NOT FOR REPLICATION AS
BEGIN
SET NOCOUNT ON;
UPDATE [dbo].[AWBuildVersion]
SET [dbo].[AWBuildVersion].[ModifiedDate] = GETDATE()
FROM inserted
WHERE inserted.[SystemInformationID] = [dbo].[AWBuildVersion].[SystemInformationID];
END;
97531/-)KIG
pnljhfdYWU
server=;database=commonwealthave;user=;password=;
DSN=AdventureWorks;APP=Microsoft Visio;WSID=RUNAMUKX;DATABASE=AdventureWorks;Trusted_Connection=Yes
Date of last Validation
Date of last Mapping
Date of last Merge
Date of last Merg
IX_Address_CountryRegionCode_UC1
IX_Address_StateProvinceID
IX_Address_StateProvinceID_UC1
FK_CountryRegion_Address
FK_StateProvince_Address
UTINYINT
WCHAR
GUID
TIMESTAMP
AddressType_PK
DBversion
INTEGER
iedDa
Address_PK
IX_Address_CountryRegionCode
AWBuildVersion_PK
AssemblyID
SMALLINT
DOUBLE
EffectiveDate
ObsoleteDate
BillOfMaterials_PK
IX_BillOfMaterials_UnitMeasureCode
IX_BillOfMaterials_UnitMeasureCode_UC1
AK_BillOfMaterials_AssemblyID_ComponentID_ObsoleteDate
FK_Product_BillOfMaterials_AssemblyID
FK_Product_BillOfMaterials_ComponentID
FK_UnitMeasure_BillOfMaterials
Salutation
BOOL
Password
LONGCHAR
Contact_PK
ContactType_PK
AK_ContactType_rowguid
CountryCurrency
CountryCurrency_PK
IX_CountryCurrency_CurrencyCode
IX_CountryCurrency_CurrencyCode_UC1
AK_CountryCurrency_rowguid
PK_CountryCurrency_CountryRegionCode_CurrencyCode
FK_CountryRegion_CountryCurrency
FK_Currency_CountryCurrency
CountryRegion_PK
AK_CountryRegion_rowguid
SecurityCode
CreditCard_CreditCardID
CreditCard_UC2
Currency_PK
AK_Currency_rowguid
CurrencyRate_PK
AK_CurrencyRate_rowguid
PK_CurrencyRate_CurrencyRateID
FK_Currency_CurrencyRate_From
FK_Currency_CurrencyRate_To
Customer_PK
IX_Customer_SalesPersonID
IX_Customer_SalesPersonID_UC1
IX_Customer_TerritoryID
IX_Customer_TerritoryID_UC1
FK_SalesPerson_Customer
FK_SalesTerritory_Customer
FK_Address_CustomerAddress
FK_AddressType_CustomerAddress
FK_Customer_CustomerAddress
CustomerAddress_UC2
WCHA
Department_PK
AK_Department_rowguid
ShortName
BINARY
Document_PK
AK_Document_ShortName_Revision
EmergencyContactName
EmergencyContactPhone
BaseRate
CURRENCY
SalesPersonFlag
Employee_PK
IX_Employee_AddressID
IX_Employee_AddressID_UC1
IX_Employee_ManagerID
IX_Employee_ManagerID_UC1
IX_Employee_ShiftID
IX_Employee_ShiftID_UC1
FK_Address_Employee
FK_Department_Employee
FK_ManagerID_EmployeeID
FK_Shift_Employee
EmployeeDepartmentHistory_PK
IX_EmployeeDepartmentHistory_DepartmentID
IX_EmployeeDepartmentHistory_DepartmentID_UC1
AK_EmployeeDepartmentHistory_rowguid
PK_EmployeeDepartme_EmployeeID_StartDate_DepartmentID
FK_Department_EmployeeDepartmentHistory
FK_Employee_EmployeeDepartmentHistory
EmployeePayHistory_PK
FK_Employee_EmployeePayHistory
Illustration_PK
AK_Illustration_rowguid
PK_Illustration_ProductModelID_IllustrationID
FK_ProductModel_Illustration
IndividualID
CreditCardNumber
CreditCardExpMonth
CreditCardExpYear
roper
Individual_PK
AK_Individual_rowguid
PK_Individual_IndividualID
FK_Customer_Individual
JobCandidate_PK
IX_JobCandidate_EmployeeID
IX_JobCandidate_EmployeeID_UC1
AK_JobCandidate_rowguid
FK_Employee_JobCandidate
Location_PK
AK_Location_rowguid
DealerPrice
ProductSubCategoryID
Product_PK
FK_ProductModel_Product
FK_Product_ProductPhoto
FK_ProductSubCategory_Product
ProductSubCategory
FK_Product_UnitMeasure_Size
FK_Product_UnitMeasure_Weight
oduct
ProductCategory_PK
PK_CategoryID
ProductCostID
EstimatedStandardCost
ProductCostHistory_PK
IX_ProductCostHistory_ProductID
IX_ProductCostHistory_ProductID_UC1
AK_ProductCostHistory_rowguid
PK_ProductCostHistory_ProductCostID
FK_ProductCostHistory_Product
ewid()
ProductDescription_PK
PK_ProductDescription
ProductInventoryID
WorkCenterID
ProductInventory_PK
IX_ProductInventory_LocationID
IX_ProductInventory_LocationID_UC1
IX_ProductInventory_WorkCenterID
IX_ProductInventory_WorkCenterID_UC1
AK_ProductInventory_ProductID_LocationID_WorkCenterID_Type_Shelf_Bin
PK_ProductInventory_ProductInventoryID
FK_Location_ProductInventory
FK_Product_ProductInventory
FK_WorkCenter_ProductInventory
WorkCenter
ProductModel_PK
ProductPhoto_PK
AK_ProductPhoto_rowguid
PK_ProductPhoto_PhotoID
ProductSubCategory_PK
AK_ProductSubCategory_Name
AK_ProductSubCategory_rowguid
PK_ProductSubCategory_ProductSubCategoryID
FK_ProductCategory_ProductSubCategory
lesPe
ProductVendor_PK
IX_ProductVendor_UnitMeasureCode
IX_ProductVendor_UnitMeasureCode_UC1
IX_ProductVendor_VendorID
IX_ProductVendor_VendorID_UC1
FK_Product_ProductVendor
FK_UnitMeasure_ProductVendor
FK_Vendor_ProductVendor
LineNumber
PurchaseOrderDetail_PK
IX_PurchaseOrderDetail_ProductID
IX_PurchaseOrderDetail_ProductID_UC1
AK_PurchaseOrderDetail_rowguid
PK_PurchaseOrderDetail_PurchaseOrderID_LineNumber
FK_Product_PurchaseOrderDetail
FK_PurchaseOrderHeader_PurchaseOrderDetail
PurchaseOrderHeader_PK
IX_PurchaseOrderHeader_EmployeeID
IX_PurchaseOrderHeader_EmployeeID_UC1
IX_PurchaseOrderHeader_VendorID
IX_PurchaseOrderHeader_VendorID_UC1
AK_PurchaseOrderHeader_rowguid
FK_Employee_PurchaseOrderHeader
FK_ShipMethod_PurchaseOrderHeader
FK_Vendor_PurchaseOrderHeader
BackOrderDate
SalesOrderDetail_PK
IX_SalesOrderDetail_AddressID
IX_SalesOrderDetail_AddressID_UC1
IX_SalesOrderDetail_ProductID
IX_SalesOrderDetail_ProductID_UC1
PK_SalesOrderDetail_SalesOrderID_LineNumber
FK_Address_SalesOrderDetail
FK_Product_SalesOrderDetail
FK_SalesOrderHeader_SalesOrderDetail
FK_SpecialOfferProduct_SalesOrderDetail
SAPAccountNumber
FK_Address_SalesOrderHeader_BillToAddress
FK_Address_SalesOrderHeader_ShipToAddress
FK_Contact_SalesOrderHeader
FK_CreditCard_SalesOrderHeader
FK_Customer_SalesOrderHeader
FK_SalesPerson_SalesOrderHeader
FK_SalesTerritory_SalesOrderHeader
FK_ShipMethod_SalesOrderHeader
IX_SalesOrderHeader_CustomerID
IX_SalesOrderHeader_SalesPersonID
FK_CurrencyRate_SalesOrderHeader
uSalesOrderHeader
SalesPerson_PK
FK_Employee_SalesPerson
FK_SalesTerritory_SalesPerson
SalesPersonQuotaHistory_PK
PK_SalesPersonQuota_SalesPersonID_YearMonth
FK_SalesPerson_SalesPersonQuotaHistory
FK_StateProvince_SalesTaxRate
SalesTaxRate_UC3
FK_SalesPerson_SalesTerritoryHistory
FK_SalesTerritory_SalesTerritoryHistory
ScrapReason_UC2
Shift_UC3
FK_Product_SpecialOfferProduct
FK_SpecialOffer_SpecialOfferProduct
SpecialOfferProduct_UC3
AK_SpecialOfferProduct_ProductID
rankl
FK_StateProvince_CountryRegion
NumberEmployees
FK_Customer_Store
FK_Contact_StoreContact
FK_ContactType_StoreContact
PK_StoreContact_Customer_ContactID
IX_StoreContact_ContactID
IX_StoreContact_ContactTypeID
FK_Store_StoreContact
ReferenceOrderLineNumber
FK_Product_TransactionHistory
IX_TransactionHistory_ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineNumber
IX_TransactionHistoryArchive_ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineNumber
PK_UnitMeasure_UnitOfMeasureCode
UnitMeasure_UC2
Modi
fiedDate
Vendor_UC2
FK_Address_VendorAddress
FK_AddressType_VendorAddress
FK_Vendor_VendorAddress
PK_VendorAddress_AddressID_VendorID
IX_VendorAddress_VendorID
FK_Contact_VendorContact
FK_ContactType_VendorContact
FK_Vendor_VendorContact
IX_VendorContact_ContactID
IX_VendorContact_ContactTypeID
FK_Product_WorkOrder
FK_ScrapReason_WorkOrder
IX_WorkOrder_ProductID
IX_WorkOrder_ScrapReasonID
uWorkOrder
iWorkOrder
FK_WorkCenter_WorkOrderRouting
FK_WorkOrder_WorkOrderRouting
PK_WorkOrderRouting_WorkdOrderID_ProductID_OperationSequence
IX_WorkOrderRouting_ProductID
FK_Location_WorkOrderRouting
ContactXCreditCard
PK_ContactXCreditCard_ContactID_CreditCardID
FK_Contact_ContactXCreditCard
FK_CreditCard_ContactXCreditCard
FK_Product_ProductReview
ProductModelXProductDescriptionXCulture
PK_ProductModelXProductDescriptionXCulture
FK_Culture_ProductModelXProductDescriptionXCulture
FK_ProductDescription_ProductModelXProductDescriptionXCulture
FK_Product_ProductModelXProductDescriptionXCulture
ProductXDocument
PK_ProductXDocument
FK_Document_ProductXDocument
FK_Product_ProductXDocument
FK_Product_ProductListPriceHistory
ProductModelXIllustration
PK_ProductModelXIllustration
FK_Illustration_ProductModelXIllustration
FK_ProductModel_ProductModelXDocument
SalesOrderHeaderXSalesReason
PK_SalesOrderHeaderXSalesReason
FK_SalesOrderHeader_SalesOrderHeaderXSalesReason
FK_SalesReason_SalesOrderHeaderXSalesReason
PK_ShoppingCart_ShoppingCartItemID
IX_ShoppingCartItem_ShoppingCartID_ProductID
FK_Product_ShoppingCartItem
PK_SalesReason
uAddress
uAddressType
DBVersion
float
CK_BillOfMaterials_EndDate
CK_BillOfMaterials_ProductAsse
uBillOfMaterials
Contact_UC2
uContact
uContactType
FK_ContactXCreditCard_Contact_ContactID
FK_ContactXCreditCard_CreditCard_CreditCardID
uContactXCreditCard
FK_CountryCurrency_CountryRegion_CountryRegionCode
FK_CountryCurrency_Currency_CurrencyCode
uCountryCurrency
nvarch
uCountryRegion
uCreditCard
uCulture
uCurrency
uCurrencyRate
CK_Customer_CustomerType
FK_Customer_SalesPerson_SalesPersonID
uCustomer
OLWID
uCustomerAddress
uDepartment
VisDBEngrSecondaryObjMapData
VisDBEngrModelEngData
IMWDD.Document
ORMInfo
Folders
SummaryInformation
DBSnapshot
CK_Document_Status
varbinary
uDocument
Root Entry
VisDBEngrData
VisDBEngrDocData
VisDBEngrObjMapData
EmergencyContactID
CK_Employee_PayFrequency
FK_Employee_Address_AddressID
FK_Employee_Department_DepartmentID
FK_Employee_Shift_ShiftID
uEmployee
uEmployeeDepartmentHistory
CK_EmployeePayHistory_PayFrequ
uEmployeePayHistory
ill S
uIllustration
uIndividual
uJobCandidate
uLocation
WeightUnitMea
ureCode
CK_Product_ProductLine
CK_Product_Class
CK_Product_Style
FK_Product_ProductModel_ProductModelID
uProduct
uProductCategory
CK_ProductCostHistory_StartDat
uProductCostHistory
uProductDescription
ProductInventory_UC1
IX_ProductInventory_ProductID
uProductInventory
FK_ProductListPriceHistory_Product_ProductID
uProductListPriceHistory
uProductModel
PK_ProductModelXIllustration_ProductModelID_IllustrationID
FK_ProductModelXIllustration_Illustration_IllustrationID
ProductModelXIllu
stration
FK_Product_ProductModel_ProductModelIDModelXDocument
uProductM
odelXIllustration
PK_ProductModelXProductDescriptionXCulture_ProductModelID_ProductDescriptionID_CultureID
FK_ProductModelXProductDescriptionXCulture_Culture_CultureID
FK_ProductModelXProductDescriptionXCulture_ProductDescription_ProductDescriptionID
FK_ProductModelXProductDescriptionXCulture_ProductModel_ProductModelID
uProductModelXProductDescriptionXCulture
ThumbnailPhotoFilePath
LargePhotoFilePath
AK_ProductPhoto_ProductID
FK_ProductPhoto_Product_ProductID
uProductPhoto
uProductReview
uProductSubcategory
uProductVendor
PK_ProductXDocument_ProductID_DocumentID
FK_ProductXDocument_Document_DocumentID
FK_ProductXDocument_Product_ProductID
uProductXDocument
uPurchaseOrderDetail
iPurchaseOrderDetail
CK_PurchaseOrderHeader_Status
uPurchaseOrderHeader
FK_SalesOrderDetail_Product_ProductID
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferID
uSalesOrderDetail
iSalesOrderDetail
CK_SalesOrderHeader_Status
alesOrderHeader_UC1
PK_SalesOrderHeaderXSalesReason_SalesOrderID_SalesReasonID
FK_SalesOrderHeaderXSalesReason_SalesOrderHeader_SalesOrderID
FK_SalesOrderHeaderXSalesReason_SalesReason_SalesReasonID
uSalesOrderHeaderXSalesReason
uSalesPerson
uSalesPersonQuotaHistory
uSalesReason
CK_SalesTaxRate_TaxType
uSalesTaxRate
uSalesTerritory
uSalesTerritoryHistory
uScrapReason
uShift
uShipMethod
uShoppingCartItem
uSpecialOffer
uSpecialOfferProduct
uStateProvince
uStore
toreContact_ContactID
uStoreContact
CK_TransactionHistory_Transact
uTransacti
nHistory
CK_TransactionHistoryArchive_T
uTransactionHistoryArchive
uUnitMeasure
CK_Vendor_CreditRating
uVendor
uVendorAddress
uVendorContact
uWorkOrderRouting
Curr
ntFlag
FK_EmployeeDepartmentHistory_Departme
nt_DepartmentID
IX_EmployeeDepartmentHistory_ShiftID
IX_Contact_EmailAddress
PK_Produc
Inventory_ProductID_LocationID
IX_ProductReview_ProductID_Name
Producti
ocat
IX_Transaction
istory_ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
Purcha
IX_VendorAddress_AddressID
K_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
erritoryID
SalesPer
sonID
IX_SpecialOfferProduct_ProductID
IX_Store_SalesPersonID
IX_CountryRegionCurrency_CurrencyCode
Add,use,Relational,Database,your,table,Entity,Relationship,diagram,ER,IDEF1X
0 = IDEF1X, 2 = Relational
Set to hide the PK seperator lines in the Entities on this page.
Set to hide the Tabstop lines in the Entities on this page.
Use to add a table to your Entity Relationship diagram.
se schema.
Entity
Identifies the shape's version to the add-on.
Set for dependent tables.
Set to allow free-from edits (manual edits are not maintained in the model)
Set if this shape's Database | Document | Options have have local overrides.
User.DBNotation Conditionally sets the DBNotation setting.
width of this shape's text
height of this shape's text
Subshape id within the Entity group shape.
Subshape ID within the Entity group shape.
specifies the number of columns in the tables primary key
Set to hide the horizontal line seperating the PK columns from the rest.
Set to hide the 1st vertical tab line.
Set to hide the 2nd vertical tab line.
Indicates the number of lines in the text.
Indicates the height of one text line.
use,two,key,between,Relational,Database,define,your,Entity,Relationship,diagram,ER,IDEF1X,foreign,tables
Use to define a foreign key between two tables in your Entity Relationship diagram.
Add text here.
Rounded,rectangle,variable,corner,rounding,Basic,signal,flow,systems,design,control,engineering
Rectangle shape with variable corner rounding.
ers on rectangle.
Adjust Corner Rounding
Relational,Database,Entity,Relationship,IDEF1X
Drag onto the page to add a table.
elationship diagram.
Conditionally sets the DBNotation setting.
two,key,Relational,Database,Entity,Relationship,IDEF1X,foreign,tables
Drag onto the page to define a foreign key between two tables.
This formula conditionally sets the DBNotation setting.
This formula conditionally sets the CrowsFoot notation flag.
Arial Unicode MS
Symbol
Wingdings
SimSun
PMingLiU
MS PGothic
Dotum
Sylfaen
Estrangelo Edessa
Vrinda
Shruti
Mangal
Tunga
Sendnya
Raavi
Dhenu
Latha
Gautami
Cordia New
MS Farsi
Gulim
Times New Roman
C:\Program Files\Microsoft Office\Office12\1033\ENTITY_U.VSS
C:\Program Files\Microsoft Office\Office12\1033\ENTITY_M.VSS
Set to hide category discriminators.
Set to hide PK, FK, and Index annotations within Entities.
Set to Hide Primary Key section within Entities.
Set to hide Datatypes section within Entities.
Set to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
Set to hide the horizontal line that seperates the PK section from the other columns of an Entity.
{33E09E37-EF53-4C6E-83CC-20672EE29B16}
Database Properties...
Show Related Tables
{84603B9E-DE21-4D51-8F64-803F955BC551}
{B59024C0-BEC8-46DF-8AE3-BA9DEDE86C6A}
{BF6939AA-17FB-46A8-8E7F-F82553F3819C}
{1F7DB938-06C6-4720-B0DC-59AF45B1E836}
{6C9920B4-4457-413A-BEEC-EF0BDD238EE0}
{467143FA-1E34-4FE5-9BF2-6777C5CFB92B}
{E8F554EF-A10C-4A6E-B37B-1A140A1360FE}
{7576472C-39CD-4C25-B75B-7FD9A0924E62}
{F1672714-3837-45AA-B4BD-8651E2781FA2}
{37642070-1A2E-4EFE-827C-27F53FBF4912}
{DC143FA2-72FE-45D7-B4C0-EE8A810F7C64}
{7942DB64-1424-434F-936C-281D522AEF75}
{D46DFC03-B316-4F0C-B4B0-C0B5F1E0AC61}
{F2B5AC59-65B1-4AB3-8A42-3504FE3B1910}
{7E81C895-46B6-4122-A6EA-66839C02A6A0}
{229A694D-3A52-40E7-A393-BCB44A36FE86}
{E591CB4E-4753-40B0-A003-1269FE869C85}
{06EC3FDA-AD1C-4160-933E-8BAC93D32FA3}
{9B449F4F-AC61-4597-84DC-E70304BB7663}
{29BFDB85-FDC5-46F6-8962-B3594B257BAA}
{3F6D764D-CD10-4D8D-B9B7-259BE93BBC85}
{4A6E64A3-8DE2-4CB5-AA23-3887D68A9BAD}
{369C89E7-1EBB-4B27-AC46-1C2E568E94CD}
{37081802-ABD0-49B3-B841-1FCF566EB257}
{9F5CA8D6-6C75-41AE-B020-3A5540C8D850}
{85549D25-698E-415D-A779-40EC89A6C766}
{BD6A2AB2-6379-4A38-89CA-9FF646F2DC8C}
{F905F040-374A-41F5-ACC9-234352A108F6}
{F62D25FE-D8D1-49BE-8C3A-93A6313EE9BD}
{CD8C8295-2BFB-4734-AE93-30EF36C7236F}
{8F449353-336E-413F-85E0-B4E845C464A4}
{A79D96AB-3230-4A10-B28A-E241FB4B4918}
{0CEA34BB-3D34-4339-AFDA-60A1D6258D1D}
{ABAACF78-FAC6-43A3-AFF9-B24FB6BDAC73}
{FAA974DD-B15B-4CAC-8F82-EAE48640B82A}
{17329CC9-1701-48BA-AB40-B4FFEA71B70E}
{BD7DB3E6-4D9C-4FBA-BEF7-9A1A8F0E6D76}
{4A3E9F23-7C66-42C5-9146-C73428D459CA}
{C9C2BCAE-00F5-418A-B035-42D3A3C5FA8B}
{9C5EC1B0-C0C9-487D-BE69-78073FB4B1FC}
{119E5DEE-EC7D-40B6-B29D-E121CC449309}
{FC4E12E1-BD36-4096-8B00-937A05273BD7}
{CE5685CF-3248-4BE8-AA3F-64AB8F9F2903}
{10791805-DC20-4B86-8C5A-AC99B049E016}
{85141DAE-11F9-4A9F-8C70-5EE745DE6D8F}
{24C46D6C-5EA1-443B-9E26-A4481EF7F259}
{33347BE1-8D63-4839-ADAE-D426EB4ACFD8}
{AA9F88FD-8889-4D54-BE77-952AC1515D45}
{7DAF7FDD-808A-4BE2-90E4-F57DD2921C3C}
{A5E59234-4739-4FBD-9F20-B38427B3BF3D}
{0CE2BA9D-AF0C-4A93-9790-B2E2776C8BDA}
{BA53C549-EFC5-4BD3-87B0-4E3C3B72EBE4}
{59FF0162-4360-491D-935E-FB19E5199BBF}
{A794ABBF-4BEE-49A4-BDCD-7E264E1BB484}
{619F5F56-2363-457A-8506-ECF587162063}
{724C936C-0BFD-4233-A5E5-83EF5A63643C}
{71288407-B597-4991-A3F0-A64A47032409}
{3F07D00D-DA46-45E4-B216-E23ECD379C78}
{7B719D7F-B1D4-4186-A498-75E863A0DE03}
{413755FE-FAD7-41D6-9E19-8C64D3D007D0}
{D9E0867A-769E-41E8-9391-F8718CC13EE0}
{198516E4-4ACE-4453-BFB0-9328BE581F28}
{A7228ED3-EA89-46F1-98CA-5E2F184BEDBC}
{9640DD68-2003-4BB0-B624-2C8B7FD3E14D}
{23E88E9C-AB0E-4BDC-A0EC-AFAAA5197997}
{0B286E5B-1C13-404B-BE65-998A6D50B936}
{73762D92-FB2C-4E7A-9BBF-B2702FF63DB4}
{20DE9556-1C4D-4511-A6D6-EF6495D5734F}
{1C8B7A59-019C-495A-8ED1-059EF214C119}
{225F6572-3116-4AEA-8860-6F34F9F4FE57}
{0611FAAD-F284-4D6C-902D-85F7A277A9B8}
{6026745E-6D99-4490-9ACF-6731607E68F8}
{57A07E44-F021-47CB-884E-75FBB79C25D3}
{E86D800B-7A2C-41E7-8727-184E225EA530}
{7678712E-59F8-4358-A058-0017BC7B5BA5}
{DDB16BD7-191D-47F0-B0F0-DEC61DD03BAC}
{A45E11F0-65A8-4566-B8A2-512A0A86E50B}
{F75F32C3-534A-4BDA-BBF1-A6FF1EA86DB7}
{B7315346-6C52-482C-9582-E3A6604CEE16}
{00278B23-60C5-4A43-BE91-FDD1662EAF32}
{4DF7BF9C-B06E-4CC5-B6EB-DF68C2CEDBD2}
{985E555C-AF80-49D2-81D0-7DCC1CB37A40}
{618B9100-EA21-4042-AEC0-4055BD1EC6E7}
{BB0FF48E-3DD9-43B2-87D6-FB4C42EBAF80}
{BDF835A2-55FB-4ADB-89BF-27C172B35A83}
{C0AE8C45-0321-4B3D-8DC0-380DF29703DA}
{0F288B82-E2C7-4E5B-9918-97E2F4E9571B}
{3E7BAB3D-1A0E-4E4B-B937-7057609678B2}
{3ABDB394-AC31-4985-B6EF-4A37C762C68B}
{F764B372-7417-48C1-A3B6-506698F2632F}
{FA880B3D-D558-4220-ABE2-221499B4FAE2}
{CAF86E19-690C-46B6-AB38-5F3E663D7A5B}
{CE35300E-16EF-482F-8712-398912D8CAF4}
{43AF05E5-E165-426D-968D-E586B4CFE20A}
{127878FC-C490-4CCB-ABCA-C946A8FC9C7B}
{5BB4E4A2-4597-4325-A7A5-557D3A1BEE4C}
{722BDFCA-D79D-4803-BB0F-B2810FF65EFB}
{9015EEA7-F6F2-4A27-95FF-BF4A9E0246DE}
{0D072F53-924D-493F-9C85-97557A5A444A}
{3E0DFD50-E32F-46F2-A435-AA8D15005811}
{80B5C88B-EAAC-45F0-8ABA-2DB419BB681C}
{386231E6-C63F-44CA-A6FC-BDF212DDBC38}
{265C44E5-9D81-41CC-BB88-AD7A3F9C9FA5}
{EA792EA4-ABE3-4D9D-927F-578AF3C6AE26}
{446217E7-5382-4CAB-9E39-BFD79DBD835F}
{FB2C7ECF-0BFC-4BD5-AF62-BFC3F715873A}
{5ECF0CBF-D42D-4B47-93EE-B3E3377898EE}
{D64BAD3C-6430-4446-9630-03862B8DA907}
{FF863E27-CB81-461C-97BA-98DA8F19E1F2}
{D442435D-275A-40B8-93CF-7EF266BC3D71}
{805FD4E8-5747-44F6-B6EE-5FFBF8B32B5E}
{11465BEB-E38B-4F5B-9148-8FF5C6C531EC}
{1E9E1A5D-3718-4AD7-92F0-E5FB64E898B7}
{6FA5232F-1673-4263-8C20-44DBC5A3DECC}
{0F988B89-0BA4-414A-B26D-995161A156F7}
{2BE6CA20-BF02-419A-8C50-C77F847C919E}
{10711475-91BC-4064-A81A-36AE85B78125}
{582A98EA-5397-4AC9-839D-70A846B0973D}
{E563AF62-440D-45FF-800B-A1CE3FCF641A}
{C3E997B0-B5B2-49A5-8844-F936AFF25D68}
{C5EBA3EA-072E-4D3A-814B-F6EE9E8B0A06}
{2137FE1C-F5AC-4917-A5F5-E504829A0C0F}
{4BE3DC27-EA53-4EF4-9310-8F83603BAFF9}
{BD18334A-8CD3-4CE0-A225-83ACD185658C}
{096BBE4F-F267-4FB9-AD26-907A15363A36}
{DAA1AFB5-1CFB-45F1-BCB3-166910C9F692}
{CD868BDC-36C3-4283-9075-C65F41E7BB17}
{DE4AD3FB-6F91-45CE-BC5B-9B9B79B67E82}
{57A54EC2-3FC5-4F12-AF4B-98D0986BBEF9}
{43C2B7BD-3AAD-4F2A-BF7B-BFDCA46796BE}
{747B18DE-1C73-41F5-A1DB-0CCBCFA44B0A}
{51EC9851-7B49-45BD-A0B0-304B799595A6}
{3EE7F6DC-2158-4AD1-BF0F-A1A41A604934}
{EB76D7EE-FE87-4F19-BC45-7483DA4EDEBB}
{C5EE5C0E-8049-4518-8CAD-0C2FE5884111}
{4C4E9BBD-BB06-48FC-AD3D-C6DD6B681A95}
{9A9A1223-2E4E-4538-84DB-7BDD0C2A2DA2}
{2CCF6482-32B1-4756-97E5-0375A54C8EE0}
{516FE3B9-1DDD-4979-B31B-6D9E58B7288B}
{CB2F174D-0EC6-4ABF-A3A6-234A278E038B}
{66E137E0-ACA9-4ACC-A5DC-EB92846AF8D6}
{4E405B20-E592-4058-9239-33B561597946}
{7CF6ACB4-D99E-4D87-A089-ED29B3D6D156}
{68A6132A-3CB1-46C1-B603-822C0EE465B9}
{518300A1-90BF-41FA-B87A-8775B1BE669F}
{39BA5E9B-D0BE-4616-B62F-E87E2ADA87E1}
{FFE655AC-241D-4063-863F-0FC8052D4223}
{1EF5A612-9DE0-405C-A34A-201769A2D9F6}
{4BE7190F-B1E8-4AF9-BBF8-D8257BC698F8}
{B730CEDC-DCBA-4678-A311-C09C41306504}
{F5796B65-D64D-479C-A00C-5FE1E121F975}
{98EF0F78-D642-4973-B87A-435C7C8D7D13}
{B108E730-05A8-4C6E-A7D6-1F392FCB7ED3}
{EA63E60C-8C1B-4484-9AE2-36D71755FAF9}
{66FFB92A-BAE7-4AEC-8F72-B8DBDBE5D9C4}
{7D4A7DBF-432A-462D-98C0-7B59415844DB}
{E433B2A3-54AE-4411-919D-710E091CC8A6}
{5DB84BD3-024A-47B8-B486-541F01CEEE53}
DB Engineer
/CMD=1
Guide
TheDoc
Page-1
Gesture Format
Database Model
DBNotation
Visio Extended Data
DBCrowsFoot
DBHideDiscriminator
DBDependent
DBHideAnnotations
visDescription
DBHidePKRow
Relationship.14
DBHideTypes
visVersion
DBHideVerticalLines
Width
DBHideHorizontalLine
Connector
White line
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
Tracking Text
DBShapeType
DBEventTrigger
OldPinX
OldPinY
ManualEdits
Hide
SetPinX
SetPinY
DBShapeVersion
RefSheetID
RefControl
Dynamic Connector
DBHideRelationships
DBHideRelationshipText
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship
Entity.15
Basic
Visio 00
Rounded rectangle
Rounded rectangle.293
Rounded rectangle.294
Rounded rectangle.331
Relationship.13
Row_1
Row_2
Row_3
Row_4
Entity.10
Relationship.11
Relationship.12
Rounded rectangle.292
Rounded rectangle.302
Rounded rectangle.288
msvNoAutoConnect