Purchasing.VendorContact (table)

From dbscript Online Help
Revision as of 00:11, 27 November 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table Purchasing.VendorContact


Column Data Type Nullable Default PK Index
VendorID int not null PK_VendorContact_VendorID_ContactID
ContactID int not null PK_VendorContact_VendorID_ContactID IX_VendorContact_ContactID
ContactTypeID int not null IX_VendorContact_ContactTypeID
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.Contact ContactID ContactID
Person.ContactType ContactTypeID ContactTypeID
Purchasing.Vendor VendorID VendorID

automatically generated

Table Purchasing.VendorContact
Description Cross-reference table mapping vendors and their employees.


Column Data Type Nullable Default Description / PK / Index
VendorID int not null Primary key.
PK_VendorContact_VendorID_ContactID
ContactID int not null Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
PK_VendorContact_VendorID_ContactIDIX_VendorContact_ContactID
ContactTypeID int not null Contact type such as sales manager, or sales agent.
IX_VendorContact_ContactTypeID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Contact ContactID ContactID
Person.ContactType ContactTypeID ContactTypeID
Purchasing.Vendor VendorID VendorID


Referencing Object Object Type Reference Type
Purchasing.vVendor View Select
dbo.ufnGetContactInformation SQL table-valued-function Select