User

From DreamFactory
Jump to: navigation, search

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
email_addr_text varchar(200) utf8_general_ci NO UNI select,insert,update,references
password_text varchar(200) utf8_general_ci NO select,insert,update,references Big cuz it is a hash
remember_token varchar(128) utf8_general_ci YES select,insert,update,references
first_name_text varchar(64) utf8_general_ci YES select,insert,update,references
last_name_text varchar(64) utf8_general_ci YES select,insert,update,references
nickname_text varchar(128) utf8_general_ci YES select,insert,update,references
api_token_text varchar(128) utf8_general_ci YES select,insert,update,references
storage_id_text varchar(64) utf8_general_ci NO select,insert,update,references
external_id_text varchar(128) utf8_general_ci YES select,insert,update,references
external_password_text varchar(200) utf8_general_ci YES select,insert,update,references
owner_id int(11) YES MUL select,insert,update,references
owner_type_nbr int(11) YES select,insert,update,references
company_name_text varchar(128) utf8_general_ci YES select,insert,update,references
title_text varchar(128) utf8_general_ci YES select,insert,update,references
city_text varchar(64) utf8_general_ci YES select,insert,update,references
state_province_text varchar(64) utf8_general_ci YES select,insert,update,references
country_text varchar(2) utf8_general_ci YES select,insert,update,references
postal_code_text varchar(32) utf8_general_ci YES select,insert,update,references
phone_text varchar(32) utf8_general_ci YES select,insert,update,references
opt_in_ind tinyint(1) NO 1 select,insert,update,references
agree_ind tinyint(1) NO 0 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
admin_ind tinyint(1) NO 0 select,insert,update,references
activate_ind tinyint(1) NO 0 select,insert,update,references
active_ind tinyint(1) NO 1 select,insert,update,references
create_date datetime NO select,insert,update,references
lmod_date timestamp NO CURRENT_TIMESTAMP select,insert,update,references