art_cycle_summary

Summary or persistent information about a single cycle of assisted reproduction treatment.

Summary or persistent information about a single cycle of assisted reproduction treatment.

Purpose. To record summary or persistent information about a single cycle of assisted reproduction treatment.

Source

Columns

Constraints

check (cycle_identifier_system is null or cycle_identifier_value is not null)
check ((activities_code is null and activities_system is null and activities_valueset_id is null) or (activities is not null and activities_code is not null and activities_system is not null and activities_valueset_id is not null))
check ((donation_received_code is null and donation_received_system is null and donation_received_valueset_id is null and donation_received is null) or (donation_received is not null and donation_received_code is not null and donation_received_system is not null and donation_received_valueset_id is not null))
check ((hormone_protocol_code is null and hormone_protocol_system is null and hormone_protocol_valueset_id is null) or (hormone_protocol is not null and hormone_protocol_code is not null and hormone_protocol_system is not null and hormone_protocol_valueset_id is not null))
check ((cumulative_gonadotropin_dose_magnitude is null and cumulative_gonadotropin_dose_units is null) or (cumulative_gonadotropin_dose_magnitude is not null and cumulative_gonadotropin_dose_units is not null))
check (cumulative_gonadotropin_dose_magnitude is null or (cumulative_gonadotropin_dose_units = '[iU]' and cumulative_gonadotropin_dose_magnitude >= 0) or (cumulative_gonadotropin_dose_units = 'ug'))
check ((cycle_outcome_code is null and cycle_outcome_system is null and cycle_outcome_valueset_id is null) or (cycle_outcome is not null and cycle_outcome_code is not null and cycle_outcome_system is not null and cycle_outcome_valueset_id is not null))
check ((pregnancy_test_outcome_code is null and pregnancy_test_outcome_system is null and pregnancy_test_outcome_valueset_id is null and pregnancy_test_outcome is null) or (pregnancy_test_outcome is not null and pregnancy_test_outcome_code is not null and pregnancy_test_outcome_system is not null and pregnancy_test_outcome_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• art_cycle_summary_complications via art_cycle_summary_id

Indexes

• art_cycle_summary_form_id_idx on form_id

Child tables

1 table hang off art_cycle_summary, one row per repetition.

art_cycle_summary_complications

Child table — one row per repetition, deleted with its parent.

Constraints

check ((condition_code is null and condition_system is null and condition_valueset_id is null) or (condition is not null and condition_code is not null and condition_system is not null and condition_valueset_id is not null))

Unique

• art_cycle_summary_id, position

References

Value sets