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"...)
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| Purchasing.VendorAddress
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference mapping vendors and addresses.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| VendorID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Vendor.VendorID.
 +
|- valign="top"
 +
| AddressID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Address.AddressID.
 +
|- valign="top"
 +
| AddressTypeID
 +
| int
 +
| not null
 +
|
 +
| Address type. Foreign key to AddressType.AddressTypeID.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (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_VendorAddress_VendorID_AddressID
 +
| VendorID, AddressID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| IX_VendorAddress_AddressID
 +
|
 +
| AddressID
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Person.Address_(table)|Person.Address]]
 +
| AddressID
 +
| AddressID
 +
|- valign="top"
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
| AddressTypeID
 +
| AddressTypeID
 +
|- valign="top"
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
| 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]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 124:
 
| '''Table
 
| '''Table
 
| Purchasing.VendorAddress
 
| Purchasing.VendorAddress
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference mapping vendors and addresses.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 137:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| VendorID
 
| VendorID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_VendorAddress_VendorID_AddressID
+
| Primary key. Foreign key to Vendor.VendorID.<br />PK_VendorAddress_VendorID_AddressID
−
|
+
|- valign="top"
−
|-
 
 
| AddressID
 
| AddressID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_VendorAddress_VendorID_AddressID
+
| Primary key. Foreign key to Address.AddressID.<br />PK_VendorAddress_VendorID_AddressIDIX_VendorAddress_AddressID
−
| IX_VendorAddress_AddressID
+
|- valign="top"
−
|-
 
 
| AddressTypeID
 
| AddressTypeID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Address type. Foreign key to AddressType.AddressTypeID.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 68: Line 185:
 
| 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]]
 +
 
|}
 
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

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

Columns[edit]

Column Data Type Nullable Default Description
VendorID int not null Primary key. Foreign key to Vendor.VendorID.
AddressID int not null Primary key. Foreign key to Address.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.

Primary Key[edit]

Primary Key Columns
PK_VendorAddress_VendorID_AddressID VendorID, AddressID

Indexes[edit]

Index Type Columns
IX_VendorAddress_AddressID AddressID

Foreign Keys[edit]

Relation Column Referenced Column
Person.Address AddressID AddressID
Person.AddressType AddressTypeID AddressTypeID
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


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Schema Schema Purchasing


Reference Type Object Type Referencing Object
Select View Purchasing.vVendor
Retrieved from "http://dbshelp.devio.at/index.php?title=Purchasing.VendorAddress_(table)&oldid=2656"