Owner: | Purchasing |
Creation Date: | 04/26/2006 |
Located On: | PRIMARY |
Data Size KB: | 8 |
Index Size KB: | 24 |
Rows: | 104 |
Description: | Cross-reference mapping vendors and addresses. |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
VendorID | int | 4 | Primary key. Foreign key to Vendor.VendorID. | ||||||
AddressID | int | 4 | Primary key. Foreign key to Address.AddressID. | ||||||
AddressTypeID | int | 4 | Address type. Foreign key to AddressType.AddressTypeID. | ||||||
ModifiedDate | datetime | 8 | (getdate()) | Date and time the record was last updated. |
Index | Primary | Unique | Description | |
PK_VendorAddress_VendorID_AddressID | Primary key (clustered) constraint | |||
IX_VendorAddress_AddressID | Nonclustered index. |
Table | Foreign Key | Primary Key or Unique Constraint | |
Person.Address | FK_VendorAddress_Address_AddressID | PK_Address_AddressID | |
Person.AddressType | FK_VendorAddress_AddressType_AddressTypeID | PK_AddressType_AddressTypeID | |
Purchasing.Vendor | FK_VendorAddress_Vendor_VendorID | PK_Vendor_VendorID |
Objects that [Purchasing].[VendorAddress] depends on
Object Name | Owner | Object Type | Dep Level | |
AccountNumber | dbo | User Defined type | 1 | |
Flag | dbo | User Defined type | 1 | |
Name | dbo | User Defined type | 1 | |
AddressType | Person | Table | 2 | |
CountryRegion | Person | Table | 2 | |
SalesTerritory | Sales | Table | 2 | |
Vendor | Purchasing | Table | 2 | |
StateProvince | Person | Table | 3 | |
Address | Person | Table | 4 |
Objects that depend on [Purchasing].[VendorAddress]
Object Name | Owner | Object Type | Dep Level | |
vVendor | Purchasing | View | 1 |
CREATE TABLE [VendorAddress] (
[VendorID] [int] NOT NULL ,
[AddressID] [int] NOT NULL ,
[AddressTypeID] [int] NOT NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_VendorAddress_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_VendorAddress_VendorID_AddressID] PRIMARY KEY CLUSTERED
(
[VendorID],
[AddressID]
) ON [PRIMARY] ,
CONSTRAINT [FK_VendorAddress_Address_AddressID] FOREIGN KEY
(
[AddressID]
) REFERENCES [Address] (
[AddressID]
),
CONSTRAINT [FK_VendorAddress_AddressType_AddressTypeID] FOREIGN KEY
(
[AddressTypeID]
) REFERENCES [AddressType] (
[AddressTypeID]
),
CONSTRAINT [FK_VendorAddress_Vendor_VendorID] FOREIGN KEY
(
[VendorID]
) REFERENCES [Vendor] (
[VendorID]
)
) ON [PRIMARY]
GO
See Also
List of tables