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

InnoDB free: 778240 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

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

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 14  Edit Drop id
id_2 UNIQUE 14  Edit Drop id
id_3 UNIQUE 14  Edit Drop id
id_6 UNIQUE 14  Edit Drop id
id_7 UNIQUE 14  Edit Drop id
id_10 UNIQUE 14  Edit Drop id
id_12 UNIQUE 14  Edit Drop id
id_14 UNIQUE 14  Edit Drop id
email_user_access_userid_idx INDEX Edit Drop userid
userid INDEX Edit Drop userid
area INDEX Edit Drop area
id INDEX 14  Edit Drop id
id_4 INDEX 14  Edit Drop id
userid_2 INDEX Edit Drop userid
area_2 INDEX Edit Drop area
area_3 INDEX Edit Drop area
id_5 INDEX 14  Edit Drop id
userid_3 INDEX Edit Drop userid
id_8 INDEX 14  Edit Drop id
userid_4 INDEX Edit Drop userid
area_4 INDEX Edit Drop area
id_9 INDEX 14  Edit Drop id
area_5 INDEX Edit Drop area
userid_5 INDEX Edit Drop userid
userid_6 INDEX Edit Drop userid
id_11 INDEX 14  Edit Drop id
userid_7 INDEX Edit Drop userid
area_6 INDEX Edit Drop area
id_13 INDEX 14  Edit Drop id
area_7 INDEX Edit Drop area
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 475,136 Bytes
Total 491,520 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Apr 23, 2018 at 09:08 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: