Sales.SpecialOffer - AdventureWorks

Sale discounts lookup table.

Columns

		Name	Data type	Attributes	Description
	1	SpecialOfferID	int	Identity	Primary key for SpecialOffer records.
Primary key for SpecialOffer records. Identity
	2	Description	nvarchar(255)		Discount description.
Discount description.
	3	DiscountPct	smallmoney	Default: 0.00	Discount precentage.
Discount precentage. Default: 0.00
	4	Type	nvarchar(50)		Discount type category.
Discount type category.
	5	Category	nvarchar(50)		Group the discount applies to such as Reseller or Customer.
Group the discount applies to such as Reseller or Customer.
	6	StartDate	datetime		Discount start date.
Discount start date.
	7	EndDate	datetime		Discount end date.
Discount end date.
	8	MinQty	int	Default: 0	Minimum discount percent allowed.
Minimum discount percent allowed. Default: 0
	9	MaxQty	int		Maximum discount percent allowed.
Maximum discount percent allowed.
	10	rowguid	uniqueidentifier	Default: newid()	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	11	ModifiedDate	datetime	Default: getdate()	Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Sales.SpecialOfferProduct		Sales.SpecialOffer	Sales.SpecialOfferProduct.SpecialOfferID = Sales.SpecialOffer.SpecialOfferID	FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Foreign key constraint referencing SpecialOffer.SpecialOfferID.
Sales.SpecialOfferProduct.SpecialOfferID = Sales.SpecialOffer.SpecialOfferID Name: FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Foreign key constraint referencing SpecialOffer.SpecialOfferID.

Unique keys

	Key name	Columns	Description
	PK_SpecialOffer_SpecialOfferID	SpecialOfferID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_SpecialOffer_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Used by

Name
Sales.SpecialOffer
Sales.SpecialOfferProduct

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56