|
id
|
int(10)
|
|
|
|
|
advocate_id
|
int(11)
|
|
|
|
|
name
|
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
|
email
|
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
|
password
|
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
|
first_name
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
last_name
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
mobile
|
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
|
registration_no
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
associated_name
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
address
|
text
|
utf8mb4_unicode_ci
|
|
|
|
city_id
|
int(11)
|
|
|
|
|
zipcode
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
state_id
|
int(11)
|
|
|
|
|
country_id
|
int(11)
|
|
|
|
|
profile_img
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
is_activated
|
tinyint(1)
|
|
|
|
|
is_account_setup
|
tinyint(1)
|
|
|
|
|
remember_token
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
is_user_type
|
enum('SUPERADMIN', 'ADVOCATE', 'STAFF')
|
utf8mb4_unicode_ci
|
|
|
|
invitation_status
|
enum('accepted', 'sent')
|
utf8mb4_unicode_ci
|
|
|
|
accepted_at
|
datetime
|
|
|
|
|
current_package
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
payment_id
|
int(11)
|
|
|
|
|
started_at
|
date
|
|
|
|
|
expires_at
|
timestamp
|
|
|
|
|
last_login_at
|
timestamp
|
|
|
|
|
last_login_ip
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
is_active
|
enum('Yes', 'No')
|
utf8mb4_unicode_ci
|
|
|
|
is_expired
|
enum('Yes', 'No')
|
utf8mb4_unicode_ci
|
|
|
|
otp
|
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
|
otp_date
|
timestamp
|
|
|
|
|
is_otp_verify
|
enum('0', '1')
|
utf8mb4_unicode_ci
|
|
|
|
plateform
|
enum('App', 'Web')
|
utf8mb4_unicode_ci
|
|
|
|
user_type
|
enum('Admin', 'User')
|
utf8mb4_unicode_ci
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|
