Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Purchasing VendorAddress (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:50


wikibot

TablePurchasing.VendorAddress
DescriptionCross-reference mapping vendors and addresses.

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



RelationColumnReferenced Column
Person.AddressAddressIDAddressID
Person.AddressTypeAddressTypeIDAddressTypeID
Purchasing.VendorVendorIDVendorID

Reference TypeObject TypeReferencing Object
SelectViewPurchasing.vVendor

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