|
id
|
int(11)
|
|
|
|
|
label
|
varchar(100)
|
|
|
|
|
task_type
|
varchar(20)
|
|
|
|
|
login_url
|
text
|
|
|
|
|
username_encrypted
|
text
|
|
|
|
|
password_encrypted
|
text
|
|
|
|
|
username_selector
|
varchar(255)
|
|
|
|
|
password_selector
|
varchar(255)
|
|
|
|
|
submit_selector
|
varchar(255)
|
|
|
|
|
nav_steps_json
|
text
|
|
|
|
|
wa_group_name
|
varchar(255)
|
|
|
|
|
sheet_url
|
text
|
|
|
|
|
schedule_hour
|
int(11)
|
|
|
|
|
schedule_minute
|
int(11)
|
|
|
|
|
recipient_email
|
text
|
|
|
|
|
active
|
tinyint(1)
|
|
|
1
|
|
send_email
|
tinyint(1)
|
|
|
1
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
reminder_interval_hours
|
int(11)
|
|
|
2
|
|
cached_sheet_gid
|
varchar(50)
|
|
|
|
|
cached_gid_month
|
varchar(7)
|
|
|
|
|
reminder_schedule_type
|
varchar(20)
|
|
|
interval_hours
|
|
reminder_interval_minutes
|
int(11)
|
|
|
|
|
reminder_fixed_times
|
varchar(255)
|
|
|
|
|
relay_target_group_name
|
varchar(255)
|
|
|
|
|
relay_trigger_pattern
|
varchar(255)
|
|
|
|
|
dest_sheet_url
|
text
|
|
|
|
|
copy_mode
|
varchar(30)
|
|
|
verbatim
|