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