| staffid |
int(11)
|
|
|
|
| email |
varchar(100)
|
utf8_general_ci
|
|
|
| firstname |
varchar(50)
|
utf8_general_ci
|
|
|
| lastname |
varchar(50)
|
utf8_general_ci
|
|
|
| facebook |
mediumtext
|
utf8_general_ci
|
|
|
| linkedin |
mediumtext
|
utf8_general_ci
|
|
|
| phonenumber |
varchar(30)
|
utf8_general_ci
|
|
|
| skype |
varchar(50)
|
utf8_general_ci
|
|
|
| password |
varchar(250)
|
utf8_general_ci
|
|
|
| datecreated |
datetime
|
|
|
|
| profile_image |
varchar(191)
|
utf8_general_ci
|
|
|
| last_ip |
varchar(40)
|
utf8_general_ci
|
|
|
| last_login |
datetime
|
|
|
|
| last_activity |
datetime
|
|
|
|
| last_password_change |
datetime
|
|
|
|
| new_pass_key |
varchar(32)
|
utf8_general_ci
|
|
|
| new_pass_key_requested |
datetime
|
|
|
|
| admin |
int(11)
|
|
|
|
| role |
int(11)
|
|
|
|
| active |
int(11)
|
|
|
|
| default_language |
varchar(40)
|
utf8_general_ci
|
|
|
| direction |
varchar(3)
|
utf8_general_ci
|
|
|
| media_path_slug |
varchar(191)
|
utf8_general_ci
|
|
|
| is_not_staff |
int(11)
|
|
|
|
| hourly_rate |
decimal(15,2)
|
|
|
|
| two_factor_auth_enabled |
tinyint(1)
|
|
|
|
| two_factor_auth_code |
varchar(100)
|
utf8_general_ci
|
|
|
| two_factor_auth_code_requested |
datetime
|
|
|
|
| email_signature |
text
|
utf8_general_ci
|
|
|
| position |
varchar(256)
|
utf8_general_ci
|
|
|
| hourly_rate_person |
decimal(15,2)
|
|
|
|