Server: mysql.puroparty.com | Database: puroparty | Table: jos_bannerclient |
Field | Type | Null | Default |
---|---|---|---|
cid | int(11) | No | |
name | varchar(255) | No | |
contact | varchar(255) | No | |
varchar(255) | No | ||
extrainfo | text | No | |
checked_out | tinyint(1) | No | 0 |
checked_out_time | time | Yes | NULL |
editor | varchar(50) | Yes | NULL |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 1 | cid | |
cid_2 | UNIQUE | 1 | cid | |
name_2 | UNIQUE | 1 | name | |
contact_2 | UNIQUE | 1 | contact | |
email_2 | UNIQUE | 1 | ||
checked_out_2 | UNIQUE | 1 | checked_out | |
checked_out_3 | UNIQUE | 1 | checked_out | |
cid_3 | UNIQUE | 1 | cid | |
contact_4 | UNIQUE | 1 | contact | |
name_5 | UNIQUE | 1 | name | |
email_6 | UNIQUE | 1 | ||
name_7 | UNIQUE | 1 | name | |
checked_out_6 | UNIQUE | 1 | checked_out | |
cid_5 | UNIQUE | 1 | cid | |
email_9 | UNIQUE | 1 | ||
contact_8 | UNIQUE | 1 | contact | |
checked_out_7 | UNIQUE | 1 | checked_out | |
contact_11 | UNIQUE | 1 | contact | |
email_10 | UNIQUE | 1 | ||
checked_out_time_2 | UNIQUE | None | checked_out_time | |
editor_2 | UNIQUE | None | editor | |
editor_4 | UNIQUE | None | editor | |
checked_out_time_3 | UNIQUE | None | checked_out_time | |
checked_out_time_5 | UNIQUE | None | checked_out_time | |
editor_9 | UNIQUE | None | editor | |
cid | INDEX | None | cid | |
name | INDEX | None | name | |
contact | INDEX | None | contact | |
INDEX | None | |||
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
editor | INDEX | None | editor | |
email_4 | INDEX | None | ||
name_4 | INDEX | None | name | |
editor_5 | INDEX | None | editor | |
checked_out_4 | INDEX | None | checked_out | |
contact_5 | INDEX | None | contact | |
cid_4 | INDEX | None | cid | |
checked_out_time_4 | INDEX | None | checked_out_time | |
contact_7 | INDEX | None | contact | |
name_8 | INDEX | None | name | |
checked_out_5 | INDEX | None | checked_out | |
email_8 | INDEX | None | ||
editor_8 | INDEX | None | editor | |
cid_6 | INDEX | None | cid | |
checked_out_time_6 | INDEX | None | checked_out_time | |
contact_10 | INDEX | None | contact | |
name_3 | INDEX | None | name | |
contact_3 | INDEX | None | contact | |
email_3 | INDEX | None | ||
extrainfo | INDEX | None | extrainfo | |
editor_3 | INDEX | None | editor | |
editor_6 | INDEX | None | editor | |
name_6 | INDEX | None | name | |
email_5 | INDEX | None | ||
extrainfo_2 | INDEX | None | extrainfo | |
contact_6 | INDEX | None | contact | |
editor_7 | INDEX | None | editor | |
email_7 | INDEX | None | ||
name_9 | INDEX | None | name | |
extrainfo_3 | INDEX | None | extrainfo | |
contact_9 | INDEX | None | contact | |
extrainfo_4 | INDEX | None | extrainfo | |
editor_10 | INDEX | None | editor |
Space usage :
|
Row Statistic :
|