Castor EDC

Explore the interactive ERD

Table & Field Reference

participant

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`created_by`	Unknown	FK
`site_id`	Unknown	FK
`updated_by`	Unknown	FK
`archived`	Unknown
`archived_reason`	Unknown
`ccr_patient_id`	Unknown
`created_on_date`	Unknown
`created_on_timezone`	Unknown
`created_on_timezone_type`	Unknown
`deleted`	Unknown
`last_opened_step`	Unknown
`locked`	Unknown
`participant_status_id`	Unknown
`participant_status_name`	Unknown
`progress`	Unknown
`randomization_group`	Unknown
`randomization_group_name`	Unknown
`randomized_id`	Unknown
`randomized_on_date`	Unknown
`randomized_on_timezone`	Unknown
`randomized_on_timezone_type`	Unknown
`status`	Unknown
`updated_on_date`	Unknown
`updated_on_timezone`	Unknown
`updated_on_timezone_type`	Unknown

repeating_data_instance_data_point

Column	Type	Keys
`field_id`	Unknown	PKFK
`participant_id`	Unknown	PKFK
`repeating_data_instance_id`	Unknown	PKFK
`study_id`	Unknown	PKFK
`field_value`	Unknown
`repeating_data_instance_name`	Unknown
`updated_on`	Unknown

institute_permission

Column	Type	Keys
`institute_id`	Unknown	PKFK
`study_user_id`	Unknown	PKFK
`add`	Unknown
`decrypt`	Unknown
`delete`	Unknown
`edit`	Unknown
`email_addresses`	Unknown
`encrypts`	Unknown
`export`	Unknown
`lock`	Unknown
`query`	Unknown
`randomization_read`	Unknown
`randomization_write`	Unknown
`role`	Unknown
`sdv`	Unknown
`sign`	Unknown
`survey_send`	Unknown
`survey_view`	Unknown
`televisit`	Unknown
`view`	Unknown

study_user

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`department`	Unknown
`email_address`	Unknown
`full_name`	Unknown
`institute`	Unknown
`last_login`	Unknown
`manage_permissions_manage_encryption`	Unknown
`manage_permissions_manage_form`	Unknown
`manage_permissions_manage_records`	Unknown
`manage_permissions_manage_settings`	Unknown
`manage_permissions_manage_users`	Unknown
`name_first`	Unknown
`name_last`	Unknown
`name_middle`	Unknown

study

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown	FK
`main_contact`	Unknown	FK
`created_on`	Unknown
`domain`	Unknown
`duration`	Unknown
`expected_centers`	Unknown
`expected_records`	Unknown
`gcp_enabled`	Unknown
`live`	Unknown
`name`	Unknown
`premium_support_enabled`	Unknown
`randomization_enabled`	Unknown
`slug`	Unknown
`surveys_enabled`	Unknown
`trial_registry_id`	Unknown
`version`	Unknown

role

Column	Type	Keys
`name`	Unknown	PK
`study_id`	Unknown	PKFK
`description`	Unknown

country

Column	Type	Keys
`id`	Unknown	PK
`country_cca_2`	Unknown
`country_cca_3`	Unknown
`country_name`	Unknown
`country_tld`	Unknown

field_dependency

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`child_id`	Unknown
`description`	Unknown
`field_dependency_type`	Unknown
`operator`	Unknown
`value`	Unknown

repeating_data

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown
`type`	Unknown

study_statistics_institute

Column	Type	Keys
`institute_id`	Unknown	PK
`study_statistics_study_id`	Unknown	PKFK
`institute_name`	Unknown
`record_count`	Unknown

study_statistics

Column	Type	Keys
`study_id`	Unknown	PKFK
`records_total_count`	Unknown

field_option

Column	Type	Keys
`id`	Unknown	PK
`field_option_group_id`	Unknown	PKFK
`group_order`	Unknown
`name`	Unknown
`value`	Unknown

field_option_group

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`description`	Unknown
`layout`	Unknown
`name`	Unknown

participant_progress_form

Column	Type	Keys
`form_id`	Unknown	PKFK
`participant_progress_participant_id`	Unknown	PKFK
`participant_progress_study_id`	Unknown	PKFK
`complete`	Unknown
`locked`	Unknown
`progress`	Unknown
`sdv`	Unknown
`signed`	Unknown

repeating_data_form

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`repeating_data_id`	Unknown	FK
`repeating_data_form_description`	Unknown
`repeating_data_form_name`	Unknown
`repeating_data_form_number`	Unknown

site

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`country_id`	Unknown	FK
`abbreviation`	Unknown
`code`	Unknown
`date_format`	Unknown
`deleted`	Unknown
`name`	Unknown
`orders`	Unknown

survey_instance

Column	Type	Keys
`id`	Unknown	PKFK
`study_id`	Unknown	PKFK
`field_id`	Unknown
`field_value`	Unknown
`participant_id`	Unknown
`survey_name`	Unknown
`updated_on`	Unknown

form

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`visit_id`	Unknown	FK
`form_description`	Unknown
`form_name`	Unknown
`form_order`	Unknown

survey_package_instance_survey_instance

Column	Type	Keys
`id`	Unknown	PK
`survey_package_instance_id`	Unknown	PKFK
`survey_id`	Unknown	FK
`progress`	Unknown
`progress_total_fields`	Unknown
`progress_total_fields_not_empty`	Unknown

survey_package_instance

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`participant_id`	Unknown	FK
`site_id`	Unknown	FK
`survey_package_id`	Unknown	FK
`all_fields_filled_on_date`	Unknown
`all_fields_filled_on_timezone`	Unknown
`all_fields_filled_on_timezone_type`	Unknown
`archived`	Unknown
`auto_lock_on_finish`	Unknown
`auto_send`	Unknown
`available_from_date`	Unknown
`available_from_timezone`	Unknown
`available_from_timezone_type`	Unknown
`created_by`	Unknown
`created_on_date`	Unknown
`created_on_timezone`	Unknown
`created_on_timezone_type`	Unknown
`expire_on_date`	Unknown
`expire_on_timezone`	Unknown
`expire_on_timezone_type`	Unknown
`finished_on_date`	Unknown
`finished_on_timezone`	Unknown
`finished_on_timezone_type`	Unknown
`first_opened_on_date`	Unknown
`first_opened_on_timezone`	Unknown
`first_opened_on_timezone_type`	Unknown
`invitation_content`	Unknown
`invitation_subject`	Unknown
`locked`	Unknown
`parent_type`	Unknown
`progress`	Unknown
`received_on_date`	Unknown
`received_on_timezone`	Unknown
`received_on_timezone_type`	Unknown
`sent_on_date`	Unknown
`sent_on_timezone`	Unknown
`sent_on_timezone_type`	Unknown
`site_name`	Unknown
`started_on_date`	Unknown
`started_on_timezone`	Unknown
`started_on_timezone_type`	Unknown
`survey_package_instance_id`	Unknown
`survey_package_name`	Unknown
`survey_reminders_send_ondate`	Unknown
`survey_reminders_send_ontimezone`	Unknown
`survey_reminders_send_ontimezone_type`	Unknown
`survey_remindersid`	Unknown
`survey_remindersmessage`	Unknown
`survey_reminderssubject`	Unknown
`survey_url_string`	Unknown

meta_data

Column	Type	Keys
`id`	Unknown	PK
`field_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`_embedded_metadata_type_description`	Unknown
`_embedded_metadata_type_id`	Unknown
`_embedded_metadata_type_name`	Unknown
`description`	Unknown
`value`	Unknown

field_field_option_group

Column	Type	Keys
`field_id`	Unknown	PKFK
`id`	Unknown	PKFK

field_field_validation

Column	Type	Keys
`field_id`	Unknown	PKFK
`id`	Unknown	PKFK

field

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`additional_config`	Unknown
`dependency_children`	Json
`dependency_parents`	Json
`exclude_on_data_export`	Unknown
`field_enforce_decimals`	Unknown
`field_hidden`	Unknown
`field_image`	Unknown
`field_info`	Unknown
`field_label`	Unknown
`field_length`	Unknown
`field_max`	Unknown
`field_max_label`	Unknown
`field_min`	Unknown
`field_min_label`	Unknown
`field_number`	Unknown
`field_required`	Unknown
`field_slider_step`	Unknown
`field_slider_step_value`	Unknown
`field_summary_template`	Unknown
`field_type`	Unknown
`field_units`	Unknown
`field_variable_name`	Unknown
`randomize_option_order`	Unknown
`report_id`	Unknown

survey_form

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`survey_id`	Unknown	FK
`field_alignment`	Unknown
`form_numbering`	Unknown
`label_bold_if_required`	Unknown
`survey_form_description`	Unknown
`survey_form_name`	Unknown
`survey_form_number`	Unknown

survey_survey_form

Column	Type	Keys
`id`	Unknown	PKFK
`survey_id`	Unknown	PKFK

survey

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`description`	Unknown
`intro_text`	Unknown
`name`	Unknown
`outro_text`	Unknown

repeating_data_instance

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`created_by`	Unknown	FK
`parent_id`	Unknown	FK
`participant_id`	Unknown	FK
`repeating_data_id`	Unknown	FK
`archived`	Unknown
`created_on`	Unknown
`name`	Unknown
`parent_type`	Unknown
`repeating_data_name`	Unknown
`status`	Unknown

study_data_entry

Column	Type	Keys
`field_id`	Unknown	PKFK
`participant_id`	Unknown	PKFK
`study_id`	Unknown	PKFK
`field_variable_name`	Unknown
`updated_on`	Unknown
`value`	Unknown

randomization

Column	Type	Keys
`randomized_id`	Unknown	PK
`participant_id`	Unknown	PKFK
`study_id`	Unknown	PKFK
`randomization_group`	Unknown
`randomization_group_name`	Unknown
`randomized_on_date`	Unknown
`randomized_on_timezone`	Unknown
`randomized_on_timezone_type`	Unknown

visit

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`visit_description`	Unknown
`visit_duration`	Unknown
`visit_name`	Unknown
`visit_order`	Unknown

query_remark

Column	Type	Keys
`id`	Unknown	PK
`query_id`	Unknown	PKFK
`created_by`	Unknown	FK
`created_on_date`	Unknown
`created_on_timezone`	Unknown
`created_on_timezone_type`	Unknown
`description`	Unknown
`title`	Unknown

query

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`created_by`	Unknown	FK
`participant_id`	Unknown	FK
`updated_by`	Unknown	FK
`created_on_date`	Unknown
`created_on_timezone`	Unknown
`created_on_timezone_type`	Unknown
`field_id`	Unknown
`first_query_remark`	Unknown
`record_id`	Unknown
`status`	Unknown
`updated_on_date`	Unknown
`updated_on_timezone`	Unknown
`updated_on_timezone_type`	Unknown

survey_package_survey

Column	Type	Keys
`id`	Unknown	PKFK
`survey_package_id`	Unknown	PKFK

survey_package

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`allow_open_survey_link`	Unknown
`allow_step_navigation`	Unknown
`as_needed`	Unknown
`auto_lock_on_finish`	Unknown
`auto_send`	Unknown
`default_invitation`	Unknown
`default_invitation_subject`	Unknown
`description`	Unknown
`expire_after_hours`	Unknown
`field_pagination`	Unknown
`finish_url`	Unknown
`intro_text`	Unknown
`is_mobile`	Unknown
`is_repeatable`	Unknown
`is_resumable`	Unknown
`is_training`	Unknown
`name`	Unknown
`outro_text`	Unknown
`sender_email`	Unknown
`sender_name`	Unknown
`show_step_navigator`	Unknown
`survey_package_id`	Unknown

field_validation

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`field_id`	Unknown	FK
`operator`	Unknown
`text`	Unknown
`type`	Unknown
`value`	Unknown

verification

Column	Type	Keys
`id`	Unknown	PK
`study_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`changed_field`	Unknown
`dropped_by`	Unknown
`dropped_on_date`	Unknown
`dropped_on_timezone`	Unknown
`dropped_on_timezone_type`	Unknown
`entity_id`	Unknown
`entity_type`	Unknown
`record_id`	Unknown
`status`	Unknown
`verification_type_id`	Unknown
`verification_type_is_sdv`	Unknown
`verification_type_name`	Unknown
`verified_by`	Unknown
`verified_on_date`	Unknown
`verified_on_timezone`	Unknown
`verified_on_timezone_type`	Unknown