AdventureWorks
| Table Name: | Purchasing.VendorContact |
| Description: | Cross-reference table mapping vendors and their employees. |
| Primary Keys: | VendorID ContactID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| VendorID | int | None | No | Primary key. |
| ContactID | int | None | No | Contact (Vendor employee) identification number. Foreign key to Contact.ContactID. |
| ContactTypeID | int | None | No | Contact type such as sales manager, or sales agent. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_VendorContact_VendorID_ContactID | Yes | Yes | VendorID ContactID |
| IX_VendorContact_ContactID | No | No | ContactID |
| IX_VendorContact_ContactTypeID | No | No | ContactTypeID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_VendorContact_Contact_ContactID | ContactID | Person.Contact |
| FK_VendorContact_ContactType_ContactTypeID | ContactTypeID | Person.ContactType |
| FK_VendorContact_Vendor_VendorID | VendorID | Purchasing.Vendor |