mysql.puroparty.com
puroparty
jos_bannerclient
| 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 :
|
|||||||||||||||||||||||||||||||