Table transmart.i2b2demodata.async_job
Stores record per an advanced analysis job.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int4 10
storage_system.id Implied Constraint R
job_name varchar 200  √  null The job name. e.g. admin-RHeatmap-100448
job_status varchar 200  √  null The status of the job. [Started|Cancelled|Error|Completed|...]
run_time varchar 200  √  null
job_status_time timestamp 29,6  √  null The time when current job_status took place.
last_run_on timestamp 29,6  √  null The start time of the job.
viewer_url varchar 4000  √  null
alt_viewer_url varchar 4000  √  null
job_results text 2147483647  √  null
job_inputs_json text 2147483647  √  null
job_type varchar 20  √  null
user_id varchar 50  √  null Name of the user.

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc async_job_pkey

Close relationships: