Tables


SchemaSpy Analysis of cpdb

Generated on Sat Sep 25 14:52 CDT 2021

XML Representation
Insertion Order Deletion Order
TABLES 108
VIEWS 2
COLUMNS 855
Constraints 113
Anomalies 10
Routines 0

Database Properties

Database Type: PostgreSQL - 13.0

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
pinboard_pinboard_officers 0 2 4 6251 Table
activity_grid_activitypaircard 0 2 8 10 Table
twitterbot_twitterbotvisitlog 0 1 5 5465 Table
data_officeryearlypercentile 0 1 7 231491 Table
wagtailimages_filter 1 0 2 0 Table
pinboard_pinboard_allegations 0 2 4 220 Table
data_attachmentfile 4 3 29 48478 Table
wagtailcore_pagerevision 0 2 7 31 Table
pgbench_tellers 1 1 4 100 Table
wagtailredirects_redirect 0 2 6 0 Table
auth_group 4 0 2 2 Table
django_session 0 0 3 679 Table
taggit_taggeditem 0 2 4 12 Table
data_area 5 2 12 1551 Table
data_racepopulation 0 1 6 517 Table
data_salary 0 1 14 209219 Table
document_cloud_documentcloudsearchquery 0 0 5 1 Table
pinboard_pinboard 5 1 7 1116 Table
wagtailsearch_querydailyhits 0 1 4 0 Table
data_allegation_line_areas 0 2 3 4307 Table
pinboard_pinboard_trrs 0 2 4 4 Table
data_tag 1 0 4 1 Table
data_policeunit 8 0 7 272 Table
twitterbot_tweetresponseroundrobin 0 0 6 685 Table
trr_charge 0 1 8 194080 Table
data_attachmentrequest 0 1 8 14 Table
trr_trr 7 3 40 67019 Table
pinboard_examplepinboard 0 1 3 2 Table
wagtailforms_formsubmission 0 1 4 0 Table
data_searchwarrant 0 2 19 19419 Table
data_officer 20 1 33 35545 Table
toast_toast 0 0 6 6 Table
search_terms_searchtermcategory 1 0 6 7 Table
wagtailembeds_embed 0 0 12 0 Table
document_cloud_documentcrawler 0 0 10 1856 Table
app_config_appconfig 0 0 6 1 Table
email_service_emailtemplate 0 0 5 4 Table
twitterbot_twitterbotresponselog 1 0 14 3399 Table
activity_grid_activitycard 0 1 6 75 Table
data_officerbadgenumber 0 1 6 46509 Table
analytics_searchtracking 0 0 7 400429 Table
data_officerassignmentattendance 0 3 14 18023555 Table
lawsuit_payment 0 1 10 1794 Table
wagtailcore_pageviewrestriction 0 1 3 0 Table
wagtailcore_page 7 3 20 13 Table
analytics_event 0 0 5 839 Table
lawsuit_lawsuit 3 0 22 1454 Table
data_investigatorallegation 0 3 9 181161 Table
auth_group_permissions 0 2 3 14 Table
data_complainant 0 1 8 123815 Table
data_award 0 1 14 656116 Table
trr_trrstatus 0 2 10 201325 Table
wagtailcore_collection 3 0 5 1 Table
data_officerallegation 0 3 15 249788 Table
data_attachmentnarrative 0 1 8 45451 Table
data_allegationcategory 2 0 8 416 Table
data_officerrank 0 2 7 62735 Table
data_attachmentocr 0 1 6 232567 Table
activity_log_activitylog 0 2 8 51 Table
authtoken_token 0 1 3 15 Table
lawsuit_lawsuitplaintiff 0 1 7 2037 Table
taggit_tag 1 0 3 24 Table
data_policerank 1 0 3 207 Table
wagtailsearch_query 2 0 2 0 Table
wagtailsearch_editorspick 0 2 5 0 Table
django_content_type 6 0 3 104 Table
django_site 0 0 3 1 Table
wagtaildocs_document 0 2 6 0 Table
data_investigator 1 1 11 4787 Table
wagtailimages_image 1 2 13 0 Table
auth_user_groups 0 2 3 0 Table
data_officerhistory 0 2 7 113100 Table
lawsuit_lawsuit_officers 0 2 3 4328 Table
twitterbot_responsetemplate 0 0 5 3 Table
trr_subjectweapon 0 1 7 50530 Table
trr_trrattachmentrequest 0 1 7 0 Table
spatial_ref_sys 2 0 5 8500 Table
wagtailimages_rendition 0 2 7 0 Table
data_versioning_changelog 0 0 7 0 Table
django_admin_log 0 2 8 534 Table
pgbench_branches 3 0 3 10 Table
wagtailusers_userprofile 0 1 5 0 Table
data_attachmentfile_tags 0 2 4 1 Table
pgbench_history 0 3 6 10 Table
analytics_attachmenttracking 0 1 6 10057 Table
data_allegation 12 2 20 216052 Table
pgbench_accounts 1 1 4 1000000 Table
wagtailcore_site 1 1 6 0 Table
data_allegation_areas 0 2 3 928000 Table
django_migrations 0 0 4 380 Table
cms_slugpage 1 0 5 5 Table
search_terms_searchtermitem 0 1 11 73 Table
data_officeralias 0 1 5 8 Table
data_victim 0 1 8 126508 Table
data_policebeat 1 2 10 47063 Table
trr_weapondischarge 0 1 21 9209 Table
auth_user_user_permissions 0 2 3 241 Table
app_config_visualtokencolor 0 0 7 17 Table
trr_actionresponse 0 1 13 523090 Table
data_policewitness 0 2 5 42735 Table
auth_user 11 0 11 20 Table
wagtailcore_groupcollectionpermission 0 3 4 8 Table
data_involvement 0 2 10 0 Table
data_pipeline_appliedfixture 0 0 3 27 Table
data_linearea 1 0 6 126 Table
wagtailcore_grouppagepermission 0 2 4 6 Table
auth_permission 3 1 4 384 Table
popup_popup 0 0 7 12 Table
geography_columns 0 1 7 0 View
geometry_columns 0 1 7 0 View