cpdb Database

TABLES 33

COLUMNS 316

Constraints 39

Anomalies 2

Routines 0

Database Type: PostgreSQL - 10.5

standard public schema

Table / View	Children	Parents	Columns	Rows	Type
trr_trrstatus	0	2	8	201325	Table
trr_charge	0	1	6	194080	Table
data_attachmentrequest	0	1	5	115	Table
trr_trr	6	3	38	67019	Table
trr_trrattachmentrequest	0	1	4	29	Table
spatial_ref_sys	3	0	5	5757	Table
data_officerallegation	0	3	13	244455	Table
data_versioning_changelog	0	0	7	0	Table
data_allegationcategory	1	0	6	415	Table
data_officer	12	0	19	33671	Table
data_allegation	10	1	13	181534	Table
data_attachmentfile	0	1	11	3418	Table
data_allegation_areas	0	2	3	444878	Table
data_officerbadgenumber	0	1	4	43079	Table
data_officeralias	0	1	3	8	Table
data_victim	0	1	6	89487	Table
trr_weapondischarge	0	1	19	9209	Table
data_area	4	2	10	1551	Table
trr_actionresponse	0	1	11	523090	Table
data_policewitness	0	2	3	38675	Table
data_racepopulation	0	1	4	517	Table
data_involvement	0	2	8	0	Table
data_investigator	1	1	9	3464	Table
data_salary	0	1	11	209219	Table
data_investigatorallegation	0	3	7	132235	Table
data_pipeline_appliedfixture	0	0	3	27	Table
data_linearea	1	0	4	126	Table
data_allegation_line_areas	0	2	3	1038	Table
data_officerhistory	0	2	5	106874	Table
data_complainant	0	1	6	85846	Table
data_award	0	1	12	656116	Table
data_policeunit	4	0	5	264	Table
trr_subjectweapon	0	1	5	50530	Table
geography_columns	0	1	7	0	View
geometry_columns	0	1	7	0	View
raster_columns	0	1	17	0	View
raster_overviews	0	0	9	0	View