Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bos_couponsbos_coupons

bos_coupons

Field Type Null Default
coupon_id  int(11) No   
coupon_code  varchar(255) No   
coupon_percent  tinyint(3) No 
coupon_amount  float(6,2) No  0.00 
coupon_expires  date No  0000-00-00 
coupon_uses  int(5) No 
coupon_restrict  tinyint(1) No 
coupon_type  tinyint(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 2 coupon_id
coupon_id_2 UNIQUE 2 coupon_id
coupon_code_2 UNIQUE 2 coupon_code
coupon_expires_2 UNIQUE 2 coupon_expires
coupon_uses_2 UNIQUE 2 coupon_uses
coupon_expires_3 UNIQUE 2 coupon_expires
coupon_uses_4 UNIQUE 2 coupon_uses
coupon_code_5 UNIQUE 2 coupon_code
coupon_id_4 UNIQUE 2 coupon_id
coupon_id_6 UNIQUE 2 coupon_id
coupon_code_8 UNIQUE 2 coupon_code
coupon_expires_6 UNIQUE 2 coupon_expires
coupon_uses_6 UNIQUE 2 coupon_uses
coupon_expires_8 UNIQUE 2 coupon_expires
coupon_code_11 UNIQUE 2 coupon_code
coupon_uses_7 UNIQUE 2 coupon_uses
coupon_id_8 UNIQUE 2 coupon_id
coupon_code_13 UNIQUE 2 coupon_code
coupon_uses_10 UNIQUE 2 coupon_uses
coupon_code_14 UNIQUE 2 coupon_code
coupon_expires_10 UNIQUE 2 coupon_expires
coupon_id INDEX None coupon_id
coupon_code INDEX None coupon_code
coupon_percent INDEX None coupon_percent
coupon_amount INDEX None coupon_amount
coupon_expires INDEX None coupon_expires
coupon_uses INDEX None coupon_uses
coupon_restrict INDEX None coupon_restrict
coupon_type INDEX None coupon_type
coupon_percent_2 INDEX None coupon_percent
coupon_code_4 INDEX None coupon_code
coupon_amount_2 INDEX None coupon_amount
coupon_restrict_2 INDEX None coupon_restrict
coupon_expires_4 INDEX None coupon_expires
coupon_uses_3 INDEX None coupon_uses
coupon_id_3 INDEX None coupon_id
coupon_type_2 INDEX None coupon_type
coupon_id_5 INDEX None coupon_id
coupon_code_7 INDEX None coupon_code
coupon_percent_3 INDEX None coupon_percent
coupon_amount_3 INDEX None coupon_amount
coupon_expires_5 INDEX None coupon_expires
coupon_uses_5 INDEX None coupon_uses
coupon_restrict_3 INDEX None coupon_restrict
coupon_type_3 INDEX None coupon_type
coupon_expires_7 INDEX None coupon_expires
coupon_id_7 INDEX None coupon_id
coupon_percent_4 INDEX None coupon_percent
coupon_code_10 INDEX None coupon_code
coupon_restrict_4 INDEX None coupon_restrict
coupon_amount_4 INDEX None coupon_amount
coupon_type_4 INDEX None coupon_type
coupon_uses_8 INDEX None coupon_uses
coupon_percent_5 INDEX None coupon_percent
coupon_amount_5 INDEX None coupon_amount
coupon_uses_9 INDEX None coupon_uses
coupon_type_5 INDEX None coupon_type
coupon_expires_9 INDEX None coupon_expires
coupon_code_15 INDEX None coupon_code
coupon_id_9 INDEX None coupon_id
coupon_code_3 INDEX None coupon_code
coupon_code_6 INDEX None coupon_code
coupon_code_9 INDEX None coupon_code
coupon_code_12 INDEX None coupon_code


 Space usage :
Type Usage
Data 48 Bytes
Index 3,072 Bytes
Total 3,120 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 2
Row length ø 24
Row size  ø 1,560 Bytes
Next Autoindex 6
Creation Feb 25, 2018 at 04:22 PM
Last update Mar 29, 2018 at 02:20 PM
Last check Mar 29, 2018 at 02:20 PM