Page History

...

Expand

title	INVENTORY_JOBS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_INSTANCES.ID`
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
SCHEDULE_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_SCHEDULES.ID`
`NAME`	NOT NULL	VARCHAR			job name e.g. `/test/my_job` for a given job path`/test/my_job.job.xml`
`BASENAME`	NOT NULL	VARCHAR			job base name e.g. `my_job` for a given job path `/test/my_job.job.xml`
`TITLE`	NULL	VARCHAR			job title
`IS_ORDER_JOB`	NOT NULL	NUMERIC			specifies if this job is part of a job chain: `1: yes` `0: no`
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC			specifies if a start time has been configured: `1: yes` `0: no`
USED_IN_JOB_CHAINS		NUMERIC
PROCESS_CLASS		VARCHAR
PROCESS_CLASS_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME`
SCHEDULE		VARCHAR
SCHEDULE_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_SCHEDULES.NAME`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_ORDERSLOCKS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign KeyKey		references `INVENTORY_INSTANCES.ID` used for simplified clean-up
FILE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
NAME	NOT NULL	VARCHAR			order name e.g. `test/my_jobchain,my_order` for a given order path `test/my_jobchain,my_order.order.xml`
BASENAME	NOT NULL	VARCHAR
MAX_NON_EXCLUSIVE		NUMERIC
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_OPERATING_SYSTEMS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`HOSTNAME`	NOT NULL	VARCHAR
NAME		VARCHAR
ARCHITECTURE		VARCHAR
DISTRIBUTION		VARCHAR
`CREATED`	NOT NULL	DATETIME		UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		UTC timestamp of record modification

Expand

title	INVENTORY_ORDERS

Field	Nullable	Data type	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	references `INVENTORY_FILES.ID`
JOB_CHAIN_ID	NOT_NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
SCHEDULER_ID	NOT_NULL	NUMERIC	Foreign Key	references `INVENTORY_SCHEDULES.ID`
`NAME`	NOT NULL	VARCHAR		order name e.g. `/test/my_jobchain,my_order` for a given order path /`test/my_jobchain,my_order.order.xml`
`BASENAME`	NOT NULL	VARCHAR		order base name e.g.`my_jobchain,my_` order base name e.g.`my_jobchain,my_order` for a given job chain path `/test/my_jobchain,my_order.order.xml`
`TITLE`	NULL	VARCHAR		order title
`ORDER_ID`	NOT NULL	VARCHAR		order identification (unique per job chain) e.g. `my_order` for a given order path`/test/my_jobchain,my_order.order.xml`
`JOB_CHAIN_NAME`	NOT NULL	VARCHAR	Foreign Key	corresponds to `INVENTORY_JOB_CHAINS.NAME` e.g. `/test/my_jobchain`
SCHEDULE		VARCHAR
SCHEDULE_NAME	NOT_NULL	VARCHAR
INITIAL_STATE		VARCHAR
END_STATE		VARCHAR
PRIORITY		NUMERIC
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC		specifies if a start time has been configured: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME		UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		UTC timestamp of record modification

...

Space shortcuts