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

extcal_1users

Table comments : Table for calendar users

Field Type Null Default
user_id  int(11) No   
username  varchar(30) No   
password  varchar(64) No   
firstname  varchar(64) Yes   
lastname  varchar(64) Yes   
group_id  int(11) No 
lastvisit  datetime No  0000-00-00 00:00:00 
email  varchar(255) No   
user_regdate  datetime No  0000-00-00 00:00:00 
user_lang  varchar(255) No   
user_website  varchar(255) No   
user_location  varchar(255) No   
user_occupation  varchar(255) No   
reg_key  varchar(64) Yes  NULL 
user_status  tinyint(1) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 15 user_id
username UNIQUE 15 username
user_id_2 UNIQUE 15 user_id
username_3 UNIQUE 15 username
lastvisit_2 UNIQUE 15 lastvisit
email_2 UNIQUE 15 email
user_regdate_2 UNIQUE 15 user_regdate
username_5 UNIQUE 15 username
email_4 UNIQUE 15 email
user_id_4 UNIQUE 15 user_id
lastvisit_4 UNIQUE 15 lastvisit
user_regdate_4 UNIQUE 15 user_regdate
user_id INDEX None user_id
username_2 INDEX None username
password INDEX None password
firstname INDEX None firstname
lastname INDEX None lastname
group_id INDEX None group_id
lastvisit INDEX None lastvisit
email INDEX None email
user_regdate INDEX None user_regdate
user_lang INDEX None user_lang
user_website INDEX None user_website
user_location INDEX None user_location
user_occupation INDEX None user_occupation
reg_key INDEX None reg_key
user_status INDEX None user_status
user_lang_3 INDEX None user_lang
user_occupation_3 INDEX None user_occupation
user_regdate_3 INDEX None user_regdate
group_id_2 INDEX None group_id
user_website_4 INDEX None user_website
reg_key_3 INDEX None reg_key
user_status_2 INDEX None user_status
user_id_3 INDEX None user_id
email_5 INDEX None email
lastvisit_3 INDEX None lastvisit
user_location_4 INDEX None user_location
lastname_3 INDEX None lastname
username_6 INDEX None username
password_4 INDEX None password
firstname_4 INDEX None firstname
group_id_3 INDEX None group_id
username_4 INDEX None username
password_2 INDEX None password
firstname_2 INDEX None firstname
lastname_2 INDEX None lastname
email_3 INDEX None email
user_lang_2 INDEX None user_lang
user_website_2 INDEX None user_website
user_location_2 INDEX None user_location
user_occupation_2 INDEX None user_occupation
reg_key_2 INDEX None reg_key
user_website_3 INDEX None user_website
user_location_3 INDEX None user_location
user_lang_4 INDEX None user_lang
firstname_3 INDEX None firstname
reg_key_4 INDEX None reg_key
password_3 INDEX None password
lastname_4 INDEX None lastname
user_occupation_4 INDEX None user_occupation
username_7 INDEX None username
email_6 INDEX None email
lastname_5 INDEX None lastname


 Space usage :
Type Usage
Data 2,184 Bytes
Index 4,096 Bytes
Total 6,280 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 15
Row length ø 145
Row size  ø 419 Bytes
Next Autoindex 16
Creation Nov 02, 2017 at 08:09 AM
Last update Mar 12, 2018 at 11:00 PM
Last check Mar 26, 2018 at 06:25 AM