|
id
|
int(11)
|
|
|
|
|
firstname
|
varchar(100)
|
|
|
|
|
lastname
|
varchar(100)
|
|
|
|
|
email
|
varchar(190)
|
|
|
|
|
organization
|
varchar(150)
|
|
|
|
|
password
|
varchar(255)
|
|
|
|
|
last_login_at
|
datetime
|
|
|
|
|
is_verified
|
tinyint(1)
|
|
|
0
|
|
role
|
enum
|
-- |
|
user
|
|
sub_start
|
datetime
|
|
|
|
|
sub_end
|
datetime
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
subscription_start
|
date
|
|
|
|
|
subscription_end
|
date
|
|
|
|
|
org_name
|
varchar(255)
|
|
|
|
|
org_logo_path
|
varchar(255)
|
|
|
|
|
otp_code
|
varchar(10)
|
|
|
|
|
otp_expires_at
|
datetime
|
|
|
|
|
slideshow_seconds
|
tinyint(3) unsigned
|
|
|
5
|