User
From DreamFactory
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 |
