Owner: Purchasing 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 40 
Rows: 156 
Description: Cross-reference table mapping vendors and their employees. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    VendorID  int          Primary key. 
    ContactID  int          Contact (Vendor employee) identification number. Foreign key to Contact.ContactID. 
    ContactTypeID  int          Contact type such as sales manager, or sales agent. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)


Index Primary Unique Description
  PK_VendorContact_VendorID_ContactID      Primary key (clustered) constraint 
  IX_VendorContact_ContactID      Nonclustered index. 
  IX_VendorContact_ContactTypeID      Nonclustered index. 
Total: 3 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.Contact  FK_VendorContact_Contact_ContactID  PK_Contact_ContactID 
  Person.ContactType  FK_VendorContact_ContactType_ContactTypeID  PK_ContactType_ContactTypeID 
  Purchasing.Vendor  FK_VendorContact_Vendor_VendorID  PK_Vendor_VendorID 
Total: 3 table(s)

Objects that [Purchasing].[VendorContact] depends on

Object Name Owner Object Type Dep Level
  AccountNumber  dbo  User Defined type 
  Flag  dbo  User Defined type 
  Name  dbo  User Defined type 
  NameStyle  dbo  User Defined type 
  Phone  dbo  User Defined type 
  Contact  Person  Table 
  ContactType  Person  Table 
  Vendor  Purchasing  Table 
Total: 8 object(s)

Objects that depend on [Purchasing].[VendorContact]

Object Name Owner Object Type Dep Level
  ufnGetContactInformation  dbo  Function 
  vVendor  Purchasing  View 
Total: 2 object(s)


CREATE TABLE [VendorContact] (
    [VendorID] [int] NOT NULL ,
    [ContactID] [int] NOT NULL ,
    [ContactTypeID] [int] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_VendorContact_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_VendorContact_Contact_ContactID] FOREIGN KEY
    ) REFERENCES [Contact] (
    CONSTRAINT [FK_VendorContact_ContactType_ContactTypeID] FOREIGN KEY
    ) REFERENCES [ContactType] (
    CONSTRAINT [FK_VendorContact_Vendor_VendorID] FOREIGN KEY
    ) REFERENCES [Vendor] (

See Also

List of tables