| Field | Nullable | Data type | Constraint | Unique Constraint | Description |
|---|
ID | NOT NULL | NUMERIC | Primary Key | | |
SCHEDULER_ID | NOT NULL | VARCHAR | | X | corresponds to the SCHEDULER_ID that is specified during installation of the JobScheduler instance |
ACCOUNT | NOT NULL | VARCHAR | | | user account the audit was stored for |
REQUEST | NOT NULL | VARCHAR | | | REST API request the audit was stored for |
PARAMETERS | | LONGTEXT | | | given parameters from the request |
JOB | | VARCHAR | | | the job that was started, modified, etc. references INVENTORY_JOBS.NAME |
JOB_CHAIN | | VARCHAR | | | the job chain that was started, modified, etc. references INVENTORY_JOB_CHAINS.NAME |
ORDER_ID | | VARCHAR | | | the order that was started, modified, etc. references INVENTORY_ORDERS.ORDER_ID |
FOLDER | | VARCHAR | | | the path of the folder where the job, job chain, etc. resides |
COMMENT | | VARCHAR | | | a user comment on the action taken |
CREATED | NOT NULL | DATETIME | | | UTC timestamp of record creation |
TICKET_LINK | | VARCHAR | | | the link to a ticket, issue, bugtracker, etc. describing the problem the action was taken for |
TIME_SPENT | | NUMERIC | | | time spent on the action taken |