Sales.SalesReason Table

Description

Lookup table of customer purchase reasons.

Properties

Creation Date	17/07/2014 16:11
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	10
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length	Default
SalesReasonID	Primary key for SalesReason records.	Integer	4
Name	Sales reason description.	dbo.Name	50
ReasonType	Category the sales reason belongs to.	dbo.Name	50
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
PK_SalesReason_SalesReasonID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	Foreign key constraint referencing SalesReason.SalesReasonID.

Objects that depend on Sales.SalesReason

	Database Object	Object Type	Description	Dep Level
	Sales.SalesOrderHeaderSalesReason	Table	Cross-reference table mapping sales orders to sales reason codes.	1

Objects that Sales.SalesReason depends on

	Database Object	Object Type	Description	Dep Level
	dbo.Name	User Defined Data Type		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[SalesReason](
    [SalesReasonID] [int] IDENTITY(1,1) NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [ReasonType] [dbo].[Name] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_SalesReason_SalesReasonID] PRIMARY KEY CLUSTERED 
(
    [SalesReasonID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Sales].[SalesReason] ADD  CONSTRAINT [DF_SalesReason_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Sales Schema
AdventureWorks Database