Difference between revisions of "Purchasing.VendorContact (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.VendorContact |- |} {| border="1" cellpadding="5" cellspacing="0"...)
 
Line 45: Line 45:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
| ContactID
 +
| ContactID
 +
|-
 +
| [[Person.ContactType_(table)|Person.ContactType]]
 +
| ContactTypeID
 +
| ContactTypeID
 +
|-
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
| VendorID
 +
| VendorID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Purchasing.VendorContact
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping vendors and their employees.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:27, 26 November 2009

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.VendorContact_(table)&oldid=1139"