Navigation: iVend Database Database > Tables > ProCouponCondition Table > Indexes >
iVend 6.6 Database Help
IX_ProCouponCondition Index
Collapse All Expand All
iVend Database Database > ProCouponCondition Table : IX_ProCouponCondition Index |
Properties
File Group |
PRIMARY |
Space Used |
16.00 KB |
Fill Factor |
0 |
Do not Recompute Statistics |
|
Full Text Key |
|
Clustered Index |
|
Primary Key Index |
|
Unique Index |
|
Pad Index |
|
Columns
|
Column |
Description |
Sort Order |
|
CouponKey |
Reference Key of Coupon Key. See also inventory Coupon |
Ascending |
|
SourceKey |
Specifies the Source key based on chosen Source type |
Ascending |
|
SourceType |
Specifies the Source type for Coupon. Valid values are: product = 0 product group = 1 product category = 2 manufacturer = 3 customer group = 4 |
Ascending |
Index Statistics
Average key length |
88.00 |
Density |
0.50 |
Rows in the Table |
53 |
Rows Sampled |
53 |
Distribution Steps |
6 |
Updated |
Oct 8 2018 5:57PM |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.