From dbscript Online Help
wikibot
Table
|
Purchasing.VendorAddress
|
Description
|
Cross-reference mapping vendors and addresses.
|
Columns
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
Primary Key
|
Columns
|
PK_VendorAddress_VendorID_AddressID
|
VendorID, AddressID
|
Indexes
Index
|
Type
|
Columns
|
IX_VendorAddress_AddressID
|
|
AddressID
|
Foreign Keys
References
Dependency Type
|
Object Type
|
Referenced Object
|
Schema
|
Schema
|
Purchasing
|
Dependencies
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.
|
Dependency Type
|
Object Type
|
Referenced Object
|
Schema
|
Schema
|
Purchasing
|