taskmanager_adhoc_task

property name="event"          type="string"  dbtype="varchar"  maxlength=255 required=true;
property name="event_args"     type="string"  dbtype="longtext"               required=false;
property name="retry_interval" type="string"  dbtype="longtext"               required=false;
property name="reference"      type="string"  dbtype="varchar"  maxlength=100 required=false indexes="reference";
property name="title"          type="string"  dbtype="varchar"  maxlength=255 required=false;
property name="title_args"     type="string"  dbtype="longtext"               required=false;
property name="result"         type="string"  dbtype="longtext"               required=false;
property name="result_url"     type="string"  dbtype="varchar"  maxlength=255 required=false;
property name="return_url"     type="string"  dbtype="varchar"  maxlength=255 required=false;
property name="log"            type="string"  dbtype="longtext"               required=false;

property name="status"              type="string"  dbtype="varchar"   maxlength=50  required=false default="pending" enum="adhocTaskStatus" indexes="status";
property name="progress_percentage" type="numeric" dbtype="int"                     required=false default=0;

property name="discard_on_complete"    type="boolean" dbtype="boolean"  required=false default=false indexes="discardoncomplete";
property name="discard_after_interval" type="numeric" dbtype="bigint"   required=false default=0 indexes="discardafterinterval";
property name="discard_expiry"         type="date"    dbtype="datetime" required=false indexes="discardexpiry";
property name="disable_cancel"         type="boolean" dbtype="boolean"  required=false default=false;

property name="attempt_count"     type="numeric" dbtype="int"      required=false default=0 indexes="attemptcount";
property name="next_attempt_date" type="date"    dbtype="datetime" required=false indexes="nextattempt";
property name="last_error"        type="string"  dbtype="longtext" required=false;
property name="started_on"        type="date"    dbtype="datetime" required=false indexes="startedon";
property name="finished_on"       type="date"    dbtype="datetime" required=false indexes="finishedon";

property name="admin_owner" relationship="many-to-one" relatedto="security_user" required=false feature="admin";
property name="web_owner"   relationship="many-to-one" relatedto="website_user"  required=false feature="websiteUsers";