| Field | Nullable | Data type | Constraint | Unique Constraint | Description |
|---|
ID | NOT NULL | NUMERIC | Primary Key | | |
INSTANCE_ID | NOT NULL | NUMERIC | Foreign Key | | references |
FILE_ID | NOT NULL | NUMERIC | Foreign Key | X | references INVENTORY_FILES.ID |
JOB_CHAIN_ID | NOT_NULL | NUMERIC | Foreign Key | | references INVENTORY_JOB_CHAINS.ID |
SCHEDULERSCHEDULE_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 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 | | | corresponds to INVENTORY_JOB_CHAINS.NAME e.g. /test/my_jobchain |
SCHEDULE | | VARCHAR | | | |
SCHEDULE_NAME | NOT_NULL | VARCHAR | | | corresponds to INVENTORY_SCHEDULES.NAME |
INITIAL_STATE | | VARCHAR | | | |
END_STATE | | VARCHAR | | | |
PRIORITY | | NUMERIC | | | |
IS_RUNTIME_DEFINED
| NOT NULL | NUMERIC | | | specifies if a start time has been configured: |
CREATED | NOT NULL | DATETIME | | | UTC timestamp of record creation |
MODIFIED | NOT NULL | DATETIME | | | UTC timestamp of record modification |