ScrewTurn Wiki

Edit

wikibot

TablePurchasing.VendorAddress
DescriptionCross-reference mapping vendors and addresses.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_VendorAddress_VendorID_AddressIDVendorID, AddressID

Edit

Indexes

IndexTypeColumns
IX_VendorAddress_AddressID AddressID

Edit

Foreign Keys

RelationColumnReferenced Column
Person.AddressAddressIDAddressID
Person.AddressTypeAddressTypeIDAddressTypeID
Purchasing.VendorVendorIDVendorID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaPurchasing

Edit

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewPurchasing.vVendor

Edit

automatically generated

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

Dependency TypeObject TypeReferenced Object
SchemaSchemaPurchasing

Reference TypeObject TypeReferencing Object
SelectViewPurchasing.vVendor

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