user-table.txt

Field           Type              Collation        Null    Key     Default  Extra           Privileges                       Comment  
--------------  ----------------  ---------------  ------  ------  -------  --------------  -------------------------------  ---------
id              int(10) unsigned  (NULL)           NO      PRI     (NULL)   auto_increment  select,insert,update,references           
name            varchar(255)      utf8_unicode_ci  NO      MUL     (NULL)                   select,insert,update,references           
email           varchar(255)      utf8_unicode_ci  NO      UNI     (NULL)                   select,insert,update,references           
birthplace      varchar(50)       utf8_unicode_ci  YES             (NULL)                   select,insert,update,references           
birthdate       date              (NULL)           YES             (NULL)                   select,insert,update,references           
gender          enum('m','f')     utf8_unicode_ci  NO              m                        select,insert,update,references           
about           varchar(500)      utf8_unicode_ci  NO              (NULL)                   select,insert,update,references           
phone           varchar(20)       utf8_unicode_ci  NO              (NULL)                   select,insert,update,references           
mobile          varchar(20)       utf8_unicode_ci  NO              (NULL)                   select,insert,update,references           
is_active       tinyint(1)        (NULL)           NO              1                        select,insert,update,references           
password        varchar(255)      utf8_unicode_ci  NO              (NULL)                   select,insert,update,references           
remember_token  varchar(100)      utf8_unicode_ci  YES             (NULL)                   select,insert,update,references           
created_at      timestamp         (NULL)           YES             (NULL)                   select,insert,update,references           
updated_at      timestamp         (NULL)           YES             (NULL)                   select,insert,update,references           
deleted_at      timestamp         (NULL)           YES             (NULL)                   select,insert,update,references           
 
/*Index Information*/
---------------------
 
Table   Non_unique  Key_name            Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null    Index_type  Comment  Index_comment  
------  ----------  ------------------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  -------  ---------------
users            0  PRIMARY                        1  id           A                   11    (NULL)  (NULL)          BTREE                               
users            0  users_email_unique             1  email        A                   11    (NULL)  (NULL)          BTREE                               
users            1  users_name_index               1  name         A                   11    (NULL)  (NULL)          BTREE