Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TablePurchasing.VendorAddress
DescriptionCross-reference mapping vendors and addresses.

Columns

ColumnData TypeNullableDefaultDescription
VendorIDintnot null Primary key. Foreign key to Vendor.VendorID.
AddressIDintnot null Primary key. Foreign key to Address.AddressID.
AddressTypeIDintnot null Address type. Foreign key to AddressType.AddressTypeID.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_VendorAddress_VendorID_AddressIDVendorID, AddressID

Indexes

IndexTypeColumns
IX_VendorAddress_AddressID AddressID

Foreign Keys

RelationColumnReferenced Column
Person.AddressAddressIDAddressID
Person.AddressTypeAddressTypeIDAddressTypeID
Purchasing.VendorVendorIDVendorID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaPurchasing

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewPurchasing.vVendor

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.