job_batches


Description

Job batches allow jobs to be collected into groups for managed processing.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 255 null
metrics_context.load_id Implied ConstraintR
metrics_counter_submission_daily.load_id Implied ConstraintR
metrics_counter_submission_institution_daily.load_id Implied ConstraintR
metrics_issue.load_id Implied ConstraintR
metrics_submission.load_id Implied ConstraintR
metrics_submission_geo_daily.load_id Implied ConstraintR
usage_stats_institution_temporary_records.load_id Implied ConstraintR
usage_stats_total_temporary_records.load_id Implied ConstraintR
usage_stats_unique_item_investigations_temporary_records.load_id Implied ConstraintR
usage_stats_unique_item_requests_temporary_records.load_id Implied ConstraintR
name VARCHAR 255 null
total_jobs INT 10 null
pending_jobs INT 10 null
failed_jobs INT 10 null
failed_job_ids TEXT 65535 null
options MEDIUMTEXT 16777215 √ NULL
cancelled_at INT 10 √ NULL
created_at INT 10 null
finished_at INT 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation