.

Generated using SQL Data Dictionary demo version.

Table dbo.Affiliates (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	AffiliateId	int	X
FK	VendorId	int		X
	StartDate	datetime		X
	EndDate	datetime		X
	CPC	float
	Clicks	int
	CPA	float
	Acquisitions	int

Indexes:

PK_Affiliates
- (Primary Key)
- (Clustered)
- AffiliateId

References:

dbo.Vendors
- VendorId

Used by:

Procedure
dbo.AddAffiliate
Procedure
dbo.DeleteAffiliate
Procedure
dbo.GetAffiliate
Procedure
dbo.GetAffiliates
Procedure
dbo.UpdateAffiliate
Procedure
dbo.UpdateAffiliateStats