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

ads_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 0 coupon_id
coupon_id_2 UNIQUE 0 coupon_id
coupon_code_2 UNIQUE 0 coupon_code
coupon_percent_2 UNIQUE 0 coupon_percent
coupon_amount_2 UNIQUE 0 coupon_amount
coupon_expires_2 UNIQUE 0 coupon_expires
coupon_uses_2 UNIQUE 0 coupon_uses
coupon_restrict_2 UNIQUE 0 coupon_restrict
coupon_type_2 UNIQUE 0 coupon_type
coupon_id_4 UNIQUE 0 coupon_id
coupon_code_5 UNIQUE 0 coupon_code
coupon_percent_4 UNIQUE 0 coupon_percent
coupon_amount_4 UNIQUE 0 coupon_amount
coupon_expires_4 UNIQUE 0 coupon_expires
coupon_uses_4 UNIQUE 0 coupon_uses
coupon_restrict_4 UNIQUE 0 coupon_restrict
coupon_type_4 UNIQUE 0 coupon_type
coupon_restrict_5 UNIQUE 0 coupon_restrict
coupon_id_5 UNIQUE 0 coupon_id
coupon_expires_6 UNIQUE 0 coupon_expires
coupon_percent_6 UNIQUE 0 coupon_percent
coupon_amount_5 UNIQUE 0 coupon_amount
coupon_code_9 UNIQUE 0 coupon_code
coupon_uses_6 UNIQUE 0 coupon_uses
coupon_type_6 UNIQUE 0 coupon_type
coupon_expires_7 UNIQUE 0 coupon_expires
coupon_id_8 UNIQUE 0 coupon_id
coupon_restrict_8 UNIQUE 0 coupon_restrict
coupon_code_12 UNIQUE 0 coupon_code
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_id_3 INDEX None coupon_id
coupon_code_4 INDEX None coupon_code
coupon_percent_3 INDEX None coupon_percent
coupon_amount_3 INDEX None coupon_amount
coupon_expires_3 INDEX None coupon_expires
coupon_uses_3 INDEX None coupon_uses
coupon_restrict_3 INDEX None coupon_restrict
coupon_type_3 INDEX None coupon_type
coupon_uses_5 INDEX None coupon_uses
coupon_type_5 INDEX None coupon_type
coupon_restrict_6 INDEX None coupon_restrict
coupon_expires_5 INDEX None coupon_expires
coupon_percent_5 INDEX None coupon_percent
coupon_code_7 INDEX None coupon_code
coupon_id_6 INDEX None coupon_id
coupon_amount_6 INDEX None coupon_amount
coupon_code_10 INDEX None coupon_code
coupon_id_7 INDEX None coupon_id
coupon_percent_7 INDEX None coupon_percent
coupon_expires_8 INDEX None coupon_expires
coupon_uses_7 INDEX None coupon_uses
coupon_restrict_7 INDEX None coupon_restrict
coupon_type_7 INDEX None coupon_type
coupon_code_3 INDEX None coupon_code
coupon_code_6 INDEX None coupon_code
coupon_code_8 INDEX None coupon_code
coupon_code_11 INDEX None coupon_code


 Space usage :
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Feb 17, 2018 at 04:32 PM
Last update Apr 08, 2018 at 03:33 PM
Last check Apr 08, 2018 at 03:33 PM