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

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.
`JOB_CHAIN`		VARCHAR			the job chain that was started, modified, etc.
`ORDER_ID`		VARCHAR			the order that was started, modified, etc.
`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

SQL scripts in this article are provided for PostgreSQL. The SQL scrpts for the respective DBMS are provided by the JobScheduler installer.

...

Space shortcuts