SchemaSpy Analysis of oscar_bc Generated by
SchemaSpy
Generated by SchemaSpy on Tue Feb 24 13:26 EST 2009
Database Type: MySQL - 5.0.67-0ubuntu6 SourceForge.net

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

366 Tables:

Table Children Parents Columns Rows Comments
access_type 3 50
admission 18 0
agency 5 1
allergies 16 0
app_lookuptable 7 13
app_lookuptable_fields 11 40
app_module 2 5
appointment 19 0
appointment_status 7 13
batchEligibility 3 0
bed 8 0
bed_check_time 3 0
bed_demographic 7 0
bed_demographic_historical 4 0
bed_demographic_status 4 1
bed_type 3 1
bill_recipients 9 0
billactivity 15 0
billcenter 2 0
billing 25 0
billing_cdm_service_codes 3 3
billing_history 11 0
billing_msp_servicecode_times 3 10
billing_on_3rdPartyAddress 9 0
billing_payment_type 2 10
billing_preferences 4 0
billing_private_transactions 5 0
billing_service_code_conditions 4 8
billing_trayfees 3 0
billingdetail 9 0
billinginr 16 0
billinglocation 3 218
billingmaster 60 0
billingnote 6 0
billingreferral 12 10,203
billingservice 10 4,395
billingstatus_types 4 16
billingtypes 2 4
billingvisit 3 12
caisi_form 6 0
caisi_form_data 7 0
caisi_form_data_tmpsave 7 0
caisi_form_instance 8 0
caisi_form_instance_tmpsave 9 0
caisi_form_question 8 0
caisi_role 5 4
casemgmt_cpp 14 0
casemgmt_issue 10 0
casemgmt_issue_notes 2 0
casemgmt_note 20 0
casemgmt_note_ext 5 0
casemgmt_note_link 4 0
casemgmt_tmpsave 7 0
client_image 6 0
client_referral 13 0
ClientLink 4 9 0
clinic 12 1
clinic_location 3 11
config_Immunization 6 5
consultationRequests 18 0
consultationServices 3 5
consultdocs 7 0
country_codes 4 247
cr_cert 13 0
cr_machine 3 0
cr_policy 18 5
cr_securityquestion 4 0
cr_user 5 0
cr_userrole 2 0
ctl_billingservice 7 67
ctl_billingservice_age_rules 4 126
ctl_billingservice_premium 4 0
ctl_billingservice_sex_rules 3 0
ctl_diagcode 3 18
ctl_doctype 3 16
ctl_document 4 3
ctl_frequency 4 20
ctl_provider 3 0
ctl_servicecodes_dxcodes 3 0
ctl_specialinstructions 2 26
custom_filter 10 0
custom_filter_assignees 2 0
custom_filter_providers 2 0
default_role_access 3 17
demographic 5 38 0
demographic_merged 6 0
demographicaccessory 2 0
demographiccust 6 0
demographicExt 7 0
demographicPharmacy 4 0
demographicQueryFavourites 13 0
demographicSets 3 0
demographicstudy 4 0
desannualreviewplan 8 0
desaprisk 8 0
diagnosticcode 5 7,203
diseases 4 0
document 15 0
drugs 36 0
dxresearch 7 0
eChart 11 0
eform 9 0
eform_data 10 0
eform_groups 3 0
eform_values 6 0
eforms 9 0
eforms_data 11 0
encounter 8 0
encounterForm 4 46
encountertemplate 4 213
encounterWindow 5 0
Facility 6 18 3
facility_message 6 0
favorites 26 0
favoritesprivilege 4 0
FaxClientLog 7 0
fileUploadCheck 5 0
flowsheet_customization 10 0
form 7 0
form2MinWalk 22 0
formAdf 62 0
formAdfV2 68 0
formAlpha 48 0
formAnnual 119 0
formAnnualV2 198 0
formAR 673 0
formBCAR 695 0
formBCAR2007 814 0
formBCBirthSumMo 210 0
formBCClientChartChecklist 333 0
formBCHP 265 0
formBCINR 168 0
formBCNewBorn 353 0
formCaregiver 53 0
formCESD 87 0
formchf 189 0
formConsult 26 0
formCostQuestionnaire 65 0
formDischargeSummary 57 0
formFalls 17 0
formfollowup 170 0
formGripStrength 14 0
formGrowth0_36 131 0
formGrowthChart 261 0
formHomeFalls 69 0
formImmunAllergy 25 0
formintakea 154 0
formintakeb 170 0
formintakec 240 0
formIntakeInfo 156 0
formInternetAccess 18 0
formLabReq 70 0
formLateLifeFDIDisability 166 0
formLateLifeFDIFunction 206 0
formMentalHealth 73 0
formMentalHealthForm1 40 0
formMentalHealthForm14 14 0
formMMSE 30 0
formPalliativeCare 95 0
formPeriMenopausal 216 0
formreceptionassessment 138 0
formRhImmuneGlobulin 81 0
formRourke 425 0
formRourke2006 627 0
formSatisfactionScale 33 0
formSelfAdministered 33 0
formSelfEfficacy 49 0
formSelfManagement 55 0
formSF36 210 0
formSF36Caregiver 210 0
formTreatmentPref 9 0
formType2Diabetes 138 0
formVTForm 160 0
formWCB 45 0
functional_user_type 2 0
groupMembers_tbl 2 0
groups_tbl 3 1
gstControl 2 1
hash_audit 5 0
health_safety 5 0
hl7_link 5 0
hl7_message 3 0
hl7_msh 21 0
hl7_obr 46 0
hl7_obx 20 0
hl7_orc 21 0
hl7_pid 33 0
hl7TextInfo 14 0
hl7TextMessage 4 0
HnrDataValidation 3 8 0
icd9 3 15,361
ichppccode 3 232
immunizations 6 0
incomingLabRules 5 0
indivoDocs 6 0
intake 1 1 11 0
intake_answer 2 4 0
intake_answer_element 2 5 8
intake_answer_validation 1 2 4
intake_node 3 3 10 2
intake_node_label 2 2 15
intake_node_template 2 2 4 15
intake_node_type 1 2 8
IntegratorConsent 3 14 0
IntegratorConsentComplexExitInterview 2 14 0
issue 7 39
IssueGroup 2 0
IssueGroupIssues 2 0
joint_admissions 8 0
log 6 0
log_letters 5 0
log_teleplantx 4 0
lst_admission_status 4 2
lst_discharge_reason 5 3
lst_field_category 4 4
lst_gender 4 3
lst_organization 4 3
lst_orgcd 5 2
lst_program_type 4 3
lst_sector 4 4
lst_service_restriction 4 3
mdsMSH 10 0
mdsNTE 4 0
mdsOBR 8 0
mdsOBX 10 0
mdsPID 8 0
mdsPV1 9 0
mdsZCL 12 0
mdsZCT 4 0
mdsZFR 7 0
mdsZLB 8 0
mdsZMC 7 0
mdsZMN 11 0
mdsZRG 8 0
measurementCSSLocation 2 0
measurementGroup 2 0
measurementGroupStyle 3 0
measurementMap 5 776
measurements 9 0
measurementsDeleted 10 0
measurementsExt 4 0
measurementType 6 28
measurementTypeDeleted 7 0
messagelisttbl 4 0
messagetbl 12 0
msgDemoMap 2 0
mygroup 5 1
oscar_annotations 10 0
oscarcommlocations 6 1
oscarKeys 3 0
patientLabRouting 4 0
pharmacyInfo 14 0
pmm_log 7 0
preference 10 1
prescribe 6 0
prescription 7 0
preventions 12 0
preventionsExt 4 0
professionalSpecialists 10 0
program 1 1 41 15
program_access 4 0
program_access_roles 2 0
program_client_restriction 3 9 0
program_clientstatus 3 0
program_functional_user 4 0
program_provider 5 0
program_provider_team 2 0
program_queue 11 0
program_team 3 0
programSignature 7 0
property 4 0
provider 5 25 2
provider_default_program 4 0
provider_facility 2 1
providerbillcenter 2 0
providerExt 2 0
providerLabRouting 7 0
publicKeys 3 0
quickList 4 10
quickListUser 3 0
radetail 12 0
raheader 10 0
recycle_bin 4 0
recyclebin 6 0
RedirectLink 2 0
RedirectLinkTracking 3 0
rehabStudy2004 2 0
relationships 11 0
remoteAttachments 5 0
report 13 4
report_date 7 0
report_date_sp 8 1
report_doctext 3 0
report_document 15 1
report_filter 13 6
report_letters 7 0
report_lk_reportgroup 6 4
report_option 14 3
report_qgviewfield 11 103
report_qgviewsummary 16 8
report_role 3 5
report_template 11 5
report_template_criteria 9 6
report_template_org 3 3
reportagesex 8 0
reportByExamples 4 0
reportByExamplesFavorite 4 0
reportConfig 7 0
reportFilter 9 0
reportItem 3 0
reportprovider 4 1
reportTableFieldCaption 4 0
reporttemp 6 0
reportTemplates 7 0
room 1 9 0
room_bed 5 0
room_bed_historical 4 0
room_demographic 6 0
room_type 3 1
rschedule 10 0
scheduledate 9 0
scheduledaytemplate 3 0
scheduleholiday 2 28
scheduletemplate 4 0
scheduletemplatecode 5 21
scratch_pad 4 0
secObjectName 3 57
secObjPrivilege 5 71
secPrivilege 3 6
secRole 3 9
security 9 1
secUserRole 5 3
serviceSpecialists 2 1
specialistsJavascript 2 1
specialty 3 44
study 9 0
studydata 7 0
studylogin 11 0
survey 11 0
survey_test_data 8 0
survey_test_instance 5 0
surveyData 8 0
SystemMessage 4 0
table_modification 8 0
teleplan_adj_codes 3 70
teleplan_refusal_code 3 742
teleplan_response_log 6 0
teleplan_submission_link 3 0
teleplanC12 17 0
teleplanS00 55 0
teleplanS21 16 0
teleplanS22 15 0
teleplanS23 23 0
teleplanS25 13 0
tickler 10 0
tickler_comments 5 0
tickler_update 5 0
tmpdiagnosticcode 4 0
user_ds_message_prefs 7 0
validations 10 10
waitingList 7 0
waitingListName 6 0
wcb 54 0
wcb_bp_code 6 85
wcb_noi_code 6 82
wcb_side 3 4

Columns: 11,488   Rows: 40,973