Scope

Inventory Tables

INVENTORY_INSTANCES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`SCHEDULER_ID`	NOT NULL	VARCHAR
`HOSTNAME`	NOT NULL	VARCHAR
`PORT`	NOT NULL	NUMERIC		TO BE DISCUSSED TCP, UDP Port extra?
`LIVE_DIRECTORY`	NOT NULL	VARCHAR
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

INVENTORY_FILES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_INSTANCES.ID`
`FILE_TYPE`	NOT NULL	VARCHAR		`job` `job_chain` `order` Not treated: `process_class` `config` `lock` `schedule` `...`
`FILE_NAME`	NOT NULL	VARCHAR		Path from live directory `test/my_job.job.xml`
`FILE_BASENAME`	NOT NULL	VARCHAR		File basename `my_job.job.xml`
`FILE_DIRECTORY`	NOT NULL	VARCHAR		Path from live directory `test`
`FILE_CREATED`	NULL	DATETIME		UTC time timestamp of the creation of the file
`FILE_MODIFIED`	NULL	DATETIME		UTC time timestamp of the last change of the file
`FILE_LOCAL_CREATED`	NULL	DATETIME		Local time timestamp of the creation of the file
`FILE_LOCAL_MODIFIED`	NULL	DATETIME		Local time timestamp of the last change of the file
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

INVENTORY_JOBS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_INSTANCES.ID` for easy cleanup
`FILE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_FILES.ID`
`NAME`	NOT NULL	VARCHAR		Job name `test/my_job (test/my_job.job.xml)`
`BASENAME`	NOT NULL	VARCHAR		Job base name `my_job (test/my_job.job.xml)`
`TITLE`	NULL	VARCHAR
`IS_ORDER_JOB`	NOT NULL	NUMERIC		`yes` `no`
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC		`yes` `no`
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

INVENTORY_JOB_CHAINS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_INSTANCES.ID` for easy cleanup
`FILE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_FILES.ID`
`START_CAUSE`	NOT NULL	VARCHAR		`file trigger` `order` ...
`NAME`	NOT NULL	VARCHAR		Job chain name `test/my_jobchain (test/my_jobchain.job_chain.xml)`
`BASENAME`	NOT NULL	VARCHAR		Job chain base name `my_jobchain (test/my_jobchain.job_chain.xml)`
`TITLE`	NULL	VARCHAR
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

INVENTORY_JOB_CHAIN_NODES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_INSTANCES.ID` for easy cleanup
`JOB_CHAIN_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_JOB_CHAINS.ID`
`NAME`	NOT NULL	VARCHAR		`file_order_source` `job_chain_node` TO BE DISCUSSED Eventuell END_NODE ...
`ORDERING`	NOT NULL	NUMERIC		Node order
`STATE`	NULL	VARCHAR
`NEXT_STATE`	NULL	VARCHAR
`ERROR_STATE`	NULL	VARCHAR
`JOB`	NULL	VARCHAR		`../my_job`
`JOB_NAME`	NOT NULL	VARCHAR	Foreign key	`INVENTORY_JOBS.NAME` `test/my_job`
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

INVENTORY_JOB_CHAIN_ORDERS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_INSTANCES.ID` for easy cleanup
`FILE_ID`	NOT NULL	NUMERIC	Foreign key	`INVENTORY_FILES.ID`
`JOB_CHAIN_NAME`	NOT NULL	VARCHAR	Foreign key	`INVENTORY_JOB_CHAINS.NAME` `test/my_jobchain`
`ORDER_ID`	NOT NULL	VARCHAR		Order name `my_order (test/my_jobchain,my_order.order.xml)`
`TITLE`	NULL	VARCHAR
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC		`yes` `no`
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

Fact Tables

TO BE DISCUSSED

Eine neue extra Tabelle REPORT_TRIGGER_CONFIGURATIONS für JobChains - mit den PARENT_xxx Sachen???

REPORT_TRIGGERS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`SCHEDULER_ID`	NOT NULL	VARCHAR		`SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		`SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`NAME`	NOT NULL	VARCHAR		`SCHEDULER_ORDER_HISTORY.ORDER_ID`
`TITLE`	NULL	VARCHAR		Title `INVENTORY_JOB_CHAIN_ORDERS.TITLE`
`PARENT_NAME`	NOT NULL	VARCHAR		`SCHEDULER_ORDER_HISTORY.JOB_CHAIN`
`PARENT_BASENAME`	NULL	VARCHAR		Job chain basename
`PARENT_TITLE`	NULL	VARCHAR		`INVENTORY_JOB_CHAINS.TITLE`
`START_TIME`	NOT NULL	DATETIME		`SCHEDULER_ORDER_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME		`SCHEDULER_ORDER_HISTORY.END_TIME`
`SYNC_COMPLETED`	NOT NULL	NUMERIC		0 1
`RESULTS_COMPLETED`	NOT NULL	NUMERIC		0 1
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

REPORT_EXECUTIONS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`SCHEDULER_ID`	NOT NULL	NUMERIC	Foreign key	`SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC	Foreign key	`SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign key	`REPORT_TRIGGERS.ID`
`STEP`	NOT NULL	NUMERIC		Sequence of steps `SCHEDULER_ORDER_STEP_HISTORY.STEP`
`NAME`	NOT NULL	VARCHAR		`SCHEDULER_HISTORY.JOB_NAME` `test/my_job`
`BASENAME`	NOT NULL	VARCHAR		Job base name `my_job (test/my_job.job.xml)`
`TITLE`	NULL	VARCHAR		`INVENTORY_JOBS.TITLE`
`START_TIME`	NOT NULL	DATETIME		`SCHEDULER_ORDER_STEP_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME		`SCHEDULER_ORDER_STEP_HISTORY.END_TIME`
`STATE`	NOT NULL	VARCHAR		`SCHEDULER_ORDER_STEP_HISTORY.STATE`
`CAUSE`	NOT NULL	VARCHAR
`ERROR`	NOT NULL	NUMERIC		0 1
`ERROR_CODE`	NULL	VARCHAR
`ERROR_TEXT`	NULL	VARCHAR
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

Custom Tables

REPORT_APPS

Field	Nullable	Data type	Constraint
`ID`	NOT NULL	NUMERIC	Primary key
`NAME`	NOT NULL	VARCHAR
`TITLE`	NULL	VARCHAR

REPORT_JOBS

Field	Nullable	Data type	Constraint
`ID`	NOT NULL	NUMERIC	Primary key
`NAME`	NOT NULL	VARCHAR
`TITLE`	NULL	VARCHAR

REPORT_MANDATORS

Field	Nullable	Data type	Constraint
`ID`	NOT NULL	NUMERIC	Primary key
`NAME`	NOT NULL	VARCHAR
`TITLE`	NULL	VARCHAR

REPORT_MAP_JOB_APPS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`JOB_ID`	NOT NULL	VARCHAR	Foreign key	`REPORT_JOBS.ID`
`APPLICATION_ID`	NOT NULL	NUMERIC	Foreign key	`REPORT_APPLICATIONS.ID`

REPORT_MAP_JOB_MANDATORS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`JOB_CHAIN`	NOT NULL	VARCHAR	Foreign key	`REPORT_JOBS.ID`
`MANDATOR_ID`	NOT NULL	NUMERIC	Foreign key	`REPORT_MANDATOR.ID`

REPORT_MAP_CAUSES

Field	Nullable	Data type	Constraint
`ID`	NOT NULL	NUMERIC	Primary key
`CAUSE`	NOT NULL	VARCHAR
`MAPPED_CAUSE`	NOT NULL	VARCHAR

Aggregation Tables

REPORT_TRIGGER_RESULTS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign key	Reference to the `REPORT_TRIGGERS.ID`
`START_CAUSE`	NOT NULL	VARCHAR		`SCHEDULER_HISTORY.CAUSE` of the 1.st step if equals `"order"` check in the `INVENTORY_JOB_CHAINS.START_CAUSE`
`STEPS`	NOT NULL	NUMERIC		Number of steps `SCHEDULER_ORDER_STEP_HISTORY.STEP` of the last step or `1` for not order jobs
`ERROR`	NOT NULL	NUMERIC		0 1
`ERROR_CODE`	NULL	VARCHAR
`ERROR_TEXT`	NULL	VARCHAR
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

REPORT_EXECUTION_DATES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary key
`REFERENCE_ID`	NOT NULL	NUMERIC	Foreign key	Reference to the `REPORT_TRIGGERS.ID` or `REPORT_EXECUTIONS.ID`
`REFERENCE_TYPE`	NOT NULL	NUMERIC		`0` - `REPORT_TRIGGERS` `1` - `REPORT_EXECUTIONS`
`START_DAY`	NOT NULL	NUMERIC		Calendar day 1
`START_WEEK`	NOT NULL	NUMERIC		Calendar week 52
`START_MONTH`	NOT NULL	NUMERIC		Calendar month 12
`START_QUARTER`	NOT NULL	NUMERIC		Quarter 1
`START_YEAR`	NOT NULL	NUMERIC		Year 2015
`END_DAY`	NOT NULL	NUMERIC		Calendar day 1
`END_WEEK`	NOT NULL	NUMERIC		Calendar week 52
`END_MONTH`	NOT NULL	NUMERIC		Calendar month 12
`END_QUARTER`	NOT NULL	NUMERIC		Quarter 1
`END_YEAR`	NOT NULL	NUMERIC		Calendar year 2015
`CREATED`	NOT NULL	DATETIME
`MODIFIED`	NOT NULL	DATETIME

Space shortcuts

Page tree

Scope

Inventory Tables

Fact Tables

Custom Tables

Aggregation Tables

Space shortcuts

Page tree

JobScheduler Reporting Interface - Data Model

Scope

Inventory Tables

Fact Tables

Custom Tables

Aggregation Tables