Properties

Owner:	Sales
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	688
Index Size KB:	16
Rows:	27647
Description:	Cross-reference table mapping sales orders to sales reason codes.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		SalesOrderID	int	4					Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
		SalesReasonID	int	4					Primary key. Foreign key to SalesReason.SalesReasonID.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.

Total: 3 column(s)

Indexes

	Index	Primary	Unique	Description
	PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID			Primary key (clustered) constraint

Total: 1 index(es)

Referenced Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Sales.SalesOrderHeader	FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID	PK_SalesOrderHeader_SalesOrderID
	Sales.SalesReason	FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	PK_SalesReason_SalesReasonID

Total: 2 table(s)

Objects that [Sales].[SalesOrderHeaderSalesReason] 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
	NameStyle	dbo	User Defined type	1
	OrderNumber	dbo	User Defined type	1
	Phone	dbo	User Defined type	1
	ufnLeadingZeros	dbo	Function	2
	Contact	Person	Table	2
	CountryRegion	Person	Table	2
	CreditCard	Sales	Table	2
	Currency	Sales	Table	2
	SalesReason	Sales	Table	2
	SalesTerritory	Sales	Table	2
	ShipMethod	Purchasing	Table	2
	CurrencyRate	Sales	Table	3
	Customer	Sales	Table	3
	Employee	HumanResources	Table	3
	StateProvince	Person	Table	3
	Address	Person	Table	4
	SalesPerson	Sales	Table	4
	SalesOrderHeader	Sales	Table	5

Total: 21 object(s)

SQL

CREATE TABLE [SalesOrderHeaderSalesReason] (
    [SalesOrderID] [int] NOT NULL ,
    [SalesReasonID] [int] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_SalesOrderHeaderSalesReason_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID] PRIMARY KEY  CLUSTERED
    (
        [SalesOrderID],
        [SalesReasonID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID] FOREIGN KEY
    (
        [SalesOrderID]
    ) REFERENCES [SalesOrderHeader] (
        [SalesOrderID]
    ) ON DELETE CASCADE ,
    CONSTRAINT [FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID] FOREIGN KEY
    (
        [SalesReasonID]
    ) REFERENCES [SalesReason] (
        [SalesReasonID]
    )
) ON [PRIMARY]
GO

See Also

List of tables