SchemaSpy Analysis of clean.public Generated by
SchemaSpy
Generated by SchemaSpy on Wed Feb 01 09:18 EST 2012
Database Type: PostgreSQL - 8.4.9 SourceForge.net

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

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