AdventureWorks - Sales.SpecialOffer

AdventureWorks

Basic Index Expanded Index

Table Name:	Sales.SpecialOffer
Description:	Sale discounts lookup table.
Primary Keys:	SpecialOfferID

Field	Type	Defaults	Nulls?	Comments
SpecialOfferID	int - Identity	None	No	Primary key for SpecialOffer records.
Description	nvarchar (255)	None	No	Discount description.
DiscountPct	smallmoney	((0.00))	No	Discount precentage.
Type	nvarchar (50)	None	No	Discount type category.
Category	nvarchar (50)	None	No	Group the discount applies to such as Reseller or Customer.
StartDate	datetime	None	No	Discount start date.
EndDate	datetime	None	No	Discount end date.
MinQty	int	((0))	No	Minimum discount percent allowed.
MaxQty	int	None	Yes	Maximum discount percent allowed.
rowguid	uniqueidentifier	(newid())	No	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	(getdate())	No	Date and time the record was last updated.

Index	Clustered?	Unique?	Fields
PK_SpecialOffer_SpecialOfferID	Yes	Yes	SpecialOfferID
AK_SpecialOffer_rowguid	No	Yes	rowguid

Check Constraint	Text
CK_SpecialOffer_EndDate	([EndDate]>=[StartDate])
CK_SpecialOffer_DiscountPct	([DiscountPct]>=(0.00))
CK_SpecialOffer_MinQty	([MinQty]>=(0))
CK_SpecialOffer_MaxQty	([MaxQty]>=(0))

No internal foreign key constraints

Primary Key as Foreign Key Constraint	Affected Table	Affected Field
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID	Sales.SpecialOfferProduct	SpecialOfferID

No triggers