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

From dbscript Online Help
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Purchasing.VendorContact
 
| Purchasing.VendorContact
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping vendors and their employees.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| VendorID
 
| VendorID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_VendorContact_VendorID_ContactID
+
| Primary key.
−
|
+
|- valign="top"
−
|-
 
 
| ContactID
 
| ContactID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_VendorContact_VendorID_ContactID
+
| Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
−
| IX_VendorContact_ContactID
+
|- valign="top"
−
|-
 
 
| ContactTypeID
 
| ContactTypeID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Contact type such as sales manager, or sales agent.
−
| IX_VendorContact_ContactTypeID
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
 +
| Date and time the record was last updated.
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_VendorContact_VendorID_ContactID
 +
| VendorID, ContactID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| IX_VendorContact_ContactID
 
|  
 
|  
 +
| ContactID
 +
|- valign="top"
 +
| IX_VendorContact_ContactTypeID
 
|  
 
|  
 +
| ContactTypeID
 
|}
 
|}
  
−
 
+
=== Foreign Keys ===
−
 
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 78:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Person.Contact_(table)|Person.Contact]]
 
| [[Person.Contact_(table)|Person.Contact]]
 
| ContactID
 
| ContactID
 
| ContactID
 
| ContactID
−
|-
+
|- valign="top"
 
| [[Person.ContactType_(table)|Person.ContactType]]
 
| [[Person.ContactType_(table)|Person.ContactType]]
 
| ContactTypeID
 
| ContactTypeID
 
| ContactTypeID
 
| ContactTypeID
−
|-
+
|- valign="top"
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 
| VendorID
 
| VendorID
 
| VendorID
 
| VendorID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Purchasing_(schema)|Purchasing]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
 +
|- valign="top"
 +
| Select
 +
| SQL table-valued-function
 +
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 76: Line 133:
 
| '''Table
 
| '''Table
 
| Purchasing.VendorContact
 
| Purchasing.VendorContact
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping vendors and their employees.
 
| Cross-reference table mapping vendors and their employees.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 91: Line 146:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| VendorID
 
| VendorID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key.
+
| Primary key.<br />PK_VendorContact_VendorID_ContactID
−
| PK_VendorContact_VendorID_ContactID
+
|- valign="top"
−
|-
 
 
| ContactID
 
| ContactID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
+
| Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.<br />PK_VendorContact_VendorID_ContactIDIX_VendorContact_ContactID
−
| PK_VendorContact_VendorID_ContactIDIX_VendorContact_ContactID
+
|- valign="top"
−
|-
 
 
| ContactTypeID
 
| ContactTypeID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| Contact type such as sales manager, or sales agent.
+
| Contact type such as sales manager, or sales agent.<br />IX_VendorContact_ContactTypeID
−
| IX_VendorContact_ContactTypeID
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 144: Line 194:
 
| VendorID
 
| VendorID
 
| VendorID
 
| VendorID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Purchasing_(schema)|Purchasing]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
 +
|-
 +
| Select
 +
| SQL table-valued-function
 +
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 +
 
|}
 
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

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

Columns[edit]

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

Primary Key[edit]

Primary Key Columns
PK_VendorContact_VendorID_ContactID VendorID, ContactID

Indexes[edit]

Index Type Columns
IX_VendorContact_ContactID ContactID
IX_VendorContact_ContactTypeID ContactTypeID

Foreign Keys[edit]

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

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Purchasing

Dependencies[edit]

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


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Schema Schema Purchasing


Reference Type Object Type Referencing Object
Select View Purchasing.vVendor
Select SQL table-valued-function dbo.ufnGetContactInformation
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.VendorContact_(table)&oldid=2657"