Object type: Table

Cross-reference mapping vendors and addresses.

Columns 

Name	Data type	Nullable	Description
VendorID	int	No	Primary key. Foreign key to Vendor.VendorID.
AddressID	int	No	Primary key. Foreign key to Address.AddressID.
AddressTypeID	int	No	Address type. Foreign key to AddressType.AddressTypeID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_VendorAddress_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_VendorAddress_VendorID_AddressID	PRIMARY KEY	VendorID AddressID	Clustered index created by a primary key constraint.
FK_VendorAddress_Address_AddressID	FOREIGN KEY	AddressID	Reference table: Person.Address Foreign key constraint referencing Address.AddressID.
FK_VendorAddress_AddressType_AddressTypeID	FOREIGN KEY	AddressTypeID	Reference table: Person.AddressType Foreign key constraint referencing AddressType.AddressTypeID.
FK_VendorAddress_Vendor_VendorID	FOREIGN KEY	VendorID	Reference table: Purchasing.Vendor Foreign key constraint referencing Vendor.VendorID.

Indices 

Name	Description
IX_VendorAddress_AddressID	Nonclustered index.

Triggers 

Name	Description
Purchasing.uVendorAddress	AFTER UPDATE trigger setting the ModifiedDate column in the VendorAddress table to the current date.

Accessed by 

Name	Description
Purchasing.vVendor	Vendor (company) names and addresses and the names of vendor employees to contact.

Modified by 

Name	Description
Purchasing.uVendorAddress	AFTER UPDATE trigger setting the ModifiedDate column in the VendorAddress table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation