         CHECK(
             (job_type IN ('deterministic', 'event_based'))
             OR
-            ((job_type = 'classical')
+            ((job_type IN ('classical', 'disaggregation'))
              AND (gmf_random_seed IS NULL))),
     gmpe_lt_random_seed integer
         CONSTRAINT gmpe_lt_random_seed_is_set

    -- Probabilities of exceedence
    poes float[] CONSTRAINT poes_are_set
        CHECK(
            ((job_type = 'classical') AND (poes IS NOT NULL))
            OR ((job_type != 'classical') AND (poes IS NULL))),
    -- Number of logic tree samples
    realizations integer CONSTRAINT realizations_is_set
        CHECK(

            ((job_type = 'classical')
             AND (compute_mean_hazard_curve IS NOT NULL))
            OR
            ((job_type IN ('deterministic', 'event_based', 'disaggregation'))
             AND (compute_mean_hazard_curve IS NULL))),
    conditional_loss_poe float[],
    fault_magnitude_scaling_relationship VARCHAR
