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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Purchasing.VendorAddress |- |} {| 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.Address_(table)|Person.Address]]
 +
| AddressID
 +
| AddressID
 +
|-
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
| AddressTypeID
 +
| AddressTypeID
 +
|-
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
| VendorID
 +
| VendorID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Purchasing.VendorAddress
 +
|-
 +
 +
| '''Description
 +
| Cross-reference mapping vendors and addresses.
 +
|-
 +
 +
|}
 +
 +
 +
{| 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. Foreign key to Vendor.VendorID.
 +
| PK_VendorAddress_VendorID_AddressID
 +
|-
 +
| AddressID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Address.AddressID.
 +
| PK_VendorAddress_VendorID_AddressIDIX_VendorAddress_AddressID
 +
|-
 +
| AddressTypeID
 +
| int
 +
| not null
 +
|
 +
| Address type. Foreign key to AddressType.AddressTypeID.
 +
|
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:27, 26 November 2009

wikibot

Table Purchasing.VendorAddress


Column Data Type Nullable Default PK Index
VendorID int not null PK_VendorAddress_VendorID_AddressID
AddressID int not null PK_VendorAddress_VendorID_AddressID IX_VendorAddress_AddressID
AddressTypeID int not null
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Person.Address AddressID AddressID
Person.AddressType AddressTypeID AddressTypeID
Purchasing.Vendor VendorID VendorID

automatically generated

Table Purchasing.VendorAddress
Description Cross-reference mapping vendors and addresses.


Column Data Type Nullable Default Description PK / Index
VendorID int not null Primary key. Foreign key to Vendor.VendorID. PK_VendorAddress_VendorID_AddressID
AddressID int not null Primary key. Foreign key to Address.AddressID. PK_VendorAddress_VendorID_AddressIDIX_VendorAddress_AddressID
AddressTypeID int not null Address type. Foreign key to AddressType.AddressTypeID.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Person.Address AddressID AddressID
Person.AddressType AddressTypeID AddressTypeID
Purchasing.Vendor VendorID VendorID
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.VendorAddress_(table)&oldid=1138"