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

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

339 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
billactivity 13 0
billcenter 2 0
billing 24 0
billing_on_3rdPartyAddress 9 0
billing_on_cheader1 34 0
billing_on_cheader2 10 0
billing_on_diskname 11 0
billing_on_eareport 23 0
billing_on_errorCode 2 317
billing_on_ext 7 0
billing_on_favourite 6 0
billing_on_filename 9 0
billing_on_header 20 0
billing_on_item 13 0
billing_on_proc 6 0
billing_on_repo 5 0
billing_payment_type 2 10
billing_private_service 6 0
billingdetail 9 0
billinginr 16 0
billingperclimit 3 0
billingreferral 13 10,222
billingservice 11 4,391
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_premium 4 0
ctl_billingtype 2 0
ctl_diagcode 3 18
ctl_doctype 3 16
ctl_document 4 3
ctl_frequency 4 20
ctl_provider 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
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
formLabReq07 120 0
formLateLifeFDIDisability 166 0
formLateLifeFDIFunction 206 0
formMentalHealth 73 0
formMentalHealthForm1 40 0
formMentalHealthForm14 14 0
formMMSE 30 0
formONAR 862 0
formovulation 364 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
functional_user_type 2 0
groupMembers_tbl 2 0
groups_tbl 3 1
gstControl 2 1
hash_audit 5 0
health_safety 5 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
labPatientPhysicianInfo 23 0
labReportInformation 7 0
labTestResults 15 0
log 6 0
log_letters 5 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
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
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

Columns: 9,643   Rows: 39,881