Page History

...

Expand

title	INVENTORY_SCHEDULES

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_INSTANCES.ID`
FILE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
SUBSTITUTE_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_SCHEDULES.ID`
NAME	NOT NULL	VARCHAR			schedule file name
BASENAME	NOT NULL	VARCHAR			schedule base name
TITLE		VARCHAR			schedule's title
SUBSTITUTE		NUMERIC			substitute attribute
SUBSTITUTE_NAME	NOT NULL	NUMERIC			full path of the substituted schedule, references `INVENTORY_SCHEDULES.NAME`
SUBSTITUTE_VALID_FROM		DATETIME			timestamp "from" when SUBSTITUTE will be valid
SUBSTITUTE_VALID_TO		DATETIME			timestamp "to" until SUBSTITUTE will be valid
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

the following table is used to store information if a user takes actions with a specific Job Scheduler Object, e.g. starting/stopping of a JobScheduler instance, pausing a Job, modifying an order, etc..
This table can be used to create individual reports on user interaction as well as security related actions as login/logout.

Expand

title	AUDIT_LOG

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

...

Space shortcuts