Page History

...

Expand

title	INVENTORY_JOB_CHAIN_NODES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID`
JOB_ID	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOBS.ID`
`JOB_CHAIN_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
NESTED_JOB_CHAIN_ID	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
`NAME`	NOT NULL	VARCHAR		job node name: `file_order_source` `job_chain_node` `file_order_sink`
`ORDERING`	NOT NULL	NUMERIC		ordering of node in job chain
`STATE`		VARCHAR		job node state as specified in the configuration
`NEXT_STATE`		VARCHAR		next state for an order in case of successful execution
`ERROR_STATE`		VARCHAR		error state for an order in case of unsuccessful execution
`JOB`		VARCHAR		job name as specified in the job node configuration e.g. `../my_job`
`JOB_NAME`	NOT NULL	VARCHAR		corresponds to `INVENTORY_JOBS.NAME.` Paths are resolved to absolute values starting from the `live` directory e.g. `/test/my_job`
NESTED_JOB_CHAIN		VARCHAR
NESTED_JOB_CHAIN_NAME	NOT NULL	VARCHAR		corresponds to `INVENTORY_JOB_CHAINS.NAME`
NODE_TYPE	NOT NULL	NUMERIC
ON_ERROR		VARCHAR
DELAY		NUMERIC
DIRECTORY		VARCHAR
REGEX		VARCHAR
FILE_SINK_OP		NUMERIC
MOVE_PATH		VARCHAR
`CREATED`	NOT NULL	DATETIME		UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		UTC timestamp of record modification

Expand

title	INVENTORY_JOB_CHAINS

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`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
FW_PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
`START_CAUSE`	NOT NULL	VARCHAR			the following start causes are available: `file_trigger` `order`
`NAME`	NOT NULL	VARCHAR			job chain name e.g. `/test/my_jobchain` for a given job chain path`/test/my_jobchain.job_chain.xml`
`BASENAME`	NOT NULL	VARCHAR			job chain base name e.g. `my_jobchain` for a given job chain path `/test/my_jobchain.job_chain.xml`
`TITLE`	NULL	VARCHAR			job chain title
MAX_ORDERS		NUMERIC
DISTRIBUTED	NOT NULL	NUMERIC
PROCESS_CLASS		VARCHAR
PROCESS_CLASS_NAME	NOT NULL	VARCHR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME.`
FW_PROCESS_CLASS		VARCHAR
FW_PROCESS_CLASS_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME.`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_JOBS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID`used for simplified clean-up
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	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	`CREATED`	NOT NULL	DATETIME	timestamp of record creation	`MODIFIED`	NOT NULL
PROCESS_CLASS		VARCHARDATETIME		timestamp of record modification

Expand

title	INVENTORY_JOB_CHAINS

Field	Nullable	Data type	Constraint	Description

PROCESS_CLASS_NAME
`ID`	NOT NULL	NUMERICVARCHAR	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID` used for simplified clean-up
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_FILES.ID`
`START_CAUSE`	NOT NULL	VARCHAR		the following start causes are available: `file_trigger` `order`
`NAME`	NOT NULL	VARCHAR		job chain name e.g. `test/my_jobchain` for a given job chain path`test/my_jobchain.job_chain.xml`
`BASENAME`	NOT NULL	VARCHAR		job chain base name e.g. `my_jobchain` for a given job chain path `test/my_jobchain.job_chain.xml`
`TITLE`	NULL	VARCHAR		job chain title
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Expand

title	INVENTORY_JOB_CHAIN_NODES

Field	Nullable	Data type	Constraint	Description
corresponds to `INVENTORY_PROCESS_CLASSES.NAME`
SCHEDULE		VARCHAR
SCHEDULE
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID` used for simplified clean-up
`JOB_CHAIN_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
`NAME`	NOT NULL	VARCHAR		job node name: `file_order_source` `job_chain_node` `file_order_sink`
`ORDERING`	NOT NULL	NUMERIC		ordering of node in job chain
`STATE`	NULL	VARCHAR		job node state as specified in the configuration
`NEXT_STATE`	NULL	VARCHAR		next state for an order in case of successful execution
`ERROR_STATE`	NULL	VARCHAR		error state for an order in case of unsuccessful execution
`JOB`	NULL	VARCHAR		job name as specified in the job node configuration e.g. `../my_job`
JOB _NAME	NOT NULL	VARCHAR	Foreign Key	corresponds to `INVENTORY_`JOBS`SCHEDULES.NAME`. Paths are resolved to absolute values starting from the `live` directorye.g. `test/my_job`
`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` `used for simplified clean-up`
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	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		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`
`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