maia_jobs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('maia_jobs_id_seq'::regclass)
maia_annotation_candidate_feature_vectors.job_id maia_annotation_candidate_feature_vectors_job_id_foreignC
maia_annotation_candidates.job_id maia_annotation_candidates_job_id_foreignC
maia_training_proposal_feature_vectors.job_id maia_training_proposal_feature_vectors_job_id_foreignC
maia_training_proposals.job_id maia_training_proposals_job_id_foreignC
volume_id int4 10 null
volumes.id maia_jobs_volume_id_foreignC
user_id int4 10 √ null
users.id maia_jobs_user_id_foreignN
created_at timestamp 22 √ null
updated_at timestamp 22 √ null
state int4 10 null
attrs json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
maia_jobs_pkey Primary key Asc id
maia_jobs_volume_id_index Performance Asc volume_id

Check Constraints

Constraint Name Constraint
maia_jobs_state_check (((state >= 1) AND (state <= 6))) NOT VALID

Relationships

Close relationships within degrees of separation