SchemaSpy Analysis of oc312.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on za okt 20 16:34 CEST 2012
Legend:
Primary key columns
Columns with indexes
 

oc312.public contains 791 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
user_account lock_counter int4 10 0
dyn_item_form_metadata passed_dde int4 10  √  0
dyn_item_group_metadata passed_dde int4 10  √  0
event_crf sdv_update_id int4 10  √  0
study_module_status crf int4 10  √  1
study_module_status event_definition int4 10  √  1
event_crf old_status_id int4 10  √  1
study old_status_id int4 10  √  1
study_module_status rule int4 10  √  1
study_module_status site int4 10  √  1
study_module_status study int4 10  √  1
study_module_status subject_group int4 10  √  1
study_module_status users int4 10  √  1
event_definition_crf electronic_signature bool 1  √  false
event_crf electronic_signature_status bool 1  √  false
event_definition_crf hide_crf bool 1  √  false
user_account run_webservices bool 1 false
event_crf sdv_status bool 1 false
dataset show_crf_int_date bool 1  √  false
dataset show_crf_int_name bool 1  √  false
dataset show_crf_status bool 1  √  false
dataset show_crf_version bool 1  √  false
dataset show_disc_info bool 1  √  false
dataset show_event_end bool 1  √  false
dataset show_event_location bool 1  √  false
dataset show_event_start bool 1  √  false
dataset show_event_status bool 1  √  false
dataset show_group_info bool 1  √  false
dataset show_secondary_id bool 1  √  false
dataset show_subject_age_at_event bool 1  √  false
dataset show_subject_dob bool 1  √  false
dataset show_subject_gender bool 1  √  false
dataset show_subject_status bool 1  √  false
dataset show_subject_unique_id bool 1  √  false
archived_dataset_file archived_dataset_file_id serial 10  √  nextval('archived_dataset_file_archived_dataset_file_id_seq'::regclass)
audit_event audit_id serial 10  √  nextval('audit_event_audit_id_seq'::regclass)
audit_log_event audit_id serial 10  √  nextval('audit_log_event_audit_id_seq'::regclass)
audit_log_event_type audit_log_event_type_id serial 10  √  nextval('audit_log_event_type_audit_log_event_type_id_seq'::regclass)
audit_user_login id serial 10  √  nextval('audit_user_login_id_seq'::regclass)
authorities id serial 10  √  nextval('authorities_id_seq'::regclass)
completion_status completion_status_id serial 10  √  nextval('completion_status_completion_status_id_seq'::regclass)
configuration id serial 10  √  nextval('configuration_id_seq'::regclass)
crf crf_id serial 10  √  nextval('crf_crf_id_seq'::regclass)
crf_version crf_version_id serial 10  √  nextval('crf_version_crf_version_id_seq'::regclass)
dataset dataset_id serial 10  √  nextval('dataset_dataset_id_seq'::regclass)
dataset_item_status dataset_item_status_id serial 10  √  nextval('dataset_item_status_dataset_item_status_id_seq'::regclass)
dc_computed_event dc_summary_event_id serial 10  √  nextval('dc_computed_event_dc_summary_event_id_seq'::regclass)
dc_event dc_event_id serial 10  √  nextval('dc_event_dc_event_id_seq'::regclass)
dc_primitive dc_primitive_id serial 10  √  nextval('dc_primitive_dc_primitive_id_seq'::regclass)
dc_section_event dc_event_id serial 10  √  nextval('dc_section_event_dc_event_id_seq'::regclass)
dc_send_email_event dc_event_id serial 10  √  nextval('dc_send_email_event_dc_event_id_seq'::regclass)
dc_substitution_event dc_event_id serial 10  √  nextval('dc_substitution_event_dc_event_id_seq'::regclass)
decision_condition decision_condition_id serial 10  √  nextval('decision_condition_decision_condition_id_seq'::regclass)
discrepancy_note discrepancy_note_id serial 10  √  nextval('discrepancy_note_discrepancy_note_id_seq'::regclass)
discrepancy_note_type discrepancy_note_type_id serial 10  √  nextval('discrepancy_note_type_discrepancy_note_type_id_seq'::regclass)
dyn_item_form_metadata id serial 10  √  nextval('dyn_item_form_metadata_id_seq'::regclass)
dyn_item_group_metadata id serial 10  √  nextval('dyn_item_group_metadata_id_seq'::regclass)
event_crf event_crf_id serial 10  √  nextval('event_crf_event_crf_id_seq'::regclass)
event_definition_crf event_definition_crf_id serial 10  √  nextval('event_definition_crf_event_definition_crf_id_seq'::regclass)
export_format export_format_id serial 10  √  nextval('export_format_export_format_id_seq'::regclass)
filter filter_id serial 10  √  nextval('filter_filter_id_seq'::regclass)
group_class_types group_class_type_id serial 10  √  nextval('group_class_types_group_class_type_id_seq'::regclass)
item_data item_data_id serial 10  √  nextval('item_data_item_data_id_seq'::regclass)
item_data_type item_data_type_id serial 10  √  nextval('item_data_type_item_data_type_id_seq'::regclass)
item_form_metadata item_form_metadata_id serial 10  √  nextval('item_form_metadata_item_form_metadata_id_seq'::regclass)
item_group item_group_id serial 10  √  nextval('item_group_item_group_id_seq'::regclass)
item_group_metadata item_group_metadata_id serial 10  √  nextval('item_group_metadata_item_group_metadata_id_seq'::regclass)
item item_id serial 10  √  nextval('item_item_id_seq'::regclass)
item_reference_type item_reference_type_id serial 10  √  nextval('item_reference_type_item_reference_type_id_seq'::regclass)
measurement_unit id serial 10  √  nextval('measurement_unit_id_seq'::regclass)
null_value_type null_value_type_id serial 10  √  nextval('null_value_type_null_value_type_id_seq'::regclass)
openclinica_version id serial 10  √  nextval('openclinica_version_id_seq'::regclass)
privilege priv_id serial 10  √  nextval('privilege_priv_id_seq'::regclass)
resolution_status resolution_status_id serial 10  √  nextval('resolution_status_resolution_status_id_seq'::regclass)
response_set response_set_id serial 10  √  nextval('response_set_response_set_id_seq'::regclass)
response_type response_type_id serial 10  √  nextval('response_type_response_type_id_seq'::regclass)
rule_action id serial 10  √  nextval('rule_action_id_seq'::regclass)
rule_action_property id serial 10  √  nextval('rule_action_property_id_seq'::regclass)
rule_action_run id serial 10  √  nextval('rule_action_run_id_seq'::regclass)
rule_action_run_log id serial 10  √  nextval('rule_action_run_log_id_seq'::regclass)
rule_expression id serial 10  √  nextval('rule_expression_id_seq'::regclass)
rule id serial 10  √  nextval('rule_id_seq'::regclass)
rule_set_audit id serial 10  √  nextval('rule_set_audit_id_seq'::regclass)
rule_set id serial 10  √  nextval('rule_set_id_seq'::regclass)
rule_set_rule_audit id serial 10  √  nextval('rule_set_rule_audit_id_seq'::regclass)
rule_set_rule id serial 10  √  nextval('rule_set_rule_id_seq'::regclass)
scd_item_metadata id serial 10  √  nextval('scd_item_metadata_id_seq'::regclass)
section section_id serial 10  √  nextval('section_section_id_seq'::regclass)
status status_id serial 10  √  nextval('status_status_id_seq'::regclass)
study_event_definition study_event_definition_id serial 10  √  nextval('study_event_definition_study_event_definition_id_seq'::regclass)
study_event study_event_id serial 10  √  nextval('study_event_study_event_id_seq'::regclass)
study_group_class study_group_class_id serial 10  √  nextval('study_group_class_study_group_class_id_seq'::regclass)
study_group study_group_id serial 10  √  nextval('study_group_study_group_id_seq'::regclass)
study_module_status id serial 10  √  nextval('study_module_status_id_seq'::regclass)
study_parameter study_parameter_id serial 10  √  nextval('study_parameter_study_parameter_id_seq'::regclass)
study_parameter_value study_parameter_value_id serial 10  √  nextval('study_parameter_value_study_parameter_value_id_seq'::regclass)
study study_id serial 10  √  nextval('study_study_id_seq'::regclass)
study_subject study_subject_id serial 10  √  nextval('study_subject_study_subject_id_seq'::regclass)
study_type study_type_id serial 10  √  nextval('study_type_study_type_id_seq'::regclass)
subject_event_status subject_event_status_id serial 10  √  nextval('subject_event_status_subject_event_status_id_seq'::regclass)
subject_group_map subject_group_map_id serial 10  √  nextval('subject_group_map_subject_group_map_id_seq'::regclass)
subject subject_id serial 10  √  nextval('subject_subject_id_seq'::regclass)
usage_statistics_data id serial 10  √  nextval('usage_statistics_data_id_seq'::regclass)
user_account user_id serial 10  √  nextval('user_account_user_id_seq'::regclass)
user_role role_id serial 10  √  nextval('user_role_role_id_seq'::regclass)
user_type user_type_id serial 10  √  nextval('user_type_user_type_id_seq'::regclass)
audit_event action_message varchar 4000  √  null
rule_action action_type int4 10
rule_action_run_log action_type int4 10  √  null
user_account active_study int4 10  √  null
rule_action_run administrative_data_entry bool 1  √  null
dn_age_days age int4 10  √  null
study age_max varchar 3  √  null
study age_min varchar 3  √  null
study allocation varchar 64  √  null
event_crf annotations varchar 4000  √  null
dataset approver_id int4 10  √  null
discrepancy_note assigned_user_id int4 10  √  null
study assignment varchar 30  √  null
audit_event audit_date timestamptz 35,6
audit_log_event audit_date timestamptz 35,6
audit_event_context audit_id int4 10  √  null
audit_event_values audit_id int4 10  √  null
audit_log_event audit_log_event_type_id int4 10  √  null
audit_event audit_table varchar 500
audit_log_event audit_table varchar 500
databasechangelog author varchar 63
authorities authority varchar 50
rule_action_run batch bool 1  √  null
oc_qrtz_blob_triggers blob_data bytea 2147483647  √  null
dc_send_email_event body varchar 4000  √  null
item_group_metadata borders int4 10  √  null
section borders int4 10  √  null
openclinica_version build_number varchar 1000  √  null
oc_qrtz_calendars calendar bytea 2147483647
oc_qrtz_calendars calendar_name varchar 200
oc_qrtz_triggers calendar_name varchar 200  √  null
study_event_definition category varchar 2000  √  null
oc_qrtz_scheduler_state checkin_interval int8 19
item_data_type code varchar 20  √  null
null_value_type code varchar 20  √  null
study collaborators varchar 1000  √  null
audit_event_values column_name varchar 255  √  null
dn_event_crf_map column_name varchar 255  √  null
dn_item_data_map column_name varchar 255  √  null
dn_study_event_map column_name varchar 255  √  null
dn_study_subject_map column_name varchar 255  √  null
dn_subject_map column_name varchar 255  √  null
item_form_metadata column_number int4 10  √  null
databasechangelog comments varchar 255  √  null
decision_condition comments varchar 3000
dc_primitive comparison varchar 3
event_crf completion_status_id int4 10  √  null
study conditions varchar 500  √  null
dc_primitive constant_value varchar 4000  √  null
rule_expression context int4 10
study control varchar 30  √  null
scd_item_metadata control_item_form_metadata_id int4 10  √  null
scd_item_metadata control_item_name varchar 255  √  null
audit_event_context crf_id int4 10  √  null
crf_version crf_id int4 10
event_definition_crf crf_id int4 10  √  null
item_group crf_id int4 10
rule_set crf_id int4 10  √  null
audit_event_context crf_version_id int4 10  √  null
decision_condition crf_version_id int4 10  √  null
dyn_item_form_metadata crf_version_id int4 10  √  null
event_crf crf_version_id int4 10  √  null
filter_crf_version_map crf_version_id int4 10  √  null
item_form_metadata crf_version_id int4 10  √  null
item_group_metadata crf_version_id int4 10
rule_set crf_version_id int4 10  √  null
section crf_version_id int4 10
versioning_map crf_version_id int4 10  √  null
oc_qrtz_cron_triggers cron_expression varchar 120
archived_dataset_file dataset_id int4 10  √  null
dataset_crf_version_map dataset_id int4 10  √  null
dataset_filter_map dataset_id int4 10  √  null
dataset_study_group_class_map dataset_id int4 10
dataset dataset_item_status_id int4 10  √  null
event_crf date_completed timestamptz 35,6  √  null
archived_dataset_file date_created timestamp 29,6  √  null
crf date_created date 13  √  null
crf_version date_created date 13  √  null
dataset date_created date 13  √  null
decision_condition date_created date 13  √  null
discrepancy_note date_created date 13  √  null
event_crf date_created date 13  √  null
event_definition_crf date_created date 13  √  null
filter date_created date 13  √  null
item date_created date 13  √  null
item_data date_created date 13  √  null
item_group date_created date 13  √  null
rule date_created date 13  √  null
rule_action date_created date 13  √  null
rule_expression date_created date 13  √  null
rule_set date_created date 13  √  null
rule_set_rule date_created date 13  √  null
section date_created date 13  √  null
study date_created date 13  √  null
study_event date_created date 13  √  null
study_event_definition date_created date 13  √  null
study_group_class date_created date 13  √  null
study_module_status date_created date 13  √  null
study_subject date_created date 13  √  null
study_user_role date_created date 13  √  null
subject date_created date 13  √  null
subject_group_map date_created date 13  √  null
user_account date_created date 13  √  null
dataset date_end date 13  √  null
study_event date_end timestamptz 35,6  √  null
event_crf date_interviewed date 13  √  null
dataset date_last_run date 13  √  null
user_account date_lastvisit timestamptz 35,6  √  null
subject date_of_birth date 13  √  null
study date_planned_end date 13  √  null
study date_planned_start date 13  √  null
dataset date_start date 13  √  null
study_event date_start timestamptz 35,6  √  null
crf date_updated date 13  √  null
crf_version date_updated date 13  √  null
dataset date_updated date 13  √  null
decision_condition date_updated date 13  √  null
event_crf date_updated date 13  √  null
event_definition_crf date_updated date 13  √  null
filter date_updated date 13  √  null
item date_updated date 13  √  null
item_data date_updated date 13  √  null
item_group date_updated date 13  √  null
rule date_updated date 13  √  null
rule_action date_updated date 13  √  null
rule_expression date_updated date 13  √  null
rule_set date_updated date 13  √  null
rule_set_audit date_updated date 13  √  null
rule_set_rule date_updated date 13  √  null
rule_set_rule_audit date_updated date 13  √  null
section date_updated date 13  √  null
study date_updated date 13  √  null
study_event date_updated date 13  √  null
study_event_definition date_updated date 13  √  null
study_group_class date_updated date 13  √  null
study_module_status date_updated date 13  √  null
study_subject date_updated date 13  √  null
study_user_role date_updated date 13  √  null
subject date_updated date 13  √  null
subject_group_map date_updated date 13  √  null
user_account date_updated date 13  √  null
event_crf date_validate date 13  √  null
event_crf date_validate_completed timestamptz 35,6  √  null
databasechangelog dateexecuted timestamptz 35,6
dn_age_days days int4 10  √  null
dc_computed_event dc_event_id int4 10
dc_summary_item_map dc_summary_event_id int4 10  √  null
dc_event decision_condition_id int4 10  √  null
dc_primitive decision_condition_id int4 10  √  null
item_form_metadata decision_condition_id int4 10  √  null
event_definition_crf decision_conditions bool 1  √  null
item_form_metadata default_value varchar 4000  √  null
study_parameter default_value varchar 50  √  null
event_definition_crf default_version_id int4 10  √  null
item_data_type definition varchar 1000  √  null
null_value_type definition varchar 1000  √  null
completion_status description varchar 1000  √  null
configuration description varchar 512  √  null
crf description varchar 2048  √  null
crf_version description varchar 4000  √  null
databasechangelog description varchar 255  √  null
dataset description varchar 2000  √  null
dataset_item_status description varchar 255  √  null
discrepancy_note description varchar 255  √  null
discrepancy_note_type description varchar 255  √  null
export_format description varchar 1000  √  null
filter description varchar 2000  √  null
group_class_types description varchar 1000  √  null
item description varchar 4000  √  null
item_reference_type description varchar 1000  √  null
measurement_unit description varchar 255  √  null
oc_qrtz_job_details description varchar 250  √  null
oc_qrtz_triggers description varchar 250  √  null
resolution_status description varchar 255  √  null
response_type description varchar 1000  √  null
rule description varchar 255  √  null
status description varchar 1000  √  null
study_event_definition description varchar 2000  √  null
study_group description varchar 1000  √  null
study_parameter description varchar 255  √  null
study_type description varchar 1000  √  null
subject_event_status description varchar 1000  √  null
discrepancy_note detailed_notes varchar 1000  √  null
dn_age_days discrepancy_note_id int4 10  √  null
dn_event_crf_map discrepancy_note_id int4 10  √  null
dn_item_data_map discrepancy_note_id int4 10  √  null
dn_study_event_map discrepancy_note_id int4 10  √  null
dn_study_subject_map discrepancy_note_id int4 10  √  null
dn_subject_map discrepancy_note_id int4 10  √  null
discrepancy_note discrepancy_note_type_id int4 10  √  null
subject dob_collected bool 1  √  null
rule_action_run double_data_entry bool 1  √  null
event_definition_crf double_entry bool 1  √  null
study duration varchar 30  √  null
dc_primitive dynamic_value_item_id int4 10  √  null
study eligibility varchar 500  √  null
user_account email varchar 120  √  null
rule_action email_to varchar 255  √  null
rule enabled bool 1  √  null
oc_qrtz_triggers end_time int8 19  √  null
study_event end_time_flag bool 1  √  null
study endpoint varchar 64  √  null
study_subject enrollment_date date 13  √  null
audit_event entity_id int4 10  √  null
audit_log_event entity_id int4 10  √  null
audit_log_event entity_name varchar 500  √  null
discrepancy_note entity_type varchar 30  √  null
oc_qrtz_fired_triggers entry_id varchar 95
audit_event_context event_crf_id int4 10  √  null
audit_log_event event_crf_id int4 10  √  null
dn_event_crf_map event_crf_id int4 10  √  null
dyn_item_form_metadata event_crf_id int4 10  √  null
dyn_item_group_metadata event_crf_id int4 10  √  null
item_data event_crf_id int4 10  √  null
audit_log_event event_crf_version_id int4 10  √  null
dataset_crf_version_map event_definition_crf_id int4 10  √  null
study expected_total_enrollment int4 10  √  null
archived_dataset_file export_format_id int4 10  √  null
rule_action expression_evaluates_to bool 1
study facility_city varchar 255  √  null
study facility_contact_degree varchar 255  √  null
study facility_contact_email varchar 255  √  null
study facility_contact_name varchar 255  √  null
study facility_contact_phone varchar 255  √  null
study facility_country varchar 64  √  null
study facility_name varchar 255  √  null
study facility_recruitment_status varchar 60  √  null
study facility_state varchar 20  √  null
study facility_zip varchar 64  √  null
subject father_id int4 10  √  null
archived_dataset_file file_reference varchar 1000  √  null
archived_dataset_file file_size int4 10  √  null
databasechangelog filename varchar 200
dataset_filter_map filter_id int4 10  √  null
filter_crf_version_map filter_id int4 10  √  null
oc_qrtz_fired_triggers fired_time int8 19
user_account first_name varchar 50  √  null
study gender varchar 30  √  null
subject gender bpchar 1  √  null
study_group_class group_class_type_id int4 10  √  null
study_parameter handle varchar 50  √  null
item_form_metadata header varchar 2000  √  null
item_group_metadata header varchar 255  √  null
study healthy_volunteer_accepted bool 1  √  null
databasechangelog id varchar 63
databasechangeloglock id int4 10
rule_action_run import_data_entry bool 1  √  null
rule_action_run initial_data_entry bool 1  √  null
oc_qrtz_fired_triggers instance_name varchar 200
oc_qrtz_scheduler_state instance_name varchar 200
user_account institutional_affiliation varchar 255  √  null
section instructions varchar 2000  √  null
study interventions varchar 1000  √  null
event_crf interviewer_name varchar 255  √  null
oc_qrtz_job_details is_durable bool 1
oc_qrtz_fired_triggers is_stateful bool 1  √  null
oc_qrtz_job_details is_stateful bool 1
oc_qrtz_fired_triggers is_volatile bool 1
oc_qrtz_job_details is_volatile bool 1
oc_qrtz_triggers is_volatile bool 1
dn_item_data_map item_data_id int4 10  √  null
dyn_item_form_metadata item_data_id int4 10  √  null
rule_action_run_log item_data_id int4 10  √  null
item item_data_type_id int4 10  √  null
dyn_item_form_metadata item_form_metadata_id int4 10  √  null
dyn_item_group_metadata item_group_id int4 10  √  null
item_group_metadata item_group_id int4 10
rule_set item_group_id int4 10  √  null
dyn_item_group_metadata item_group_metadata_id int4 10  √  null
audit_event_context item_id int4 10  √  null
dc_primitive item_id int4 10  √  null
dc_substitution_event item_id int4 10  √  null
dc_summary_item_map item_id int4 10  √  null
dyn_item_form_metadata item_id int4 10  √  null
item_data item_id int4 10
item_form_metadata item_id int4 10
item_group_metadata item_id int4 10
rule_set item_id int4 10  √  null
versioning_map item_id int4 10  √  null
item item_reference_type_id int4 10  √  null
dc_computed_event item_target_id int4 10  √  null
oc_qrtz_job_details job_class_name varchar 250
oc_qrtz_job_details job_data bytea 2147483647  √  null
oc_qrtz_triggers job_data bytea 2147483647  √  null
oc_qrtz_fired_triggers job_group varchar 200  √  null
oc_qrtz_job_details job_group varchar 200
oc_qrtz_job_listeners job_group varchar 200
oc_qrtz_triggers job_group varchar 200
oc_qrtz_job_listeners job_listener varchar 200
oc_qrtz_fired_triggers job_name varchar 200  √  null
oc_qrtz_job_details job_name varchar 200
oc_qrtz_job_listeners job_name varchar 200
oc_qrtz_triggers job_name varchar 200
configuration key varchar 255  √  null
study keywords varchar 255  √  null
decision_condition label varchar 1000
response_set label varchar 80  √  null
section label varchar 2000  √  null
study_subject label varchar 30  √  null
oc_qrtz_scheduler_state last_checkin_time int8 19
user_account last_name varchar 50  √  null
item_group_metadata layout varchar 100  √  null
item_form_metadata left_item_text varchar 4000  √  null
databasechangelog liquibase varchar 10  √  null
study_event location varchar 2000  √  null
oc_qrtz_locks lock_name varchar 40
databasechangeloglock locked bool 1
databasechangeloglock lockedby varchar 255  √  null
databasechangeloglock lockgranted timestamptz 35,6  √  null
audit_user_login login_attempt_date timestamptz 35,6  √  null
audit_user_login login_status_code int4 10  √  null
study masking varchar 30  √  null
databasechangelog md5sum varchar 32  √  null
study medline_identifier varchar 255  √  null
rule_action message varchar 255  √  null
scd_item_metadata message varchar 3000  √  null
export_format mime_type varchar 255  √  null
oc_qrtz_triggers misfire_instr int2 5  √  null
subject mother_id int4 10  √  null
archived_dataset_file name varchar 255  √  null
audit_log_event_type name varchar 255  √  null
completion_status name varchar 255  √  null
crf name varchar 255  √  null
crf_version name varchar 255  √  null
dataset name varchar 255  √  null
dataset_item_status name varchar 50  √  null
discrepancy_note_type name varchar 50  √  null
export_format name varchar 255  √  null
filter name varchar 255  √  null
group_class_types name varchar 255  √  null
item name varchar 255  √  null
item_data_type name varchar 255  √  null
item_group name varchar 255  √  null
item_reference_type name varchar 255  √  null
measurement_unit name varchar 100
null_value_type name varchar 255  √  null
openclinica_version name varchar 255  √  null
resolution_status name varchar 50  √  null
response_type name varchar 255  √  null
rule name varchar 255  √  null
status name varchar 255  √  null
study name varchar 255  √  null
study_event_definition name varchar 2000  √  null
study_group name varchar 255  √  null
study_group_class name varchar 30  √  null
study_parameter name varchar 50  √  null
study_type name varchar 255  √  null
subject_event_status name varchar 255  √  null
audit_event_values new_value varchar 2000  √  null
audit_log_event new_value varchar 4000  √  null
oc_qrtz_triggers next_fire_time int8 19  √  null
subject_group_map notes varchar 255  √  null
event_definition_crf null_values varchar 255  √  null
dataset num_runs int4 10  √  null
crf oc_oid varchar 40
crf_version oc_oid varchar 40
item oc_oid varchar 40
item_group oc_oid varchar 40
measurement_unit oc_oid varchar 40
rule oc_oid varchar 40  √  null
rule_action_property oc_oid varchar 512  √  null
study oc_oid varchar 40
study_event_definition oc_oid varchar 40
study_subject oc_oid varchar 40
dataset odm_metadataversion_name varchar 255  √  null
dataset odm_metadataversion_oid varchar 255  √  null
dataset odm_prior_metadataversion_oid varchar 255  √  null
dataset odm_prior_study_oid varchar 255  √  null
study official_title varchar 255  √  null
item_data old_status_id int4 10  √  null
audit_event_values old_value varchar 2000  √  null
audit_log_event old_value varchar 4000  √  null
scd_item_metadata option_value varchar 500  √  null
response_set options_text varchar 4000  √  null
response_set options_values varchar 4000  √  null
dataset_filter_map ordinal int4 10  √  null
dc_event ordinal int4 10
dc_summary_item_map ordinal int4 10  √  null
event_definition_crf ordinal int4 10  √  null
item_data ordinal int4 10  √  null
item_form_metadata ordinal int4 10
item_group_metadata ordinal int4 10
section ordinal int4 10  √  null
study_event_definition ordinal int4 10  √  null
study_parameter overridable bool 1  √  null
archived_dataset_file owner_id int4 10  √  null
crf owner_id int4 10  √  null
crf_version owner_id int4 10  √  null
dataset owner_id int4 10  √  null
decision_condition owner_id int4 10  √  null
discrepancy_note owner_id int4 10  √  null
event_crf owner_id int4 10  √  null
event_definition_crf owner_id int4 10  √  null
filter owner_id int4 10
item owner_id int4 10  √  null
item_data owner_id int4 10  √  null
item_group owner_id int4 10  √  null
rule owner_id int4 10  √  null
rule_action owner_id int4 10  √  null
rule_expression owner_id int4 10  √  null
rule_set owner_id int4 10  √  null
rule_set_rule owner_id int4 10  √  null
section owner_id int4 10
study owner_id int4 10  √  null
study_event owner_id int4 10  √  null
study_event_definition owner_id int4 10  √  null
study_group_class owner_id int4 10  √  null
study_module_status owner_id int4 10  √  null
study_subject owner_id int4 10  √  null
study_user_role owner_id int4 10  √  null
subject owner_id int4 10  √  null
subject_group_map owner_id int4 10  √  null
user_account owner_id int4 10  √  null
item_form_metadata page_number_label varchar 5  √  null
section page_number_label varchar 5  √  null
usage_statistics_data param_key varchar 255  √  null
usage_statistics_data param_value varchar 1000  √  null
study_parameter_value parameter varchar 50  √  null
discrepancy_note parent_dn_id int4 10  √  null
event_definition_crf parent_id int4 10  √  null
item_form_metadata parent_id int4 10  √  null
section parent_id int4 10  √  null
user_role parent_id int4 10  √  null
item_form_metadata parent_label varchar 120  √  null
study parent_study_id int4 10  √  null
user_account passwd varchar 255  √  null
user_account passwd_challenge_answer varchar 255  √  null
user_account passwd_challenge_question varchar 64  √  null
user_account passwd_timestamp date 13  √  null
study phase varchar 30  √  null
item phi_status bool 1  √  null
user_account phone varchar 64  √  null
oc_qrtz_triggers prev_fire_time int8 19  √  null
study principal_investigator varchar 255  √  null
oc_qrtz_fired_triggers priority int4 10
oc_qrtz_triggers priority int4 10  √  null
privilege priv_desc varchar 2000  √  null
role_privilege_map priv_id int4 10
privilege priv_name varchar 50  √  null
role_privilege_map priv_value varchar 50  √  null
study protocol_date_verification date 13  √  null
study protocol_description varchar 1000  √  null
study protocol_type varchar 30  √  null
study purpose varchar 64  √  null
decision_condition quantity int4 10
item_form_metadata question_number_label varchar 20  √  null
audit_event reason_for_change varchar 1000  √  null
audit_log_event reason_for_change varchar 1000  √  null
item_data_type reference varchar 1000  √  null
null_value_type reference varchar 1000  √  null
item_form_metadata regexp varchar 1000  √  null
item_form_metadata regexp_error_msg varchar 255  √  null
item_group_metadata repeat_array varchar 255  √  null
oc_qrtz_simple_triggers repeat_count int8 19
oc_qrtz_simple_triggers repeat_interval int8 19
item_group_metadata repeat_max int4 10  √  null
item_group_metadata repeat_number int4 10  √  null
study_event_definition repeating bool 1  √  null
oc_qrtz_fired_triggers requests_recovery bool 1  √  null
oc_qrtz_job_details requests_recovery bool 1
event_definition_crf require_all_text_filled bool 1  √  null
item_form_metadata required bool 1  √  null
event_definition_crf required_crf bool 1  √  null
discrepancy_note resolution_status_id int4 10  √  null
item_form_metadata response_layout varchar 255  √  null
item_form_metadata response_set_id int4 10
response_set response_type_id int4 10  √  null
study results_reference bool 1  √  null
crf_version revision_notes varchar 255  √  null
item_form_metadata right_item_text varchar 2000  √  null
user_role role_desc varchar 2000  √  null
role_privilege_map role_id int4 10
audit_event_context role_name varchar 200  √  null
study_user_role role_name varchar 40  √  null
user_role role_name varchar 50
item_group_metadata row_start_number int4 10  √  null
rule_action_property rule_action_id int4 10  √  null
rule_action rule_action_run_id int4 10  √  null
rule rule_expression_id int4 10
rule_action_property rule_expression_id int4 10  √  null
rule_set rule_expression_id int4 10
rule_set_rule rule_id int4 10
rule_action_run_log rule_oc_oid varchar 40  √  null
rule_set_audit rule_set_id int4 10
rule_set_rule rule_set_id int4 10
rule_action rule_set_rule_id int4 10
rule_set_rule_audit rule_set_rule_id int4 10
archived_dataset_file run_time int4 10  √  null
study_event sample_ordinal int4 10  √  null
scd_item_metadata scd_item_form_metadata_id int4 10  √  null
study secondary_identifier varchar 255  √  null
study_subject secondary_label varchar 30  √  null
dc_section_event section_id int4 10
item_form_metadata section_id int4 10
event_definition_crf selected_version_ids varchar 150  √  null
study selection varchar 30  √  null
event_definition_crf source_data_verification_code int4 10  √  null
crf source_study_id int4 10  √  null
study sponsor varchar 255  √  null
dataset sql_statement text 2147483647  √  null
filter sql_statement varchar 4000  √  null
oc_qrtz_triggers start_time int8 19
study_event start_time_flag bool 1  √  null
oc_qrtz_fired_triggers state varchar 16
completion_status status_id int4 10  √  null
crf status_id int4 10  √  null
crf_version status_id int4 10  √  null
dataset status_id int4 10  √  null
decision_condition status_id int4 10  √  null
event_crf status_id int4 10  √  null
event_definition_crf status_id int4 10  √  null
filter status_id int4 10  √  null
item status_id int4 10  √  null
item_data status_id int4 10  √  null
item_group status_id int4 10  √  null
rule status_id int4 10  √  null
rule_action status_id int4 10  √  null
rule_expression status_id int4 10  √  null
rule_set status_id int4 10  √  null
rule_set_audit status_id int4 10  √  null
rule_set_rule status_id int4 10  √  null
rule_set_rule_audit status_id int4 10  √  null
section status_id int4 10  √  null
study status_id int4 10  √  null
study_event status_id int4 10  √  null
study_event_definition status_id int4 10  √  null
study_group_class status_id int4 10  √  null
study_module_status status_id int4 10  √  null
study_subject status_id int4 10  √  null
study_user_role status_id int4 10  √  null
subject status_id int4 10  √  null
subject_group_map status_id int4 10  √  null
user_account status_id int4 10  √  null
audit_event_context study_crf_id int4 10  √  null
audit_event_context study_event_definition_id int4 10  √  null
event_definition_crf study_event_definition_id int4 10  √  null
rule_set study_event_definition_id int4 10  √  null
study_event study_event_definition_id int4 10  √  null
audit_event_context study_event_id int4 10  √  null
audit_log_event study_event_id int4 10  √  null
dn_study_event_map study_event_id int4 10  √  null
event_crf study_event_id int4 10  √  null
dataset_study_group_class_map study_group_class_id int4 10
study_group study_group_class_id int4 10  √  null
subject_group_map study_group_class_id int4 10  √  null
subject_group_map study_group_id int4 10  √  null
audit_event_context study_id int4 10  √  null
dataset study_id int4 10  √  null
discrepancy_note study_id int4 10  √  null
event_definition_crf study_id int4 10  √  null
rule study_id int4 10  √  null
rule_set study_id int4 10
study_event_definition study_id int4 10  √  null
study_group_class study_id int4 10  √  null
study_module_status study_id int4 10  √  null
study_parameter_value study_id int4 10  √  null
study_subject study_id int4 10  √  null
study_user_role study_id int4 10  √  null
audit_event_context study_subject_id int4 10  √  null
dn_item_data_map study_subject_id int4 10  √  null
dn_study_subject_map study_subject_id int4 10  √  null
event_crf study_subject_id int4 10  √  null
study_event study_subject_id int4 10  √  null
subject_group_map study_subject_id int4 10  √  null
item_form_metadata subheader varchar 240  √  null
item_group_metadata subheader varchar 255  √  null
dc_send_email_event subject varchar 1000  √  null
study_group_class subject_assignment varchar 30  √  null
study_event subject_event_status_id int4 10  √  null
audit_event_context subject_id int4 10  √  null
dn_subject_map subject_id int4 10  √  null
study_subject subject_id int4 10  √  null
section subtitle varchar 2000  √  null
study summary varchar 255  √  null
dc_computed_event summary_type varchar 255  √  null
databasechangelog tag varchar 255  √  null
oc_qrtz_cron_triggers time_zone_id varchar 80  √  null
oc_qrtz_simple_triggers times_triggered int8 19
study timing varchar 30  √  null
section title varchar 2000  √  null
dc_send_email_event to_address varchar 1000
oc_qrtz_blob_triggers trigger_group varchar 200
oc_qrtz_cron_triggers trigger_group varchar 200
oc_qrtz_fired_triggers trigger_group varchar 200
oc_qrtz_paused_trigger_grps trigger_group varchar 200
oc_qrtz_simple_triggers trigger_group varchar 200
oc_qrtz_trigger_listeners trigger_group varchar 200
oc_qrtz_triggers trigger_group varchar 200
oc_qrtz_trigger_listeners trigger_listener varchar 200
oc_qrtz_blob_triggers trigger_name varchar 200
oc_qrtz_cron_triggers trigger_name varchar 200
oc_qrtz_fired_triggers trigger_name varchar 200
oc_qrtz_simple_triggers trigger_name varchar 200
oc_qrtz_trigger_listeners trigger_name varchar 200
oc_qrtz_triggers trigger_name varchar 200
oc_qrtz_triggers trigger_state varchar 16
oc_qrtz_triggers trigger_type varchar 8
dc_event type varchar 256
decision_condition type varchar 3
study_event_definition type varchar 20  √  null
study type_id int4 10  √  null
study unique_identifier varchar 30  √  null
subject unique_identifier varchar 255  √  null
item units varchar 64  √  null
crf update_id int4 10  √  null
crf_version update_id int4 10  √  null
dataset update_id int4 10  √  null
decision_condition update_id int4 10  √  null
event_crf update_id int4 10  √  null
event_definition_crf update_id int4 10  √  null
filter update_id int4 10  √  null
item update_id int4 10  √  null
item_data update_id int4 10  √  null
item_group update_id int4 10  √  null
rule update_id int4 10  √  null
rule_action update_id int4 10  √  null
rule_expression update_id int4 10  √  null
rule_set update_id int4 10  √  null
rule_set_rule update_id int4 10  √  null
section update_id int4 10  √  null
study update_id int4 10  √  null
study_event update_id int4 10  √  null
study_event_definition update_id int4 10  √  null
study_group_class update_id int4 10  √  null
study_module_status update_id int4 10  √  null
study_subject update_id int4 10  √  null
study_user_role update_id int4 10  √  null
subject update_id int4 10  √  null
subject_group_map update_id int4 10  √  null
user_account update_id int4 10  √  null
openclinica_version update_timestamp timestamptz 35,6  √  null
usage_statistics_data update_timestamp timestamptz 35,6  √  null
rule_set_audit updater_id int4 10  √  null
rule_set_rule_audit updater_id int4 10  √  null
study url varchar 255  √  null
study url_description varchar 255  √  null
audit_user_login user_account_id int4 10  √  null
audit_event user_id int4 10  √  null
audit_log_event user_id int4 10  √  null
audit_user_login user_name varchar 255  √  null
study_user_role user_name varchar 40  √  null
user_account user_name varchar 64  √  null
user_type user_type varchar 50  √  null
user_account user_type_id int4 10  √  null
authorities username varchar 50
event_crf validate_string varchar 256  √  null
event_crf validator_annotations varchar 4000  √  null
event_crf validator_id int4 10  √  null
configuration value varchar 255  √  null
dc_substitution_event value varchar 1000
item_data value varchar 4000  √  null
rule_action_property value varchar 512  √  null
rule_action_run_log value varchar 4000  √  null
rule_expression value varchar 1025
study_parameter_value value varchar 50  √  null
audit_user_login version int4 10  √  null
authorities version int4 10  √  null
configuration version int4 10  √  null
dyn_item_form_metadata version int4 10  √  null
dyn_item_group_metadata version int4 10  √  null
measurement_unit version int4 10  √  null
openclinica_version version int4 10  √  null
rule version int4 10  √  null
rule_action version int4 10  √  null
rule_action_property version int4 10  √  null
rule_action_run version int4 10  √  null
rule_action_run_log version int4 10  √  null
rule_expression version int4 10  √  null
rule_set version int4 10  √  null
rule_set_audit version int4 10  √  null
rule_set_rule version int4 10  √  null
rule_set_rule_audit version int4 10  √  null
scd_item_metadata version int4 10  √  null
study_module_status version int4 10  √  null
usage_statistics_data version int4 10  √  null
response_set version_id int4 10  √  null
item_form_metadata width_decimal varchar 10  √  null
user_account account_non_locked bool 1 true
user_account enabled bool 1 true
study_parameter inheritable bool 1  √  true
item_group_metadata repeating_group bool 1 true
dyn_item_group_metadata show_group bool 1  √  true
item_group_metadata show_group bool 1  √  true
dyn_item_form_metadata show_item bool 1  √  true
item_form_metadata show_item bool 1  √  true