mysql.puroparty.com
puroparty
bosdevUUS
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: bosdevUUS
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(5) | No | |
| username | varchar(255) | No | |
| password | varchar(255) | No | |
| varchar(255) | No | ||
| status | tinyint(1) | No | 0 |
| last_login | date | No | 0000-00-00 |
| bd1 | tinyint(2) | No | 0 |
| bd2 | varchar(255) | No | |
| bd3 | varchar(255) | No | |
| bd4 | varchar(255) | No | |
| bd5 | varchar(255) | No | |
| bc1 | tinyint(2) | No | 0 |
| bc2 | varchar(255) | No | 0 |
| bc3 | varchar(255) | No | |
| bc4 | varchar(255) | No | |
| bc5 | varchar(255) | No | |
| bdir1 | tinyint(2) | No | 0 |
| bdir2 | varchar(255) | No | |
| bdir3 | varchar(255) | No | |
| bdir4 | varchar(255) | No | |
| bdir5 | varchar(255) | No | |
| bm1 | tinyint(2) | No | 0 |
| bm2 | varchar(255) | No | |
| bm3 | varchar(255) | No | |
| bm4 | varchar(255) | No | |
| bm5 | varchar(255) | No | |
| bn1 | tinyint(2) | No | 0 |
| bn2 | varchar(255) | No | |
| bn3 | varchar(255) | No | |
| bn4 | varchar(255) | No | |
| bn5 | varchar(255) | No | |
| bf1 | varchar(255) | No | |
| bf2 | varchar(255) | No | |
| bf3 | varchar(255) | No | |
| bf4 | varchar(255) | No | |
| bf5 | varchar(255) | No | |
| bdl | varchar(255) | No | |
| extraFName | varchar(255) | No | |
| extraLName | varchar(255) | No | |
| extraAddr1 | varchar(255) | No | |
| extraAddr2 | varchar(255) | No | |
| extraCity | varchar(255) | No | |
| extraState | varchar(255) | No | |
| extraPostal | varchar(255) | No | |
| extraHPhone | varchar(255) | No | |
| extraMPhone | varchar(255) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | id | |
| id_2 | UNIQUE | 0 | id | |
| username_2 | UNIQUE | 0 | username | |
| email_2 | UNIQUE | 0 | ||
| bf3_2 | UNIQUE | 0 | bf3 | |
| id | INDEX | None | id | |
| username | INDEX | None | username | |
| password | INDEX | None | password | |
| INDEX | None | |||
| status | INDEX | None | status | |
| last_login | INDEX | None | last_login | |
| bd1 | INDEX | None | bd1 | |
| bd2 | INDEX | None | bd2 | |
| bd3 | INDEX | None | bd3 | |
| bd4 | INDEX | None | bd4 | |
| bd5 | INDEX | None | bd5 | |
| bc1 | INDEX | None | bc1 | |
| bc2 | INDEX | None | bc2 | |
| bc3 | INDEX | None | bc3 | |
| bc4 | INDEX | None | bc4 | |
| bc5 | INDEX | None | bc5 | |
| bdir1 | INDEX | None | bdir1 | |
| bdir2 | INDEX | None | bdir2 | |
| bdir3 | INDEX | None | bdir3 | |
| bdir4 | INDEX | None | bdir4 | |
| bdir5 | INDEX | None | bdir5 | |
| bm1 | INDEX | None | bm1 | |
| bm2 | INDEX | None | bm2 | |
| bm3 | INDEX | None | bm3 | |
| bm4 | INDEX | None | bm4 | |
| bm5 | INDEX | None | bm5 | |
| bn1 | INDEX | None | bn1 | |
| bn2 | INDEX | None | bn2 | |
| bn3 | INDEX | None | bn3 | |
| bn4 | INDEX | None | bn4 | |
| bn5 | INDEX | None | bn5 | |
| bf1 | INDEX | None | bf1 | |
| bf2 | INDEX | None | bf2 | |
| bf3 | INDEX | None | bf3 | |
| username_3 | INDEX | None | username | |
| password_2 | INDEX | None | password | |
| email_3 | INDEX | None | ||
| bd2_2 | INDEX | None | bd2 | |
| bd3_2 | INDEX | None | bd3 | |
| bd4_2 | INDEX | None | bd4 | |
| bd5_2 | INDEX | None | bd5 | |
| bc2_2 | INDEX | None | bc2 | |
| bc3_2 | INDEX | None | bc3 | |
| bc4_2 | INDEX | None | bc4 | |
| bc5_2 | INDEX | None | bc5 | |
| bdir2_2 | INDEX | None | bdir2 | |
| bdir3_2 | INDEX | None | bdir3 | |
| bdir4_2 | INDEX | None | bdir4 | |
| bdir5_2 | INDEX | None | bdir5 | |
| bm2_2 | INDEX | None | bm2 | |
| bm3_2 | INDEX | None | bm3 | |
| bm4_2 | INDEX | None | bm4 | |
| bm5_2 | INDEX | None | bm5 | |
| bn2_2 | INDEX | None | bn2 | |
| bn3_2 | INDEX | None | bn3 | |
| bn4_2 | INDEX | None | bn4 | |
| bn5_2 | INDEX | None | bn5 | |
| bf1_2 | INDEX | None | bf1 | |
| bf2_2 | INDEX | None | bf2 | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||