SchemaSpy Analysis of rice-2.1.1 Generated by
SchemaSpy
Generated by SchemaSpy on Tue Sep 18 22:24 PDT 2012
Database Type: MySQL - 5.5.27 SourceForge.net


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

Table / View Children Parents Columns Rows Comments
acct_dd_attr_doc 10 0
bk_address_t 11 2
bk_address_typ_t 5 2
bk_author_account_t 3 2
bk_author_t 8 2
bk_book_author_t 2 3
bk_book_t 1 11 2
bk_book_typ_t 6 2
bk_order_doc_t 3 0
bk_order_entry_t 2 9 0
kr_kim_test_bo 2 0
krcr_cmpnt_set_t 4 1
krcr_cmpnt_t 1 6 28
krcr_drvd_cmpnt_t 4 88
krcr_nmspc_t 2 6 11
krcr_parm_t 2 10 49
krcr_parm_typ_t 1 5 4
krcr_style_t 6 2
kren_chnl_prodcr_t 2 2 8
kren_chnl_subscrp_t 1 5 2
kren_chnl_t 5 6 6
kren_cntnt_typ_t 1 10 2
kren_msg_deliv_t 1 8 0
kren_msg_t 1 12 0
kren_ntfctn_msg_deliv_t 1 8 0
kren_ntfctn_t 3 4 15 0
kren_prio_t 1 6 3
kren_prodcr_t 2 6 3
kren_recip_deliv_t 5 6
kren_recip_list_t 1 6 2
kren_recip_prefs_t 5 0
kren_recip_t 1 6 0
kren_rvwer_t 1 6 3
kren_sndr_t 1 5 0
krew_actn_itm_t 19 51
krew_actn_rqst_t 28 119
krew_actn_tkn_t 11 64
krew_app_doc_stat_tran_t 7 0
krew_att_t 6 3
krew_attr_defn_t 2 8 2
krew_dlgn_rsp_t 6 1
krew_doc_hdr_cntnt_t 2 141
krew_doc_hdr_ext_dt_t 4 0
krew_doc_hdr_ext_flt_t 4 0
krew_doc_hdr_ext_long_t 4 0
krew_doc_hdr_ext_t 4 7
krew_doc_hdr_t 19 135
krew_doc_lnk_t 3 0
krew_doc_nte_t 6 3
krew_doc_typ_app_doc_stat_t 4 0
krew_doc_typ_attr_t 4 10
krew_doc_typ_plcy_reln_t 6 4
krew_doc_typ_proc_t 6 23
krew_doc_typ_t 27 44
krew_edl_assctn_t 7 1
krew_edl_def_t 6 1
krew_edl_dmp_t 9 0
krew_edl_fld_dmp_t 5 0
krew_hlp_t 5 0
krew_init_rte_node_instn_t 2 121
krew_out_box_itm_t 18 6
krew_ppl_flw_attr_t 2 5 0
krew_ppl_flw_dlgt_t 1 8 0
krew_ppl_flw_mbr_t 1 1 8 0
krew_ppl_flw_t 2 1 7 0
krew_rte_brch_proto_t 3 1
krew_rte_brch_st_t 5 36
krew_rte_brch_t 7 121
krew_rte_node_cfg_parm_t 4 140
krew_rte_node_instn_lnk_t 2 50
krew_rte_node_instn_st_t 5 0
krew_rte_node_instn_t 9 171
krew_rte_node_lnk_t 2 14
krew_rte_node_t 14 37
krew_rule_attr_t 10 22
krew_rule_expr_t 1 5 2
krew_rule_ext_t 4 4
krew_rule_ext_val_t 5 3
krew_rule_rsp_t 10 9
krew_rule_t 1 20 11
krew_rule_tmpl_attr_t 9 7
krew_rule_tmpl_optn_t 5 6
krew_rule_tmpl_t 6 14
krew_typ_attr_t 2 6 2
krew_typ_t 2 6 1
krew_usr_optn_t 4 0
krim_addr_typ_t 1 7 3
krim_afltn_typ_t 1 8 4
krim_attr_defn_t 6 8 33
krim_ctznshp_stat_t 1 7 0
krim_dlgn_mbr_attr_data_t 2 7 0
krim_dlgn_mbr_t 1 10 0
krim_dlgn_t 1 2 7 0
krim_email_typ_t 7 3
krim_emp_stat_t 1 7 7
krim_emp_typ_t 1 7 3
krim_ent_nm_typ_t 7 3
krim_ent_typ_t 1 6 2
krim_entity_addr_t 3 22 0
krim_entity_afltn_t 1 2 9 0
krim_entity_bio_t 16 0
krim_entity_cache_t 13 1
krim_entity_ctznshp_t 2 10 0
krim_entity_email_t 2 10 37
krim_entity_emp_info_t 4 14 0
krim_entity_ent_typ_t 6 2 6 39
krim_entity_ethnic_t 1 6 0
krim_entity_ext_id_t 2 7 0
krim_entity_nm_t 1 16 38
krim_entity_phone_t 3 12 0
krim_entity_priv_pref_t 9 0
krim_entity_residency_t 1 6 0
krim_entity_t 10 5 39
krim_entity_visa_t 1 7 0
krim_ext_id_typ_t 1 8 6
krim_grp_attr_data_t 3 7 0
krim_grp_document_t 9 0
krim_grp_mbr_t 1 9 41
krim_grp_mbr_v 7 view
krim_grp_t 2 1 9 18
krim_grp_v 6 view
krim_perm_attr_data_t 3 7 92
krim_perm_attr_v 8 view
krim_perm_t 2 1 8 72
krim_perm_tmpl_t 1 1 8 53
krim_perm_v 8 view
krim_person_document_t 1 9 0
krim_phone_typ_t 1 7 4
krim_pnd_addr_mt 22 0
krim_pnd_afltn_mt 1 9 0
krim_pnd_ctznshp_mt 10 0
krim_pnd_dlgn_mbr_attr_data_t 10 0
krim_pnd_dlgn_mbr_t 12 0
krim_pnd_dlgn_t 8 0
krim_pnd_email_mt 10 0
krim_pnd_emp_info_mt 14 0
krim_pnd_grp_attr_data_t 10 0
krim_pnd_grp_mbr_t 10 0
krim_pnd_grp_prncpl_mt 14 0
krim_pnd_nm_mt 16 0
krim_pnd_phone_mt 12 0
krim_pnd_priv_pref_mt 9 0
krim_pnd_role_mbr_attr_data_mt 10 0
krim_pnd_role_mbr_mt 11 0
krim_pnd_role_mt 9 0
krim_pnd_role_perm_t 7 0
krim_pnd_role_rsp_actn_mt 11 0
krim_pnd_role_rsp_t 7 0
krim_prncpl_t 1 8 39
krim_prncpl_v 8 view
krim_role_document_t 9 0
krim_role_grp_v 8 view
krim_role_mbr_attr_data_t 2 7 0
krim_role_mbr_t 1 9 3
krim_role_perm_t 1 6 87
krim_role_perm_v 11 view
krim_role_prncpl_v 10 view
krim_role_role_v 9 view
krim_role_rsp_actn_t 9 0
krim_role_rsp_t 1 6 0
krim_role_t 2 1 9 15
krim_role_v 6 view
krim_rsp_attr_data_t 3 7 0
krim_rsp_attr_v 7 view
krim_rsp_role_actn_v 12 view
krim_rsp_role_v 10 view
krim_rsp_t 2 1 8 0
krim_rsp_tmpl_t 1 1 8 2
krim_typ_attr_t 2 7 75
krim_typ_t 11 7 40
krlc_cmp_t 1 7 12
krlc_cmp_typ_t 1 5 3
krlc_cntry_t 2 7 303
krlc_cnty_t 3 7 0
krlc_pstl_cd_t 6 8 0
krlc_st_t 2 1 6 63
krms_actn_attr_t 2 5 0
krms_actn_t 1 1 8 1
krms_agenda_attr_t 2 5 0
krms_agenda_itm_t 3 6 8 9
krms_agenda_t 3 1 7 3
krms_attr_defn_t 6 8 9
krms_cmpnd_prop_props_t 2 2 11
krms_cntxt_attr_t 2 5 1
krms_cntxt_t 7 7 2
krms_cntxt_vld_actn_typ_t 1 4 4
krms_cntxt_vld_agenda_typ_t 1 4 1
krms_cntxt_vld_func_t 1 4 0
krms_cntxt_vld_rule_typ_t 1 4 1
krms_cntxt_vld_term_spec_t 2 4 8
krms_ctgry_t 2 4 1
krms_func_ctgry_t 2 2 0
krms_func_parm_t 1 6 0
krms_func_t 2 1 8 0
krms_prop_parm_t 1 6 48
krms_prop_t 4 1 8 20
krms_rule_attr_t 2 5 0
krms_rule_t 3 1 8 9
krms_term_parm_t 1 5 1
krms_term_rslvr_attr_t 2 5 0
krms_term_rslvr_input_spec_t 2 2 0
krms_term_rslvr_parm_spec_t 1 4 3
krms_term_rslvr_t 3 2 7 2
krms_term_spec_ctgry_t 2 2 0
krms_term_spec_t 5 7 9
krms_term_t 1 1 4 7
krms_typ_attr_t 2 6 10
krms_typ_t 4 6 10
krns_adhoc_rte_actn_recip_t 6 0
krns_att_t 1 8 0
krns_doc_hdr_t 2 7 41
krns_lookup_rslt_t 6 0
krns_lookup_sel_t 6 0
krns_maint_doc_att_lst_t 1 7 0
krns_maint_doc_att_t 6 0
krns_maint_doc_t 1 1 4 8
krns_maint_lock_t 5 3
krns_nte_t 1 1 10 0
krns_nte_typ_t 1 5 2
krns_pessimistic_lock_t 7 0
krns_sesn_doc_t 9 0
krsb_bam_parm_t 3 0
krsb_bam_t 10 0
krsb_msg_pyld_t 2 0
krsb_msg_que_t 13 0
krsb_qrtz_blob_triggers 2 3 0
krsb_qrtz_calendars 2 0
krsb_qrtz_cron_triggers 2 4 0
krsb_qrtz_fired_triggers 12 0
krsb_qrtz_job_details 2 9 0
krsb_qrtz_job_listeners 2 3 0
krsb_qrtz_locks 1 5
krsb_qrtz_paused_trigger_grps 1 0
krsb_qrtz_scheduler_state 3 0
krsb_qrtz_simple_triggers 2 5 0
krsb_qrtz_trigger_listeners 2 3 0
krsb_qrtz_triggers 8 16 0
krsb_svc_def_t 1 12 0
krsb_svc_dscrptr_t 1 2 0
trav_doc_2_accounts 2 61
trv_acct 1 10 7
trv_acct_ext 4 7
trv_acct_fo 1 4 3
trv_acct_type 4 3
trv_acct_use_rt_t 5 0
trv_att_sample 1 7 0
trv_doc_2 8 37
trv_doc_acct 2 0
trv_multi_att_sample 1 8 0
tst_search_attr_indx_tst_doc_t 8 0
           
237 Tables     1,741 3,107  
13 Views     110