AdventureWorks

Basic Index   Expanded Index

Table Name:Purchasing.VendorAddress
Description:Cross-reference mapping vendors and addresses.
Primary Keys:VendorID
AddressID
FieldTypeDefaultsNulls?Comments
VendorIDintNoneNoPrimary key. Foreign key to Vendor.VendorID.
AddressIDintNoneNoPrimary key. Foreign key to Address.AddressID.
AddressTypeIDintNoneNoAddress type. Foreign key to AddressType.AddressTypeID.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_VendorAddress_VendorID_AddressIDYesYesVendorID
AddressID
IX_VendorAddress_AddressIDNoNoAddressID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_VendorAddress_Address_AddressIDAddressIDPerson.Address
FK_VendorAddress_AddressType_AddressTypeIDAddressTypeIDPerson.AddressType
FK_VendorAddress_Vendor_VendorIDVendorIDPurchasing.Vendor

No primary keys as foreign key constraints
No triggers