     subduction_fault_magnitude_scaling_relationship VARCHAR
         CONSTRAINT subduction_fault_magnitude_scaling_relationship_is_set
         CHECK(
-            ((job_type IN ('classical', 'event_based', 'disaggregation'))
+            ((job_type != 'deterministic')
              AND (subduction_fault_magnitude_scaling_relationship IS NOT NULL))
             OR
             ((job_type = 'deterministic')

    subduction_fault_magnitude_scaling_sigma float
        CONSTRAINT subduction_fault_magnitude_scaling_sigma_is_set
        CHECK(
            ((job_type IN ('classical', 'event_based', 'disaggregation'))
             AND (subduction_fault_magnitude_scaling_sigma IS NOT NULL))
            OR
            ((job_type = 'deterministic')

    subduction_fault_rupture_offset float
        CONSTRAINT subduction_fault_rupture_offset_is_set
        CHECK(
            ((job_type != 'deterministic')
             AND (subduction_fault_rupture_offset IS NOT NULL))
            OR
            ((job_type = 'deterministic')
