SchemaSpy Analysis of oc312.public Generated by
SchemaSpy
Generated by SchemaSpy on za okt 20 16:34 CEST 2012
Database Type: PostgreSQL - 8.4.9

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
archived_dataset_file 2 9
audit_event 2 7
audit_event_context 1 12
audit_event_values 1 4
audit_log_event 13
audit_log_event_type 2
audit_user_login 1 6
authorities 4
completion_status 1 1 4
configuration 5
crf 3 3 10
crf_version 7 3 11
databasechangelog 9
databasechangeloglock 4
dataset 4 4 36
dataset_crf_version_map 2 2
dataset_filter_map 2 3
dataset_item_status 1 3
dataset_study_group_class_map 2 2
dc_computed_event 1 1 4
dc_event 4 1 4
dc_primitive 3 6
dc_section_event 1 2
dc_send_email_event 1 4
dc_substitution_event 2 3
dc_summary_item_map 2 3
decision_condition 2 3 11
discrepancy_note 5 5 11
discrepancy_note_type 1 3
dn_age_days 3
dn_event_crf_map 2 3
dn_item_data_map 2 4
dn_study_event_map 2 3
dn_study_subject_map 2 3
dn_subject_map 2 3
dyn_item_form_metadata 9
dyn_item_group_metadata 7
event_crf 2 6 23
event_definition_crf 1 6 21
export_format 1 4
filter 2 2 9
filter_crf_version_map 2 2
group_class_types 1 3
item 8 4 13
item_data 1 4 11
item_data_type 1 5
item_form_metadata 2 3 23
item_group 1 3 9
item_group_metadata 3 15
item_reference_type 1 3
measurement_unit 5
null_value_type 5
oc_qrtz_blob_triggers 2 3
oc_qrtz_calendars 2
oc_qrtz_cron_triggers 2 4
oc_qrtz_fired_triggers 12
oc_qrtz_job_details 4 9
oc_qrtz_job_listeners 2 3
oc_qrtz_locks 1
oc_qrtz_paused_trigger_grps 1
oc_qrtz_scheduler_state 3
oc_qrtz_simple_triggers 2 5
oc_qrtz_trigger_listeners 2 3
oc_qrtz_triggers 8 2 16
openclinica_version 5
privilege 1 3
resolution_status 1 3
response_set 1 1 6
response_type 1 3
role_privilege_map 2 3
rule 13
rule_action 13
rule_action_property 6
rule_action_run 7
rule_action_run_log 6
rule_expression 9
rule_set 14
rule_set_audit 6
rule_set_rule 9
rule_set_rule_audit 6
scd_item_metadata 2 7
section 1 3 15
status 22 3
study 10 5 56
study_event 2 4 15
study_event_definition 2 3 14
study_group 1 1 4
study_group_class 3 3 10
study_module_status 1 15
study_parameter 1 7
study_parameter_value 2 4
study_subject 4 4 12
study_type 1 3
study_user_role 3 8
subject 4 4 12
subject_event_status 3
subject_group_map 5 10
usage_statistics_data 5
user_account 23 3 23
user_role 1 4
user_type 1 2
versioning_map 2 2
         
101 Tables     788  
1 View     3