Purchasing.VendorAddress

Table: 'Purchasing.VendorAddress'

4 fields. 28 bytes.

Cross-reference mapping vendors and addresses.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
VendorID	int				Not null	Primary key. Foreign key to Vendor.VendorID.
AddressID	int				Not null	Primary key. Foreign key to Address.AddressID.
AddressTypeID	int				Not null	Address type. Foreign key to AddressType.AddressTypeID.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.VendorAddress'

Primary Key Name	Field Names
PK_VendorAddress_VendorID_AddressID	VendorID, AddressID

Foreign keys for table 'Purchasing.VendorAddress', 3 items

Foreign	Primary	Key Name
VendorAddress.AddressID	Address.AddressID	FK_VendorAddress_Address_AddressID
VendorAddress.AddressTypeID	AddressType.AddressTypeID	FK_VendorAddress_AddressType_AddressTypeID
VendorAddress.VendorID	Vendor.VendorID	FK_VendorAddress_Vendor_VendorID

Indexes for table 'Purchasing.VendorAddress', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_VendorAddress_VendorID_AddressID	Clustered index created by a primary key constraint.	Yes	Yes	VendorID, AddressID
IX_VendorAddress_AddressID	Nonclustered index.	No	No	AddressID

Triggers for table 'Purchasing.VendorAddress', 1 item

Name	Description	Type	Enabled
uVendorAddress	AFTER UPDATE trigger setting the ModifiedDate column in the VendorAddress table to the current date.	after Update	Yes

Dependencies for table 'Purchasing.VendorAddress', 2 items

Object Name	Type	Field Name
Purchasing.uVendorAddress	trigger	N/A
Purchasing.vVendor	view	N/A