<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > ProPromotionBonusBuysMaster Table > Indexes > IX_ProPromotionBonusBuysMaster Index |
Navigation: iVend Database Database > Tables > ProPromotionBonusBuysMaster Table > Indexes >
iVend 6.6 Database Help
IX_ProPromotionBonusBuysMaster Index
Collapse All Expand All
iVend Database Database > ProPromotionBonusBuysMaster Table : IX_ProPromotionBonusBuysMaster 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 |
|
IsDeleted |
Value is True if the record has been deleted from the system. Record is always Soft Deleted |
Ascending |
|
Active |
Value is True if the promotion is active. |
Ascending |
|
EndDate |
Stores the End Time to which the promotion ends if the HasValidTime value is true. |
Ascending |
|
StartDate |
Stores the start date if HasValidDates value is true. |
Ascending |
Index Statistics
Average key length |
30.00 |
Density |
0.00 |
Rows in the Table |
6 |
Rows Sampled |
6 |
Distribution Steps |
1 |
Updated |
Oct 8 2018 5:57PM |
See Also
ProPromotionBonusBuysMaster Table
© 2019 All Rights Reserved.
Send comments on this topic.