mysql.puroparty.com
puroparty
photopost_comments
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: photopost_comments
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| username | varchar(32) | No | |
| userid | int(11) | No | 0 |
| date | int(15) | No | 0 |
| rating | float(12,2) | Yes | NULL |
| comment | text | No | |
| photo | int(11) | No | 0 |
| cat | int(11) | No | 0 |
| approved | int(2) | No | 0 |
| ipaddress | varchar(32) | Yes | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | id | |
| id_2 | UNIQUE | 0 | id | |
| username_2 | UNIQUE | 0 | username | |
| userid_2 | UNIQUE | 0 | userid | |
| date_2 | UNIQUE | 0 | date | |
| photo_3 | UNIQUE | 0 | photo | |
| cat_3 | UNIQUE | 0 | cat | |
| approved_2 | UNIQUE | 0 | approved | |
| date_3 | UNIQUE | 0 | date | |
| username_5 | UNIQUE | 0 | username | |
| userid_3 | UNIQUE | 0 | userid | |
| cat_4 | UNIQUE | 0 | cat | |
| approved_3 | UNIQUE | 0 | approved | |
| photo_4 | UNIQUE | 0 | photo | |
| id_3 | UNIQUE | 0 | id | |
| id_5 | UNIQUE | 0 | id | |
| approved_6 | UNIQUE | 0 | approved | |
| date_5 | UNIQUE | 0 | date | |
| photo_6 | UNIQUE | 0 | photo | |
| userid_6 | UNIQUE | 0 | userid | |
| cat_7 | UNIQUE | 0 | cat | |
| username_9 | UNIQUE | 0 | username | |
| rating_2 | UNIQUE | None | rating | |
| ipaddress_2 | UNIQUE | None | ipaddress | |
| rating_3 | UNIQUE | None | rating | |
| ipaddress_5 | UNIQUE | None | ipaddress | |
| rating_5 | UNIQUE | None | rating | |
| ipaddress_8 | UNIQUE | None | ipaddress | |
| photo | INDEX | None | photo | |
| cat | INDEX | None | cat | |
| id | INDEX | None | id | |
| username | INDEX | None | username | |
| userid | INDEX | None | userid | |
| date | INDEX | None | date | |
| rating | INDEX | None | rating | |
| photo_2 | INDEX | None | photo | |
| cat_2 | INDEX | None | cat | |
| approved | INDEX | None | approved | |
| ipaddress | INDEX | None | ipaddress | |
| rating_4 | INDEX | None | rating | |
| username_6 | INDEX | None | username | |
| date_4 | INDEX | None | date | |
| ipaddress_4 | INDEX | None | ipaddress | |
| cat_5 | INDEX | None | cat | |
| photo_5 | INDEX | None | photo | |
| userid_4 | INDEX | None | userid | |
| id_4 | INDEX | None | id | |
| approved_4 | INDEX | None | approved | |
| approved_5 | INDEX | None | approved | |
| userid_5 | INDEX | None | userid | |
| ipaddress_7 | INDEX | None | ipaddress | |
| date_6 | INDEX | None | date | |
| cat_6 | INDEX | None | cat | |
| username_8 | INDEX | None | username | |
| photo_7 | INDEX | None | photo | |
| rating_6 | INDEX | None | rating | |
| id_6 | INDEX | None | id | |
| username_3 | INDEX | None | username | |
| comment | INDEX | None | comment | |
| ipaddress_3 | INDEX | None | ipaddress | |
| username_4 | INDEX | None | username | |
| ipaddress_6 | INDEX | None | ipaddress | |
| comment_2 | INDEX | None | comment | |
| username_7 | INDEX | None | username | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||