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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   float(6,2)     No  0.00    Change Drop Primary Index Unique Fulltext
   date     No  0000-00-00    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop coupon_id
coupon_id_2 UNIQUE Edit Drop coupon_id
coupon_code_2 UNIQUE Edit Drop coupon_code
coupon_expires_2 UNIQUE Edit Drop coupon_expires
coupon_uses_2 UNIQUE Edit Drop coupon_uses
coupon_expires_3 UNIQUE Edit Drop coupon_expires
coupon_uses_4 UNIQUE Edit Drop coupon_uses
coupon_code_5 UNIQUE Edit Drop coupon_code
coupon_id_4 UNIQUE Edit Drop coupon_id
coupon_id_6 UNIQUE Edit Drop coupon_id
coupon_code_8 UNIQUE Edit Drop coupon_code
coupon_expires_6 UNIQUE Edit Drop coupon_expires
coupon_uses_6 UNIQUE Edit Drop coupon_uses
coupon_expires_8 UNIQUE Edit Drop coupon_expires
coupon_code_11 UNIQUE Edit Drop coupon_code
coupon_uses_7 UNIQUE Edit Drop coupon_uses
coupon_id_8 UNIQUE Edit Drop coupon_id
coupon_code_13 UNIQUE Edit Drop coupon_code
coupon_uses_10 UNIQUE Edit Drop coupon_uses
coupon_code_14 UNIQUE Edit Drop coupon_code
coupon_expires_10 UNIQUE Edit Drop coupon_expires
coupon_id INDEX None  Edit Drop coupon_id
coupon_code INDEX None  Edit Drop coupon_code
coupon_percent INDEX None  Edit Drop coupon_percent
coupon_amount INDEX None  Edit Drop coupon_amount
coupon_expires INDEX None  Edit Drop coupon_expires
coupon_uses INDEX None  Edit Drop coupon_uses
coupon_restrict INDEX None  Edit Drop coupon_restrict
coupon_type INDEX None  Edit Drop coupon_type
coupon_percent_2 INDEX None  Edit Drop coupon_percent
coupon_code_4 INDEX None  Edit Drop coupon_code
coupon_amount_2 INDEX None  Edit Drop coupon_amount
coupon_restrict_2 INDEX None  Edit Drop coupon_restrict
coupon_expires_4 INDEX None  Edit Drop coupon_expires
coupon_uses_3 INDEX None  Edit Drop coupon_uses
coupon_id_3 INDEX None  Edit Drop coupon_id
coupon_type_2 INDEX None  Edit Drop coupon_type
coupon_id_5 INDEX None  Edit Drop coupon_id
coupon_code_7 INDEX None  Edit Drop coupon_code
coupon_percent_3 INDEX None  Edit Drop coupon_percent
coupon_amount_3 INDEX None  Edit Drop coupon_amount
coupon_expires_5 INDEX None  Edit Drop coupon_expires
coupon_uses_5 INDEX None  Edit Drop coupon_uses
coupon_restrict_3 INDEX None  Edit Drop coupon_restrict
coupon_type_3 INDEX None  Edit Drop coupon_type
coupon_expires_7 INDEX None  Edit Drop coupon_expires
coupon_id_7 INDEX None  Edit Drop coupon_id
coupon_percent_4 INDEX None  Edit Drop coupon_percent
coupon_code_10 INDEX None  Edit Drop coupon_code
coupon_restrict_4 INDEX None  Edit Drop coupon_restrict
coupon_amount_4 INDEX None  Edit Drop coupon_amount
coupon_type_4 INDEX None  Edit Drop coupon_type
coupon_uses_8 INDEX None  Edit Drop coupon_uses
coupon_percent_5 INDEX None  Edit Drop coupon_percent
coupon_amount_5 INDEX None  Edit Drop coupon_amount
coupon_uses_9 INDEX None  Edit Drop coupon_uses
coupon_type_5 INDEX None  Edit Drop coupon_type
coupon_expires_9 INDEX None  Edit Drop coupon_expires
coupon_code_15 INDEX None  Edit Drop coupon_code
coupon_id_9 INDEX None  Edit Drop coupon_id
coupon_code_3 FULLTEXT None  Edit Drop coupon_code
coupon_code_6 FULLTEXT None  Edit Drop coupon_code
coupon_code_9 FULLTEXT None  Edit Drop coupon_code
coupon_code_12 FULLTEXT None  Edit Drop coupon_code
Create an index on  columns  
 
Space usage: 
Type Usage
Data 48 Bytes
Index 3,072 Bytes
Total 3,120 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
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

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: