Tables


SchemaSpy Analysis of bev

Generated on Tue Sep 27 13:15 UTC 2022

os2bos/3.9.1

XML Representation
Insertion Order Deletion Order
TABLES 51
VIEWS 0
COLUMNS 308
Constraints 37
Anomalies 1
Routines 0

Database Properties

Database Type: PostgreSQL - 10.14 (Debian 10.14-1.pgdg90+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
core_section_allowed_for_target_groups 0 0 3 92 Table
core_effort_allowed_for_target_groups 0 0 3 4 Table
constance_config 0 0 3 0 Table
core_internalpaymentrecipient 0 0 3 2 Table
core_historicalrateperdate 0 0 12 0 Table
core_user_groups 0 1 3 0 Table
core_sectioninfo 0 3 9 86 Table
core_user_user_permissions 0 1 3 0 Table
mailer_messagelog 0 0 8 0 Table
core_appropriation 1 2 9 0 Table
core_rateperdate 0 2 7 30 Table
core_approvallevel 1 0 3 6 Table
auth_group 2 0 2 0 Table
core_municipality 3 0 3 98 Table
core_price 0 2 2 0 Table
django_content_type 2 0 3 44 Table
core_serviceprovider 1 0 12 421 Table
django_session 0 0 3 0 Table
core_paymentschedule 2 3 17 0 Table
core_user 5 1 13 7 Table
core_activity 2 6 18 0 Table
core_activitydetails_main_activities 0 0 3 241 Table
core_activitydetails 2 0 7 82 Table
core_effortstep 1 0 4 6 Table
core_team 1 1 4 5 Table
mailer_dontsendentry 0 0 3 0 Table
core_rate 1 1 5 30 Table
core_payment 0 1 14 0 Table
core_effort 0 0 4 2 Table
mailer_message 0 0 4 0 Table
core_activitydetails_service_providers 0 0 3 0 Table
django_admin_log 0 2 8 0 Table
core_activitydetails_supplementary_activity_for 0 0 3 203 Table
django_migrations 0 0 4 133 Table
core_dstpayload 0 0 7 0 Table
core_accountaliasmapping 0 0 4 204 Table
core_activitycategory 1 0 4 25 Table
core_targetgroup 1 0 4 2 Table
core_variablerate 3 0 1 30 Table
core_relatedperson 0 1 11 0 Table
core_case 2 7 18 0 Table
core_paymentmethoddetails 1 0 3 2 Table
core_section_allowed_for_steps 0 0 3 126 Table
core_case_efforts 0 0 3 0 Table
core_section 2 0 8 146 Table
core_historicalcase 0 0 15 0 Table
core_historicalpayment 0 0 10 0 Table
auth_group_permissions 0 2 3 0 Table
auth_permission 2 1 4 174 Table
core_schooldistrict 1 0 3 5 Table
core_paymentdateexclusion 0 0 2 341 Table