ServiceUser

From DreamFactory
Jump to: navigation, search

service_user_t

Table definition as of 2015-09-18 11:28:46

Field Type Collation Null Key Default Extra Privileges Comment
id int(11) NO PRI auto_increment select,insert,update,references
first_name_text varchar(64) utf8_general_ci NO select,insert,update,references
last_name_text varchar(64) utf8_general_ci NO select,insert,update,references
nickname_text varchar(128) utf8_general_ci YES select,insert,update,references
email_addr_text varchar(320) utf8_general_ci NO select,insert,update,references
password_text varchar(200) utf8_general_ci NO select,insert,update,references Big cuz it is a hash
owner_id int(11) YES MUL select,insert,update,references
owner_type_nbr int(11) YES select,insert,update,references
last_login_date datetime YES select,insert,update,references
last_login_ip_text varchar(64) utf8_general_ci YES select,insert,update,references
remember_token varchar(128) utf8_general_ci YES select,insert,update,references
active_ind tinyint(1) NO 0 select,insert,update,references
create_date datetime NO select,insert,update,references
lmod_date timestamp NO CURRENT_TIMESTAMP select,insert,update,references