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

bak_bannerclient

Field Type Null Default
cid  int(11) No   
name  varchar(255) No   
contact  varchar(255) No   
email  varchar(255) No   
extrainfo  text No   
checked_out  tinyint(1) No 
checked_out_time  time Yes  NULL 
editor  varchar(50) Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 cid
cid_2 UNIQUE 0 cid
name_2 UNIQUE 0 name
contact_2 UNIQUE 0 contact
email_2 UNIQUE 0 email
checked_out_2 UNIQUE 0 checked_out
contact_4 UNIQUE 0 contact
cid_3 UNIQUE 0 cid
email_6 UNIQUE 0 email
checked_out_4 UNIQUE 0 checked_out
name_6 UNIQUE 0 name
name_7 UNIQUE 0 name
contact_9 UNIQUE 0 contact
email_9 UNIQUE 0 email
cid_6 UNIQUE 0 cid
checked_out_6 UNIQUE 0 checked_out
cid_8 UNIQUE 0 cid
name_11 UNIQUE 0 name
checked_out_time_2 UNIQUE None checked_out_time
editor_2 UNIQUE None editor
editor_4 UNIQUE None editor
checked_out_time_4 UNIQUE None checked_out_time
editor_7 UNIQUE None editor
checked_out_time_6 UNIQUE None checked_out_time
cid INDEX None cid
name INDEX None name
contact INDEX None contact
email INDEX None email
checked_out INDEX None checked_out
checked_out_time INDEX None checked_out_time
editor INDEX None editor
checked_out_3 INDEX None checked_out
email_4 INDEX None email
name_4 INDEX None name
checked_out_time_3 INDEX None checked_out_time
editor_5 INDEX None editor
cid_4 INDEX None cid
contact_6 INDEX None contact
checked_out_time_5 INDEX None checked_out_time
email_8 INDEX None email
contact_8 INDEX None contact
checked_out_5 INDEX None checked_out
name_8 INDEX None name
cid_5 INDEX None cid
editor_9 INDEX None editor
cid_7 INDEX None cid
name_10 INDEX None name
contact_10 INDEX None contact
name_3 INDEX None name
contact_3 INDEX None contact
email_3 INDEX None email
extrainfo INDEX None extrainfo
editor_3 INDEX None editor
email_5 INDEX None email
name_5 INDEX None name
contact_5 INDEX None contact
extrainfo_2 INDEX None extrainfo
editor_6 INDEX None editor
contact_7 INDEX None contact
extrainfo_3 INDEX None extrainfo
editor_8 INDEX None editor
email_7 INDEX None email
name_9 INDEX None name
name_12 INDEX None name


 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 Nov 21, 2017 at 10:44 PM
Last update Apr 06, 2018 at 01:38 PM
Last check Apr 06, 2018 at 01:38 PM